Forum Stats

  • 3,735,082 Users
  • 2,247,100 Discussions
  • 7,857,673 Comments

Discussions

Listener status visible using srvctl but not using lsnrctl

Alain
Alain Member Posts: 78 Bronze Badge

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.

Answers

  • Adityanath Dewoolkar
    Adityanath Dewoolkar Member Posts: 346 Bronze Badge
    edited Feb 5, 2020 10:45AM

    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
    Alain Member Posts: 78 Bronze Badge
    edited Feb 12, 2020 8:18AM

    -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
    eronitascott Member Posts: 9 Green Ribbon
    edited Mar 17, 2020 9:10AM

    /*+ 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
    Alain Member Posts: 78 Bronze Badge
    edited Feb 21, 2020 4:05AM

    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
    PTimmermans Member Posts: 6 Red Ribbon

    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 ?

Sign In or Register to comment.