"Invalid Login Credentials" ERROR for ADMIN user in APEX 4.1
Raj1976Jan 8 2012 — edited Jan 10 2012Hi
I installed APEX 4.1 after couple of attempts. Prior to this I tried to install 4.0.2 on my Oracle R12 DB (11.1.7).
The 4.1 installation was successful. I later used script apxchpwd to set my ADMIN password and then tried to login to Administrator console using link -
http://<host>:7878/apex/apex_admin (NOTE- I changed my HTTP port from default 8080 to 7878)
The page loads properly, but when I try to login using the ADMIN username and password I get the "Invalid Login Credentials" error.
Does anyone have any idea what is wrong?
I am using APEX Listener on Glassfish server. Also, one more thing that I would to like to mention is that I have 2 APEX user schema in my DB - APEX_040000 and APEX_040100.
So I have following APEX users -
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED PASSWORD_VERSION
-----------------------------------------------------------------------------------------------------------------------------------------------------------
APEX_PUBLIC_USER OPEN SYSTEM 06-JAN-12 10G 11G
APEX_040100 OPEN SYSAUX 08-JAN-12 10G 11G
APEX_040000 LOCKED SYSAUX 06-JAN-12 10G 11G
FLOWS_FILES EXPIRED & LOCKED HTMLDB 29-SEP-04 10G
Please note the FLOWS_FILE user. Is this correct? Its status is EXPIRED and LOCKED and it has password version of only 10G. Is it safe to change the password of FLOWS_FILES user?
Should I delete the APEX_040000 user?
Thanks
Raj
Edited by: user519111 on Jan 9, 2012 12:49 PM