Monday, 25 August 2014

How to unlock Scott user in Oracle 10g


We cannot Communicate directly with the Sql Plus Database, require of user account, one of that the 'Scott' user is default user.
But need of unlock this account at a first time.
So follow the process to unlock the account

After completion of installation of Oracle [ SQL Plus ] setup,
Go for SQL Plus | Path [ Oracle\product\10.2.0\db_1\BIN\sqlplus.exe ] / sqlplusw.exe
[Show] Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name : [Type]  \ sys as sysdba
Enter password  : [Type] sys
SQl > [Type]  alter user scott account unlock;

[Show] User altered.

SQL > conn scott/tiger;
[Show]ERROR:
ORA-28001 : the Password has expired

Changing password for scott
New password : [Type]  tiger
Retype new password : [Type]  tiger
Password changed

Connected.

Sql >


Enjoy with Queries.

No comments:

Post a Comment