Re: Unable to connect to Oracle 8

If colleague can connect listener is running!

Ok to check tnsnames.ora, but you could get more error diagnostics by using tnsping80 <alias>.

try on server and then on you client, verify that connection (server address and listener ports) parameters are the same.

In article <7v7031$u03$1_at_nnrp1.deja.com>, rock_cogar_at_my-deja.com wrote:
> 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.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!