Re: Connection to Oracle Database Problems

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 01 Dec 2005 11:09:11 -0600
Message-ID: <hbbuo1l9cg294nc7ct79of3lm6bcn8mh0n@4ax.com>

"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?

What did they open up?..Just opening 1521 ( The default listener port) is not enough....)

The listener , after getting the connection request on 1521, hands off the session's connection to a random port.

If you use Connection Manager you can specify that port as well..

Read the docs on Oracle behind a firewall for more info.. Received on Thu Dec 01 2005 - 11:09:11 CST