Not able to open PDB database

User_PPRF6 · May 10, 2021 1:02PM

Hello all,

Installed Oracle XE 18.0 database and was trying to install APEX but as I didn't alter session to XEPDB1 - installation failed.

Aftermath is my PDB database XEPDB1 is in MOUNTED state and "alter pluggable database XEPDB1 open read write;" throws following error:

Error starting at line : 5 in command -

alter pluggable database XEPDB1 open read write

Error report -

ORA-00604: error occurred at recursive SQL level 1

ORA-01405: fetched column value is NULL

00604. 00000 - "error occurred at recursive SQL level %s"

*Cause: An error occurred while processing a recursive SQL statement

(a statement applying to internal dictionary tables).

*Action: If the situation described in the next error on the stack

can be corrected, do so; otherwise contact Oracle Support.

If I try running APEX remove .sql script - it fails, as it can't access SYS.DBMS_DB_VERSION package - I'm assuming because PDB database is not OPEN?

I'm at my last breath here and would appreciate any help I can get, before I throw it all away. Thanks!

jariola · May 10, 2021 7:19PM

Login as SYS

sqlplus / as sysdba

Check is PDB open

SELECT name, open_mode from v$pdbs;

You can try open PDB.

First

alter session set container=xepdb1;

And open

alter pluggable database xepdb1 open;

User_PPRF6 · May 10, 2021 9:05PM

@jariola - Please read what I posted. ALTER PLUGGABLE DATABASE XEPDB1 OPEN; is not working, as described in question.

cormaco · May 11, 2021 5:55AM

Here is a blog of someone who had the same problem:

In short, he opened the PDB in upgrade mode like this:

ALTER PLUGGABLE DATABASE xepdb1 OPEN UPGRADE

then removed the failed APEX installation.

Forum Stats