我在本地建立了一个实例,实例名为orcl,用sqlplus连接,用户名为system ,主机字符串为orcl还有密码。变出现错误提示 ora-12537 : tns :连接已关闭。
tnsnames.ora一段为:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora一段为:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)listener.log提示为:
28-4月 -2011 14:01:11 * giop * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2262)) * handoff * giop * 12523
TNS-12523: TNS: 监听程序无法找到适用于客户机连接的例程。
求高手指点。
tnsnames.ora一段为:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora一段为:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)listener.log提示为:
28-4月 -2011 14:01:11 * giop * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2262)) * handoff * giop * 12523
TNS-12523: TNS: 监听程序无法找到适用于客户机连接的例程。
求高手指点。
用tnsping orcl 后显示tns:连接已关闭
如果都打开了。那你把127.0.0.1改成LocalHost试下。。