11g生产环境监听日志告警问题处理-Subscription for

1、系统报错Command: failed        stdout: yes           stderr: noBefore command completion, additional instructions may appear below.Initializing mkcd log: /var/adm/ras/mkcd.log...Verifying command parameters...Creating image.data file...Creating mksysb image...Creating list of files to back up..Backing up 143824 files..............................7293 of 143824 files (5%)..............0512-005 mksysb: Backup Completed.        The backup command completed with errors.        The messages displayed on Standard Error contained additional        information.cp: /BACKUPXXaaa_JarMa: There is not enough space in the file system.backup: 0511-086 Cannot copy ./opt/oracle/diag/tnslsnr/HISMNG/listener/trace/listener.log to a temporary location.backup: 0511-084 An internal packing error occurred: incorrect sizebackup: 0511-442 ./opt/oracle/diag/tnslsnr/HISMNG/listener/trace/listener.log will not be backed up.ls: 0653-341 The file /nas/sysbackup/hismng/mksysb_17957188 does not exist.Populating the CD or DVD file system...Copying backup to the CD or DVD file system...copy_backup[46]:  total_size = fs_size + BACKUP_SIZE + boot_image_size + EFI_PARTITION_SIZE + PADDING_128K : 0403-009 The specified number is not valid for this command.2、查看监听日志HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$ tail -f listener.log04-APR-2018 09:10:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 004-APR-2018 09:10:32 * service_register * LsnrAgt * 1195TNS-01195: Listener rejected registration of endpoint "(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxxxxxxxx)(PORT=1521)(IP=FIRST))"WARNING: Subscription for node down event still pending04-APR-2018 09:10:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0Wed Apr 04 09:10:53 201804-APR-2018 09:10:53 * service_register * mgrdb * 004-APR-2018 09:10:53 * service_register * hisdb * 004-APR-2018 09:10:57 * service_register * +ASM * 004-APR-2018 09:10:59 * service_update * mgrdb * 0Wed Apr 04 09:11:33 2018WARNING: Subscription for node down event still pending3、查看官方文档WARNING: Subscription for node down event still pending in Listener Log (文档 ID 372959.1)官方建议关闭到这个featureThese messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription.   This feature was introduced in Oracle 10g.4、处理过程使用grid用户，在listener.ora配置文件中添加一行SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF然后reload监听，使配置文件生效。lsnrctl reload listenerHISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$ vi /opt/oracle/product/11203/db/network/admin/listener.ora"/opt/oracle/product/11203/db/network/admin/listener.ora" 13 lines, 356 characters # listener.ora Network Configuration File: /opt/oracle/product/11203/db/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = hmboot)(PORT = 1521))    )  )ADR_BASE_LISTENER = /opt/oracleSUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF   #line added by manual保存退出！5、查看监听日志文件再次查看监听日志文件，发现告警已经不再产生，问题得以解决。HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$ tail -f listener.logTrace level is currently 0Log messages written to /opt/oracle/diag/tnslsnr/HISMNG/listener/alert/log.xml04-APR-2018 09:20:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=listener)(VERSION=186647296)) * reload * 004-APR-2018 09:20:30 * service_register * mgrdb * 004-APR-2018 09:20:30 * service_register * hisdb * 004-APR-2018 09:20:30 * service_register * +ASM * 004-APR-2018 09:20:38 * service_update * mgrdb * 0Wed Apr 04 09:20:38 201804-APR-2018 09:20:38 * service_update * hisdb * 004-APR-2018 09:20:47 * service_update * hisdb * 0Wed Apr 04 09:20:59 201804-APR-2018 09:20:59 * service_update * hisdb * 004-APR-2018 09:21:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0Wed Apr 04 09:21:38 201804-APR-2018 09:21:38 * service_update * hisdb * 0Wed Apr 04 09:22:02 201804-APR-2018 09:22:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 004-APR-2018 09:22:08 * service_update * hisdb * 0Wed Apr 04 09:22:52 201804-APR-2018 09:22:52 * (CONNECT_DATA=(SID=hisdb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.125.2)(PORT=64960)) * establish * hisdb * 004-APR-2018 09:22:59 * service_update * hisdb * 004-APR-2018 09:23:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0