Re: can no longer connect

Thanks Walter,

All your suggestions tested fine. That's what I figured though, but no one wants to hear that it's not our end that's the problem.

Steve

On Wed, 12 Jul 2000 14:50:02 -0400, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:

>"Steve ." wrote:
>>
>> I have an Oracle 8i database running on a Sun box. I can currently
>> and always could get in using SQL*PLUS. We have a third part app that
>> connects behind the scenes to the database and allows clients to work
>> with the software thru Windows. All of a sudden yesterday they could
>> no longer connect. At the end of this message I have the output of
>> the sqlnet.log file. Not sure if it's relevant, Any idea what's
>> going on? The only difference between now and before is I needed most
>> of the drive space for a temporary backup, but there is still a few
>> megs free and the space left is not going down any. Thanks.
>
>Someone either changed the tnsnames.ora on the client or the
>listener.ora file on the server.
>
>Are you able to connect with sqlplus on the server? That means the
>database is up.
>
>Are you able to tnsping the service name? If so, it means that the
>listener is configured for that service name.
>
>Can you connect with sqlplus on the client using the service name? If so
>then the problem is in your client application.
Received on Wed Jul 12 2000 - 00:00:00 CDT