今天我换了网络,也出现了这个问题。搞了一上午才解决。
主要是配置2个文件tnsnames.ora和listener.ora。
不知道LZ什么情况。
附上我的配置,给LZ参考
listener.ora。SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = H:\oracle\install\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME=STAR)
(SID_NAME = XE)
(ORACLE_HOME = H:\oracle\install\app\oracle\product\11.2.0\server)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)DEFAULT_SERVICE_LISTENER = (XE)
tnsnames.oraXE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
主要是配置2个文件tnsnames.ora和listener.ora。
不知道LZ什么情况。
附上我的配置,给LZ参考
listener.ora。SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = H:\oracle\install\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME=STAR)
(SID_NAME = XE)
(ORACLE_HOME = H:\oracle\install\app\oracle\product\11.2.0\server)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)DEFAULT_SERVICE_LISTENER = (XE)
tnsnames.oraXE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
http://my.csdn.net/my/album/detail/1642277,表示orcl已经动态注册到监听器,应该可以正常连接了。建议楼主如下操作试试看:
1、停止oracleserviceorcl服务
2、stop listener
3、start listener
4、启动oracleserviceorcl服务
5、sqlplus / nolog
6、startup
我把监听程序删除,重新添加了一下,端口号为1521
重新配置了一下本地NET服务名设置
用plsql登陆显示:ORA-12514错误
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ORCL)
)
)然后连接下看看吧
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)然后重启监听,重启服务,再次查看lsnrctl status的内容。
sqlplus / as sysdba
已经重建了,不行哇
检查一下network-admin-tnsnames.ora里的配置,名字也要检查下哦,前面不能有空格的