营帐容灾库二节点监听起不来故障处理

容灾库 现场支持 文档编号 现场工作起始日期 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