Create a second database from an existing ORACLE_HOME
DB Version:11.1.0.6.0
OS : AIX
We have a database running for an OLTP test environment. We need to create another database of same version (11.1.0.6.0) for Datawarehousing needs. The init.ora parameter are going to be different for this. So we need to create another database.
We are having some issues with dbca due to some JAVA related errors. So, we need to use the 'CREATE DATABASE' statement.
This is what i am going to do.
1. create an init.ora file for the new db and copy it to $ORACLE_HOME/dbs
2. Set the env variables
export ORACLE_HOME=/u01/oracle/product/11.1.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID= <sid of the database which i am going to create>
3.
sqlplus / as sysdba
SQL> startup nomount pfile=$ORACLE_HOME/dbs/initora318.ora
4. Copy, Paste the Create Database statement.
Are these steps right?
I know that Enterprise Manager would not be configured using this method. But configuring EM shouldn't be a complex exercise.Right?
Edited by: N.Page on 11-Sep-2009 00:28