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

前端之家收集整理的这篇文章主要介绍了11g生产环境监听日志告警问题处理-Subscription for前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
1、系统报错
Command:Failedstdout:yesstderr:no
Beforecommandcompletion,additionalinstructionsmayappearbelow.
Initializingmkcdlog:/var/adm/ras/mkcd.log...
Verifyingcommandparameters...
Creatingimage.datafile...
Creatingmksysbimage...
Creatinglistoffilestobackup.
.
Backingup143824files..............................
7293of143824files(5%)..............
0512-005mksysb:BackupCompleted.
Thebackupcommandcompletedwitherrors.
ThemessagesdisplayedonStandardErrorcontainedadditional
information.
cp:/BACKUPXXaaa_JarMa:Thereisnotenoughspaceinthefilesystem.
backup:0511-086Cannotcopy./opt/oracle/diag/tnslsnr/HISMNG/listener/trace/listener.logtoatemporarylocation.
backup:0511-084Aninternalpackingerroroccurred:incorrectsize
backup:0511-442./opt/oracle/diag/tnslsnr/HISMNG/listener/trace/listener.logwillnotbebackedup.
ls:0653-341Thefile/nas/sysbackup/hismng/mksysb_17957188doesnotexist.
PopulatingtheCDorDVDfilesystem...
CopyingbackuptotheCDorDVDfilesystem...
copy_backup[46]:total_size=fs_size+BACKUP_SIZE+boot_image_size+EFI_PARTITION_SIZE+PADDING_128K:0403-009Thesp
ecifiednumberisnotvalidforthiscommand.

2、查看监听日志
HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$tail-flistener.log
04-APR-201809:10:32*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296))*status*0
04-APR-201809:10:32*service_register*LsnrAgt*1195
TNS-01195:Listenerrejectedregistrationofendpoint"(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxxxxxxxx)(PORT=1521)(IP=FIRST))"
WARNING:Subscriptionfornodedowneventstillpending
04-APR-201809:10:33*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296))*status*0
WedApr0409:10:532018
04-APR-201809:10:53*service_register*mgrdb*0
04-APR-201809:10:53*service_register*hisdb*0
04-APR-201809:10:57*service_register*+ASM*0
04-APR-201809:10:59*service_update*mgrdb*0
WedApr0409:11:332018
WARNING:Subscriptionfornodedowneventstillpending

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"13lines,356characters
#listener.oraNetworkConfigurationFile:/opt/oracle/product/11203/db/network/admin/listener.ora
#GeneratedbyOracleconfigurationtools.
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#lineaddedbymanual
保存退出!

5、查看监听日志文件
再次查看监听日志文件,发现告警已经不再产生,问题得以解决。
HISMNG:/opt/oracle/diag/tnslsnr/HISMNG/listener/trace$tail-flistener.log
Traceleveliscurrently0
Logmessageswrittento/opt/oracle/diag/tnslsnr/HISMNG/listener/alert/log.xml
04-APR-201809:20:28*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=listener)(VERSION=186647296))*reload*0
04-APR-201809:20:30*service_register*mgrdb*0
04-APR-201809:20:30*service_register*hisdb*0
04-APR-201809:20:30*service_register*+ASM*0
04-APR-201809:20:38*service_update*mgrdb*0
WedApr0409:20:382018
04-APR-201809:20:38*service_update*hisdb*0
04-APR-201809:20:47*service_update*hisdb*0
WedApr0409:20:592018
04-APR-201809:20:59*service_update*hisdb*0
04-APR-201809:21:02*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296))*status*0
WedApr0409:21:382018
04-APR-201809:21:38*service_update*hisdb*0
WedApr0409:22:022018
04-APR-201809:22:02*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296))*status*0
04-APR-201809:22:08*service_update*hisdb*0
WedApr0409:22:522018
04-APR-201809:22:52*(CONNECT_DATA=(SID=hisdb)(CID=(PROGRAM=JDBCThinClient)(HOST=__jdbc__)(USER=root)))*(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.125.2)(PORT=64960))*establish*hisdb*0
04-APR-201809:22:59*service_update*hisdb*0
04-APR-201809:23:02*(CONNECT_DATA=(CID=(PROGRAM=)(HOST=HISMNG)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296))*status*0
原文链接:https://www.f2er.com/oracle/206219.html

猜你在找的Oracle相关文章