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

botang

/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. 
   
4. L2 =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
   
7.   )
   
8. 
   
9. ADR_BASE_L2 = /u01/app/oracle
   
10. 
    
11. SID_LIST_LISTENER =
    
12.   (SID_LIST =
    
13.     (SID_DESC =
    
14.       (GLOBAL_DBNAME = emrep)
    
15.       (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
    
16.       (SID_NAME = emrep)
    
17.     )
    
18.   )
    
19. 
    
20. 
    
21. SID_LIST_L2 =
    
22.   (SID_LIST =
    
23.     (SID_DESC =
    
24.       (GLOBAL_DBNAME = emrep)
    
25.       (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
    
26.       (SID_NAME = emrep)
    
27.     )
    
28.   )
    
29. 
    
30. 
    
31. 
    
32. 
    
33. 
    
34. LISTENER =
    
35.   (DESCRIPTION_LIST =
    
36.     (DESCRIPTION =
    
37.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
38.     )
    
39.     (DESCRIPTION =
    
40.       (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
    
41.     )
    
42.   )
    
43. 
    
44. ADR_BASE_LISTENER = /u01/app/oracle
    
45. 
    
46. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    
47. 
    
48. 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. 
   
4. 
   
5. 
   
6. for_l2=
   
7. (DESCRIPTION =
   
8.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
   
9.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
   
10.   )
    

复制代码

/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. 
   
4. ORCL =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
   
7.     (CONNECT_DATA =
   
8.       (SERVER = DEDICATED)
   
9.       (SERVICE_NAME = orcl.example.com)
   
10.     )
    
11.   )
    
12. 
    
13. 
    
14. 
    
15. for_l2=
    
16. (DESCRIPTION =
    
17.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
    
18.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
    
19.   )
    

复制代码

/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. 
   
4. EMREP =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
   
7.     (CONNECT_DATA =
   
8.       (SERVER = DEDICATED)
   
9.       (SERVICE_NAME = emrep)
   
10.     )
    
11.   )
    
12. 
    
13. 
    
14. EMREP2 =
    
15.   (DESCRIPTION =
    
16.     (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1526))
    
17.     (CONNECT_DATA =
    
18.       (SERVER = DEDICATED)
    
19.       (SERVICE_NAME = emrep)
    
20.     )
    
21.   )
    
22. 
    
23. 
    
24. 
    
25. 
    
26. 
    
27. 
    
28. 
    
29. LISTENER_EMREP =
    
30.   (ADDRESS = (PROTOCOL = TCP)(HOST = station20.example.com)(PORT = 1521))
    
31. 
    

复制代码

[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