Re: Oracle Express & Oracle Client On Same Machine

On Feb 8, 8:47 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Feb 8, 3:19 pm, "Jack" <jrsc..._at_comcast.net> wrote:
>
> > Has anyone put Oracle Express (9i or 10g) and Oracle (10g) Client on
> > the same machine (Windows XP)? I was planning to do so, but I
> > wondering if anyone has done this already. If some one has done this,
> > are there any problems that I should look out for? What configuration
> > settings should I use on the host? Pointers would be appreciated.
>
> There is no such thing as Oracle Express 9i.
> The best you can do is (as usual) read the installation documentation
> (which you obviously try to avoid by posting here), and you will find
> the customary answer they need to be installed in different
> Oracle_homes.
> Apart from that obviously both products will use resources, and all of
> our crystal balls have worn out, you can not expect anyone here is
> capable of abstracting the installation document specifically for your
> situation.
>
> The installation manual can be found herehttp://download-uk.oracle.com/docs/cd/B25329_01/doc/install.102/b2514...
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Perhaps I should have made myself more clear.

Yes, there is no Oracle 9i Express, but there is Oracle 9i Personal. To me, they are one and the same. I want to either install Oracle 9i Personal or Oracle 10g Express on the same box as the Oracle 10g Client.

Yes, the binaries will be in separate directories.

My real question involves the hardware requirements and configuration parameters of the host. How much memory is needed? What should the host configuration be? I am a Unix jockey and my knowledge of Microsoft is limited. I use PCs as a means to access Unix boxes and their database servers. Unlike Sybase where you can set the database server's maximum memory use, I am worried that the multiple Oracle processes will sucking up all the memory and then some, although Oracle 10g Express supposely limits itself to a maximum of 1GB of memory. The machine is question has only 1GB of memory and it has other critical applications on it (Toad, Rapid SQL, Oracle Migration Workbench, etc.). I may want to put Sybase SQL Anywhere on it instead of Oracle Express if the resource requirements are unreasonable. Any mention of Microsoft Access will be ignored. For the moment, I am exploring the alternatives. Received on Fri Feb 09 2007 - 08:38:21 CST