topic Re: opening port 1521 in Operating System - Linux

opening port 1521

AVV — Wed, 24 Feb 2010 10:35:01 GMT

Hi All,

I need the port 1521 in my RHEL 5.3 server to be opened inorder to set up an oracle.

I have my iptables and selinux diabled. But I could not "telnet IPAddress 1521" from server .

[root@ora~]# telnet 172.16.30.230 1521
Trying 172.16.30.230...
telnet: connect to address 172.16.3.220: Connection refused
telnet: Unable to connect to remote host: Connection refused

[root@ora ~]# telnet 127.0.0.1 1521
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
Connection closed by foreign host.
[root@ora ~]#

Re: opening port 1521

Michal Kapalka (mikap) — Wed, 24 Feb 2010 11:15:28 GMT

hi,

check if you have a firewall enabled ???

if yes you should make a exeption for the 1521 port.

mikap

Re: opening port 1521

Michal Kapalka (mikap) — Wed, 24 Feb 2010 11:16:46 GMT

hi,

i forgot :

check if the port 1521 is opened for any connection :

netstat -na |grep -i listen |grep 1521

mikap

Re: opening port 1521

Horia Chirculescu — Wed, 24 Feb 2010 11:18:44 GMT

Hello,

The listner is listening on port 1521?

Maybe you have a problem and your listner is dead.

Horia.

Re: opening port 1521

Jean-Luc Oudart — Wed, 24 Feb 2010 11:33:55 GMT

Hi

Are these the right IP addresses ?
=======================================
[root@ora~]# telnet 172.16.30.230 1521
Trying 172.16.30.230...
telnet: connect to address 172.16.3.220: Connection refused
=======================================
30.230 vs 3.220 ???

1) have you configured your listener (default port 1521) on the machine

2) can youn post the output of :
"lsnrctl status" command

3) if the listener is up and running , run the "tnsping " (entry name as your tnsnames.ora config file) and post the output.
Check your listener log file.

Oracle product and version ?

Rgds
Jean-Luc

Re: opening port 1521

AVV — Wed, 24 Feb 2010 13:12:57 GMT

[root@ora etc]# netstat -na |grep -i listen |grep 1521
tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN
[root@ora etc]#

---------
lsnrctl status is not working in the system
---------
Firewall is disabled also selinux too
======

Re: opening port 1521

Steven Schweda — Wed, 24 Feb 2010 13:19:51 GMT

> telnet: connect to address 172.16.3.220: Connection refused

"Connection refused" normally means that
there is no one listening at that port.

> [...] to set up an oracle.

Disabling the firewall for a port does not
run any Oracle software.

Re: opening port 1521

AVV — Wed, 24 Feb 2010 13:30:45 GMT

HI Steven,

What are you meant by. Do our ORACLE person has to set this up ...All everything ok from system side now ?

Re: opening port 1521

Steven E. Protter — Wed, 24 Feb 2010 14:16:15 GMT

Shalom,

Connection refused means one of two things.

1) Firewall is blocking.
2) No service is listening on port 1521

1521 is a port commonly used by the Oracle Database. Oracle does not show the good manners to put an entry in /etc/services to reserve the port.

iptables -L

Look for a firewall rule or general rule blocking traffic. Consider changing the firewall to permit the traffic.

netstat -an | grep 1521

See if there is a service listening on port 1521. If not, see if you can start that service.

SEP

Re: opening port 1521

Steven Schweda — Wed, 24 Feb 2010 14:17:59 GMT

> [...] Do our ORACLE person has to set this
> up ... [...]

Apparently.

> All everything ok from system side now ?

Perhaps. I'd expect a different complaint
if a firewall of some kind were blocking the
port.

> 2) can [you] post the output of :
> "lsnrctl status" command

> lsnrctl status is not working in the system

"Is not working" is not a useful problem
description. It does not say what you did.
It does not say what happened when you did
it.

Re: opening port 1521

Elko — Wed, 24 Feb 2010 16:25:59 GMT

please enable ip tables :)

1 ) check does anything listen on port 1521, guys already described how to do it

2) open port 1521 on redhat 5 use as root

system-config-securitylevel

small window will open, then "other ports " and add port 1521.

Hope this helps

Regards,
Elko

Re: opening port 1521

Elko — Wed, 24 Feb 2010 16:56:27 GMT

here is screenshot

http://www.redhat.com/docs/manuals/enterprise/RHEL-4-Manual/sysadmin-guide/ch-basic-firewall.html

Regards,
Elko

Re: opening port 1521

Wilfred Chau_1 — Wed, 24 Feb 2010 20:44:28 GMT

What is the HOST set to the listener.ora file?

Try change it to 172.16.30.230 and restart the listener.

Re: opening port 1521

AVV — Wed, 05 Jan 2011 06:56:16 GMT

Thanks