DBCA Template based silent installation fails for 11g R2

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

For starters...

1- It should be "-characterSet" not "characterSet"
2- Check "oracle" user - or whatever account you are using to install - has proper privileges on /u02/oradata

Last but not least - for documentation purposes is not a good practice to feed everything on the command line; much better to do it thru a response file which can be saved for future reference.

Quote:

Originally Posted by PAVB

For starters...

1- It should be "-characterSet" not "characterSet"
2- Check "oracle" user - or whatever account you are using to install - has proper privileges on /u02/oradata

Last but not least - for documentation purposes is not a good practice to feed everything on the command line; much better to do it thru a response file which can be saved for future reference.

Thanks Paul for this reply.

I conducted a detailed revision. It seems that I had another transcription error on charaterset, it has to be "AL32UTF8", not "ALF32UTF8". It went fine.

From next time I will induce this practice to use response file.

Thanks for you time and advise.

Cheers,
Bhaskar