11g生產(chǎn)環(huán)境監(jiān)聽日志告警問題處理-Subscription?for

1、系統(tǒng)報錯
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、查看監(jiān)聽日志
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)
官方建議關(guān)閉到這個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監(jiān)聽，使配置文件生效。
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、查看監(jiān)聽日志文件
再次查看監(jiān)聽日志文件，發(fā)現(xiàn)告警已經(jīng)不再產(chǎn)生，問題得以解決。
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