oracle静态监听配置模板

最新推荐文章于 2024-02-27 15:09:33 发布

忘的比学的还快

最新推荐文章于 2024-02-27 15:09:33 发布

阅读量534

点赞数 2

分类专栏： Oracle 文章标签： oracle 数据库 dba

本文链接：https://blog.youkuaiyun.com/levis___/article/details/127871076

版权

Oracle 专栏收录该内容

2 篇文章

订阅专栏

oracle监听模板

listener.ora模板

监听文件路径：
/u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
或者$ORACLE_home/network/admin/listener.ora

LISTENER_L1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_L1))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1522)(IP = FIRST)))))          
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_L1=ON          # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_L1=SUBNET            # line added by Agent

SID_LIST_LISTENER_L1 =
  (SID_LIST =
    (SID_DESC =
     (GLOBAL_DBNAME = ora19c)
     (ORACLE_HOME = /u01/app/oracle/product/19.3/dbhome_1/)
     (SID_NAME= ora19c)
   )
  )

配置客户端

tnsnames.ora模板

tnsnames.ora文件路径：
/u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
或者$ORACLE_home/network/admin/tnsnames.ora

ORA19C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora19c)
    )
  )