Re: Two databases but one instance

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