oracle manual database creation
oracle manual database creation steps :
Step 1: Create the environment file
~]$ vi orcl.env
export ORACLE_SID=orcl
export ORACLE_HOME=/oraeng/app/oracle/product/10.2.0
export ORACLE_BASE=/oraeng/app/oracle/prodyct
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export CLASS_PATH=$ORACLE_HOME/jlib
export TNS_ADMIN=$ORACLE_HOME/network/admin
:wq!
and execute the environment file
~]$sh orcl.env
Step 2 : make the directory structure to store the database
~]$ mkdir -p /u01/oradata/oracl
~]$ cd /u01/oradata/oracl
orcl]$ mkdir udump bdump cdump arch
step 3 : Go to $ORACLE_HOME/dbs location and edit the parameter file
~]$ $ORACLE_HOME/dbs
dbs]$ cp init.ora init$ORACLE_SID.ora
dbs]$ vi initorcl.ora
SID=orcl
shared_pool_size=64m (minimum)
control_files=/u01/oradata/orcl/control_01.ctl
user_dump_dest=/u01/oradata/orcl/udump
core_dump_dest=/u01/oradata/orcl/cdump
background_dump_dest=/u01/oradata/orcl/bdump
undo_tablespace=undotbs
undo_management=auto
undo_retention=900(default)
compatible=10.2.0
:wq!
step 4 : create the database structure in user home location
~]$ vi createorcl.sql
create database orcl
datafile '/u01/oradata/orcl/system.dbf' size 200m autoextend on
sysauxdatafile '/u01/oradata/orcl/ sysaux.dbf' size 100m autoextend on
default tablespace userdatadatafile '/u01/oradata/oracl/userdata.dbf' size 50m
default temporary tablespace temptempfile '/u01/oradata/orcl/temp.dbf' size 50m
undo tablespace undotbsdatafile '/u01/oradata/orcl/undo.dbf' size 50m
logfile
group 1(/u01/oradata/orcl/redo1a.log) size 4m, #(minimum in 10g)
group 2(/u01/oradata/orcl/redo2a.log) size 4m;
:wq!
step 5 : create the script for data dictionary views, default tables procedures etc... in user home location.
~]$ vi run.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sqlconnect system/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
:wq!
step 6: connect to sql prompt and run the both scripts (createorcl.sql, run.sql)
~]$sh orcl.env
~]$sqlpus '/as sysdba'
SQL> startup nomount
SQL>@createorcl.sql
Database created
SQL> run.sql
after finishing the script just connect as sysdba and check the status and object.
SQL>conn / as sysdba
SQL> select status from v$instance;
SQL> select count(*) from tab;
3492
one row selected.
HTML Comment Box is loading comments...