October 24, 2017 - 3:44 pm UTC
Reviewer: Yasir Iqbal from Boston,MA
APEX_PUBLIC_USER password has been reset and apex stops working
January 08, 2019 - 11:37 am UTC
Reviewer: Dipika Poraniya from Ahmedabad,India
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:-
|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
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
October 13, 2020 - 7:33 am UTC
Reviewer: Rajeshwaran, Jeyabal
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.