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

mql535

环境：
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 监听正常：

1. [grid@ora11g1 ~]$ srvctl start listener -n ora11g1
   
2. PRCR-1013 : Failed to start resource ora.LISTENER.lsnr
   
3. PRCR-1064 : Failed to start resource ora.LISTENER.lsnr on node ora11g1
   
4. 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"
   
5. CRS-2674: Start of 'ora.LISTENER.lsnr' on 'ora11g1' failed

复制代码

log见附件：

目前listener.ora
node 1:

1. LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1))))          # line added by Agent
   
2. # listener.ora.ora11g1 Network Configuration File: /oracle/grid/network/admin/listener.ora.ora11g1
   
3. # Generated by Oracle configuration tools.
   
4. 
   
5. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
   
6. 
   
7. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
   
8. 
   
9. LISTENER_SCAN1 =
   
10.   (DESCRIPTION =
    
11.     (ADDRESS_LIST =
    
12.       (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
    
13.     )
    
14.   )
    

复制代码

node 2:

1. LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1))))          # line added by Agent
   
2. # listener.ora.ora11g2 Network Configuration File: /oracle/grid/network/admin/listener.ora.ora11g2
   
3. # Generated by Oracle configuration tools.
   
4. 
   
5. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
   
6. 
   
7. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
   
8. 
   
9. LISTENER_SCAN1 =
   
10.   (DESCRIPTION =
    
11.     (ADDRESS_LIST =
    
12.       (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
    
13.     )
    
14.   )
    
15. 
    
16. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON             # line added by Agent

复制代码

求指点，哪里配置出现了问题？？？？ 在更改SCAN IP之前是正常的！

mql535

node 1:

1. [grid@ora11g1 admin]$ cat endpoints_listener.ora
   
2. 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
   
3. 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
   
4. [grid@ora11g1 admin]$

复制代码

node2:

1. [grid@ora11g2 admin]$ cat endpoints_listener.ora
   
2. 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
   
3. 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
   
4. [grid@ora11g2 admin]$

复制代码

生生不息

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

mql535

生生不息 发表于 2014-3-6 16:03
node1的listener.ora 和node2的listener.ora 不一样，少一行
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON ...

嗯，改过来了，不是这个导致的。

1. [grid@ora11g1 admin]$ lsnrctl start listener1
   
2. 
   
3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAR-2014 16:06:06
   
4. 
   
5. Copyright (c) 1991, 2013, Oracle.  All rights reserved.
   
6. 
   
7. Starting /oracle/grid/bin/tnslsnr: please wait...
   
8. 
   
9. TNSLSNR for Linux: Version 11.2.0.4.0 - Production
   
10. System parameter file is /oracle/grid/network/admin/listener.ora
    
11. Log messages written to /oracle/orabase/diag/tnslsnr/ora11g1/listener1/alert/log.xml
    
12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER1)))
    
13. 
    
14. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1)))
    
15. TNS-01153: Failed to process string: àÊP

复制代码

mql535

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

生生不息

在listener.ora中 添加 TRACE_LEVEL_LISTENER = SUPPORT， 再次启动 listener，会生成 trace文件， 把 trace文件传上来 看看。