scott account locked in SQL Plus

oracle11g sqlplus
McLosys Creative picture McLosys Creative · Jul 25, 2012 · Viewed 76k times · Source

When I am trying to logging to Oracle Sql plus by entering 'scott' as username and 'tiger' as password, it shows 'the account is locked'. How to unlock 'scott' account. The screen shot of SQL Plus CLI is given below.

The screen shot is given below

Answer

GWu picture GWu · Jul 25, 2012

Login in to your DB with user SYS

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 25 15:13:25 2012

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

Enter user-name: sys as sysdba
Enter password:

then issue

alter user scott account unlock;

Then you will be able to login as scott.

conn scott/tiger

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More
PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More