This content has been marked as final. Show 4 replies
Is there any specific reason you did not use dbca?
Make sure that you have followed all steps from the listed below document:
After manual database creation have you executed the following scripts:
Sys user: @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql System user: @$ORACLE_HOME/sqlplus/admin/pupbld.sql
X A H E E R
During Manual DB creation, we execute catalog.sql and catproc.sql
So it will create only catalog and catproc components.
To get other components you need to execute sql files available for those components
To know components and respective sql files, kindly refer
Information On Installed Database Components and Schemas (Doc ID 472937.1)
Raw devices are deprecated. In fact usage of DBCA for datafiles on raw devices is not supported in 11.2
You shouldn't be using raw devices even if you do a manual database creation.
The other, serious, risk with manual database creation is that you may not know which scripts are necessary. It was only in V7 (and maybe 8.0) that catalog.sql and catproc.sql were sufficient. Since 8i, Oracle has been introducing additional scripts.
What I prefer to do is to use DBCA to generate the create database scripts first. I then review the scripts, identify all the additional scripts that are executed. I then run the DBA generated scripts. At most, I might edit the script for datafile directory names or (when I copy scripts from one server to another) the location of $ORACLE_HOME. But I would not remove any of the scripts that DBCA generates.
Hemant K Chitale