Hi All,

I am working on automated installation and creation for Oracle DB. I have installed the base software first (went successfully) then using DBCA to install and create Database from Template. For this I have run DBCA in GUI mode first, created the template for my configuration and installed the DB which is perfectly fine, then used that template to create DB with same configuration silently. In silent mode DBCA behaves differently for the same configuration and template file generated from GUI installation.

The command I have used:
Code:
dbca -silent -createDatabase -template MyTemplate.dbt -gdbName MYDB112 -sid MYDB112 -SystemPassword manager -SysPassword manager -emConfiguration NONE -datafileDestination /u02/oradata -storageType FS characterSet ALF32UTF8
After installation is done Database behaves like this way:

STARTUP:
Code:
SQL> startup
ORACLE instance started.

Total System Global Area 1.3700E+10 bytes
Fixed Size 2161112 bytes
Variable Size 6878660136 bytes
Database Buffers 6777995264 bytes
Redo Buffers 41164800 bytes
ORA-00205: error in identifying control file, check alert log for more info
SHUTDOWN:
Code:
SQL> shutdown normal
ORA-01507: database not mounted

ORACLE instance shut down.
OBSERVATION
1. There is no controlfile/datafile created in the path mentioned in template. I wonder do I have to pass them from command line? because in template already everything was configured and that template was created from a working DB.

2. In Log file error occurs like ORA-12701: CREATE DATABASE character set is not known howwver I pass it from command line

3. Please find the log file to provide a quick glimpse to your experienced eye what has happened: (I hav resized removed same errors)

DBCA LOG FILE
Code:
Creating and starting Oracle instance
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-12701: CREATE DATABASE character set is not known

DBCA_PROGRESS : 6%
Creating database files
ORA-01109: database not open

ORA-01507: database not mounted

DBCA_PROGRESS : 7%
DBCA_PROGRESS : 13%
Creating data dictionary views
DBCA_PROGRESS : 15%
ORA-01109: database not open

ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_REGISTRY.LOADING' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored

ORA-06550: line 3, column 15:
PLS-00201: identifier 'REGISTRY$.VERSION' must be declared
ORA-06550: line 3, column 15:
PL/SQL: Item ignored
ORA-06550: line 4, column 19:
PLS-00201: identifier 'REGISTRY$.VERSION' must be declared
ORA-06550: line 4, column 19:
PL/SQL: Item ignored
ORA-06550: line 6, column 20:
PLS-00201: identifier 'DBMS_REGISTRY_SERVER.XDB_PATH' must be declared
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored
ORA-06550: line 12, column 8:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-01109: database not open

ORA-01109: database not open
.
.
.
ORA-01109: database not open

ORA-01109: database not open
Completing Database Creation
DBCA_PROGRESS : 84%
DBCA_PROGRESS : 86%
ORA-01219: database not open: queries allowed on fixed tables/views only

DBCA_PROGRESS : 88%
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

DBCA_PROGRESS : 94%
ORA-01507: database not mounted

ORA-00205: error in identifying control file, check alert log for more info

ORA-01507: database not mounted

DBCA_PROGRESS : 95%
ORA-01507: database not mounted

ORA-01507: database not mounted

ORA-00205: error in identifying control file, check alert log for more info

DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/MYDB112.
Database Information:
Global Database Name:MYDB112
System Identifier(SID):MYDB112
I have tried to search as best in this forum not able to found anything specific to this scenario. Sincere Apologies for any mistake as this is I am doing first time Oracle installation and If I have violated any thread rules.

Any help/redirection would be a great help. Let me know if you need more information.

Thanks a advance,
Bhaskar