Re: Connecting FORMS50 to PERSONAL 8.04 : ''PROBLEM !"

Valentin Mînzatu wrote in message <7lhsfv$103$1_at_news.Romania.EU.net>...
> I tried various times (various ORACLE releases of FORMS and Personal
>ORACLE) to connect, on a single PC, FORMS to Personal ORACLE and I failed
>every time. The message is (after FORMS tries for 3-4 minutes to connect) :
>"TNS could not resolve service name". The same error or something like
that
>I get when I try to connect through ODBC ...
>
> SQL Net Easy Configuration "sees" the aliases and ORACLE Net8 Easy
>Config, too.
>
> Is there anybody who can help me ?
>
> I use Windows98 on P200MMX, no network adapter (only dial-up adapter -
>so I have TCP/IP)
>
>
>
>Valentin Mînzatu
>
>

I am able to connect FORMS 5 with Personal Oracle 8.04:

Here are a few tips on configuration.
1.Developer uses SQL*Net , NOT Net80. So, make sure that sql*net 2.3.4 is installed. The bequeath protocol allows SQL*Plus 8 to connect locally by bypassing the listener process. However, Dev. needs the listener to connect locally
2. Make sure that you have %oracle_home\network\admin directory 3. You MUST start the listener after the database is started 4 Use the SQL*NET Easy config utility to create a new service. In my case, I simply deleted the exisiting 'ORCL' service and created a new one. when creating a new service, do not specify Bequeath as the protocol. Select TCP/IP instead. Also, you will need to provide the TCP/IP host name which is the computer name where oracle is installed.

1. Start Personal Oracle Database
2. Then, I go to Dos prompt and type lsnrctl80.exe
3. Then, I type START listener should be up and running! In my case, I have the following files tnsnames.ora,sqlnet.ora & listener.ora in C:\orawin95\network\admin Also, in the registery, there be an entry like net20=C:\orawin95\network

Once done, you should be able to connect from Sql*plus 3.3 as well as Developer by specifying user name, password, AND the service name. You cannot leave the connect string blank

good luck
wozi_at_dhc.net Received on Fri Jul 02 1999 - 19:51:28 CEST