Manual Database Creation 11g

Creating Oracle 11G Database manually in Linux Operating system

Step 1: Create Directory structure

#cd $ORACLE_BASE

# cd admin

# mkdir test

#cd test

#mkdir adump  bdump  pfile

#cd fast_recovery_area

# mkdir test

Step 2: Create Parameter file in  $ORACLE_HOME/dbs location

cd $ORACLE_HOME/dbs

vi initTEST.ora

TEST.__db_cache_size=8489271296

TEST.__java_pool_size=33554432

TEST.__large_pool_size=33554432

TEST.__oracle_base='/u03/app/oradba'#ORACLE_BASE set from environment

TEST.__pga_aggregate_target=3388997632

TEST.__sga_target=10166992896

TEST.__shared_io_pool_size=0

TEST.__shared_pool_size=1509949440

TEST.__streams_pool_size=33554432

*.audit_file_dest='/u03/app/oradba/admin/TEST/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u03/app/oradba/oradata/TEST/control01.ctl','/u03/app/oradba/fast_recovery_area/TEST/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='TEST'

*.db_recovery_file_dest='/u03/app/oradba/fast_recovery_area'

*.db_recovery_file_dest_size=4322230272

*.diagnostic_dest='/u03/app/oradba'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'

*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vtebz1.masscloudspace.local)(PORT=1521)))'

*.open_cursors=300

*.pga_aggregate_target=3380609024

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=10141827072

*.undo_tablespace='undo'

:wq

Step 3: Create the Password file

                        $orapwd file=$ORACLE_HOME/dbs/orapwtestdb

                        Password=sys entries=10

Step 4: Start the database in nomount state

SQL> startup nomount pfile=initTEST.ora

Step 5:Write and execute Database creation script

SQL> create database TEST

  2  logfile '/u03/app/oradba/oradata/TEST/redo01.log' size 50m,

  3             '/u03/app/oradba/oradata/TEST/redo02.log' size 50m

  4  datafile '/u03/app/oradba/oradata/TEST/system01.dbf' size 100m

  5  sysaux datafile '/u03/app/oradba/oradata/TEST/sysaux01.dbf' size 100m

  6  default temporary tablespace temp

  7  tempfile '/u03/app/oradba/oradata/TEST/temp01.dbf' size 100m

  8  undo tablespace undo

  9  datafile '/u03/app/oradba/oradata/TEST/undo01.dbf' size 100m;

Database created.

Step 7: Execute the catalog.sql,catproc.sql and pupbld.sql scripts

a)catalog.sql =>Creates dictionary tables and views
                          

b)catproc.sql =>Creates PL/SQL procedures,functions and packages necessary.

c)pupbld.sql  =>Creates user profiles.


So our database is created. Now just run the catalog.sql,catproc.sql and pupbld.sql scripts.
Location for catalog.sql and catproc.sql in $ORACLE_HOME/rdbms/admin  path and     pupbld.sql in $ORACLE_HOME/sqlplus/admin path.

                   SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
          conn system/manager

SQL>@$ORACLE_HOME/sqlplus/admin/pupbld.sql

Refer:

Manual Database Creation in Oracle9i (Single Instance and RAC) (Doc ID 137288.1)