8 Replies Latest reply: May 22, 2012 4:39 AM by user12064507 RSS

    Oracle RAC 11GR2 + load balancing

    user12064507
      Hi all,

      I have a two nodes RAC cluster 11GR2.
      Since this morning, i have a problem.
      When we connect to the database, all my sessions logged on instance 2 and never on instance 1.
      SCAN and TAF service seems to be correctly configured.

      Could you help me please ?

      Thanks.
        • 1. Re: Oracle RAC 11GR2 + load balancing
          anand prakash - oracle
          Since this morning, i have a problem.
          Any changes between yesterday and today? Did instance 1 go down in between this time ? What is the value set for remote_listener parameter? Is the tnsping to remote_listener working?

          Anand
          • 2. Re: Oracle RAC 11GR2 + load balancing
            user12064507
            Yes, remote listener and tnsping are OK :

            SQL> show parameter remote_listener

            NAME TYPE VALUE
            ------------------------------------ ----------- ------------------------------
            remote_listener string rac-cluster-lpt-scan:1521





            Copyright (c) 1997, 2010, Oracle. All rights reserved.

            Fichiers de paramÞtres utilisÚs :
            C:\Oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

            Adaptateur HOSTNAME utilisÚ pour la rÚsolution de l'alias
            Tentative de contact de (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PRO
            TOCOL=TCP)(HOST=10.176.1.181)(PORT=1521)))
            OK (30 msec)
            • 3. Re: Oracle RAC 11GR2 + load balancing
              713555
              from your client do
              nslookup rac-cluster-lpt-scan

              then repeat several times.

              If DNS round robin is on, youll see the order of the IPs rotating. If its not, check with networks to see did they change something.
              • 4. Re: Oracle RAC 11GR2 + load balancing
                user12064507
                No, it never change.
                I have only one SCAN IP corresponding to rac-cluster-lpt-scan.
                • 5. Re: Oracle RAC 11GR2 + load balancing
                  anand prakash - oracle
                  Hi,

                  Can you try to reset the remote listener which will force pmon from remote nodes to register it on node 1-

                  alter system set remote_listener='';

                  alter system set remote_listener='rac-cluster-lpt-scan:1521';


                  Anand
                  • 6. Re: Oracle RAC 11GR2 + load balancing
                    user12064507
                    It change nothing.
                    • 7. Re: Oracle RAC 11GR2 + load balancing
                      anand prakash - oracle
                      Can you paste the output of node1 :-

                      ps -ef | grep tns

                      lsnrctl status <listener_scan>


                      Anand
                      • 8. Re: Oracle RAC 11GR2 + load balancing
                        user12064507
                        [root@rac1 ~]# ps -ef | grep tns
                        root 12803 12100 0 11:38 pts/1 00:00:00 grep tns
                        grid 13916 1 0 May21 ? 00:00:03 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
                        grid 15885 1 0 May21 ? 00:00:09 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
                        [root@rac1 ~]#


                        [grid@rac1 ~]$ lsnrctl status listener_scan1

                        LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-MAY-2012 11:39:16

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

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
                        STATUS of the LISTENER
                        ------------------------
                        Alias LISTENER_SCAN1
                        Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                        Start Date 21-MAY-2012 18:17:54
                        Uptime 0 days 17 hr. 21 min. 22 sec
                        Trace Level off
                        Security ON: Local OS Authentication
                        SNMP OFF
                        Listener Parameter File /oracle/app/11.2.0/grid/network/admin/listener.ora
                        Listener Log File /oracle/app/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml
                        Listening Endpoints Summary...
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.176.1.181)(PORT=1521)))
                        Services Summary...
                        Service "lpm.landebitel.local" has 2 instance(s).
                        Instance "lpm1", status READY, has 1 handler(s) for this service...
                        Instance "lpm2", status READY, has 1 handler(s) for this service...
                        Service "lpmXDB.landebitel.local" has 2 instance(s).
                        Instance "lpm1", status READY, has 1 handler(s) for this service...
                        Instance "lpm2", status READY, has 1 handler(s) for this service...
                        Service "lpm_taf.landebitel.local" has 2 instance(s).
                        Instance "lpm1", status READY, has 1 handler(s) for this service...
                        Instance "lpm2", status READY, has 1 handler(s) for this service...
                        The command completed successfully
                        [grid@rac1 ~]$