Listing 1. Oracle Auxiliary DB Creation Script 

# Example commands needed to create a generic 
# Oracle 9i shell, in a script format, assuming 
# database name is "mydata", remote host is 'host1'
# and an Oracle 9i home already exists

#Create directories for instance
rsh host1 'grep mydata /etc/oratab' >> /etc/oratab   
cd /u01/app/oracle/admin 
mkdir mydata
cd mydata
mkdir adump bdump cdump create pfile udump
cd pfile
rcp -p host1:$(pwd)/initmydata.ora .
cd $ORACLE_HOME/dbs
ln -s /u01/app/oracle/admin/mydata/pfile/initmydata.ora  

#Determine / create directories for control files
grep ctl initmydata.ora
mkdir -p /u02/oradata/mydata/
mkdir -p /u03/oradata/mydata/
mkdir -p /u04/oradata/mydata/

#Determine / create directories for control files
# In sqlplus on target use: 
# "select file_name from dba_data_files order by 1;"
mkdir -p /u05/oradata/mydata/
mkdir -p /u06/oradata/mydata/

#Determine / create directories for archive log files 
grep log_archive_dest initmydata.ora
mkdir -p /u06/oradata/mydata/arch
 
#You should now be able to set your sid and 
#use sqlplus to set to a nomount state

