Re: can no longer connect

"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