1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Ora-12591

Discussion in 'Security, Backup and Recovery' started by kimipatel, Nov 1, 2012.

  1. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    After installation new database creation successfully finished. While I starting database, after some times, I got following error.

    ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)

    All sessions stopped to working and we are not able to get new connection of database. Oracle Enterprise Manager web console provided that database instance up and running.
    Why it's happened and how to resolve this problem?

    Thanks.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    After installation of WHICH release of Oracle, on WHICH operating system, with WHAT configuration?

    Have you run lsnrctl services on the db server to see if the database has actually registered with the listener? If not there is insufficient information to answer your question.
     
  3. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    Oracle 10.2.0.1 on Windows 2003.

    Thanks.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I don't see a response to my other question:

    Have you run lsnrctl services on the db server to see if the database is registered with the listener?
     
  5. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    No. I am not sure.. OK Firstly i check it... Thanks.
     
  6. dadbm

    dadbm Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    ORA-12519 can be caused by low "processes" values, which can be resolved by increasing he DB parameter, "parallel_max_servers".
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Not that I'm aware of -- I have parallel_max_servers set to 0 in my 11.2.0.3 database and have no problems connecting remotely:

    Code (SQL):
    C:\>sqlplus [EMAIL="bing/######@???????????"]bing/######@???????????[/EMAIL]
     
    SQL*Plus: Release 11.2.0.3.0 Production ON Mon DEC 2 12:46:30 2013
    Copyright (c) 1982, 2011, Oracle.  ALL rights reserved.

    Connected TO:
    Oracle DATABASE 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
     
    SQL> SHOW parameter parallel_max
     
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    parallel_max_servers                 INTEGER     0
    SQL>
     
     
    kimipatel likes this.
  8. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    I solve my issue. Thanks for helping me.

    Thanks.
     
  9. Michaelsork

    Michaelsork Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Kenya
    Ora-12591 - Reply to Topic

    I apologize, but this variant does not approach me . Who else , what can prompt ?