课程第7次（2016-11-14星期一）

botang

oraenv的用法：

1. [root@station90 桌面]# vim /etc/oratab
   
2. [root@station90 桌面]# su - oracle
   
3. [oracle@station90 ~]$ . oraenv
   
4. ORACLE_SID = [orcl] ? rcat
   
5. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
   

复制代码

监听器和pmon的关系：

1. [oracle@station90 ~]$ ps aux | grep pmon
   
2. oracle    1384  0.0  0.0 103304  2144 pts/3    S+   19:59   0:00 grep pmon
   
3. oracle   10691  0.0  0.2 478736 44016 ?        Ss   19:20   0:00 asm_pmon_+ASM
   
4. oracle   10858  0.0  0.3 6834040 48984 ?       Ss   19:20   0:00 ora_pmon_orcl
   
5. oracle   23180  0.0  0.3 1789856 49948 ?       Ss   19:43   0:00 ora_pmon_rcat
   
6. [oracle@station90 ~]$ lsnrctl services
   
7. 
   
8. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-NOV-2016 20:01:28
   
9. 
   
10. Copyright (c) 1991, 2009, Oracle.  All rights reserved.
    
11. 
    
12. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
    
13. Services Summary...
    
14. Service "+ASM" has 1 instance(s).
    
15.   Instance "+ASM", status READY, has 1 handler(s) for this service...
    
16.     Handler(s):
    
17.       "DEDICATED" established:58 refused:0 state:ready
    
18.          LOCAL SERVER
    
19. Service "orcl.example.com" has 1 instance(s).
    
20.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
21.     Handler(s):
    
22.       "DEDICATED" established:53 refused:0 state:ready
    
23.          LOCAL SERVER
    
24. Service "orclXDB.example.com" has 1 instance(s).
    
25.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
26.     Handler(s):
    
27.       "D000" established:0 refused:0 current:0 max:1022 state:ready
    
28.          DISPATCHER <machine: station90.example.com, pid: 10896>
    
29.          (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=26631))
    
30. Service "rcat.example.com" has 1 instance(s).
    
31.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
32.     Handler(s):
    
33.       "DEDICATED" established:0 refused:0 state:ready
    
34.          LOCAL SERVER
    
35. Service "rcatXDB.example.com" has 1 instance(s).
    
36.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
37.     Handler(s):
    
38.       "D000" established:0 refused:0 current:0 max:1022 state:ready
    
39.          DISPATCHER <machine: station90.example.com, pid: 23212>
    
40.          (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=2751))
    
41. The command completed successfully
    

复制代码

监听器的管理命令：

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ cd $TNS_ADMIN
   
3. [oracle@station90 admin]$ pwd
   
4. /u01/app/oracle/product/11.2.0/grid/network/admin
   
5. [oracle@station90 admin]$ ls
   
6. listener.ora  listener.ora.bak.station90  samples  shrept.lst
   
7. [oracle@station90 admin]$ lsnrctl stop
   
8. 
   
9. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-NOV-2016 20:17:35
   
10. 
    
11. Copyright (c) 1991, 2009, Oracle.  All rights reserved.
    
12. 
    
13. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
    
14. The command completed successfully
    
15. [oracle@station90 admin]$ crs_stat -t
    
16. Name           Type           Target    State     Host        
    
17. ------------------------------------------------------------
    
18. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
19. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
20. ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               
    
21. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
22. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
23. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
24. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
25. [oracle@station90 admin]$ crs_stat -p | grep lsnr
    
26. NAME=ora.LISTENER.lsnr
    
27. [oracle@station90 admin]$ crsctl start  res ora.LISTENER.lsnr
    
28. CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'station90'
    
29. CRS-2676: Start of 'ora.LISTENER.lsnr' on 'station90' succeeded
    
30. [oracle@station90 admin]$ lsnrctl services
    
31. 
    
32. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-NOV-2016 20:19:40
    
33. 
    
34. Copyright (c) 1991, 2009, Oracle.  All rights reserved.
    
35. 
    
36. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
    
37. Services Summary...
    
38. Service "+ASM" has 1 instance(s).
    
39.   Instance "+ASM", status READY, has 1 handler(s) for this service...
    
40.     Handler(s):
    
41.       "DEDICATED" established:0 refused:0 state:ready
    
42.          LOCAL SERVER
    
43. Service "orcl.example.com" has 1 instance(s).
    
44.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
45.     Handler(s):
    
46.       "DEDICATED" established:0 refused:0 state:ready
    
47.          LOCAL SERVER
    
48. Service "orclXDB.example.com" has 1 instance(s).
    
49.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
50.     Handler(s):
    
51.       "D000" established:0 refused:0 current:0 max:1022 state:ready
    
52.          DISPATCHER <machine: station90.example.com, pid: 10896>
    
53.          (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=26631))
    
54. Service "rcat.example.com" has 1 instance(s).
    
55.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
56.     Handler(s):
    
