Re: Can not see 9i Linux RH Server from client

From: HansF <News.Hans_at_telus.net>
Date: Thu, 12 May 2005 23:34:35 GMT
Message-Id: <pan.2005.05.12.23.37.10.570203@telus.net>

On Thu, 12 May 2005 15:10:29 -0700, Steve interested us by writing:

> Hi,
> Am stumped here. Have a 9i rh as 3 db which looks great on the
> server. Can sql plus and query away no problems. But ..... try and have
> a client see it and it get a problem connecting. Any ideas greatly
> appreciated ! Have used the correct tcpip, tried as a service and as a
> sid. As a linux beginner is there something obvious to look at ?
>
> Many thanks, Steve.

Basic Oracle Network troubleshoting questions, including the obvious ones:

On server ...

Is the listener running? any listener log info?

On client ...

Have you installed the Oracle Networking client? Can you tnsping to any service?
Can you tnsping to the service?
Error messages from SQLPlus?

/Hans Received on Thu May 12 2005 - 18:34:35 CDT