RE: Multiple databases under the same ORACLE

From: <Yosi_at_comhill.com>
Date: Mon, 18 Jun 2001 08:56:15 -0700
Message-ID: <F001.0032D36D.20010618084050@fatcity.com>

Yes. Each db gets its own service, created by you, using the oradim command (and/or two services, and/or oradim80, both depending on the version of Oracle you're running.)

You would want to separate the db's data files from the Oracle_Home anyway. The only thing in Oracle_Home would be the init.ora file, which would contain the line ifile=FILENAME where FILENAME is the name of the db's real init.ora file, which you put in its own database specific directory outside of Oracle_Home.

Check out the paper(s) on OFA, Oracle Optimal Flexible Architecture, available in many places on the net, I imagine Metalink has it too.

HTH, Yosi

-----Original Message-----
Sent: Monday, June 18, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L

Dear list !
Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ?
If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 18 2001 - 10:56:15 CDT

RE: Multiple databases under the same ORACLE_HOME