Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Yasir.

Asked: October 24, 2017 - 2:53 am UTC

Last updated: October 14, 2020 - 4:05 am UTC

Version: APEX_040200

Viewed 1000+ times

You Asked

Hi. We have Oracle database 12c installed and I can see below Apex schemas as well.

APEX_030200
APEX_040200
APEX_PUBLIC_USER
FLOWS_FILES

Below query also returns 'VALID' value.
SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

Can you please tell me how I can connect to apex or is there anything else that we need to do before we can connect to APEX and start creating workspace?

Thanks,

and Connor said...

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

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.


Connor McDonald
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.
Connor McDonald
October 14, 2020 - 4:05 am UTC

Some good demos and walkthroughs here

https://www.oracle.com/au/database/technologies/appdev/rest.html

https://apex.oracle.com/en/learn/getting-started/

the latter leads onto a set of tutorials as well

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.