Re: How do you create 2 dbs on the same machine
From: Morgan Skinner <morgan_at_odo.fisons-lims.com>
Date: 16 Feb 1995 19:02:08 GMT
Message-ID: <3i07fg$p9u_at_alterdial.UU.NET>
> I would like to know if it is possible to create another separate
> database with its own files on the same machine?
> There is currently the "scms" database on the machine. Would there
> be a problem with the ORACLE_SID with 2 dbs on the same machine?
>
Date: 16 Feb 1995 19:02:08 GMT
Message-ID: <3i07fg$p9u_at_alterdial.UU.NET>
cs5gr_at_scms.rgu.ac.UK (Graeme Raffan) wrote:
>
> I would like to know if it is possible to create another separate
> database with its own files on the same machine?
> There is currently the "scms" database on the machine. Would there
> be a problem with the ORACLE_SID with 2 dbs on the same machine?
>
No problem - just go into ORACLEINS and create a new instance etc. You can have the instances on the same disks if you so desire - we have one sales machine with four instances running at the same time so two should be no problem at all.
As for connecting the two together, we use SQL*Net and can access one DB from the other with no problems.
Hope this helps!. Received on Thu Feb 16 1995 - 20:02:08 CET