Results 1 to 6 of 6

Thread: How to unlock scott account in sqlplus?

  1. #1
    Join Date
    Feb 2012
    Posts
    104

    How to unlock scott account in sqlplus?

    I was trying to load oracle10g in my system and as it was taking a lot of time I had skipped password management option and now the problem is that when I am trying to og into sql+ using scott/tiger account then I am getting the below error:
    Error:
    ORA-28000 - the account is locked

    Is there anyone who can help me out??

  2. #2
    Join Date
    Jan 2012
    Posts
    122

    Re: How to unlock scott account in sqlplus?

    I was trying to load oracle10g in my system and as it was taking a lot of time I had skipped password management option and now the problem is that when I am trying to og into sql+ using scott/tiger account then I am getting the below error:
    Error:
    ORA-28000 - the account is locked
    Is there anyone who can help me out??
    I am not very sure but then just try out the following and see if it is helping:
    G:\oracle10g\product\10.1.0\cd sqlplus
    G:\oracle10g\product\10.1.0\sqlplus\sqlplus/nolog
    SQL> connect sys/(PASSWORD) as sysdba
    SQL> alter user scott account unlock.

  3. #3
    Join Date
    Feb 2012
    Posts
    104

    Re: How to unlock scott account in sqlplus?

    Hey thanks for your interest but then now I have tried out the same and it is not making any difference, I have tried all of them, is there anything else that I can try out to unlock scott account in sqlplus?? Any further help for the same will be highly appreciated.

  4. #4
    Join Date
    Oct 2011
    Posts
    224

    Re: How to unlock scott account in sqlplus?

    You should have not skipped the password management section as in the start the accounts remains locked and one has to manually unlock them, the only possible solution that can help you out here is uninstalling the oracle and then reinstalling it without missing the password management. It should probably help you out in dealing with it, just try it out and then let me know if you have any further issues.

  5. #5
    Join Date
    May 2009
    Posts
    529

    Re: How to unlock scott account in sqlplus?

    I think I can help you out here as I had faced the same once, first just connect to database as sysdba privileges and after that try out the below commands:
    sql> alter user scott identified by tiger;
    sql>alter user scott account unlock;

    after this connect by scott

    sql> conn scott/tiger
    or
    sql>conn scott/tiger@database_name

  6. #6
    Join Date
    Jan 2012
    Posts
    122

    Re: How to unlock scott account in sqlplus?

    Even my code was right:
    G:\oracle10g\product\10.1.0\cd sqlplus
    G:\oracle10g\product\10.1.0\sqlplus\sqlplus/nolog
    SQL> connect sys/(PASSWORD) as sysdba
    SQL> alter user scott account unlock.
    I had just missed semicolon “;” for the all the command.

Similar Threads

  1. How to unlock android phone without a Google account
    By Diellza in forum Technology & Internet
    Replies: 5
    Last Post: 30-01-2013, 01:21 PM
  2. Replies: 4
    Last Post: 03-10-2011, 02:36 AM
  3. How do I unblock/unlock my hotmail account?
    By Seema Bhati in forum Technology & Internet
    Replies: 5
    Last Post: 16-08-2010, 09:56 AM
  4. Replies: 1
    Last Post: 01-12-2008, 02:18 PM
  5. Permission to allows users to Unlock Account
    By dave@at in forum Active Directory
    Replies: 2
    Last Post: 10-11-2004, 05:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,838,370.74065 seconds with 16 queries