plsql deveploper安装

一、服务端
1、tnsnames.ora文件内容

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

2、listener.ora文件内容

LISTENER = 
(DESCRIPTION_LIST = 
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)) 
) 
) 

SID_LIST_LISTENER= 
(SID_LIST=
(SID_DESC= 
(GLOBAL_DBNAME=orcl) 
(SID_NAME=orcl)
) 
)
ADR_BASE_LISTENER = /home/oracle/app

3、启停tns

service lsnrctl status\start\stop

 

二、客户端
1、下载instantclient-basic-win32-11.2.0.1.0.zip和instantclient-sqlplus-win32-11.2.0.1.0.zip
2、把下载的包解压到instantclient_11_2目录下面
3、在instantclient_11_2目录下面，新建tnsnames.ora文件，里面的内容如下

ORCL=
(DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    )
    (CONNECT_DATA = 
        (SERVICE_NAME = ORCL)
    )
)

4、下载安装plsqlDeveloper、在程序目录下面添加start.bat文件，内容如下

@echo off 
set path=D:\oracle\instantclient_11_2
set ORACLE_HOME=D:\oracle\instantclient_11_2
set TNS_ADMIN=D:\oracle\instantclient_11_2
set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
start plsqldev.exe

5、打开start.bat，tools=>preferences，修改OCIlirary为D:\oracle\instantclient_11_2\oci.dll