1、在PL/SQL的安装路径中放入"instantclient_11_2"文件,这个文件中配置了远程数据路的配置信息。

listener.ora文件

# listener.ora Network Configuration File: H:\app\JJ\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = H:\app\JJ\product\11.2.0\dbhome_1)  #远程数据库的位置
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:H:\app\JJ\product\11.2.0\dbhome_1\bin\oraclr11.dll")  #远程数据库的位置
    )
    (SID_DESC=
    (SID_NAME = ORCL)
    (ORACLE_HOME = H:\app\JJ\product\11.2.0\dbhome_1)  #远程数据库的位置
    (GLOBAL_DBNAME = ORCL))
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.22.199)(PORT = 1521))  #远程数据库的ip和端口
    )
  )

ADR_BASE_LISTENER = H:\app\JJ

tnsnames.ora文件

# tnsnames.ora Network Configuration File: H:\app\JJ\product\11.2.0\dbhome_1\network\admin\tnsnames.ora  #远程数据库tnsnames。ora文件位置
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.22.199)(PORT = 1521))  #远程数据库IP和端口


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.22.199)(PORT = 1521)) #远程数据库IP和端口
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

2、计算机环境配置: 

新建变量名:NLS_LANG

变量值: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

新建变量名:ORACLE_HOME

变量值: 本机配置的instantcliet_*_*的路径

新建变量名:TNS_ADMIN

变量值: 本机配置的instantcliet_*_*路径\NETWORK\ADMIN

instantclietn文件

 

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