Wednesday, 29 October 2014

PRCN-2065 : Port(s) 1521 are not available on the nodes given

Error:--

INFO: Problem in configuration: PRCN-2061 : Failed to add listener ora.LISTENER.lsnr
INFO: PRCN-2065 : Port(s) 1521 are not available on the nodes given
INFO: PRCN-2067 : Port 1521 is not available across node(s) "hww-poc1-VIP,hww-poc2-VIP"
INFO: Oracle Net Listener Startup:
INFO:     Listener does not exists.
INFO: Check the trace file for details: /home/grid/app/grid/cfgtoollogs/netca/trace_Ora11g_gridinfrahome1-1410287PM2700.log
INFO: Oracle Net Services configuration failed.  The exit code is 1




I had a similar issue to this. It turned out the tns listener had already started on the VIP address on the both nodes.


[root@test-poc1 ~]# ps -ef | grep tns
root        165      2  0 Oct27 ?        00:00:00 [netns]
grid      80554      1  0 19:23 ?        00:00:00 /home/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
root      83352  62292  0 19:33 pts/2    00:00:00 grep tns


[root@test-poc2 ~]# ps -ef | grep tns
root        165      2  0 Oct27 ?        00:00:00 [netns]
grid      80554      1  0 19:23 ?        00:00:00 /home/11.2.0/grid/bin/tnslsnr LISTENER_SCA2 -inherit
root      83352  62292  0 19:33 pts/2    00:00:00 grep tns
 

Check below command :--
if 1521 port assign to other ip like below show in bold. 

[root@test-poc1 ~]# netstat -nltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
tcp        0      0 0.0.0.0:000                 0.0.0.0:*                   LISTEN      9774/rpcbind
tcp        0      0 00.100.10.00:1521           0.0.0.0:*                   LISTEN      80554/tnslsnr
tcp        0      0 0.0.0.0:5522                0.0.0.0:*                   LISTEN      33613/sshd

Kill the SCAN listner & stop/disable listner process in both node using below command :-

[grid@test-poc1 ~]$ /home/11.2.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node hww-poc1
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node hww-poc2

[grid@test-poc1 ~]$ /home/11.2.0/grid/bin/srvctl stop scan_listener

[grid@test-poc1 ~]$ /home/11.2.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is not running

[grid@test-poc1 ~]$ /home/11.2.0/grid/bin/srvctl disable scan_listener

[grid@test-poc1 ~]$  /home/11.2.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is disabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is disabled
SCAN listener LISTENER_SCAN2 is not running


then re-try the Oracle Net Configuration Assistant step allowed me to continue.

No comments:

Post a Comment