using [b]dbca[/b] to create a database is preferred approach:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm
The following describes MANUALLY creating a new oracle database:
Oracle online doc reference:
[u]http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm[/u]
Reference 2:
Search youtube "Oracle DBA Justin - How to create an 11g Oracle database"
http://www.youtube.com/watch?v=QCYIo2Pkke4
1. Create the database ini file under location "$ORACLE_HOME/database".
The file name must be "initMydbname.ora". for instance, for database
SID(less than 8 characters?) "AWCC", the file would be
"$ORACLE_HOME/database/initAWCC.ora".
two mandatory params are "db_name" and "control_files". for example:
db_name=AWCC and control_files="/u02/oracle/databae/oradata
/AWCC/control_01.ctl"
2. create the directories to store database files, this can be anywhere, like:
mkdir /u02/database/oradata/AWCC
3. set env variables:
export ORACLE_HOME=Oracel_installation_dir/product/11.x.x/db_1
export ORACEL_SID=AWCC
4. sqlplus to the database to create, ie, AWCC
sqlplus / as sysdba
5. startup the database, though it's not created yet!
SQL>startup;
6. run your create database script (create database AWCC ...) from sqlplus
SQL>@full_path_to_your_create_db_script;
After complete successfully, database files would be created, including
control files(.CTL), log files(.LOG) and data files (.DBF) etc.
7. run two Oracle scripts "catalog.sql" and "catproc.sql" from sqlplus, these
files are located at $ORACLE_HOME/rdbms/admin
SQL>@?/rdbms/admin/catalog.sql;
SQL>@?/rdbms/admin/cataproc.sql;
? means $ORACLE_HOME
8. restart your database
SQL>shutdown;
SQL>startup;
Warning: these only the steps to create a new Oracle database on the video, not yet tested on a linux machine.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm
The following describes MANUALLY creating a new oracle database:
Oracle online doc reference:
[u]http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm[/u]
Reference 2:
Search youtube "Oracle DBA Justin - How to create an 11g Oracle database"
http://www.youtube.com/watch?v=QCYIo2Pkke4
1. Create the database ini file under location "$ORACLE_HOME/database".
The file name must be "initMydbname.ora". for instance, for database
SID(less than 8 characters?) "AWCC", the file would be
"$ORACLE_HOME/database/initAWCC.ora".
two mandatory params are "db_name" and "control_files". for example:
db_name=AWCC and control_files="/u02/oracle/databae/oradata
/AWCC/control_01.ctl"
2. create the directories to store database files, this can be anywhere, like:
mkdir /u02/database/oradata/AWCC
3. set env variables:
export ORACLE_HOME=Oracel_installation_dir/product/11.x.x/db_1
export ORACEL_SID=AWCC
4. sqlplus to the database to create, ie, AWCC
sqlplus / as sysdba
5. startup the database, though it's not created yet!
SQL>startup;
6. run your create database script (create database AWCC ...) from sqlplus
SQL>@full_path_to_your_create_db_script;
After complete successfully, database files would be created, including
control files(.CTL), log files(.LOG) and data files (.DBF) etc.
7. run two Oracle scripts "catalog.sql" and "catproc.sql" from sqlplus, these
files are located at $ORACLE_HOME/rdbms/admin
SQL>@?/rdbms/admin/catalog.sql;
SQL>@?/rdbms/admin/cataproc.sql;
? means $ORACLE_HOME
8. restart your database
SQL>shutdown;
SQL>startup;
Warning: these only the steps to create a new Oracle database on the video, not yet tested on a linux machine.