Re: Unable to connect to Oracle 10g

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 27 Nov 2004 19:16:51 +1100
Message-ID: <41a837e4$0$31870$afc38c87@news.optusnet.com.au>

Elias Saade wrote:
> hi
>
> I installed Oracle Database 10g on Fedora Core2 and i started it, but
> when i tried to connect to the database from an Oracle Client 9i under
> windows 2000 i get the following error ORA-12560: TNS:protocol adapter
> error.

Is the instance started?

Can you 'sqlplus / as sysdba' at the command prompt on the server itself?

Is there a listener?

> To be noticed that i pinged the client from the Linux Server and vice
> versa and everything was ok.

That's a start.

I'd begin by making sure everything works on the server itself before getting ambitious and trying to get clients working.

If you have, you haven't mentioned it in your post!

Regards
HJR
> Anyone can help?
>
> Tanhks in advance
Received on Sat Nov 27 2004 - 02:16:51 CST