ORACLE_HOME in 7.3.2.3 
Author Message
 ORACLE_HOME in 7.3.2.3

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.

Has anyone heard of or dealt with this situation?  How do we set up the
two separate areas?

Thanks,

--Kitt Edelstein

--
------------------------------------------------------------------------------

Christopher (Kitt) Edelstein                    email:

ISC - Systems Engineering                       phone:  215.573.7242
University of Pennsylvania                        fax: 215.898.0386
3401 Walnut Street, Suite 265C
Philadelphia, PA 19104-6228



Sun, 28 Nov 1999 03:00:00 GMT
 ORACLE_HOME in 7.3.2.3

Can't help with your question, BUT  -  Is 10.5 certified to run on a
version of Oracle higher than 7.1.6??



Quote:
> 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.

> Has anyone heard of or dealt with this situation?  How do we set up the
> two separate areas?

> Thanks,

> --Kitt Edelstein

> --

----------------------------------------------------------------------------
--

- Show quoted text -

Quote:

> Christopher (Kitt) Edelstein                    email:

> ISC - Systems Engineering                       phone:  215.573.7242
> University of Pennsylvania                        fax: 215.898.0386
> 3401 Walnut Street, Suite 265C
> Philadelphia, PA 19104-6228



Mon, 29 Nov 1999 03:00:00 GMT
 ORACLE_HOME in 7.3.2.3


Quote:

>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



Mon, 29 Nov 1999 03:00:00 GMT
 ORACLE_HOME in 7.3.2.3

Quote:

> Can't help with your question, BUT  -  Is 10.5 certified to run on a
> version of Oracle higher than 7.1.6??



> > 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.

> > Has anyone heard of or dealt with this situation?  How do we set up the
> > two separate areas?

> > Thanks,

> > --Kitt Edelstein

> > --

> ----------------------------------------------------------------------------
> --

> > Christopher (Kitt) Edelstein                    email:

> > ISC - Systems Engineering                       phone:  215.573.7242
> > University of Pennsylvania                        fax: 215.898.0386
> > 3401 Walnut Street, Suite 265C
> > Philadelphia, PA 19104-6228

In order to run OGF 10.5 under rdbms 7.3.2 (from 7.1.6), you must order
an "interoperability patch" from Oracle support.


Mon, 29 Nov 1999 03:00:00 GMT
 ORACLE_HOME in 7.3.2.3

As long as the version of Developer you have is compatible for a server
install with your database version you should have no problems installing
into the same ORACLE_HOME.

I have Reports installed in my 7.3.2.3 ORACLE_HOME and everything works
fine.

Quote:
> 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.

> Has anyone heard of or dealt with this situation?  How do we set up the
> two separate areas?



Tue, 30 Nov 1999 03:00:00 GMT
 ORACLE_HOME in 7.3.2.3

Yes.  It was certified to run with 7.3.2.3 a couple of months ago.

Quote:

> Can't help with your question, BUT  -  Is 10.5 certified to run on a
> version of Oracle higher than 7.1.6??

--
------------------------------------------------------------------------------

Christopher (Kitt) Edelstein                    email:

ISC - Systems Engineering                       phone:  215.573.7242
University of Pennsylvania                        fax: 215.898.0386
3401 Walnut Street, Suite 265C
Philadelphia, PA 19104-6228



Fri, 03 Dec 1999 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Finding Oracle_Home programatically(sp?)

2. ORACLE_HOME is not set in your environment (Mandrake-80)

3. %ORACLE_HOME%: OAS 4.0 vs Oracle 7.3 on Win NT

4. Avoiding Symbolic Links in setting ORACLE_HOME variable on UNIX

5. cron and ORACLE_HOME env

6. TNSNAMES.ORA not in ORACLE_HOME

7. What are all the files in $ORACLE_HOME/bin ?

8. OAS/Database ORACLE_HOME compatabilities and related issues

9. ORACLE_HOME for application server

10. DRG-11208 and ORACLE_HOME

11. ORACLE_HOME and DEFAULT_HOME

12. 2 databases 2 listeners 1 oracle_home


 
Powered by phpBB® Forum Software