oracle客户端连接配置指南

1.看PL/SQL Developer是32|64下载对应的instantclient-basic-win32-11.2.0.1.0.zip
2.解压instantclient-basic-win32-11.2.0.1.0.zip到目录
3.配置环境变量
Path C:\softs\instantclient_11_2
TNS_ADMIN C:\softs\instantclient_11_2
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4.在目录下放tnsnames.ora文件配置数据库连接参数

LISTENER_ORCLDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.120.65.244)(PORT = 1521))
  
#Me Do
LOCAL_ORCLDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcldb)
    )
  )

IP_ORCLDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.120.65.244)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.121.2.105)
    )
  )

注意：

jdbc连接信息，一定要把as sysdba带上：

10.120.65.244:1521
orcl.121.2.105
sys as sysdba

不要忘记配置监听，使oracle可以远程连接。

注意：本文归作者所有，未经作者允许，不得转载