先说明安装步骤:
1)安装Oracle 11g 64位
2)安装32位的Oracle客户端( instantclient-basic-nt-12.1.0.1.0)
3)安装PL/SQL Developer
4) 设置环境变量(修改PATH和TNS_ADMIN环境变量)问题:在PL/SQL Developer下sys用户下执行conn scott/tiger报ORA-12560:TNS:协议适配器错误;
说明:监听OracleOraDb11g_home1TNSListener和服务OracleServiceORCL都已经确认打开,注册表oracle_sid也已经设置为orcl,即与服务名相同.求大神指导怎么解决此处ORA-12560协议适配器错误.oracle11gwin8pl/sql developer64位oracle
1)安装Oracle 11g 64位
2)安装32位的Oracle客户端( instantclient-basic-nt-12.1.0.1.0)
3)安装PL/SQL Developer
4) 设置环境变量(修改PATH和TNS_ADMIN环境变量)问题:在PL/SQL Developer下sys用户下执行conn scott/tiger报ORA-12560:TNS:协议适配器错误;
说明:监听OracleOraDb11g_home1TNSListener和服务OracleServiceORCL都已经确认打开,注册表oracle_sid也已经设置为orcl,即与服务名相同.求大神指导怎么解决此处ORA-12560协议适配器错误.oracle11gwin8pl/sql developer64位oracle
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
以上是客户端,以下是服务端:# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
二 你把localhost修改为客户端的主机名试试,有时会不识别。