Oracle-RAC管理和维护.docx

工具介绍 OEM（略） ASMasm管理维护工具asmcaasmcmdsqlplus第一次分享讲过。（略）监听lsnrctl查看帮助信息：[grid@ux1 ~]$ lsnrctl helpLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-JUN-2017 10:58:58Copyright (c) 1991, 2013, Oracle. All rights reserved.The following operations are availableAn asterisk (*) denotes a modifier or extended command:start stop statusservices version reloadsave_config trace spawnchange_password quit exitset* show*可以直接使用：lsnrctl startlsnrctl stoplsnrctl statuslsnrctl services……[grid@ux1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-JUN-2017 11:36:28Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date 22-JUN-2017 11:17:22Uptime 0 days 0 hr. 19 min. 5 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/11.2.0/grid/network/admin/listener.oraListener Log File /u01/app/grid/diag/tnslsnr/ux1/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.30)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.32)(PORT=1521)))Services Summary...Service +ASM has 1 instance(s). Instance +ASM1, status READY, has 1 handler(s) for this service...Service myrac has 1 instance(s). Instance rac1, status READY, has 1 handler(s) for this service...Service racXDB has 1 instance(s). Instance rac1, status READY, has 1 handler(s) for this service...The command completed successfully有两个服务+ASM 和 myrac，对应两个实例 +ASM1 和 rac1READY说明是动态注册。常见问题：监听注册不了的解决办法（讲解）。监听日志文件查看 /u01/app/grid/diag/tnsls