57.       "DEDICATED" established:0 refused:0 state:ready
    
58.          LOCAL SERVER
    
59. Service "rcatXDB.example.com" has 1 instance(s).
    
60.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
61.     Handler(s):
    
62.       "D000" established:0 refused:0 current:0 max:1022 state:ready
    
63.          DISPATCHER <machine: station90.example.com, pid: 23212>
    
64.          (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=2751))
    
65. The command completed successfully
    
66. [oracle@station90 admin]$ srvctl stop listener
    
67. [oracle@station90 admin]$ crs_stat -t
    
68. Name           Type           Target    State     Host        
    
69. ------------------------------------------------------------
    
70. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
71. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
72. ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               
    
73. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
74. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
75. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
76. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
77. [oracle@station90 admin]$ srvctl start listener
    
78. [oracle@station90 admin]$ crs_stat -t
    
79. Name           Type           Target    State     Host        
    
80. ------------------------------------------------------------
    
81. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
82. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
83. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
    
84. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
85. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
86. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
87. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
88. [oracle@station90 admin]$ ls
    
89. listener.ora  listener.ora.bak.station90  samples  shrept.lst
    
90. [oracle@station90 admin]$ vim listener.ora
    
91. [oracle@station90 admin]$ ls
    
92. listener.ora  listener.ora.bak.station90  samples  shrept.lst
    
93. [oracle@station90 admin]$ srvctl status listener
    
94. 监听程序 LISTENER 已启用
    
95. 监听程序 LISTENER 正在节点上运行: station90
    
96. [oracle@station90 admin]$ srvctl stop listener
    
97. [oracle@station90 admin]$ ls
    
98. listener.ora  listener.ora.bak.station90  samples  shrept.lst

复制代码

交互式使用lsnrctl命令：

1. LSNRCTL> help
   
2. The following operations are available
   
3. An asterisk (*) denotes a modifier or extended command:
   
4. 
   
5. start               stop                status              
   
6. services            version             reload              
   
7. save_config         trace               spawn               
   
8. change_password     quit                exit               
   
9. set*                show*               
   
10. 
    
11. LSNRCTL> set -h
    
12. NL-00853: undefined set command "-h".  Try "help set"
    
13. LSNRCTL> help set
    
14. The following operations are available after set
    
15. An asterisk (*) denotes a modifier or extended command:
    
16. 
    
17. password                           rawmode                           
    
18. displaymode                        trc_file                           
    
19. trc_directory                      trc_level                          
    
20. log_file                           log_directory                     
    
21. log_status                         current_listener                  
    
22. inbound_connect_timeout            startup_waittime                  
    
23. save_config_on_stop                dynamic_registration               
    
24. enable_global_dynamic_endpoint     
    
25. 
    
26. LSNRCTL> set current_listener l2
    
27. Current Listener is l2
    
28. LSNRCTL> status
    
29. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.90)(PORT=1522)))
    
30. STATUS of the LISTENER
    
31. ------------------------
    
32. Alias                     L2
    
33. Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    
34. Start Date                14-NOV-2016 21:16:17
    
35. Uptime                    0 days 0 hr. 12 min. 57 sec
    
36. Trace Level               off
    
37. Security                  ON: Local OS Authentication
    
38. SNMP                      OFF
    
39. Listener Parameter File   /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
    
40. Listener Log File         /u01/app/oracle/diag/tnslsnr/station90/l2/alert/log.xml
    
41. Listening Endpoints Summary...
    
42.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.90)(PORT=1522)))
    
43. Services Summary...
    
44. Service "+ASM" has 1 instance(s).
    
45.   Instance "+ASM", status READY, has 1 handler(s) for this service...
    
46. Service "orcl.example.com" has 2 instance(s).
    
47.   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    
48.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
49. Service "orclXDB.example.com" has 1 instance(s).
    
50.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
51. Service "rcat.example.com" has 2 instance(s).
    
52.   Instance "rcat", status UNKNOWN, has 1 handler(s) for this service...
    
53.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
54. Service "rcatXDB.example.com" has 1 instance(s).
    
55.   Instance "rcat", status READY, has 1 handler(s) for this service...
    
56. The command completed successfully
    
57. LSNRCTL> exit
    

复制代码

在演示环境中的网络配置文件：
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 = 192.168.0.90)(PORT = 1522))
   
7.   )
   
8. 
   
9. SID_LIST_LISTENER =
   
10.   (SID_LIST =
    
11.     (SID_DESC =
    
12.       (GLOBAL_DBNAME = orcl.example.com)
    
13.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
14.       (SID_NAME = orcl)
    
15.     )
    
16.     (SID_DESC =
    
17.       (GLOBAL_DBNAME = rcat.example.com)
    
18.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
19.       (SID_NAME = rcat)
    
20.     )
    
21.   )
    
22. 
    
23. ADR_BASE_L2 = /u01/app/oracle
    
24. 
    
25. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2 = ON
    
