Re: Error for OCILogon2()

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 17 Aug 2003 10:44:00 -0700
Message-ID: <F9P%a.4111$kP.3536@fed1read03>

Matt wrote:
> Hi all,
>
> Oracle 9.2.0.3, RH Linux 7.2.
> My oci applicetion creates a connection pool at startup, then use
> OCILogon2() to get a session. I'm trying to check OCILogon2()'s error to
> determine if a logon failure caused by the database server (down/stoped,
> network,..), then restart the appl to recreat the pool. I'm not sure about
> following errors on my hand, anymore errors apply to this scenario?
> ORA-00107 failed to connect to ORACLE listener process
> ORA-00130 invalid listener address 'string'
> ORA-00132 syntax error or unresolved network name 'string'
>
> TIA
>
> -matt
>

The most basic questions are -

Has this ever worked?
If so, what changed?
If not, how/why are you sure all is setup correctly to allow it to work?

Can you get a connection using SQL*Plus or some other client s/w using the same connections string? If not, why should OCI succeed? Received on Sun Aug 17 2003 - 12:44:00 CDT