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
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 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
[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.
