Re: ORACLE_HOME in 7.3.2.3

In article <339EBFC4.8AA31804_at_isc.upenn.edu>, edelstec_at_isc.upenn.edu says...
>
>Hi. We are running Oracle Government Financials 10.5 over a 7.1.6.2
>database, and we are preparing to upgrade to 7.3.2.3. I have heard
>through the grapevine (it's not noted in the upgrade/installation
>manuals) that we will have to establish a separate ORACLE_HOME for
>Oracle's CDE tools (SQL*Forms, reports, etc.) - that they cannot share
>the same ORACLE_HOME as the database.

If Financials is based on Developer/2000 (aka, Forms 4.5 and Reports 2.5) this is probably true. We were using D/2000 release 1.0 with Oracle 7.1.6 in the same ORACLE_HOME. We installed Oracle 7.3.3 in a new directory and tried to re-install D/2000 in the same directory. The install blew up and we called Oracle. They said we had two choices: upgrade D/2000 to 1.3.2 and keep Oracle in the same directory or keep D/2000 1.0 and go client/server. We took the second option.

The idea with client/server is that Oracle7 is on one machine and D/2000 is running on another. Using two machines, obviously, requires two ORACLE_HOMEs. You CAN put them both on the same machine, you just need point ORACLE_HOME to a different place for each install. This is the setup we use: ORACLE_BASE=/tools/cots/solaris.2.x/oracle7 For Oracle7
  ORACLE_HOME=$ORACLE_BASE/product
For Developer/2000
  ORACLE_HOME=$ORACLE_BASE/d2000 Received on Thu Jun 12 1997 - 00:00:00 CDT