mql535 发表于 2014-3-6 15:20:52

scan IP 由3个调整为2个,节点1 监听无法启动!!!

环境:
OS:rhel 5.8
db: oracle 11.2.0.4 RAC


以前SCAN IP 有3个

scan.oracle.com   ————>  192.168.9.26/27/28

将scan.oracle.com 拆分为:

scan.oracle.com  ---->192.168.9.26/27
dgscan.oracle.com  ----> 192.168.9.28

然后执行:

srvctl stop scan
srvctl stop scan_listener

srvctl remove scan
srvctl remove scan_listener

srvctl add scan -n dgscan.oracle.com
srvctl add scan_listener

使用netca重建(delete , add )监听。

节点1 监听无法启动,节点2 监听正常:$ srvctl start listener -n ora11g1
PRCR-1013 : Failed to start resource ora.LISTENER.lsnr
PRCR-1064 : Failed to start resource ora.LISTENER.lsnr on node ora11g1
CRS-5016: Process "/oracle/grid/bin/lsnrctl" spawned by agent "/oracle/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/oracle/grid/log/ora11g1/agent/crsd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'ora11g1' failedlog见附件:

目前listener.ora
node 1:LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1))))          # line added by Agent
# listener.ora.ora11g1 Network Configuration File: /oracle/grid/network/admin/listener.ora.ora11g1
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
    )
  )
node 2:LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1))))          # line added by Agent
# listener.ora.ora11g2 Network Configuration File: /oracle/grid/network/admin/listener.ora.ora11g2
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
    )
  )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON             # line added by Agent求指点,哪里配置出现了问题???? 在更改SCAN IP之前是正常的!

mql535 发表于 2014-3-6 15:35:30

node 1:$ cat endpoints_listener.ora
LISTENER1_ORA11G1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.30)(PORT=1521)(IP=FIRST))))          # line added by Agent
LISTENER_ORA11G1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.30)(PORT=1521)(IP=FIRST))))            # line added by Agent
$ node2:$ cat endpoints_listener.ora
LISTENER1_ORA11G2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.32)(PORT=1521)(IP=FIRST))))          # line added by Agent
LISTENER_ORA11G2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.32)(PORT=1521)(IP=FIRST))))           # line added by Agent
$

生生不息 发表于 2014-3-6 16:03:43

node1的listener.ora 和node2的listener.ora 不一样,少一行
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON             # line added by Agent
你修改后再试试看

mql535 发表于 2014-3-6 16:10:17

生生不息 发表于 2014-3-6 16:03 static/image/common/back.gif
node1的listener.ora 和node2的listener.ora 不一样,少一行
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON ...

嗯,改过来了,不是这个导致的。$ lsnrctl start listener1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAR-2014 16:06:06

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting /oracle/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /oracle/grid/network/admin/listener.ora
Log messages written to /oracle/orabase/diag/tnslsnr/ora11g1/listener1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER1)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1)))
TNS-01153: Failed to process string: àÊP

mql535 发表于 2014-3-7 09:50:30

此贴已有结果!
原因是在修改hosts文件的时候节点1配置重复导致。

生生不息 发表于 2014-3-7 11:07:35

在listener.ora中 添加 TRACE_LEVEL_LISTENER = SUPPORT, 再次启动 listener,会生成 trace文件, 把 trace文件传上来 看看。
页: [1]
查看完整版本: scan IP 由3个调整为2个,节点1 监听无法启动!!!