Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Two databases but one instance

Re: Two databases but one instance

From: Bent Mathiesen <bm_at_tli.de>
Date: Tue, 28 Dec 1999 05:20:58 +0100
Message-ID: <31eg6s4gu26gg0o1fge34eg3997vhkmish@4ax.com>


On Mon, 27 Dec 1999 21:17:25 GMT, Paul Bennett <bennett_at_cc.gatech.edu> wrote:

>We need to make sure we are on the same page when talking about "databases" If
>someone comes from the SQLServer world to the oracle world there might be some
>confusion.

Actually, if people from DB2 world talk about "databases" that is/will be different as well.

>If you have two separate sets of tables, say for two different applications, you
>can run them both in one instance of oracle. You would simply create two schemas
>and put the corresponding tables in each schema. You would then create all your
>users (which are really just schemas) for each application and set the permissions
>accordingly.

shemas=tablespaces, when talking about tables to put in ?

>Now, both applications would share the same SGA, rollback segs, etc.
>
>You can accomplish this by exporting the tables from instance1 and importing them
>into instance2. The import program allows you to import into a different schema
>then you exported from.

I would say that you should look out for name conflicts. Be sure to log the outpt from import (and export) and study it carefully. Be also sure that the nessesary permissions, space, etc exist before importing.

If users, tablespaces, table, etc all differ in the two databases, then it should be straight forward. I asume the two databases are identical (same version and have the same administration scripts applied).

/Bent

>-- Paul
>
>Vincent Ventrone wrote:
>
>> Henrik Meldgaard Frisk wrote:
>> >
>> > Hi
>> >
>> > I have to different databases running oracle8.0.4, but today they both have
>> > there own instances, but I would like to just have one instance for both
>> > databases. Then it would be more easy to administrate in the future.
>> > But I don't have a lot of experience in this. How much work dos it take, and
>> > how shall I do it?
>>
>> This is NOT POSSIBLE -- there is no way in Oracle for a single instance
>> (that is, set of background processes & memory data structures) to
>> manage two databases (i.e., two sets of database files.) You *can* have
>> multiple instances managiung a single database in a Parallel Server
>> configuration -- but this is more complex to manage. Stick with one
>> instance/one database. (In fact, I don't even know how you could manage
>> to have a single instance manage multipole databases -- each instance
>> only has a sinle internal database name, a single set of(identical)
>> control files, etc.
>> --
>> Vincent Ventrone | The MITRE Corp.
>> DBA, Dept. R101 | M/S C020
>> vav_at_mitre.org | 202 Burlington Rd.
>> (781) 271-7048 | Bedford, MA 01730
Received on Mon Dec 27 1999 - 22:20:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US