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.

6 comments:

  1. Virtual Assistant Services I would like to say that this blog really convinced me to do it! Thanks, very good post.

    ReplyDelete
  2. virtual office space Boston I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here.

    ReplyDelete
  3. Live telephone answering service Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

    ReplyDelete
  4. I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. Best virtual mailbox service massachusetts

    ReplyDelete
  5. That is the place where the arrangements designer can help. They will likewise need to work near characterize the information word reference that the framework will utilize. https://onohosting.com/

    ReplyDelete
  6. The distinction will in general be in the focal point of the two jobs. Database directors are answerable for the wellbeing of the database and the information it makes due.https://hostinglelo.in/

    ReplyDelete