Re: Multiple instance question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 21 Jul 1999 07:06:38 +0200
Message-ID: <932533576.13946.0.pluto.d4ee154e@news.demon.nl>

There should be NO need to install Oracle multiple times, especially if this is the same version.
You should rather follow OFA and make sure the datafiles of both databases are spread amongst those two drives, if that's at all possible, because your post looks like you have 2 disks in total, to hold both the OS and Oracle and datafiles.
Following OFA you could make a layout like this

/u02/oradata/inst1 on disk1
/u03/oradata/inst1 on disk2
/u02/oradata/inst2 on disk1

and so on, as long as the inst1 and inst2 directories in each tree are mount points and thus separate filesystems.
Following OFA you would also get two distinct administrative directories /u01/app/oracle/admin/inst1
/u01/app/oracle/admin/inst2
and no need to have multiple Oracle installs.

Hth,

Sybrand Bakker, Oracle DBA

s <ks_at_yahoo.com> wrote in message news:37950C93.D6764F93_at_yahoo.com...
> We are getting ready to migrate two databases to a new Sun Box with a
> separate disk array. Both will be using Oracle 8.0.5.
> Our DBA wants to have separate software installations for each database
> with separate filesystems built and mounted separately for the
> executables and datafiles.
>
> So, one installation would be built as /disk1/oracleinstall1/../../..
> and have all the software go under this filesystem mount
> and the second would go under /disk2/oracleinstall2 /../../..and the
> software for this database would then go under this filesystem mount.
> Then each instance would be started from these two separate Oracle
> Home's
>
> Then, each database would have separate disks assigned separately for
> their particular datafiles.
> By going this route, we would only be allowed to stripe 2 disks, and
> then mirror them (RAID 1+0)
>
> Has anyone else seen this approach taken before?
>
>
>
>
Received on Wed Jul 21 1999 - 00:06:38 CDT