【赛迪网-it技术报道】案例:在同一台机器的2个不同的用户下安装了oracle 10g和oracle 11g(oracle用户安装10g,daizy用户安装oracle 11g),但是发现原来的oracle 10g可以远程连接,而oracle 11g确不能连接。
解决方法:
修改listener.ora后,10g和11g的连接即可恢复正常。
具体示例如下:
oracle数据库10g
cat listener.ora
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = oratest)(port = 1521))
(address = (protocol = ipc)(key = extproc0))
)
)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /home/oracle/orahome_1)
(program = extproc)
)
(sid_desc =
(oracle_home = /home/oracle/orahome_1)
(sid_name = test)
)
)
oracle数据库11g
cat listener.ora
# listener.ora network configuration file: /home/daizy/orahome_1/network/admin/listener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = 192.168.1.170)(port = 1522))
(address = (protocol = ipc)(key = dzy))
)
)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /home/daizy/orahome_1)
(program = extproc)
)
(sid_desc =
(oracle_home = /home/daizy/orahome_1)
(sid_name = dzy)
)
)
闽公网安备 35060202000074号