Apex 5: Admin account is locked

oracle oracle12c oracle-apex-5
Quan Nguyen picture Quan Nguyen · Nov 5, 2015 · Viewed 18.9k times · Source

For a long time, I worked on my own workspace. Now I want to create a new workspace, add new users, .... I login into admin account but the account is locked.

enter image description here

I tried to change password and unlock account.

enter image description here

After running the @apxchpwd.sql script. I re-login but not successfully. Please help me to unlock and change admin password.

Answer

Quan Nguyen picture Quan Nguyen · Nov 5, 2015

It's my mistake

I am on APEX 5.0, but you used the apxchpwd.sql of the APEX version that came with RDBMS 12.1.0.2.

I tried again with the 5.0 script and it worked now.

Related questions

ORA-28040: No matching authentication protocol exception

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever I run my application I get following exception : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication …

Read More
error: ORA-65096: invalid common user or role name in oracle

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query: create user Scott identified by …

Read More
Return results of a sql query as JSON in oracle 12c

Background I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid. Currently I am fetching the rows in PHP, converting it from ISO to UTF-8 with iconv and exporting to json …

Read More