Re: Oracle 7.3 doesn't work with Sql*Forms3.0 ?

From: Oracle DBA <oracle_at_nightmare.com>
Date: 1996/08/07
Message-ID: <4u906e$fje_at_news.iag.net>#1/1


In article <4u5r1h$1ij_at_news.latnet.lv>, andris_at_andris.iric.gov.lv says...
>
>Badri Gandavadi (badrig_at_hargray.com) wrote:
>: Is it true that the latest release of Oracle v7.3 of
 the database does
>: NOT work with Sql*Forms v3.0 and Sql*ReportWriter
 v1.0?
>
>We have done it - Oracle v.7.3 & SQL*Forms 3.0 (from
 Oracle 7.2.2.3.0)
>on the same UNIX (AIX 4.1) machine. Our solution:
> - install Oracle 7.3 - everything you needi and get
 it working.
> - install Forms 3.0, SQL*Net and other things you
 need from Oracle 7.2
> in a separate ORACLE_HOME directory, so you don't
 mix them.
> Don't run .../orainst/root.sh postinstallation
> script after you install 7.2 components.
> - You will use both 7.3 and 7.2 components but you
 cannot have 2
> ORACLE_HOME directories at the same time. We
 decided to use ORACLE_HOME
> of Oracle 7.3 for all users. To be able to use
 SQL*Forms 3.0,
> we have made symbolic links in the 7.3 ORACLE_HOME
 to
> SQL*Forms 3.0 binaries in 7.2 ORACLE_HOME:
>
> cd /u01/app/oracle/product/7.3.2/bin
> ln -s

 /u01/app/oracle/product/7.2.2/bin/sqlforms30 sqlforms30
> ln -s

 /u01/app/oracle/product/7.2.2/bin/runform30 runform30
>
> cd /u01/app/oracle/product/7.3.2
> ln -s /u01/app/oracle/product/7.2.2/forms30
 forms30
> ln -s /u01/app/oracle/product/7.2.2/orakit
 orakit
>
> To be able to start SQL*Forms 3.0 we had to set up
 TWO_TASK parameter
> in the user's profile - other wise SQL*Forms don't
 work.
>
> TWO_TASK=your_SQL*NET2_service_name_here
> export TWO_TASK
>
> This solution might not be the most elegant. We
 found it just few
> days ago - it is not carefully tested.
>
> Take it carefully. May be it works for ReportWriter,
 too - find out,
> which symbolic links are necessary to add.
> Good luck !
>
>--
>Andris Mednis
>andris_at_iric.gov.lv

I do not see why you would need to make these links. I have not tested it either, but as far as I know it should work. Here is what I suggest.

   Install the form30 and other products in it own    ORACLE_HOME including sqlnet V2. Do a software only    install of these products. You might want to install    sqlplus as well to trouble shoot the sqlnet    connection. After you able to connect via TWO_TASK    then run the older installer again with TWO_TASK set    to the 7.3.* database. ORACLE_HOME should be set to    where the forms30 home is. Use the installer to    create database objects in the 7.3 database. Remember    you are not creating a database but the database    objects for those products you have installed. Received on Wed Aug 07 1996 - 00:00:00 CEST

Original text of this message