OraFAQ Forum: Security » Unlock ops$oracle in oracle 11g

Home » RDBMS Server » Security » Unlock ops$oracle in oracle 11g (oracle 11 g r2 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unlock ops$oracle in oracle 11g [message #607865]

Wed, 12 February 2014 21:30

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.

Report message to a moderator

Re: Unlock ops$oracle in oracle 11g [message #607866 is a reply to message #607865]

Wed, 12 February 2014 21:39

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/

Report message to a moderator

Re: Unlock ops$oracle in oracle 11g [message #607883 is a reply to message #607865]

Thu, 13 February 2014 00:52

Michel Cadot
Messages: 68352
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.

Report message to a moderator

Re: Unlock ops$oracle in oracle 11g [message #607888 is a reply to message #607865]

Thu, 13 February 2014 02:53

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

What does the following return?

SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='OPS$ORACLE';

Report message to a moderator

Previous Topic:	NOAUDIT
Next Topic:	Oracle Vault and sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 08 21:31:40 CST 2023