2 Replies Latest reply: Aug 12, 2013 9:25 PM by Rajasekaran_DBA RSS

    Reg: Listener in Rac env

    Rajasekaran_DBA

      Hi All,

       

       

      I recently configured a 10.2.0.1 Rac on Rhel5 . I am very new to Rac can some one please clarify my doubt ??. i have successfully configured  Rac database with ASM, i tried to check the listener status as below but it fails .if i check it from the first node the node1 listener giving me the status but if i check the node2 listener form the first node1 it says the below error.

       

       

      do i am performing a wrong command where i should not use??

       

       

      [oracle@RAC2 bin]$ srvctl config listener -n rac2

      rac2 LISTENER_RAC2

      [oracle@RAC2 bin]$ srvctl config listener -n rac1

      rac1 LISTENER_RAC1

      [oracle@RAC2 bin]$

       

       

      [oracle@RAC2 bin]$ lsnrctl status LISTENER_RAC2

       

       

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-AUG-2013 06:13:04

       

       

      Copyright (c) 1991, 2005, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2-vip.sai.com)(PORT=1521)(IP=FIRST)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER_RAC2

      Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

      Start Date                09-AUG-2013 05:55:36

      Uptime                    0 days 0 hr. 17 min. 27 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

      Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener_rac2.log

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.13)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.8)(PORT=1521)))

      Services Summary...

      Service "+ASM" has 1 instance(s).

        Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

      Service "+ASM_XPT" has 1 instance(s).

        Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

      Service "PLSExtProc" has 1 instance(s).

        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

      Service "RAC.WORLD" has 2 instance(s).

        Instance "RAC1", status READY, has 1 handler(s) for this service...

        Instance "RAC2", status READY, has 2 handler(s) for this service...

      Service "RAC_XPT.WORLD" has 2 instance(s).

        Instance "RAC1", status READY, has 1 handler(s) for this service...

        Instance "RAC2", status READY, has 2 handler(s) for this service...

      The command completed successfully

      [oracle@RAC2 bin]$

       

       

      Error if i check the status of node1 listener

       

       

      [oracle@RAC2 bin]$ lsnrctl status LISTENER_RAC1

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-AUG-2013 06:13:53

      Copyright (c) 1991, 2005, Oracle.  All rights reserved.

      TNS-01101: Could not find service name LISTENER_RAC1

       

       

       

       

       

       

       

      Regards,Raja