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.

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

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

02-19-2012, 09:59 AM

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.

02-19-2012, 06:09 PM

bhaskar_m

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.