How to troubleshoot createDb failure when at least part of the database has already been created

Document ID : KB000056985
Last Modified Date : 14/02/2018
Show Technical Document Details

PROBLEM

When attempting to create a new database on an eHealth server after either a failed installation attempt, or simply attempting to create a new database from command line, you will receive an error as seen below.

If you are trying to create a new database named CAEH1, that means you have not destroyed database CAEH1 successfully, and you need to run command of 'nhDestroyDb -s CAEH1', followed by the command of 'nhCreateDb -s EHEALTH'

# nhCreateDB -s EHEALTH
log file is: D:/EMS/CA/eHealth/log/install/CreateDb2.log
ORACLE_SID is: EHEALTH
Error.

Cannot create database for ORACLE_SID='EHEALTH'
because at least part of it has already been created:
  D:/EMS/CA/oracle/Oracle.11.2/database/initEHEALTH.ora

ENVIRONMENT

eHealth 6.0 or higher
Any OS platform

SOLUTION

The existing database or partial database must be destroyed prior to creating a new database. Use the following command to properly destroy the original/partial database.

nhDestroyDb -s {SID}

Replace {SID} with the name of your database. In the example above, the database name is EHEALTH.

Please note that in a Windows environment, you must reboot the server after destroying the database.