su - oracle
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile

cd $ORACLE_BASE/admin/$ORACLE_SID/pfile
cp ../../<SomeExistingSID>/pfile/init<SomeExistingSID>.ora ./init$ORACLE_SID.ora
cp ../../<SomeExistingSID>/pfile/config<SomeExistingSID>.ora ./config$ORACLE_SID.ora

vi init$ORACLE_SID.ora    {change all occurences of the SID 

cd $ORACLE_HOME/dbs
ln -s $ORACLE_BASE/admin/$ORACLE_SID/pfile/init$ORACLE_SID.ora init$ORACLE_SID.ora

* There are multiple ways to do this next step
* METHOD #1

* Create the volumes for your data files, owned by "oracle"/"dba".
* Connect to SERVER MANAGER:

svrmgrl
> CONNECT INTERNAL;
connected.
> CREATE DATABASE ....
  

* METHOD #2
mkdir -p $ORACLE_HOME/../../admin/$ORACLE_SID/create 
cd $ORACLE_HOME/../../admin/$ORACLE_SID/create
cp $ORACLE_HOME/../../admin/<SomeExistingSID>/create/crdb<SomeExistingSID>.sql \
	./crdb$ORACLE_SID.ora
cp $ORACLE_HOME/../../admin/<SomeExistingSID>/create/crdb2<SomeExistingSID>.sql\
	./crdb2$ORACLE_SID.ora
svrmgrl
	connect internal
	@$ORACLE_HOME/../../admin/$ORACLE_SID/create/crdb$ORACLE_SID.sql 
	@$ORACLE_HOME/../../admin/$ORACLE_SID/create/crdb2$ORACLE_SID.sql 


* Update your /var/opt/oracle/oratab file (see below)
* If using SQL*Net, update your listener (vi
$ORACLE_HOME/network/admin/listener.ora) and add the instance. Then,
restart the listener:

lsnrctl stop
lsnrctl start


You need to modify your /var/opt/oracle/oratab file. It should contain a list of all
instances, followed by the Oracle home and a Y/N. Set the value to Y if
you want to bring up the database automatically during a reboot.

Create thet startup scripts for oracle and the listener in /etc/init.d
and link them into /etc/rc0.d and /etc/rc3.d