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.

clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory

Error:--

Failed to create keys in the OLR, rc = 127, Message:
  /home/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory

Failed to create keys in the OLR at /home/11.2.0/grid/crs/install/crsconfig_lib.pm line 7660.
/home/11.2.0/grid/perl/bin/perl -I/home/11.2.0/grid/perl/lib -I/home/11.2.0/grid/crs/install /home/11.2.0/grid/crs/install/rootcrs.pl execution failed

 


Issue :--

[root@test-poc1 ~]# /home/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /home/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /home/11.2.0/grid/crs/install/crsconfig_params
User ignored Prerequisites during installation
Installing Trace File Analyzer
Failed to create keys in the OLR, rc = 127, Message:
  /home/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory

Failed to create keys in the OLR at /home/11.2.0/grid/crs/install/crsconfig_lib.pm line 7660.
/home/11.2.0/grid/perl/bin/perl -I/home/11.2.0/grid/perl/lib -I/home/11.2.0/grid/crs/install /home/11.2.0/grid/crs/install/rootcrs.pl execution failed
[root@test-poc1 ~]#


Solution :--
check below command

# yum list | grep libcap
compat-libcap1.i686 1.10-1 @ol6_ga_base
libcap.i686 2.16-5.2.el6 @ol6_ga_base
libcap.x86_64 2.16-5.2.el6 @anaconda-OracleLinuxServer-201102031546.x86_64/6.0
libcap-devel.i686 2.16-5.2.el6 @ol6_ga_base
libcap-devel.x86_64 2.16-5.2.el6 @ol6_ga_base
libcap-ng.x86_64 0.6.4-3.el6_0.1 @ol6_u1_base
compat-libcap1.x86_64 1.10-1 ol6_ga_base
libcap-ng.i686 0.6.4-3.el6_0.1 ol6_u1_base
libcap-ng-devel.i686 0.6.4-3.el6_0.1 ol6_u1_base
libcap-ng-devel.x86_64 0.6.4-3.el6_0.1 ol6_u1_base
libcap-ng-python.x86_64 0.6.4-3.el6_0.1 ol6_u1_base
libcap-ng-utils.x86_64 0.6.4-3.el6_0.1 ol6_u1_base


Install below 2 pkg & run root.sh again
 

Installed...
# yum install libcap.x86_64
Setting up Install Process
Package libcap-2.16-5.2.el6.x86_64 already installed and latest version
Nothing to do
libcap2 package installed, so install libcab1.
 

# yum install compat-libcap1.x86_64
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-1 will be installed
--> Finished Dependency Resolution

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory

Issue :--

oracle@test$sqlplus
ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory
Killed

oracle@test$



solution :--

We could see from above result that some shared library dependencies for sqlplus is not found.
Following settings are applicable for Solaris.

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/lib:/usr/lib:/usr/lib/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:
export LD_LIBRARY_PATH

 

After setting correct value for LD_LIBRARY_PATH, issue got resolved and not getting any error.


oracle@test$sqlplus

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Oct 29 13:52:25 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba