Yasir Iqbal, October 24, 2017 - 3:44 pm UTC
APEX_PUBLIC_USER password has been reset and apex stops working
Dipika Poraniya, January 08, 2019 - 11:37 am UTC
Hi Connor,
we are having apex listener 1.3,
oracle 11g(standard edition)
and glassfish 3
in window server,somehow APEX_PUBLIC_USER account gets locked,
so i fired alter user username identified by password account unlock;
user got unlocked.
but i think,that wasn't original password,so now glassfish is running,port is also pinging,database is also in read-write mode,but i'm not able to connect http:domain:8080/apex/ from URL- It throws 404 error,resource not found.
while i checked server.log of glassfish it shows below error:-
--------------ERROR START-------------------------
|SEVERE|oracle-glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=64;_ThreadName=Thread-2;|Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
---------------ERROR END---------------
i tried to reconfigure listener from /apex/listenerConfigure,but gives message of "APEX listener already configured,login with administrator to access apex listerner".
So tried fro /apex/listenerAdmin/
but it prompts for credentials and none of mine credentials are working now,I tried APEX_PUBLIC_USER and realm admin user also.but didn't work.
Please help me,thanks in advance.
January 10, 2019 - 1:37 am UTC
Wow.... version 1.3 ?!?!?!? It's time to upgrade man :-)
I can't be sure on a version that old, but I think you do:
a) find and remove* the 'credentials' file under /apex/xxxx, where xxxx is the port number
b) reset the password at the database level to something you know
c) try the listener URL again and you should be prompted for fresh passwords
(* - obviously take a backup of this file just in case this does not work)
Start up for APEX and REST
Rajeshwaran, Jeyabal, October 13, 2020 - 7:33 am UTC
Team:
we got APEX and REST available on our Test database, what link from documentation should we start reading through to get familiar our self with these two technologies.
October 14, 2020 - 4:05 am UTC