This discussion is archived
1 Reply Latest reply: Feb 6, 2013 5:55 PM by SalmanQureshi RSS

Scan error

BhaviSavla Explorer
Currently Being Moderated
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
    SalmanQureshi Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points