win7 安装plsql
下载:PLSQLDeveloper_解压版.zip
1、安装64位 oracle
环境:
为plsql配置路径:
set path=D:\install\PLSQLDeveloper\PLSQL\instantclient_11_2
set ORACLE_HOME=D:\install\PLSQLDeveloper\PLSQL\instantclient_11_2
set TNS_ADMIN=D:\install\PLSQLDeveloper\PLSQL\instantclient_11_2
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 (or AMERICAN_AMERICA.ZHS16GBK)
本地oracle:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
远程ip
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
如果连接远程oracle,需要配置4个环境,加tnsnames.ora。
如果连接本地win7的oracle,先去掉4个环境,oracle服务才可以启动,再配置4个环境,使用plsql连接。