Tuesday, August 27, 2013

Unlock PNET user when locked

[root@oraapps ~]# su - oracle
[oracle@oraapps ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 27 17:56:12 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> select username,account_status from dba_users where account_status like '%LOCKED%';

SQL> alter user PNET account unlock;










No comments:

Post a Comment

IAS Cache initialization failed

 Today I faced an Issue in R12.2 instance. The solution I followed to overcome the issue is very simple, but they are more than one solution...