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

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

1、系统报错

Command: failed        stdout: yes           stderr: no

Before 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 size

backup: 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 sp

ecified number is not valid for this command.

2、查看监听日志

HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$ tail -f listener.log

04-APR-2018 09:10:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

04-APR-2018 09:10:32 * service_register * LsnrAgt * 1195

TNS-01195: Listener rejected registration of endpoint "(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxxxxxxxx)(PORT=1521)(IP=FIRST))"

WARNING: Subscription for node down event still pending

04-APR-2018 09:10:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

Wed Apr 04 09:10:53 2018

04-APR-2018 09:10:53 * service_register * mgrdb * 0

04-APR-2018 09:10:53 * service_register * hisdb * 0

04-APR-2018 09:10:57 * service_register * +ASM * 0

04-APR-2018 09:10:59 * service_update * mgrdb * 0

Wed Apr 04 09:11:33 2018

WARNING: Subscription for node down event still pending

3、查看官方文档

WARNING: Subscription for node down event still pending in Listener Log (文档 ID 372959.1)

官方建议关闭到这个feature

These 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 listener

HISMNG:/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/oracle

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF   #line added by manual

保存退出！

5、查看监听日志文件

再次查看监听日志文件，发现告警已经不再产生，问题得以解决。

HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$ tail -f listener.log

Trace level is currently 0

Log messages written to /opt/oracle/diag/tnslsnr/HISMNG/listener/alert/log.xml

04-APR-2018 09:20:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=listener)(VERSION=186647296)) * reload * 0

04-APR-2018 09:20:30 * service_register * mgrdb * 0

04-APR-2018 09:20:30 * service_register * hisdb * 0

04-APR-2018 09:20:30 * service_register * +ASM * 0

04-APR-2018 09:20:38 * service_update * mgrdb * 0

Wed Apr 04 09:20:38 2018

04-APR-2018 09:20:38 * service_update * hisdb * 0

04-APR-2018 09:20:47 * service_update * hisdb * 0

Wed Apr 04 09:20:59 2018

04-APR-2018 09:20:59 * service_update * hisdb * 0

04-APR-2018 09:21:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

Wed Apr 04 09:21:38 2018

04-APR-2018 09:21:38 * service_update * hisdb * 0

Wed Apr 04 09:22:02 2018

04-APR-2018 09:22:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

04-APR-2018 09:22:08 * service_update * hisdb * 0

Wed Apr 04 09:22:52 2018

04-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 * 0

04-APR-2018 09:22:59 * service_update * hisdb * 0

04-APR-2018 09:23:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

©著作权归作者所有：来自51CTO博客作者roidba的原创作品，如需转载，请注明出处，否则将追究法律责任