SEO

#1 (**permalink**) 02-24-2008, 10:55 AM

Hi,

I have installed Oracle 9iR2 on Suse 9. I'm pretty sure that my TNS is
setup correctly (since I have done this before on Windows boxes several
times without incident). I can start the listener and the database no
problem. I can connect locally via OEM or SQLPlus. I can also tnsping
my instance (again, locally).

When I try to tnsping from a remote PC I get a " TNS: operation timed
Out" message. I'm pretty sure that my DNS is setup okay since I can
ping the Linux box remotely and ftp to it using the hostname used in my
tnsnames.ora file. Is there something special I need to do to enable
ports 1521 and 1526? It is almost like the Linux boxis ignoring the
incoming requests for those ports. I see nothing in the listener log
indicating an attempt to ping (or connect). Is this a firewall issue?
How do I check this and where do I start? Sorry if there is a stupid
answer, I'm relatively new to Linux.

Thanks for any assistance

Thanks,
Gerard
gbeck01@snet.net

#2 (**permalink**) 02-24-2008, 10:55 AM

On 7 Feb 2005 19:48:45 -0800, gbeck01@snet.net wrote:

>Hi,
>
>I have installed Oracle 9iR2 on Suse 9. I'm pretty sure that my TNS is
>setup correctly (since I have done this before on Windows boxes several
>times without incident). I can start the listener and the database no
>problem. I can connect locally via OEM or SQLPlus. I can also tnsping
>my instance (again, locally).
>
>When I try to tnsping from a remote PC I get a " TNS: operation timed
>Out" message. I'm pretty sure that my DNS is setup okay since I can
>ping the Linux box remotely and ftp to it using the hostname used in my
>tnsnames.ora file. Is there something special I need to do to enable
>ports 1521 and 1526? It is almost like the Linux boxis ignoring the
>incoming requests for those ports. I see nothing in the listener log
>indicating an attempt to ping (or connect). Is this a firewall issue?
>How do I check this and where do I start? Sorry if there is a stupid
>answer, I'm relatively new to Linux.
>
>Thanks for any assistance
>
>
>Thanks,
>Gerard
>gbeck01@snet.net

12535 is mostly a firewall issue
Just issue
telnet <host> <affected port>
into the machine to see whether the port is really open.

--
Sybrand Bakker, Senior Oracle DBA

#3 (**permalink**) 02-24-2008, 10:57 AM

On 2005-02-08, gbeck01@snet.net <gbeck01@snet.net> wrote:
> When I try to tnsping from a remote PC I get a " TNS: operation timed
> Out" message. I'm pretty sure that my DNS is setup okay since I can
> ping the Linux box remotely and ftp to it using the hostname used in my
> tnsnames.ora file. Is there something special I need to do to enable
> ports 1521 and 1526? It is almost like the Linux boxis ignoring the
> incoming requests for those ports. I see nothing in the listener log
> indicating an attempt to ping (or connect). Is this a firewall issue?
> How do I check this and where do I start? Sorry if there is a stupid
> answer, I'm relatively new to Linux.
>

Run "netstat -an" to see whether your listener is listening.
Then check your /var/log/messages to see whether the firewall is
dropping any packets (if you have logging enabled, which it usually is
for critical packets).
Even better, turn off the firewall "rcSuSEfirewall2 stop" and try it
again.

Regards,

Ingo

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Remote Oracle Conncetion Issue on Suse 9