Re: Connecting Oracle server from Forms 6.0

From: Oweson Flynn <Oweson.Flynn_at_liberty.co.za>
Date: Tue, 23 Jan 2001 10:24:36 +0200
Message-Id: <10750.127245@fatcity.com>

Hi Fenal,

You might have multiple Oracle Home directories, and each may have it's own SQL*Net installation. Look for all the copies of tnsnames.ora on your machine, and ensure they are identical (and contain the SID for your server).

You could also open a DOS box and try 'tnsping <SID>' where <SID> is the instance name. If that works, it is probably multiple non-identical copies of your tnsnames.ora file.

If it doesn't, we'll need more information about your configuration: Client operating system an networking configuration; Your server operating system & network Config. Does the 8i client still work? Can you connect from other clients? can you 'ping' the server normally (if you're running TCP/IP)? How did you update the tnsnames.ora? Did you use an editor, or did you use Easy Config? If Easy Config, did you try testing the link? Can you connect using SQL*Plus? What version of SQL*Plus is it? (helps in establishing what version of SQL*Net is running). Do have SQL*Plus 3.3 and SQL*Plus 8.0?

Let me know if this helps.

Regards
Oweson Flynn

Certified Oracle DBA
The Flynn Consultancy
Tel: 082-600-7-006
Fax: (011) 782-9313
EMail: oef_at_icon.co.za
----- Original Message -----
From: "Fenal shah" <fenal_at_mahindrabt.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 23, 2001 9:30 AM
Subject: Connecting Oracle server from Forms 6.0

>
> Hi,
>
> I am facing problem with connecting Forms 6.0 to my oracle server.
> How to configure the connectivity ?
> Prior to installing Forms 6.0,I had Oracle 8i client and I configured it
> which works fine.Nowalong with Forms6.0,it has installed oracle 8.0.5
client
> also.
> When I try to give database string in forms 6.0,it gives me error - Tns
could
> not resolve service name...I tried updating tnsnames.ora but it's not
serving
> my purpose.
>
> Thanks & Regards,
> Fenal.
>
>

This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message.

Received on Tue Jan 23 2001 - 02:24:36 CST