Home » RDBMS Server » Security » Unlock ops$oracle in oracle 11g (oracle 11 g r2 on linux)
Unlock ops$oracle in oracle 11g [message #607865] Wed, 12 February 2014 21:30 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
I have a oracle 11g r2 database on redhat linux.
Now my ops$oracle user has been expired.
How to unlock it.
Re: Unlock ops$oracle in oracle 11g [message #607866 is a reply to message #607865] Wed, 12 February 2014 21:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
sqlplus
/ as sysdba
ALTER USER OPS$ORACLE ACCOUNT UNLOCK;

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Unlock ops$oracle in oracle 11g [message #607883 is a reply to message #607865] Thu, 13 February 2014 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Don't confuse "password expired" and "account locked".
In the former you have to change the password or ask your DBA to change it if you are no more in the grace period.
In the later, ask your DBA to execute the command BlackSwan gave.

Re: Unlock ops$oracle in oracle 11g [message #607888 is a reply to message #607865] Thu, 13 February 2014 02:53 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What does the following return?

SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='OPS$ORACLE';
Previous Topic: NOAUDIT
Next Topic: Oracle Vault and sqlplus
Goto Forum:
  


Current Time: Thu Mar 28 16:42:45 CDT 2024