I'm not sure if this is the right place to ask this, but:
We have installed APEX 21.1 with Oracle 18c on Windows Server 2019 to get as current as possible.
But just installing APEX into a CDB will not let me import without raising all kinds of errors. So I removed APEX from CDB (XE) using the following script
Run the “Remove APEX from the CDB$ROOT” script:
SQL> @apxremov_con.sql
Then installed it into a pluggable Database XEPDB1 and things appeared to be working fine using standalone ORDS.
Then one day trying to access APEX, I started getting a message:
"Oracle REST Data Services
503 Service Unavailable
2021-07-09T23:29:30.526Z | JFLUBcmk2iFcFOM1yFl4WQ |
ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege"
And when I started checking the database, I noticed:
show con_name
CON_NAME
------------------------------
CDB$ROOT
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 XEPDB1 READ WRITE YES
select * from PDB_PLUG_IN_VIOLATIONS;
APEX mismatch: PDB has installed common APEX. CDB has not installed APEX.
So for some reason PDB is in restricted mode due to a mismatch that shouldn't be occurring. Also, it installed fine initially but something caused it to go into restricted mode and I can't get it out of that mode.
Any suggestions are appreciated...