测试环境,遇到错误如下:
ORA-12505: TNS:listener does not currently know of SID given in connect
本机连接,SID确信是对的,于是查看监听:
The listener supports no services
修改hostname,alter system register都不行。
后来修改 listener.ora,加入如下内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = aaa)
(SID_NAME = aaa)
)
)
重启监听,OK。
参考URL如下:
http://blog.csdn.net/aaron8219/article/details/11672817
http://blog.csdn.net/liqfyiyi/article/details/6941464