26. 
    
27. LISTENER =
    
28.   (DESCRIPTION_LIST =
    
29.     (DESCRIPTION =
    
30.       (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
    
31.     )
    
32.     (DESCRIPTION =
    
33.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
34.     )
    
35.   )
    
36. 
    
37. ADR_BASE_LISTENER = /u01/app/oracle
    
38. 
    
39. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    
40. 
    
41. SID_LIST_L2 =
    
42.   (SID_LIST =
    
43.     (SID_DESC =
    
44.       (GLOBAL_DBNAME = orcl.example.com)
    
45.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
46.       (SID_NAME = orcl)
    
47.     )
    
48.     (SID_DESC =
    
49.       (GLOBAL_DBNAME = rcat.example.com)
    
50.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
51.       (SID_NAME = rcat)
    
52.     )
    
53.   )
    

复制代码

服务器上的tnsnames.ora：

1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/tnsnames.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. RCAT =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS_LIST =
   
7.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
   
8.     )
   
9.     (CONNECT_DATA =
   
10.       (SERVICE_NAME = rcat.example.com)
    
11.     )
    
12.   )
    
13. 
    
14. ORCL =
    
15.   (DESCRIPTION =
    
16.     (ADDRESS_LIST =
    
17.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
18.     )
    
19.     (CONNECT_DATA =
    
20.       (SERVICE_NAME = orcl.example.com)
    
21.     )
    
22.   )
    
23. 
    
24. 
    
25. fordb =
    
26.    (DESCRIPTION =
    
27.     (ADDRESS_LIST =
    
28.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
29.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
30.     )
    
31.   )
    

复制代码

windows上的tnsnames.ora：

1. # tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. ORACLR_CONNECTION_DATA =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS_LIST =
   
7.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
   
8.     )
   
9.     (CONNECT_DATA =
   
10.       (SID = CLRExtProc)
    
11.       (PRESENTATION = RO)
    
12.     )
    
13.   )
    
14. 
    
15. DOG =
    
16.   (DESCRIPTION =
    
17.     (ADDRESS_LIST =
    
18.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
19.     )
    
20.     (CONNECT_DATA =
    
21.       (SERVICE_NAME = rcat.example.com)
    
22.     )
    
23.   )
    
24. 
    
25. CAT =
    
26.   (DESCRIPTION =
    
27.     (ADDRESS_LIST =
    
28.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
29.     )
    
30.     (CONNECT_DATA =
    
31.       (SERVICE_NAME = orcl.example.com)
    
32.     )
    
33.   )
    
34. 
    
35. WOLF =
    
36.   (DESCRIPTION =
    
37.     (ADDRESS_LIST =
    
38.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
39.     )
    
40.     (CONNECT_DATA =
    
41.       (SERVICE_NAME = orcl.example.com)
    
42.     )
    
43.   )
    
44. 
    
45. TIGER =
    
46.   (DESCRIPTION =
    
47.     (ADDRESS_LIST =
    
48.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
49.     )
    
50.     (CONNECT_DATA =
    
51.       (SERVICE_NAME = rcat.example.com)
    
52.     )
    
53.   )
    
54. 
    
55. 
    
56. UTFORCL =
    
57.   (DESCRIPTION =
    
58.     (ADDRESS_LIST =
    
59.       (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
    
60.     )
    
61.     (CONNECT_DATA =
    
62.       (SERVER = DEDICATED)
    
63.       (SERVICE_NAME = utforcl.example.com)
    
64.     )
    
65.   )
    
66. 
    
67. ORCL =
    
68.   (DESCRIPTION =
    
69.     (ADDRESS_LIST =
    
70.       (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
    
71.     )
    
72.     (CONNECT_DATA =
    
73.       (SERVER = DEDICATED)
    
74.       (SERVICE_NAME = orcl.example.com)
    
75.     )
    
76.   )
    
77. 
    

复制代码

注册监听器到集群件：

1. [oracle@station90 admin]$ srvctl add listener -l l2 -p TCP:1522

复制代码

注册数据库服务器到集群件：

1. [oracle@station90 admin]$ srvctl add database -d rcat -o /u01/app/oracle/product/11.2.0/dbhome_1

复制代码

在演示环境中的实例参数设置：
rcat.example.com：

1. SQL> alter system set local_listener=fordb;
   
2. 
   
3. System altered.

复制代码

注册监听器到集群件：

1. [oracle@station90 admin]$ srvctl add listener -l l2 -p TCP:1522

复制代码

注册数据库服务器到集群件：

1. [oracle@station90 admin]$ srvctl add database -d rcat -o /u01/app/oracle/product/11.2.0/dbhome_1

复制代码

在演示环境中的实例参数设置：
rcat.example.com：

1. SQL> alter system set local_listener=fordb;
   
2. 
   
3. System altered.

复制代码

orcl.example.com：

1. SQL> alter system set local_listener=fordb;
   
2. 
   
3. System altered.

复制代码