Problems Installing 3 tier Forms6i with 8.1.7 on NT

[raygg]

We are trying to set up a 3 tier Forms6i server on one NT server with the 8.1.7 database on the other NT database - and then have users connect over the company intranet to the application, which is developed with EE 817 and Forms6i. The initial install is the hangup. The target server for the Forms6i server is a clean machine with almost nothing on it except the oracle Forms6i. The server for the 817 database also has almost nothing on it except the 817 Oracle database. We followed the install instructions for the Forms6i and it says to connect to the test.fmx on the forms server - just fill in the blank for the user/password@alias connect string to test that the forms6i works with the test.fmx form on the installed software. We're stumped - since there is no database on the machine, what can we put in for a connect string? We set up the listener to connect to the 817 database and that works ok, but that is not where the test.fmx form is located. We used all the typical and default settings for installation.

Should we just install the Forms6i software on the same machine as the 817 database instead?

 

[karluk]

In general rule you don't need to install an application on the same server as the Oracle server it connects to. I'm assuming that's true for Oracle forms in particular.

You should try to configure your forms server as an Oracle client, with the appropriate network information to identify the Oracle instance name and the server it resides on. Then the alias is just your instance name. For example user/passsword@orcl. SQL*Net will finish the task of figuring out how and where to make the connection.

 

[raygg]

Thank you, I fully understand what you are talking about - however, you have to be familiar with this specific installation to understand what the issue is. Also, this is Net8, not sqlnet.

If someone actually does have experience with this install and has been successful installing Forms6i with 8i (hopefully 817) on NT (or even unix) - I would really like to know how you did it.