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之前是正常的! 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
$ node1的listener.ora 和node2的listener.ora 不一样,少一行
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON # line added by Agent
你修改后再试试看 生生不息 发表于 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 此贴已有结果!
原因是在修改hosts文件的时候节点1配置重复导致。
在listener.ora中 添加 TRACE_LEVEL_LISTENER = SUPPORT, 再次启动 listener,会生成 trace文件, 把 trace文件传上来 看看。
页:
[1]