2 Replies Latest reply: May 9, 2012 7:15 PM by onedbguru RSS

    Oracle Rac service registration issue in 11gR2

    user12131773
      Hi All,

      We have implemented a 11.2.0.3 on Linux OEL 5 with EBS 12.1.3 using scan IP.

      Please find the remote and local listener in db.

      remote_listener string oractestdbscan:1535
      local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
      DRESS=(PROTOCOL=TCP)(HOST=10.9
      0.8.87)(PORT=1535))))

      We are using scan listener

      On 1st node

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oractestdbscan)(PORT=1535))(CONNECT_DATA=(SERVICE_NAME=TEST)(INSTANCE_NAME=TEST1)))
      Services Summary...
      Service "TEST" has 1 instance(s).
      Instance "TEST1", status READY, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:200 refused:0 state:ready
      REMOTE SERVER
      (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.90.8.87)(PORT=1535)))
      The command completed successfully

      [dbtest@oractestdbn2 bin]$ lsnrctl services TEST2

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAY-2012 10:37:14

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

      On node 2
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oractestdbscan)(PORT=1535))(CONNECT_DATA=(SERVICE_NAME=TEST)(INSTANCE_NAME=TEST1)))
      Services Summary...
      Service "TEST" has 2 instance(s).
      Instance "TEST1", status READY, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:59 refused:0 state:ready
      REMOTE SERVER
      (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.90.8.87)(PORT=1535)))
      Instance "TEST2", status READY, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:92 refused:0 state:ready
      REMOTE SERVER
      (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.90.8.88)(PORT=1535)))
      The command completed successfully

      On node 1

      $ lsnrctl status LISTENER_SCAN1

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAY-2012 10:42:46

      Copyright (c) 1991, 2011, 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.3.0 - Production
      Start Date 07-MAY-2012 09:34:03
      Uptime 0 days 1 hr. 8 min. 42 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/JHGRID/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/JHGRID/11.2.0/grid/log/diag/tnslsnr/oractestdbn1/listener_scan1/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.90.8.67)(PORT=1535)))
      Services Summary...
      Service "JHTEST" has 1 instance(s).
      Instance "TEST1", status READY, has 1 handler(s) for this service...
      The command completed successfully

      on node 2

      lsnrctl status LISTENER_SCAN2

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAY-2012 10:46:56

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_SCAN2
      Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      Start Date 07-MAY-2012 09:34:05
      Uptime 0 days 1 hr. 12 min. 50 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/JHGRID/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/JHGRID/11.2.0/grid/log/diag/tnslsnr/oractestdbn2/listener_scan2/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.90.8.68)(PORT=1535)))
      Services Summary...
      Service "TEST" has 2 instance(s).
      Instance "TEST1", status READY, has 1 handler(s) for this service...
      Instance "TEST2", status READY, has 1 handler(s) for this service...
      The command completed successfully

      $ srvctl config scan
      SCAN name: oractestdbscan, Network: 1/10.90.8.0/255.255.255.0/eth0
      SCAN VIP name: scan1, IP: /oractestdbscan/10.90.8.67
      SCAN VIP name: scan2, IP: /oractestdbscan/10.90.8.68
      SCAN VIP name: scan3, IP: /oractestdbscan/10.90.8.66
      $ srvctl config scan_listener
      SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1535
      SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1535
      SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1535

      EBS R12 comes with 11.1.07 database. We upgraded the dataabase to 11.2.0.3.

      Test2 is ok it is showing 2 Instances but Test1 is showing only 1 instance. I have configured the remote and scan listener properly.

      Grid is under different and oracle db home is under different .

      When i start the database, Both the instances test1 and test2 doesnt any services.

      Please somebody let me know what i doing wrong. I am stuck on this since last 5 days.

      I dond find any solution and have reaised an SR with oracle but no help.

      Please help.

      Thanks and Regards,
        • 1. Re: Oracle Rac service registration issue in 11gR2
          G Srikanth
          I have just noticed the service name as JHTEST in your LISTENER_SCAN1 and TEST in your LISTENER_SCAN2, I am not sure why it is showing as below

          Services Summary...
          Service "JHTEST" has 1 instance(s).
          Instance "TEST1", status READY, has 1 handler(s) for this service...
          The command completed successfully


          Service "TEST" has 2 instance(s).
          Instance "TEST1", status READY, has 1 handler(s) for this service...
          Instance "TEST2", status READY, has 1 handler(s) for this service...

          Can you check your parameter service_names in both the instances. (just a guess).

          Thank you
          G Srikanth
          • 2. Re: Oracle Rac service registration issue in 11gR2
            onedbguru
            In RAC, you should NOT have the service_names parameter set. Services are created by srvctl

            srvctl config service -s ... ##show the configuration of the serice - how is it defined - what nodes does it run on. etc...
            srvctl status service -s ... ##show the status of the service

            The db_unique_name will always show up as a service. Read the documentation consider SCAN.


            With RAC, you need to start moving away from using lsnrctl to control the listener. There are a LOT of major changes to how it functions especially in 11.2.0.x

            srvctl config listener
            srvctl status listener

            Edited by: onedbguru on May 9, 2012 5:13 PM