【赛迪网－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)

)

)