容灾库
现场支持
文档编号
现场工作起始日期
2008年07月09日
现场及场外工作天数
1工作日
现场工程师
李娇华
报告人
李娇华
日期
2008年07月09日
文档控制
修改记录
日期
作者
版本
修改记录
2008年07月09日
李娇华
V1.0
审阅
姓名
职位
分发
拷贝No.
姓名
单位
SR
背景概述
7月9号早晨,宋工启动营帐容灾库2节点监听,报以下错误:
lsnrctl start
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=135.10.34.38)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS rotocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 73: Connection reset by peer
系统环境
硬件平台 & 操作系统
操作系统版本
内存
硬盘
CPU个数
Oracle产品及版本
第三方产品及版本
业务类型
现场支持细节
根据抱错,怀疑有2个原因导致,其一就是lintener.log日志文件太大了,超过2G了,所以无法启动。另外就是 /etc/hosts 下没有 127.0.0.1 loopback localhost 记录
查看lintener.log日志文件:大小远不足2G,第一种可能排除
rzyzdb2:/oracle/app/oracle/product/9.2.0/network/log>ls -lrt
total 24
drwxr-xr-x 2 oracle dba 256 Nov 15 2007 bak
-rw-r--r-- 1 oracle dba 6414 Feb 24 15:32 sqlnet.log
-rw-r--r-- 1 oracle dba 3025 Jul 09 11:38 listener.log
查看/etc/hosts的内容:127.0.0.1 loopback localhost # loopback (lo0) name/address也正常,第二种可能排除
/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 '#'
# indicates the beginning of a comment; characters up to the end of the
# line are not interpreted by routines which search this file. Blank
# lines are allowed.
# Internet Address Hostname # Comments
# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
##rzyzdb1
192.168.103.1 rzyzdb1_boot1
192.168.104.1 rzyzdb1_boot2
172.31.103.1 rzyzdb1_pri1
172.31.104.1 rzyzdb1_pri2
135.10.34.32 rzyzdb1_perm rzyzdb1
135.10.34.33 rzyzdb1_svc
##rzzydb2
192.168.103.2 rzyzdb2_boot1
192.168.104.2 rzyzdb2_boot2
172.31.103.2 rzyzdb2_pri1
172.31.104.2 rzyzdb2_pri2
135.10.34.37 rzyzdb2_perm rzyzdb2
135.10.34.38 rzyzdb2_svc
135.10.34.101 rzyzzjj1
135.10.34.103 rzyzzjj2
135.10.34.113 rzyzht
135.10.34.117 rzyzyj1
135.10.34.118 rzyzyj2
135.10.34.143 RZQDJTKH1
135.10.34.126 RZJFZC2
135.10.34.35 gzoscs
这里依旧尝试了一下,rm lintener.log,在touch一个listener.log,在启动监听
Lsnrctl stop -----先停掉listener
rm listener.log ----cd $ORACLE_HOME/network/log
touch listener.log
lsnrctl start
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=135.10.34.38)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS rotocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 73: Connection reset by peer
报错依旧,查看lintener.log里的记录
09-JUL-2008 12:17:05 * 12546
TNS-12546: TNS ermission denied
TNS-12560: TNS rotocol adapter error
TNS-00516: Permission denied
查看其进程:
rzyzdb2:/oracle/app/oracle/product/9.2.0/network/admin>ps -ef |grep lsnr
oracle 192870 168578 0 12:16:13 pts/9 0:00 grep lsnr
oracle 254244 274714 0 11:06:44 pts/0 0:00 lsnrctl
oracle 242390 1 0 11:06:57 pts/0 0:00 /oracle/app/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit
rzyzdb2:/oracle/app/oracle/product/9.2.0/network/admin>
kill -9 242390
rzyzdb2:/oracle/app/oracle/product/9.2.0/network/log>lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 09-JUL-2008 12:24:21
Copyright 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=135.10.34.38)(PORT=1521)))
TNS-12537: TNS:connection closed
TNS-12560: TNS rotocol adapter error
TNS-00507: Connection closed
查看节点2的sqlnet.ora发现:
rzyzdb2:/oracle/app/oracle/product/9.2.0/network/admin>cat sqlnet.ora
# SQLNET.ORA Network Configuration File: /oracle/app/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TCP.VALIDNODE_CHECKING=YES
TCP.INVITED_NODES = (
######全接入#######
135.10.34.21,
135.10.34.26,
135.10.34.31,
135.10.34.32,
135.10.34.33,
135.10.34.34,
135.10.34.35,
135.10.34.36,
135.10.34.37,
135.10.34.77,
135.10.34.101,
135.10.34.102,
135.10.34.103,
135.10.34.105,
135.10.34.106,
135.10.34.107,
135.10.34.111,
135.10.34.116,
135.10.34.121,
135.10.34.126,
135.10.34.177,
135.10.34.178,
135.10.34.181,
135.10.34.186,
135.10.34.201,
135.10.33.21,
135.10.33.22,
135.10.33.26,
135.10.33.27,
135.10.33.32,
135.10.33.37,
135.10.33.41,
135.10.33.45,
135.10.33.46,
135.10.33.51,
135.10.33.52,
135.10.33.55,
135.10.33.101,
135.10.33.103,
135.10.33.105,
135.10.33.106,
135.10.33.111,
135.10.33.113,
135.10.33.114,
135.10.33.115,
135.10.33.116,
135.10.33.121,
135.10.33.126,
135.10.33.136,
135.10.33.141,
135.10.33.146,
135.10.33.154,
…….
)
从上面内容看到,这里有ip限制的,也就是135.10.34.38不再此内容里,将135.10.34.38添加到sqlnet.ora后,启动正常
�
4
PAGE