oracle9i和oracle10g多版本共存,oracle9i不能连接问题总结

oracle9i和oracle10g多版本共存,oracle9i不能连接问题总结

 

机器上先后安装了oracle9i和oracle10g,安装好后,10g能用pl/sql developer正常连接,但9i总是连不上,总是提示:"ORA-12154: TNS:无法解析指定的连接标识符",网上说oracle目录下:c:\oracle\ora9i\network\admin下的listener.ora配置有问题

配置如下:LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = china-efe28f3fd)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
    )
  )


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\ora9i)
      (PROGRAM = extproc)
    )
  )

 

检查一遍,没发现什么问题,

 

后来又查了查资料,说可能是pl/sql developer的Oracle Home设置有问题,我的是英文版的,在Tools菜单-Perferences...下 Oracle Home 选择一下你要连接的数据库实例名,如我的是ora9i,保存,关闭,重新打开,问题解决.总结一下,以供大家参考.