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

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