http://blog.csdn.net/programpoet/article/details/4045262

Oracle10g所在目录大概是:

E:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora

Oracle9i所在目录大概是:

D:/oracle/ora90/network/admin/tnsnames.ora

配置该文件,诸如:

# TNSNAMES.ORA Network Configuration File: D:/oracle/ora90/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

MAO =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = maowenlei)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = mao.name)

)

)

APP_172.22.22.6 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.6)(PORT = 1521))

)

(CONNECT_DATA =

(SID = app)

(SERVER = DEDICATED)

)

)

APP_172.22.22.1 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.1)(PORT = 1521))

)

(CONNECT_DATA =

(SID = app)

(SERVER = DEDICATED)

)

)

APP_CESHI =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = APP)

)

)

INST1_HTTP =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = maowenlei)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

APP_10.10.141.200 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))

)

(CONNECT_DATA =

(SID = app)

(SERVER = DEDICATED)

)

)

之后在plsql developer登陆时就有以上下拉选择框了.


关于9i换成10g后,使用plsql developer登陆报错的问题.

原因:还在找老版本的tnsnames.ora.

解决方案,重新安装plsql developer,自动找新安装的数据库10g.