zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

PLSQL 配置连接ORACLE数据库

2023-09-11 14:16:57 时间

http://blog.csdn.net/leather0906/article/details/6456095

PLSQL配置登录用户信息

http://www.2cto.com/database/201208/151708.html

 

配置环境变量 TNS_ADMIN D:\OracleClient

在改目录下配置链接文件 TNSNAMES.ORA 

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.117)(PORT = 1521))


EASYCONC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.117)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = easyconc)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ZHIYUANZHE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 211.137.44.38)(PORT = 1523))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ZHIYUANZHE)
    )
  )

ShenHe=(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

hptax =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 136.16.38.120)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = syzs)
    )
  )

VSTAR =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 136.20.16.62)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = VSTAR)
    )
  )

  

解决乱码问题:配置环境变量 NLS_LANG   SIMPLIFIED CHINESE_CHINA.ZHS16GBK