This discussion is archived
12 Replies Latest reply: Jan 23, 2013 1:35 AM by 982690 RSS

After rebooting:Listener Refused the connection:ORA12519

982690 Newbie
Currently Being Moderated
Hi There,

Let me brief you first how this prob arises:

I had run RCU for creating database schemas ......for that i have change my system processes to 300 to run RCU properly....

IT worked fine but after rebooting my system...when i try to connect the db thru sqldeveloper... i am getting the error"Listener Refused the connection:ORA12519,TNS no appropriate service handler"......for which i have consulted the
ORA-12519 using thin JDBC client this forum one of the post suggested that change process to 150....

Now i have three points:

1.Can i also alter my system processes to make it work fine...?
2.Currently as i am trying to connect thru JDev it is throwing me an exception " Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"... I guess this prob is due to aforesaid issue and it will work once the instance is up.....
3.I have shutdown and startup my DB in cmd and it gives me message database mounted and opened .......does it means that db is working fine but still it wont be able to connected coz of process...

Vivekk
  • 1. Re: After rebooting:Listener Refused the connection:ORA12519
    986120 Explorer
    Currently Being Moderated
    for BASH :
    export ORACLE_BASE=<oracle_base_directory>
    export ORACLE_HOME=<oracle_home_directory>
    export ORACLE_SID=<sid>

    For C shell :
    set ORACLE_BASE=<oracle_base_directory>
    set ORACLE_HOME=<oracle_home_directory>
    set ORACLE_SID=<sid>

    then do the following

    -Wait and try to connect a second time.

    -Check instances are currently known by the listener by executing: lsnrctl services <listener name>

    -Check SID parameter in the connect descriptor.

    -Check for an event in the listener.log file.

    --
    Thanks,
    Bala.
  • 2. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    @BALA: is this a issue of listener not identifying a SID or the process...as when connecting thru sqldeveloper and thru Jdeveloper the error thrown are different?....
  • 3. Re: After rebooting:Listener Refused the connection:ORA12519
    Niket Kumar Pro
    Currently Being Moderated
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    this error stats that you are using wrong SID to connect to your database.
    check tnsnames.ora and listener status..... and use correct name for database...

    provide output of

    tnsping database_name
  • 4. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    Hi Niket

    Entry in TNSNAMES.ORA looks like:


    PRODDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ProdDB)
    )
    )






    TNSPING OUTPUT ALSO LOOKS FINE WHICH IS

    C:\Users\310628>tnsping PRODDB

    TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-JAN-2
    013 14:22:06

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

    Used parameter files:
    C:\app\310628\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
    t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ProdDB)))
    OK (10 msec)




    BUT IN MY LISTENER.ORA I HAVE NOT FOUND THE ENTRY FOR proddb WHICH IS MY DATABASE NAME:
    # listener.ora Network Configuration File: C:\app\310628\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 01HW191334.India.TCS.com)(PORT = 1521))
    )

    ADR_BASE_LISTENER1 = C:\app\310628
    ...

    DOES IT DYNAMICALLY REGISTER ITSELF?
  • 5. Re: After rebooting:Listener Refused the connection:ORA12519
    Niket Kumar Pro
    Currently Being Moderated
    chek listener status and post here

    cmd>lsnrctl status


    dynamic registration doesn't need listener.ora file...it will register with the help of pmon process....
  • 6. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    onnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    Services Summary...
    Service "ProdDBXDB" has 1 instance(s).
    Instance "proddb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: 01HW191334, pid: 4552>
    (ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=63127))
    Service "orcl.India.TCS.com" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "orclXDB.India.TCS.com" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: 01HW191334, pid: 2608>
    (ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59766))
    Service "proddb" has 1 instance(s).
    Instance "proddb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "testdb" has 1 instance(s).
    Instance "testdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "testdbXDB" has 1 instance(s).
    Instance "testdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: 01HW191334, pid: 2600>
    (ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59765))
    The command completed successfully



    _______________________________________________________________________________________________________________________________________________


    One More Thing Niket ....when i try to connect my DB thru SQLDEVELOPER i get a different error
    "Listener Refused the connection with following error:ORA-12519,TNS:no appropriate service handler found"...the desc of which i have written as a part of ques?
  • 7. Re: After rebooting:Listener Refused the connection:ORA12519
    Niket Kumar Pro
    Currently Being Moderated
    looks ok...

    cmd>username/password@database_name

    check if it is working or not
    username/password is sam as you are using in sql developer....
  • 8. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    Hi Niket,


    I was doing Hit and Trial and suddenly it got up and connected..

    what i have done..

    In connections params,in SID param i have specified the value=ProdDB...now i use param service name instead of SID with same vale and it get connected...


    I cant figure out what was wrong with earlire settings as it was working previously....
  • 9. Re: After rebooting:Listener Refused the connection:ORA12519
    Niket Kumar Pro
    Currently Being Moderated
    but you have same sid and service name....
  • 10. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    Yes thay are same...any thing wrong with keeping the name same
  • 11. Re: After rebooting:Listener Refused the connection:ORA12519
    Niket Kumar Pro
    Currently Being Moderated
    i think you have used wrong SID (typo) first time....
  • 12. Re: After rebooting:Listener Refused the connection:ORA12519
    982690 Newbie
    Currently Being Moderated
    Thats what i thought at first place......then i remove the connection and then make a new one with the same params with SID ....Again it not worked but it worked with service param :)

Legend

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