2 Replies Latest reply on Mar 3, 2020 8:30 AM by Dude!

    Cannot start Oracle-XE 18c due to being full

    4082131
    4082131 Mar 3, 2020 12:17 AM

      Cannot Start Oracle-XE 18c in order to clear out data

      ====================================================================================================================

      We are having an issue where an Oracle XE instance fills up and for a potentially unrelated reason crashes and cannot be restarted.

       

      What this means is I cannot get back into the instance to cleanout data to resume operation. No matter what path is taken, I continue to be prevented from opening the PDB.

       

      This basically then means I have to rebuild the thing from scratch which is loads of fun.

       

      SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY;

      ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY

      *

      ERROR at line 1:

      ORA-12954: The request exceeds the maximum allowed database size of 12 GB.

       

       

      SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN RESTRICTED;

      ALTER PLUGGABLE DATABASE XEPDB1 OPEN RESTRICTED

      *

      ERROR at line 1:

      ORA-12954: The request exceeds the maximum allowed database size of 12 GB.

       

       

      SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY FORCE;

      ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY FORCE

      *

      ERROR at line 1:

      ORA-12954: The request exceeds the maximum allowed database size of 12 GB.

       

      Any suggestions on how I might get the data out or get the process started so I can move forward?