Re: Connection to Oracle Database Problems

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 01 Dec 2005 18:03:11 +0100
Message-ID: <e0buo1hdenn313eekb427pacelh9gq57kj@4ax.com>

On 1 Dec 2005 08:34:19 -0800, "Boris"
<richard.ness_at_planetfootball.com> wrote:

>We have some analysts based in another part of the business,
>
>They are wanting to connect to our oracle database.
>
>The firewall has been opened up by the I&O team.
>
>The analysts can ping the oracle server successfully, but they can not
>tnsping or connect to the oracle instance.
>
>Has anyone got any suggestions on what to check?

No versions, no error messages, no nothing. The obvious suggestion would be
- to look up the error messages in the error message manual - to read the troubleshooting chapter of the Net administrators manual and work from there
- to search Google
- to try to telnet into the sqlnet port. If that doesn't work, the firewall hasn't been opened correctly
- to realize that when this is Winblows, the listener will redirect traffic to a different random port. How to circumvent that has been described in this forum many times by me.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Dec 01 2005 - 11:03:11 CST