Search This Blog

Saturday 23 March 2013

Oracle user account locked??

If you install Oracle 11g on an unsupported Windows version and try to access the default schema/user which is scott/tiger, you could face a error such as below.

This is because the schema is locked (and possibly expired as well).

So we just have to connect to Oracle as DBA and unlock our schema/user

And then as the schema is unlocked now but the password for the schema is only in 'expired' state, if you can go ahead and connect to it. It fails and asks you to set a new password. You set a password and you can happily use the scott schema now with out any issues.

Happy Learning SQL !!!