Overview
Sometimes we have to remove a configuration from the Grid Infra, this is done again fairly simple, just BE SURE YOU WANT TO DO IT :)
Basically to command to remove database configuration is the following:
[oracle@Naos dbs]$ . oraenv
ORACLE_SID = [rcat] ? +ASM
The Oracle base has been changed from /u01/app/oracle to /u01/app/12.2.0
[oracle@Naos dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BANKINGDATA.dg
ONLINE ONLINE naos STABLE
ora.BANKINGFRA.dg
ONLINE ONLINE naos STABLE
ora.LISTENER.lsnr
ONLINE ONLINE naos STABLE
ora.RCATDATA.dg
ONLINE ONLINE naos STABLE
ora.RCATFRA.dg
ONLINE ONLINE naos STABLE
ora.asm
ONLINE ONLINE naos Started,STABLE
ora.ons
OFFLINE OFFLINE naos STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE naos STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE naos STABLE
ora.rcat.db
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[oracle@Naos dbs]$ srvctl remove database -db rcat
Remove the database rcat? (y/[n]) y
[oracle@Naos dbs]$
[oracle@Naos dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BANKINGDATA.dg
ONLINE ONLINE naos STABLE
ora.BANKINGFRA.dg
ONLINE ONLINE naos STABLE
ora.LISTENER.lsnr
ONLINE ONLINE naos STABLE
ora.RCATDATA.dg
ONLINE ONLINE naos STABLE
ora.RCATFRA.dg
ONLINE ONLINE naos STABLE
ora.asm
ONLINE ONLINE naos Started,STABLE
ora.ons
OFFLINE OFFLINE naos STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE naos STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE naos STABLE
--------------------------------------------------------------------------------
[oracle@Naos dbs]$