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.