Re: Unable to connect to Oracle 9i database via Oracle 6i Developer

On 22 Feb 2006 19:16:44 -0800, "Virgil" <laynevir_at_earthlink.net> wrote:

>I don't understand this file at all as I don't recall supplying any of
>these parameters during the installation.

You didn't. It comes with the installation.
>
>Have I install the wrong Developer product?
Not necessarily though Developer 6 is desupported and comes with sqlnet for 8.0, as it originated in the 8.0 era.

  Is there a solution short
>of uninstalling both applications and installing release 10g for both?

That would be the best solution, but Developer 9i and higher don't support client server anymore.

>On a hunch, I saw a similar proble with Oracle 10g and tried copying
>both the Oracle 9i TNSNAMES.ORA and SQLNET.ORA to the Developer
>..\Net80\ADMIN directory, but I got another error
>
>ORA-03106: fatal two-task communication protocol error.
>
>As you can tell I'm very new to Oracle applications and may not
>understand your answer if you respond in a way that assumes anything
>but shear novice knowledge of the Oracle configuration process.
You could try to edit the copied tnsnames.ora and replace connect_data=(service_name=(.....))
by
connect_data=(sid=(<the sid of your database>). If you look up the Windows service running your database, the sid is the part afer OracleService. The syntax for the Windows service name is OracleServic<SID>.
The better solution is to set up the registry string variable tns_admin in hklm\software\oracle and point that to the 9i tnsnames.ora directory. You may need to edit the 9i tnsnames.ora

Obviously this is described in the installation manual, and this solution has been posted over and over and over and over again. Please try to search Google, prior to posting this yet another time.

--
Sybrand Bakker, Senior Oracle DBA