安装PLSQL Developer 连接运程Oracle 数据库
PLSQL Developer 包含两个部分一个是PLSQL Developer可视化界面,一个是instantclient客户端
解压缩包,压缩包下面包含上面两个内容
在安装目录下,新建三个文件夹,用来放:客户端环境,可视化界面安装包,可视化界面安装的目录
在安装包里面找到plsqldev906.exe双击进行安装
配置环境变量:
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN = E:\PLSQLDeveloper\SetUPOci\PLSQL\instantclient_11_2\network\admin
TNS_ADMIN是tnsnames.ora 的父级目录,为了能够找数据库;network\admin\tnsnames.ora文件是客户端环境里面的文件,需要自己配置,下载的压缩包没有
tnsnames.ora文件里面的内容
XKJ_101 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
XKJ_103 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.103)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xkj103)
)
)
222.222.222.222 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 222.222.222.222)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
在可视化界面里面进行客户端环境的配置引入
该路径为oci.dll 的路径E:\PLSQLDeveloper\SetUPOci\PLSQL\instantclient_11_2\oci.dll