Re: Sybase and Oracle on the same box?

bob wuttke wrote:

> Yes its possible, but my experience tells me running 2 different
> database servers on the same box is disasterous. Since databases use
> shared memory, there is a high probability that a memory page from
> SYBASE can find its way into the address space of an ORACLE page (or
> vice versa). The result is a corrupted datafile in ORACLE.

Er, any OS with properly written and used shared memory pages would prevent this. You must have either installed them as the same user, used a pretty crappy OS, or had some seriously buggy code.

I've run Sybase and Oracle on the same box for both AIX and HP-UX without *any* problems. I would never recommend this, but it can easily be done, especially if you've got lots of ram and free disks.

>
>
> I spent a few months (back in 1996) repairing periodic 'shotgun blasts'
> in my database (I had to edit the hex values of data block headers in my
> file system-based datafiles). We later discovered a job scheduling
> product using SYBASE in raw partitions was writing status messages in
> the middle of a data table in ORACLE. We had this product relocated and
> the problem went away.

Er, if you can tell me how a user called *sybase* (in it's own group) can write to an active partition owner by a user called *oracle* (in it's own group) - or vice versa - without any permissions on it whatsoever then I am all ears. Sounds like bad installation to me.

>
>
> I would have to strongly advise against it. Good Luck.
>
> bobw
>
> Sergei Galperin wrote:
>
> > Hi
> > Does anybody run Sybase and Oracle on the same box?
> > Is it possible?
> > I appreciate your answer.
> >
> > Sergei, Oracle/Sybase DBA

Steve Phelan,

(Oracle 7 & 8 OCP). Received on Fri Feb 19 1999 - 14:53:34 CST