Database can be created using any of the following methods. 1.At the time of installation of oracle software. 2.Using dbca. 3.Manually. we need to add oracle environments to .bash_profile. $vi .bash_profile OR $cat >> .bash_profile export ORACLE_HOME=/pathtooraclehome export ORACLE_SID=prod export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH delete the last line. :wq env |grep ORA . .bash_profile 1.Create directory structure mkdir dev cd dev mkdir control data log arch diag 2.Make the parameter file oracle$cd $ORACLE_HOME/dbs (path=/home/oracle/prod) oracle$vi initdev.ora db_name=dev control_files = '/home/oracle/dev/control/control1.ctl','/home/oracle/dev/control/control2.ctl'
virtualnuggets offering oracle dba online training,corporate training services.
ReplyDeleteDatabase can be created using any of the following methods.
1.At the time of installation of oracle software.
2.Using dbca.
3.Manually.
we need to add oracle environments to .bash_profile.
$vi .bash_profile OR $cat >> .bash_profile
export ORACLE_HOME=/pathtooraclehome
export ORACLE_SID=prod
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
delete the last line.
:wq
env |grep ORA
. .bash_profile
1.Create directory structure
mkdir dev
cd dev
mkdir control data log arch diag
2.Make the parameter file
oracle$cd $ORACLE_HOME/dbs
(path=/home/oracle/prod)
oracle$vi initdev.ora
db_name=dev
control_files = '/home/oracle/dev/control/control1.ctl','/home/oracle/dev/control/control2.ctl'