Re: Faking Forms4.5 to 9iR2 DBMS

Giganews Newsgroups
Subject: Re: Faking Forms4.5 to 9iR2 DBMS
Posted by:  DA Morgan (damorg…
Date: Thu, 27 Jan 2005

ErikYkema wrote:

> Hello,
> I fear this silly, but I see it as an option.
> Our OLTP client application is in Forms4.5/Reports2.5. From Metalink I
> understood that connecting some versions of Forms4.5 to 8i is supported
> (for as long as it lasts).
> Our underlaying DBMS is now being converted from 7.3.4. to 8iR3 - at
> last. But I have read a lot about 9iR2 new features and like to apply
> some of them.
> Upgrading Forms to 6i or 9i is not supported by management since we
> will be purchasing a new release of our OLTP which will bring us a new
> set of 9i Forms - this migration not to be completed before mid 2006.
> I am wondering - would it be possible for the meantime to:
> - convert the OLTP DBMS to 9i
> - have an 8i instance on the same machine
> - create a database link between the two
> - create public synonyms to all relevant 9i objects in the 8i instance
> over the dblink
> And hence access (DML) the 9i objects as being 8i objects from
> Forms4.5? Does Forms access the datadictionary for any lookup etc?
> I also believe that having the dblink over the bequeath protocol is not
> allowed since the dblink communications protocol should be the same as
> the client-server connection protocol (TCP/IP) accessing the link.
> Is there a serious performance penalty in having TCP/IP dblink traffic
> in the same machine. (I know Oracle Warehousebuilder 9i generates
> TCP/IP dblinks between instances on the same server.)
> I am preparing a full test for this scenario, but any input would be
> appreciated.
> Best regards,
> Erik.Yke…

I do hope you realize that you are upgrading from a Jurassic version
of Oracle to one that is Paleolithic: 8i is already in desupport.

My recommendation would be to take the database to 9i and the forms
to 6i as a first step. It will benefit every aspect of the project
including your resume.

BTW: Even if Forms itself doesn't hit the data dictionary there is
no guarantee that the code written as part of the Forms app doesn't.
Certainly all Forms apps I write have such calls.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)



In response to

Faking Forms4.5 to 9iR2 DBMS posted by ErikYkema on 27 Jan 2005