Opening port in HPUX

[Mousa55]

Hi All,

I am trying to open the port in hpux (1521|1522) for oracle Listener.

and I've entered the port in /etc/services
oralis1 1521/tcp # Oracle Listener
oralis2 1522/tcp # Oracle Listener

and executing this command
# inetd -c
but still receiving the below error

telnet localhost 1521
Trying...
telnet: Unable to connect to remote host: Connection refused

how to solving this problem?

Thanks for all

[johnsonpk · Accepted solution]

Hi Nejad,

verify the listeners are up or not

#ps -ef|grep -i lsnr

and listening on that port?
netstat -an |grep 1521

[Mousa55]

Hi All,

"verify the listeners are up or not"
host > ps -ef|grep -i lsnr
root 6159 5741 0 15:45:10 pts/tb 0:00 grep -i lsnr

"and listening on that port?"

root@ruxtstdb > netstat -an |grep 1521
root@ruxtstdb >


thanks

[johnsonpk]

oracle listeners are not running on your system,Ask your DBA to start listener . Once he confirm that ,check it with ps command again .

[Johnson Punniyalingam]

this could some issue in Database Listener. please take help from the "DBA" admin. check "Oracle Listener" running ?

Once DBA admin "started manually" the "Listener"
you can check "/etc/rc.log" or "/etc/OLD.rc.lgo" why does the "Oracle Listener" did n't start ???

did you do any "reboot" activity "??

[Mousa55]

Hi All,

thanks for your replay.

the DBA he is can't starting the Lisetner without using 1521 port, becuase he is using
this syntax
# telnet localhost 1521
Trying...
telnet: Unable to connect to remote host: Connection refused


and this output of /etc/rc.log

[24;1H [K [7mrc.log (82%) [m [24;1H [24;1H [KStarting the RST EMS listener
Output from "/sbin/rc2.d/S910rstEMSlistener start":
----------------------------
"/sbin/rc2.d/S910rstEMSlistener start" SKIPPED

Configure HP Fibre Channel Tachyon TL/TS Mass Storage interfaces
Output from "/sbin/rc2.d/S989fc_td start":
----------------------------


thanks

[johnsonpk]

>>the DBA he is can't starting the Lisetner without using 1521 port, becuase he is using
this syntax
# telnet localhost 1521
Trying...
telnet: Unable to connect to remote host: Connection refused



Please understand that untill and uless he start the listener ,you will get connection refused messge while telnet-ing to that port . as there is nothing listening on that port.

its like you are trying to talk to a person over phone before he pick up the handset on the other end.

[Steven Schweda]

> I am trying to open the port in hpux
> (1521|1522) for oracle Listener.

You might do better if you stop thinking
about "opening" (or "closing") a port, and
start thinking about running (or not running)
some server program.

> and I've entered the port in /etc/services
> [...]

Why? Was there something in the Oracle
installation/configuration instructions which
advised you to do this, or was it your own
idea?

A quick Google search for:

oracle "/etc/services"

led to (among other things):

http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=137243

and:

http://download-west.oracle.com/docs/cd/B28359_01/server.111/b32009/cnfg_net_srv.htm

neither of which suggests that this was a
good idea.

Similarly, a quick Google search for:

oracle oralis1 oralis2

led to this thread (only), which suggests
that you should leave /etc/services alone
unless you actually know what you're doing.

In general, PLEASE leave /etc/services in
peace, unless you actually know what you're
doing.

Trying to configure some Oracle thing? Why
not try reading the Oracle documentation
first?

[Patrick Wallek]

The dba needs to do a 'lsnrctl start' (with the appropriate Oracle env variables set). If the listener name isn't the default then 'lsnrctl start '. At that point the listener will be running and THEN and ONLY THEN will the port be available.

Ports are only open when some program or process is running that uses that port.

[Patrick Wallek]

I should have added that if the DBA gets an error when running 'lsnrctl start' then troubleshoot from there. Report that error back here if you wish.

[Mousa55]

Hi,

please find the error below when I try to run the listener manually,


$ which lsnrctl
/u07/oracle/proddb/10.2/bin/lsnrctl

$ lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 22-FEB-2010 14:07:58

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /u07/oracle/proddb/10.2/bin/tnslsnr: please wait...
Starting /u07/oracle/proddb/10.2/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek

thanks

[johnsonpk]

Check this thread
http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1266820264977+28353475&threadId=924690

[Mousa55]

Thanks for all except one,

The problem was solved, There was a problem in Oracle parameters.

thanks

[Steven Schweda]

> Thanks for all except one,

So, are you saying that making those changes
to "/etc/services" was a good idea?

[rick jones]

/etc/services is not a reservation mechanism, it is there simply to provide a translation from port numbers to service names. In other words it is there as a convenience.

An inetd -c command will change nothing unless one has also changed /etc/inetd.conf.

The docs for Oracle should describe how to start-up their listener processes.

[Steven Schweda]

> /etc/services is not a reservation
> mechanism, [...]

Certainly true, but the remarkably large
number of postings here (questions _and_
answers) showing a contrary belief suggests
that many folks don't seem to understand its
purpose. (This question is a good example.)

> An inetd -c command [...]

Also true.

> The docs for Oracle [...]

I'd expect so.


> [...] There was a problem in Oracle
> parameters.

Not the biggest problem in evidence, I claim.