Listener status visible using srvctl but not using lsnrctl

Alain

Hi,

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

as oracle:

-bash-4.2$ lsnrctl status LISTENER_FOR_CIGILSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-FEB-2020 15:23:27Copyright (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_CIGILSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-FEB-2020 15:23:35Copyright (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_CIGIListener LISTENER_FOR_CIGI is enabledListener 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.

Adityanath Dewoolkar

Hello,

Kindly provide below output:

ps -ef | grep tns

srvctl config listener -l LISTENER_FOR_CIGI

You should always run "lsnrctl status <LISTENER_NAME>" command in right ORACLE HOME with owner of listener process.

Regards,

Adi

Alain

-bash-4.2$ srvctl config listener -l LISTENER_FOR_CIGI

Nom : LISTENER_FOR_CIGI

Type : Database Listener

Réseau : 1 ; propriétaire : grid

Répertoire de base : <CRS home>

Adresses : TCP:1522

Le processus d'écoute est activé.

Le processus d'écoute est activé individuellement sur les noeuds :

Le processus d'écoute est désactivé individuellement sur les noeuds :

eronitascott

/*+ starting a RAC node instance & listener:

root> export ORACLE_SID=orcl1

root> srvctl start nodeapps -n linux1

root> srvctl start asm -n linux1

root> srvctl start instance -d orcldb -i orclnode

root> srvctl start mylistwener

root> emctl start dbconsole

Or do it all in one command:

root>  svrctl start database -d orcldb

/*+ shutdown a RAC node instance & listener:

root> export ORACLE_SID=orcl1

root> emctl stop dbconsole

root> srvctl stop instance -d orcldb -i orclnode immediate

root> srvctl stop asm -n linux1

root> srvctl stop nodeapps -n linux1

root> srvctl stop mylistener –I 2

Or do it all in one command:

root>  svrctl stop database -d orcldb

Alain

Did you read the question? The problem is not to start the listener nor to view the status in srvctl. In srvctl it just works!

The question is "how to see it using lsnrctl status, and so to view all databases registered to it"!

PTimmermans

If you run lsnrctl status as user oracle, maybe you should do a symlink in the $ORACLE_HOME/network/admin directory pointing to the listener.ora file in the GRID_HOME directory ?