Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener status visible using srvctl but not using lsnrctl

AlainFeb 5 2020 — edited Mar 17 2020

Hi,

Oracle linux 7 x86_64, oracle 12.2, rac-2 nodes.

as oracle:

-bash-4.2$ lsnrctl status LISTENER_FOR_CIGI
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-FEB-2020 15:23:27
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
TNS-01101: Could not find listener name or service name LISTENER_FOR_CIGI
-bash-4.2$ 
-bash-4.2$ lsnrctl status LISTENER_FOR_CIGI
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-FEB-2020 15:23:35
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
TNS-01101: Could not find listener name or service name LISTENER_FOR_CIGI
-bash-4.2$ srvctl status listener -l LISTENER_FOR_CIGI
Listener LISTENER_FOR_CIGI is enabled
Listener LISTENER_FOR_CIGI is running on node(s): rac-1,rac-2

$GRID_HOME/network/admin holds:

LISTENER_FOR_CIGI_RAC-1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac-1-vip)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.50.101)(PORT=1522)(IP=FIRST))))  # line added by Agent

Question:

why lsnrctl show "TNS-01101: Could not find listener name or service name LISTENER_FOR_CIGI"? Same error as grid.

Comments

Günter

If your stored procedures are huge maybe a Java heap space problem ?

Billy Verreynne

Recompiling a stored proc requires an exclusive lock on the meta data object for the stored proc. Sessions using and executing a stored proc, or objects with dependencies on that stored proc, place a shared lock on the stored proc meta data object. This is to prevent runtime issues and errors to occur by changing the code of an in-use stored proc.
Thus a recompile session call can wait for an extended time for obtaining an exclusive lock for changing the stored proc.

3 people found this helpful
jflack

So, if your database is busy, and your procedures are being used a lot, let me suggest that you use edition-based redefinition to make your changes.

1 - 3

Post Details

Added on Feb 5 2020
#performance-availability, #rac-asm-clusterware-installation
5 comments
1,141 views