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.
6:03 AM
how to setup oracle 10 g, how to setup scott user, how to setup sqlplus, Oracle, oracle installation at first time, sql plus, unlock scott user, unlock scott/tiger
0
0 comments:
Post a Comment