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.
>
> STeve
>

12545, 00000, "Connect failed because target host or object does not exist"

// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly;

// most likely incorrect parameter is the node name.  Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.       

Have the Windows client machines check their tnsnames.ora file. The 3rd party software may have altered the file (changed the node name or IP), and thus they cannot connect.

Cheers,
GC Received on Wed Jul 12 2000 - 00:00:00 CDT