Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

11g production environment monitoring log alarm problem handling-Subscription for

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. System error 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. 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-341The 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, View the listening log 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 * 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, Check the official document WARNING: Subscription for node down event still pending in Listener Log (document ID 372959.1) officially recommended to close to this 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, the process uses grid users, add a line of SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF to the listener.ora configuration file, and then reload listens to make the configuration file take effect. 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 save exit! 5. Check the monitoring log file and check the monitoring log file again. It is found that the alarm is no longer generated and the problem has been solved. 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 _ 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report