为什么tnsping 通,但是sqlplus sys/passw0rd@orcl as sysdba 连不上
本帖最后由 hmchzb19 于 2013-07-23 14:26 编辑sqlplus sys/passw0rd@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 23 02:22:16 2013
Copyright (c) 1982, 2009, Oracle.All rights reserved.
ERROR:
ORA-01031: insufficient privileges
每次都报这个错
tnsnames.ora的内容如下
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.37.72.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora的内容如下SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.37.72.88)(PORT = 1521))
)
)
和TNS没有关系。
oracle为了安全考虑,不允许sys用户进行远程操作。
试试remote_login_passwordfile的值修改为EXCLUSIVE
或者说,密码文件的问题。
都可以查看一下。
也有可能是oracle的属猪不对 这个问题后来搞定了,
remote_login_passwordfile的值是EXCLUSIVE
是password file创建的时候出错了
应该是
orapwd file='/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapw[$SID]
我敲成了
orapwd file='/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapwd[$SID]
回复 4# hmchzb19
关键是你怎么查出来的?
页:
[1]