tnsnames.ora配置文件

最新推荐文章于 2021-04-16 01:24:25 发布

揽峰moc

最新推荐文章于 2021-04-16 01:24:25 发布

阅读量145

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle数据库文章标签：网络数据库

本文链接：https://blog.youkuaiyun.com/big1989wmf/article/details/84244255

Oracle数据库专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍了tnsnames.ora文件中的网络配置内容，包括不同服务的连接描述符设置，如ORCL1、weboa、h5_oadb_test等，并提供了具体的主机名、端口和服务名等参数。


# tnsnames.ora Network Configuration File: E:\app\user\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

weboa =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.111)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


h5_oadb_test =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.100)(PORT = 1530))
    (LOAD_BALANCE = OFF) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oadb)
            (FAILOVER_MODE = 
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
h5_oadb_sandbox =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.101)(PORT = 1530))
    (LOAD_BALANCE = OFF) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oadb)
            (FAILOVER_MODE = 
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )