Oracle MiniCluster MC-S7: Unable To Delete Database Instance from MCMU BUI

Asset ID:	1-72-2228596.1
Update Date:	2017-07-18
Keywords:

Solution Type Problem Resolution Sure

Solution 2228596.1 : Oracle MiniCluster MC-S7: Unable To Delete Database Instance from MCMU BUI

Applies to:

MiniCluster S7-2 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Solaris on SPARC (64-bit)

Symptoms

Unable to delete Database instance in MCMU BUI

The DB instance testdb failed to create from BUI due to some reason and MCMU BUI shows the failed database in offline state. Now you want to remove the failed Database from MCMU BUI

While deleting Database from MCMU BUI, an error is returned saying "unable to delete instance, check /tmp/instance_deletion_1485319017.tmp" which has only 1 line with ORA-01078: failure in processing system parameters

bash-4.1$ more /tmp/instance_deletion_1485319017.tmp

ORA-01078: failure in processing system parameters

Changes

Failed Database creation in MCMU BUI

Cause

The reason its showing Database in MCMU BUI is because it has got registered with cluster and showing as offline state.

Solution

To remove the failed Database from MCMU BUI, delete the Database first from OCR using srvctl and then delete it from MCMU BUI

-bash-4.1$ srvctl status database -d testdb
Instance testdb1 is not running on node ammcdbn1
Instance testdb2 is not running on node ammcdbn3

-bash-4.1$ srvctl remove database -d testdb
Remove the database testdb? (y/[n]) y

-bash-4.1$ srvctl status database -d testdb
PRCD-1120 : The resource for database testdb could not be found.
PRCR-1001 : Resource ora.testdb.db does not exist

Attachments

This solution has no attachment