Operating System - HP-UX
1748128 Members
3436 Online
108758 Solutions
New Discussion юеВ

Re: 'exlusively' reserving ports ???

 
SOLVED
Go to solution
JimA
Occasional Advisor

'exlusively' reserving ports ???

Hi all,

Does anyone know how to 'exclusively' reserve a port for the Oracle listener, as we are sometimes experiencing a conflict when the listener goes to use the port that we previously assigned to for it ?.

See below;

>Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=****)(PORT=1521)))
>TNS-12542: TNS:address already in use
>TNS-12560: TNS:protocol adapter error
>TNS-00512: Address already in use
>DEC OSF/1 AXP Error: 48: Address already in use

Thanks in advance.

p.s environ: Tru64 alpha server, Oracle 8.1.7
WARNING: System Administration seriously damages your health !
15 REPLIES 15
Paula J Frazer-Campbell
Honored Contributor

Re: 'exlusively' reserving ports ???

Jim

When this happens check the port and see what has got it.

I would guess that Oracle has not dropped it from last attempt.

Paula
If you can spell SysAdmin then you is one - anon
Massimo Bianchi
Honored Contributor

Re: 'exlusively' reserving ports ???

Hi,
i don't know of any utility that can reserve a port.

You must reserve it when you install you programs, and be sure not to overlap.


152x are the favorites port for the listener, so usually one avoids using it.

What program is using the port now ? You can check with... on hpux with "netstat -a | grep 1521", i don't know on Tru64.


HTH,
Massimo
T G Manikandan
Honored Contributor

Re: 'exlusively' reserving ports ???

How is the entry in the $ORACLE_HOME/network/admin/listener.ora file.

I suspect duplicate entries there.

Please post your listener.ora file
JimA
Occasional Advisor

Re: 'exlusively' reserving ports ???

Hi Paula,

Ah!, a small problem, as it's occuring at 3am, when we shutdown & restart our instances, an ungodly hour for me to get out of bed and come and check !!

Not sure if it's the previous instance of the listener though, as we shutdown Oracle in a safe manner every night with no report of any errors/exceptions & this error is not happening on a regular basis either !?!?

Is there a way to preserve this port exlusively for the listener ?

thanks

j

WARNING: System Administration seriously damages your health !
T G Manikandan
Honored Contributor
Solution

Re: 'exlusively' reserving ports ???

Also sometimes this happens when the TCP/IP sockets which are created are sometimes hung.

These are created under /tmp/.oracle.

Any problems you can remove the .oracle subdirectory and re-start the listener to resolve the problem.

Thanks
Paula J Frazer-Campbell
Honored Contributor

Re: 'exlusively' reserving ports ???

Jim

Cron a job for just after 3am to grep usage of ports and pipe it to a file.

Not sure on tru64
Something like this:-

> /tmp/portinfo

HTH

Paula


If you can spell SysAdmin then you is one - anon
JimA
Occasional Advisor

Re: 'exlusively' reserving ports ???

hi,

massimo - it's the oracle listener using that port at the moment as Oracle is running !

TG - nope, no duplicates in the listener.ora file. we only have two listeners and both have exclusive ports assigned in the file.

???

j
WARNING: System Administration seriously damages your health !
Massimo Bianchi
Honored Contributor

Re: 'exlusively' reserving ports ???

Are you sure that you are not trying to start the listener a second time ?


The first start is succesfull, but every other subsequent try will lead at this error.

YOu can check in the $ORACLE_HOME/listener/log, if it is the case.

HTH,
Massimo
T G Manikandan
Honored Contributor

Re: 'exlusively' reserving ports ???

Also,

you can check which is already using 1521 using lsof utility.

You can confirm that if that was due to a different application then you need to think about reserving ports for Oracle listener.

If that was only from Oracle then you go for the troubleshooting way.

THanks