Re: Unable to connect to Oracle 10g

From: Yang <dbaoracle_at_wanadoo.fr>
Date: Sat, 27 Nov 2004 16:33:12 +0100
Message-ID: <41a89eab$0$6726$636a15ce@news.free.fr>

At the Linux server, do as 'oracle' account :

lsnrctl start listener

And at your NT client side, put these lines in the tnsnames.ora file : REMOTEDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = DBAY))) by replacing values like host, port and service_name.

And then try : sqlplus user/password_at_remotedb

hth.

yang
dba oracle

"Elias Saade" <eliassaade_at_hotmail.com> a écrit dans le message de news: 384c2b97.0411262356.1a737c9d_at_posting.google.com...
> 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.
> To be noticed that i pinged the client from the Linux Server and vice
> versa and everything was ok.
>
> Anyone can help?
>
> Tanhks in advance
Received on Sat Nov 27 2004 - 09:33:12 CST