-----Original Message-----
From: Marcelo Feldman [mailto:Marcelo_Feldman@metrogas.com]
Sent: Monday, August 24, 1998 3:56 PM
To: akaplan@interaccess.com
Subject: Databases creation
We want to know how we can create two databases in the same server. We want
to create each databases with one instance.
The server Operating System is Windows NT and the Oracle version is
7.3.4.0.
Other issue, could the instances run at the same time? and, ,how can
we access to the instance from the server manager?.
Thank you for your help. We are looking forward to your answer.
-----Reply Message---------
You will need to get familiar with OFA: Optimal Flexible Architecture.
Basically, you need to keep the directories of each database separate. For
example, assume you have drives /u01, /u02, and /u03, and databases db1 and db2.
You should keep the Oracle datafiles and redo logs in
/u01/oradata/db1
/u01/oradata/db2
/u02/oradata/db1
/u02/oradata/db2
/u03/oradata/db1
/u03/oradata/db2
Also keep your $ORACLE_BASE/admin/db1/bdump, cdump, udump, etc. directories
separate from $ORACLE_BASE/admin/db2/bdump, cdump, udump, etc.
In UNIX you would need to specify separate ORACLE_SID environment variables. In
NT I don't recall which variable keeps track of this. Also, use SQL*Net easy
config to add your new database to your sqlnet.ora, listener.ora, and
tnsnames.ora.
Basically, yes you can have multiple databases on the same server. For Server
Manager, you can enter the connect string to specify which database to connect
to. "db1" or "db2".
Best of luck!
-Ari Kaplan
www.arikaplan.com
Back to Ari Kaplan's Home Page