Registering Manual Database with DBCA

Database created manually using traditional CREATE DATABASE command cannot be identified using DBCA Utility for following purposes

Create or Manage templates

Drop database

Change database options

The DBCA will not identify SID for manually created database unless the entry is added in ORATAB file.

Sample:

$ vi /var/opt/oracle/oratab

prod:/u00/app/oracle/product/9.2.0.1.0:N

Drop Database using DBCA

When you drop database using DBCA it will create ShutdownInst.log in $ORACLE_HOME/assistants/dbca/logs; If this file already exists then drop database might fail. So move the old file and run DBCA again.

Sample:

$ more ShutdownInst.log

/u00/app/oracle/oradata/prod/control01.ctl

/u00/app/oracle/oradata/prod/control02.ctl

/u00/app/oracle/oradata/prod/control03.ctl

/u01/prod/database/drsys_prod.dbf

/u01/prod/database/log1a_prod.rdo

/u01/prod/database/log2a_prod.rdo

/u01/prod/database/log3a_prod.rdo

/u01/prod/database/log4a_prod.rdo

/u01/prod/database/system_prod.dbf

/u01/prod/database/tools_prod.dbf

/u01/prod/database/xdb_prod.dbf

/u02/prod/example_prod.dbf

/u02/prod/users01_prod.dbf

/u02/prod/users02_prod.dbf

/u03/prod/log1b_prod.rdo

/u03/prod/log2b_prod.rdo

/u03/prod/log3b_prod.rdo

/u03/prod/log4b_prod.rdo

/u04/prod/control04.ctl

/u04/prod/index01_prod.dbf

/u05/prod/temp01_prod.dbf

/u05/prod/undotbs01_prod.dbf

Database closed.

Database dismounted.

ORACLE instance shut down.