Re: Oracle 7.3 doesn't work with Sql*Forms3.0 ?
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