Oracle Database Appliance X4-2
 
Oracle Database Appliance
 
Oracle Database - Enterprise Edition
 

PLA-Support>Eng Systems>Exadata/ODA/SSC>Oracle Database Appliance>DB: ODA_EST
 

In this Document

Symptoms

Cause

Solution

References

Created from <SR 3-9349265611>

Applies to:

Symptoms

oakcli fails to delete the database which cannot startup and it has to be removed manually. oakcli fails to create a database with the same name and reports that the database name already exists, even though all the physical files were deleted.

Cause

The command "oakcli show databases" reports the database whose physical files may have been deleted manually as the database entry still exists in ocr and oratab.
 

Solution

If the database cannot be started, it will be necessary to execute these steps manually:
 
1) Verify you have deleted ALL the database files and control files:

      a: If the database files are stored at the OS as standard files, simply remove the files (typically $ORACLE_BASE/oradata/SID)

      b: If database was using ASM, the database files must be removed from ASM using asmcmd if directory / filenames are known.  If not known, idenitifying the database files can tricky without starting the database in mount mode.

          You will need to first get the database to mount stage and then query v$database_file for the file list. 

           Once in mount mode, you can also do aa backup controlfile to trace and use that data for the file names / locations:  "alter database backup controlfile to trace; "

          Then you can use asm (sqlplus or asmcmd) to delete the database or the specific database files

        When the file is created by Oracle the format in +ASM is:
            DISKGROUP_NAME/db_name/file_type/creation_date/<file_name>.
  
2) Delete spfile/init.ora files from the ORACLE_HOME/dbs directory (or from within ASM if stored in ASM).
 
3) Remove the database and instance resources from ocr:

      #srvctl remove database –d 
 
4) Remove the entry from oratab file.

References

This solution has no attachment