Forum Stats

  • 3,782,463 Users
  • 2,254,652 Discussions


Not able to open PDB database

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!