Bo's Oracle Station

查看: 1503|回复: 0

活动第5/6次(2018-03-24星期六上下午)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2018-3-25 16:11:53 | 显示全部楼层 |阅读模式
/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora:
  1. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.

  3. L2 =
  4.   (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
  6.   )

  7. ADR_BASE_L2 = /u01/app/oracle

  8. SID_LIST_LISTENER =
  9.   (SID_LIST =
  10.     (SID_DESC =
  11.       (GLOBAL_DBNAME = emrep)
  12.       (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
  13.       (SID_NAME = emrep)
  14.     )
  15.   )


  16. SID_LIST_L2 =
  17.   (SID_LIST =
  18.     (SID_DESC =
  19.       (GLOBAL_DBNAME = emrep)
  20.       (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
  21.       (SID_NAME = emrep)
  22.     )
  23.   )





  24. LISTENER =
  25.   (DESCRIPTION_LIST =
  26.     (DESCRIPTION =
  27.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  28.     )
  29.     (DESCRIPTION =
  30.       (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
  31.     )
  32.   )

  33. ADR_BASE_LISTENER = /u01/app/oracle

  34. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  35. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2=ON                # line added by Agent
复制代码
/u01/app/oracle/product/11.2.0/grid/network/admin/tnsnames.ora:
  1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  2. # Generated by Oracle configuration tools.



  3. for_l2=
  4. (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
  6.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
  7.   )
复制代码
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora:
  1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  2. # Generated by Oracle configuration tools.

  3. ORCL =
  4.   (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
  6.     (CONNECT_DATA =
  7.       (SERVER = DEDICATED)
  8.       (SERVICE_NAME = orcl.example.com)
  9.     )
  10.   )



  11. for_l2=
  12. (DESCRIPTION =
  13.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
  14.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
  15.   )
复制代码
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora:
  1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
  2. # Generated by Oracle configuration tools.

  3. EMREP =
  4.   (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
  6.     (CONNECT_DATA =
  7.       (SERVER = DEDICATED)
  8.       (SERVICE_NAME = emrep)
  9.     )
  10.   )


  11. EMREP2 =
  12.   (DESCRIPTION =
  13.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
  14.     (CONNECT_DATA =
  15.       (SERVER = DEDICATED)
  16.       (SERVICE_NAME = emrep)
  17.     )
  18.   )







  19. LISTENER_EMREP =
  20.   (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))

复制代码
[oracle@station20 ~]$  . oraenv
ORACLE_SID = [oracle] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[oracle@station20 ~]$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-MAR-2018 09:53:42

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "emrep" has 1 instance(s).
  Instance "emrep", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:348 refused:0
         LOCAL SERVER
Service "orcl.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: station20.example.com, pid: 4872>
         (ADDRESS=(PROTOCOL=tcp)(HOST=station20.example.com)(PORT=33615))
The command completed successfully


--------------------------------
[oracle@station20 ~]$ lsnrctl services l2

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-MAR-2018 09:54:05

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station20.example.com)(PORT=1526)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "emrep" has 1 instance(s).
  Instance "emrep", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: station20.example.com, pid: 4872>
         (ADDRESS=(PROTOCOL=tcp)(HOST=station20.example.com)(PORT=33615))
The command completed successfully


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 03:52 , Processed in 0.039061 second(s), 24 queries .

快速回复 返回顶部 返回列表