This content has been marked as final. Show 3 replies
in sqlplus / as sysdba
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "secret";
the secret password, insert in apex listener config.
for apex admin user
Edited by: user3894759 on Jan 11, 2013 10:32 AM
The apex_public_user was already unlocked, and sqlplus connection using the password works.
The apex_public_user is set in the "java -jar apex.war setup --database MYDATABASE" step. I've confirmed several times that it matches.
Running apxchpwd.sql is for changing the Internal workspace password, which is different. The default apex login page should be visible regardless of the value of the Internal workspace password.
Edited by: obipsr42 on Jan 11, 2013 12:20 PM
Solve the problem myself.
The previous Apex listener was 1.1.4 and the database already has a couple of workspaces. For upgrade to Apex Listener 2.0, need to run apex mapping command to the workspace:
java -jar apex.war map-url type base-path workspace-id MYWORKSPACE MYPREFIX MYDATABASE
To access the internal workspace after the change: