13 June 2010
1 How to Unlock Oracle Client -Oracle 10g
By default all the sample schemas/users comes locked in oracle 10g.
You can use any of the two methods for unlocking user.
1. Login to sqlplus as dba/sysdba and use the following command:
2. Using Oracle Enterprise Manager (GUI Tool).
Login as dba/sysdba user. For your database instance, goto Administration and select Users (In Schema--Users & Previleges section). Select the user you would like to unlock (Scott in this case) and Choose the action as unlock and click go.
You can use any of the two methods for unlocking user.
1. Login to sqlplus as dba/sysdba and use the following command:
ALTER USER SCOTT ACCOUNT UNLOCK;
2. Using Oracle Enterprise Manager (GUI Tool).
Login as dba/sysdba user. For your database instance, goto Administration and select Users (In Schema--Users & Previleges section). Select the user you would like to unlock (Scott in this case) and Choose the action as unlock and click go.
Subscribe to:
Post Comments (Atom)
1 comments:
If your Account get locked in Oracle client then you will need sys/system credential to unclok the same.
Please ask your DBA to unlock it.
Please give your valuable comments.