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: 50
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: 22728
Registered: January 2009
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: 58959
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: 302
Registered: November 2010
Location: Bristol, 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: Tue Sep 02 23:08:45 CDT 2014

Total time taken to generate the page: 0.26059 seconds