win7安装plsql



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连接。