Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Incomplete/Broken Oracle 8i Client Connection?

Incomplete/Broken Oracle 8i Client Connection?

From: Kathy Frisk <>
Date: Fri, 26 Jul 2002 15:30:13 +0000 (UTC)
Message-ID: <>

Hi All,

Hi All,
I am trying to install a delphi application that uses a native Oracle driver(sqlora32.dll) on a user's win98 machine. The problem is that I'm trying to verify that the Oracle Client installed on the machine is making a connection to the database before I go to all the trouble of troubleshooting the Delphi App end.

The sys dba tnsping'ed the SERVICE NAME listed in the tnsnames.ora file and received an "ok". There are no utilities to check the connection in the oracle bin directory(I was looking for sqlplus)except tnsping so I installed "Toad" and received this message in an "OCI.DLL" window(This is also the same message I am receiving in the BDE when I try to connect):

A missing dll is required to run this application.

That is the approximate message. When I try to tnsping the global service name in the tnsnames.ora file(the name with the = after it for the connection info), tnsping fails with an unrecognized db error. For example:

tnsnames.ora =
    (ADDRESS =
(PORT = 1521)

    (CONNECT_DATA = (SERVICE_NAME = payroll)     )

if I "tnsping payroll" ---------> ok
if I "tnsping" -------------fail

The sqlnet.ora file contains the correct notation for the 'world' domain. When I try to tnsping these two names on a working connection machine, I get an "ok" using either name.

TWO QUESTIONS: 1.) Since the same error message is showing up in two applications(Toad and the BDE) and in the same labeled window(OCI.DLL). Isn't this an Oracle connection issue. Is this error coming from the Oracle Call Interface and not a Toad error or a BDE app error?

2.) Does a successful(ok) tnsping on the service name and not the global name in the tnsnames.ora file mean that it is a valid connection?

3.) Are there any other utilities that I can use in the oracle client that will tell me beyond a shadow of a doubt that there is a successful oracle connection using the global service name(I must reference this in the BDE).

Thanks in advance for any Oracle/OCI expertise you can offer!


Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Jul 26 2002 - 10:30:13 CDT

Original text of this message