invalid username/password: logon denied 可能因为tnsnames 写错而产生吗
我是在我自己的windows上测试的
有两个数据库,只有一个能正常登陆(后安装的那个)
但是我只要把SQLNET.ORA里的内容换成SQLNET.AUTHENTICATION_SERVICES = (NTS),就没问题。
我现在的设置是这样的
SQLNET.ORA:
NAMES.DIRECTORY_PATH= (TNSNAMES)
=========================================
LISTENER.ORA:
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orabu)
(ORACLE_HOME = C:\oracle\product\11.2.0)
(SID_NAME = orabu)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = catdb)
(ORACLE_HOME = C:\oracle\product\11.2.0)
(SID_NAME = catdb)
)
)
ADR_BASE_LISTENER1 = c:\oracle\product\11.2.0\log
ADR_BASE_LISTENER = c:\oracle\product\11.2.0\log
=========================================
TNANAMES.ORA:
ORABU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORABU)
(SID = ORABU)
)
)
CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CATDB)
(SID = CATDB)
)
)
请问有什么问题吗?
不能登陆的是ORABU database
ERROR:
ORA-01017: invalid username/password; logon denied