- 安装plsql
- 网上下载
instantclient_11_2
文件,解压到plsql安装文件夹里 - 修改
D:\PLSQL Developer\instantclient_11_2\NETWORK\ADMIN
里的listener.ora和tnsnames.ora文件 - listener.ora示例:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\PLSQL Developer\instantclient_11_2) #根据自己的instantclient_11_2路径配置
(PROGRAM = extproc)
(ENVS = "D:\PLSQL Developer\instantclient_11_2\oraclr11.dll") #根据自己的instantclient_11_2路径配置
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.9.226)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\orcle11
- tnsnames.ora示例:
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.9.226)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
xingneng =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.9.226)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST11G)
)
)
sit =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.9.226)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST11G)
)
)
- 配置完成.