---
---问题:监听被莫名奇妙定时停掉
---
---listener.log节选
。。。。。。
25-AUG-2007 04:51:06 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=wyfaix01)(USER=orcl))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * stop * 0
。。。。。。
---发现可疑点:25-AUG-2007 04:51:06 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=wyfaix01)(USER=orcl))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERS
ION=135294976)) * stop * 0
---去270(即wyfaix01)里查看
---aix中crontab设定的备份任务仍在运行
# crontab -e
"/tmp/crontabSE0iMa" 23 lines, 1729 characters
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: (CMDCNTL) commands needed for basic system needs
#
# FUNCTIONS:
#
# ORIGINS: 27
#
# (C) COPYRIGHT International Business Machines Corp. 1989,1994
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
#0 3 * * * /usr/sbin/skulker
#45 2 * * 0 /usr/lib/spell/compress
#45 23 * * * ulimit 5000; /usr/lib/smdemon.cleanu > /dev/null
0 11 * * * /usr/bin/errclear -d S,O 30
0 12 * * * /usr/bin/errclear -d H 90
#00 3 * * * /oracle73/app/oracle/product/7.3.4/bin/autobak
#00 5 * * * /oracle/script/autobak
#* * * * 6 su - orcl -c /home/orcl/health_check/health.sh
~
---备份脚本里设定每周六做冷备,之前要做dbshut,即同时关掉监听,而后的dbstart里监听没起来。
echo "execute CDdbshut....."
#su - oracle73 -c CDdbshut
su - orcl -c dbshut
---查看监听文件$ORACLE_HOMENETWORKADMINlistener.ora,HOST = wyfaix01
$ vi listener.ora
"listener.ora" 31 lines, 687 characters
# LISTENER.ORA Network Configuration File: /u01/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wyfaix01)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = wyf)
(ORACLE_HOME = /u01/product/8.1.7)
(SID_NAME = wyf)
)
)
direct_handoff_ttc_listener=off
---查看/etc/hosts文件域名解析
$ vi /etc/hosts
"hosts" [Read only] 56 lines, 1918 characters
# @(#)47 1.1 src/bos/usr/sbin/netstart/hosts, cmdnet, bos430, 9737A_430 7/24/91 10:00:46
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos430 src/bos/usr/sbin/netstart/hosts 1.1
#
# Licensed Materials - Property of IBM
#
# (C) COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 26 27
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# /etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network. This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file. It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
# The format of this file is:
# Internet Address Hostname # Comments
# Items are separated by any number of blanks and/or tabs. A
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30383/viewspace-966491/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30383/viewspace-966491/