设置Oracle连接别名

设置oracle连接别名

设置地址

如果是oracle

C:\app\Administrator\product\11.2.0\client_1\Network\Admin\tnsnames.ora

如果是instance_client 其中 network和admin需要自己新增

D:\Tools\instantclient_11_2\network\admin\tnsnames.ora

内容

db =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <ip>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  )