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.
No comments:
Post a Comment