Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot start Oracle-XE 18c due to being full

MEdgeMar 2 2020 — edited Sep 14 2020

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?

Comments

Eric.Sacramento

User Interface Details

2019-04-29_9-34-34.png

User_EI49E

When I change 101 to LOGIN_DESKTOP I get

Sorry, this page isn't available

Application "30101" Page "LOGIN_DESKTOP" not found.

Contact your application administrator.

Eric.Sacramento

you probably deleted this pages, create another application and copy this page to your application.

User_EI49E

Yes, I deleted the new login page, but not the original 101. How do I set LOGIN_DESKTOP back to 101. Is that an application item? Thanks.

Pete

Eric.Sacramento

in the image that I sent to you, try to replace LOGIN_DESKTOP for the number of the page that you want

Neil Clare
Answer

LOGIN_DESKTOP is an alias to your login page.

When you create a new application (or new scheme) the logon page is automatically given that alias.

If you manually delete the page, then the alias does not point to anything.

All you have to do is manually add the alias back in to your original login page.

Capture.PNG

Marked as Answer by User_EI49E · Sep 27 2020
1 - 6

Post Details

Added on Mar 2 2020
9 comments
4,614 views