| Creating a Second Instance using the same user account [message #62015] |
Fri, 18 June 2004 00:27  |
Software
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
I have been asked to create a second database for the purposes of training.
I have the following situation
I have only one user account that has sysdba privilege and this user account
was used to create the production database lets call it "prod_db" and as
such the ORACLE_SID for this user account is "prod_db"
My question to you is, since this user account is the only account that can
CONNECT INTERNAL and thus create a new database is it right/correct for me
to set the new ORACLE_SID to the new database that I want to create
("train_db") like below
<DIR>
1. ORACLE_SID=train_db ; export ORACLE_SID
2. Svrmgrl
3. Connect internal
4. Create database .... Etc, etc,
</DIR>
My other question is what exactly is the use of ORACLE_SID, what is its
purpose/significance? IF I change the ORACLE_SID from "prod_db" to
"train_db" just to create this database will this not have side effects on
the "prod_db" ? I am using Oracle 7.3.4.0
Thank you in advance for all the help.
|
|
|
|
| Re: Creating a Second Instance using the same user account [message #62017 is a reply to message #62015] |
Fri, 18 June 2004 01:23  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
the way you mentioned is okay. The ORACLE_SID will tell oracle which environment you will use. If you set it to a new SID it will install a new Instance.
You need to out the SID as well into the oratab file and create the subdirectories for storing the data- and logfiles.
Than you need to change values in the $ORACLE_HOME/dbs/init.ora. You need to make a new copy for the next environment. Before sending create database you need to start up the new instance with:
startup pfile=$ORACLE_HOME/dbs/init_test_db.ora
inside sqlplus /nolog or svrmgrl.
after starting the instance you can create the database with create database.
This will give you the way to start/stop the instances without taking effect on the other instance.
hth
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
