Oracle 11g Tips

After dealing with Microsoft SQLServer 2005 and 2008, Oracle 11g behaves completely unfriendly. I will list tips here.

Index

• How can I unlock a user account?

---

How ca I unlock a user account?

I just installed Oracle 11g on my Windows Server 2008 at home andbought "Oracle Database 11g SQL" by J. Price (Osborne, 2008). The first thing this book does is to start "SQL*Plus". Unfortunately the example username/password "scott/tiger" returns the error that the account is locked. It turned out that you have to unlock the account in the following way (> is the command prompt):

	> sqlplus / as sysdba  
	SQL*Plus: Release 11.1.0.7.0 - Production on Sun Oct 11 17:15:19 2009  
	Copyright (c) 1982, 2008, Oracle.  All rights reserved.  
	Connected to:  Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production  
	With the Partitioning, OLAP, Data Mining and Real Application Testing options  
	SQL> alter user scott account unlock;  
	User altered.  
	SQL> quit
	Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
	

The next time you login as scott, then you are asked to change password.

Top

---

Home

Updated 9/17/2009