1 Reply Latest reply: Feb 6, 2013 7:55 PM by Salman Qureshi RSS

    Scan error

    Bhavi Savla
      Hi I am facing issue while connecting from jdbc(weblogic) to Oracle RAC database 11.2.0.2. I am getting the ORA - 12519 error. While trying to figure out the issue I see the following services on node2 scan listener, which is listening to both the instances MS1 and MS2. Please share your comments:
      $ lsnrctl services LISTENER_SCAN3
      
      LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 06-FEB-2013 18:13:53
      
      Copyright (c) 1991, 2010, Oracle.  All rights reserved.
      
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
      Services Summary...
      Service "MS" has 2 instance(s).
        Instance "MS1", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
               REMOTE SERVER
               (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.21.xx.xx)(PORT=1521)))
        Instance "MS2", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
               REMOTE SERVER
               (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.21.xx.xx)(PORT=1521)))
      Service "msXDB" has 2 instance(s).
        Instance "MS1", status READY, has 1 handler(s) for this service...
          Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
               DISPATCHER <machine: ORA12, pid: 17608>
               (ADDRESS=(PROTOCOL=tcp)(HOST=ORA12.com)(PORT=12321))
        Instance "MS2", status READY, has 1 handler(s) for this service...
          Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
               DISPATCHER <machine: ORA13, pid: 5205>
               (ADDRESS=(PROTOCOL=tcp)(HOST=ORA13.com)(PORT=6220))
      The command completed successfully
        • 1. Re: Scan error
          Salman Qureshi
          Hi,
          1. Please paste here result of "lsnrctl status <LISTENER_NAME>" from both of your nodes.
          2. Is init parameter local_listener set properly on both instances? Paste value of this parameter from both instance
          3. is init parameter remote_listener set properly on both instances? Paste value of this parameter from both instance


          Salman