Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle XE password reset admin internal account locked

Lorenz-OracleMar 31 2013 — edited Apr 1 2013
Dear,

I tried to connect to my xe with internal account.
The password does not work any more.
I tried to reset the password with
apxchpwd.sql
or
apxxepwd.sql
It did not work.
Now I am getting the Error Message Close Notification "The account is locked. "

What can I do?

Kind regards
Lorenz
PS: Oracle XE 11.2.0.2 // APEX 4.2.1

Comments

Logaa
hi,
Try this. 
ALTER USER username ACCOUNT UNLOCK;
Thanks,
--Loga
Lorenz-Oracle
Dear Loga,
thanks for your reply. Unfortunately I believe this is no solution.
User admin on workspace internal is still locked. Password reset still does not work.
Kind regards
Lorenz
Lorenz-Oracle
Dear,

solved the issue by myself:

apxchpwd.sql was not working as it trys to reset password for an older apex schema.

apxchpwd.sql script in ORACLE_HOME/apex needs to be edited in line 33:
I changed
alter session set current_schema = APEX_040000
to
alter session set current_schema = APEX_040200

Seems as the script has not been upgraded when I upgradet apex to 4.2.1

After that I was able to reset the passowrd with the apxchpwd.sql script.

Kind regards
Lorenz

Edited by: Lorenz on Apr 1, 2013 2:51 AM
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2013
Added on Mar 31 2013
#apex-discussions
3 comments
2,728 views