从你提供的信息来看系统监听已经配置完成,终止是在启动监听进程的时候,你可以先在DOS的提示符下键入LSNRCTL START,如果还是不行的话,那么看看%oracle_home%/network/admin/sqlnet.ora文件,将SQLNET.AUTHENTICATION_SERVICES= (NTS)注释掉(前面加一个#号),然后在连接,如果出现oracle不可用的信息的话,就以INTERNAL/ORACLE登录SVRMGRL,然后STARTUP即可
调试欢乐多
尝试使用其它用户 ID 连接:scott
测试失败。
ORA-01034: ORACLE 不可用
输入的域中可能有错误,
或服务器未做好连接准备。==使用SQL Plus进行登录
1、system/manager ,提示:ORA-12560:TNS:协议适配器错误
2、system/manager/OracleDB,提示:ORACLE not available而且:
在目录%oracle_home%/network/admin/下没有sqlnet.ora,只有listener.ora和tnsnames.ora使用INTERNAL/ORACLE/OracleDB登录,Startup可以启动例程,但无法进行操作。如何才能解决:“协议适配器错误”这个问题???
1.connect internal
2.startup
然后:
sqlplus system/manager
注意:
Net8 Easy Config 测试时最好用system/manager
仍然提示:ORA-12560:TNS:协议适配器错误同样
svrmgr>connect internal
出现同样的提示信息。
在%ORACLE_HOME%/network/admin下创建一个sqlnet.ora,内容如下:
# SQLNET.ORA Network Configuration File:
f:\Oracle\Ora81\network\admin\sqlnet.ora(注意,这里写上你自己的路径
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 AssistantLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = welcomeoa)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = OracleDB.welcomeonline)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = ORACLEDB)
)
)tnsnames.ora文件:
# D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 AssistantORACLEDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WelcomeOA)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OracleDB.welcomeonline)
)
)
sqlnet.ora文件:
# SQLNET.ORA Network Configuration File:
d:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
请帮帮忙解决,多谢!
然后重新启动计算机(或者重新启动oracleservices***和oraclehometnslinster等服务)
最好lsnrctl stop/start,或者reload小问题啦!我今天就遇到一次,哈哈!