我是在我自己的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\logADR_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
有两个数据库,只有一个能正常登陆(后安装的那个)
但是我只要把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\logADR_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
用windows local user登陆后创建一个新的用户,赋予其dba权限。之后你可以使用这个新用户操作数据库。
或sys 登录后新建个用户。