Re: Unable to connect to Oracle 8

[Quoted] [Quoted] Good point! On the services panel on the server's control panel (assume it is NT) make sure that the Oracle listener (i.e. "OracleListener?") and database service (i.e. "oracleserviceorcl?") is running. If not restart them.

Next, test SQL*Net (Net8) on the server itself. Adjust / repair / configure as needed. Next, repeat on you colleague's desktop. Now try testing on you desktop. If that does not work and your config file (or all of them, if multiple installs) TNSNAMES.ORA is really the same then make sure your Oracle Client software is also the same.

Usually, I find errors (out of date values) in TNSNAMES.ORA files cause the most connection failures at the Net8 level.

Rock Cogar.
Radian International LLC.

In article <7v51ji$6ai$1_at_plo.sierra.com>,   "Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote:
> Is the LISTENER running?
>
> (check NT services, set it to auto on startup)
>
> Matthew Jones <m.jones_at_misd.lon.ac.uk> wrote in message
> news:3815B761.2278B069_at_misd.lon.ac.uk...
> > Hello,
> >
> > I wonder if someone can help me please with a problem with Oracle 8
on
> > Windows NT. When I do a connection test in Net8 Assistant it gives
the
> > error:-
> >
> > -----------------------
> > Connecting....
> >
> > The test did not succeed.
> > ORA-12545: Connect failed because target host or object does not
exist
> >
> > There may be an error in the fields entered
> > or the server may not be ready for a connection.
> > You can check the server and retry, or continue.
> > -------------------------
> >
> > All my connection details are identical to my colleague's who can
> > connect no problem. My 'Hosts' file is identical to his too. The DBA
> > doesn't know why I can't connect either. Is there something on the
> > server machine I need to check (I have access)?
> >
> > Thanks,
> >
> > Matthew
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 27 1999 - 15:52:34 CEST