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!

How to Unlock an account in Sql developer.,.

Discussion in 'SQL PL/SQL' started by Vicky, Apr 1, 2014.

  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Can anyone tell me, how to unlock an account in SQL Developer,.,?! I'm facing the error below:


    * An error was encountered performing the requested operation:

    Listener refused the connection with the following error:
    ORA-12519, TNS:no appropriate service handler found

    Vendor code 12519.,.
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Can show file listner.ora or string connect?

    Oracle docs note this about ORA-12519:

    ORA-12519: TNS:no appropriate service handler found

    Cause: The listener could not find any available service handlers that are appropriate for the client connection.

    Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.

    Probably it is required to increase number of processes:

    Code (SQL):


    cmd>sqlplus / AS sysdba
    sqlplus>ALTER system SET processes=300 scope=spfile;
    sqlplus>shut immediate;
    sqlplus>startup
     
    P.S. If it is necessary to unlock the user, then it is necessary to execute a command : alter use account unlock;
     
    Vicky likes this.
  3. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Tnx, Krasnoslobodtsev .,