Unable to get default Apex login screen after upgrade
Oracle 126.96.36.199.0 on Linux x86 64 bit
Apex 4.1 upgraded to Apex 4.2.1
What I did:
Completed installed of Apex 4.2.1 patch (14732511) on top of Apex 4.2.0
Verified that APEX_PUBLIC_USER password the same, and working.
Copied images to glassfish docroot to "i" subdirectory
Setting up Apex Listener 2.0 (188.8.131.524.17.05)
java -jar apex.war configdir OURPATH/config
java -jar apex.war user adminlistener "Listener Administrator"
java -jar apex.war setup --database ourdatabase
java -jar apex.war static OURPATH/glassfish3/glassfish/domains/domain1/docroot/i
In glassfish console:
removed existing Apex application, and installed new apex.war with context path as /apex
installed i.war as "apeximages" with empty context path
When attempting to connect to our server (http://OURSERVER/apex), I get ORACLE APPLICATION LISTENER with 404 - Not Found
Checked if database listener status; it is up. And reentered APEX_PUBLIC_USER password at the apex.war setup step. Still not working.
Edited by: user703547 on Jan 10, 2013 12:41 PM
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: