目录
Oracle问题之ORA-12560TNS:协议适配器错误
一、造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,
启动OracleOraDb11g_home1TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务
面板,启动OracleServiceBOOKSALES, BOOKSALES就是你的database SID
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME
将该环境变量ORACLE_SID设置为XXXX, XXXX就是你的database SID.
或者右击我的电脑,属性--高级--环境变量---系统变量--新建,变量名=oracle_sid,变量值=XXXX, XXXX就是你的database SID.
或者进入sqlplus前,在command line下输 set oracle_sid=XXXX, XXXX就是你的database SID.
经过以上步骤,一般就可以解决问题。
二、如果还没有解决的话则会遇到以下问题:
1、执行请求的操作时遇到错误:
IO 错误: The Network Adapter could not establish the connection
供应商代码 17002
2、执行请求的操作时遇到错误:
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
供应商代码 12514
三、解决方法如下:
假如只有一个数据库的话:
1、找到如下路径:
D:\install\oracle\oracle-install\product\11.2.0\dbhome_1\NETWORK\ADMIN
2、将文件中的内容修改如下,当然要结合自己的实际情况做简单修改:
//listener.ora
# listener.ora Network Configuration File: D:\install\oracle\oracle-install\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=CLRExtProc)
(ORACLE_HOME= D:\install\oracle\oracle-install\product\11.2.0\dbhome_1)
(PROGRAM=extproc)
(ENVS= "EXTPROC_DLLS=ONLY:D:\install\oracle\oracle-install\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC=(SID_NAME=BOOKSALES)
(ORACLE_HOME= D:\install\oracle\oracle-install\product\11.2.0\dbhome_1)
(GLOBAL_DBNAME=BOOKSALES)
)
)
LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS= (PROTOCOL = IPC)(KEY =EXTPROC1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = acer)(PORT = 1521))
)
)
ADR_BASE_LISTENER= D:\install\oracle\oracle-install
//sqlnet.ora
# sqlnet.ora Network Configuration File: D:\install\oracle\oracle-install\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This fileis actually generated by netca. But ifcustomers choose to
# install"Software Only", thisfile wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
//tnsnames.ora
# tnsnames.ora Network Configuration File: D:\install\oracle\oracle-install\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
BOOKSALES=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
(CONNECT_DATA=(SERVICE_NAME=BOOKSALES)
)
)
3、重新启动 tnslistener
4、测试的时候要注意修改对应数据库的用户名和密码
Oracle SQL Developer连接的时候也要注意用对应的用户名和密码
执行请求的操作时遇到错误:
IO 错误: The Network Adapter could not establish the connection
供应商代码 17002
执行请求的操作时遇到错误:
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
供应商代码 12514
也是按照上面修改配置文件