Re: Error TNS already in use during datamart ETL

  • From: Saad Khan <saad4u@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Tue, 20 Apr 2010 10:16:43 -0400

I opened a SR with oracle and they explained that it has nothing to do with
oracle database rather its something with the OS at client and ETL itself.
They mentioned its a known issue (though I didnt find this solution in
metalink)  and following is the action to be taken at the app server where
ETL runs.

Increase the free port range as follows:

Start Registry Editor (Regedt32.exe).

Locate the following key in the registry:


On the Edit menu, click Add Value, and then add the following registry

Edit -> New-> DWORD Value

Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534

Valid Range: 5000-65534 (decimal) Default: 0x1388 (5000 decimal)

Description: This parameter controls the maximum port number used when an
application requests any

available user port from the system. Normally, ephemeral (that is,
short-lived) ports are allocated between the values of 1024 and 5000


The change is made and app server is rebooted after that. Datamart ETL is
yet to run, so fingers crossed :)

On Sun, Apr 18, 2010 at 9:46 AM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:

> The same port cannot be used by multiple listeners. One listener can
> service multiple databases or multiple services. You cannot however have
> multiple processes listening on the same port. I don't see the os but on
> Linux at about that release a second listener could be spawned under high
> load leading to the symptoms described - this would show up in the fuser
> command that jared listed.
> Niall Litchfield
> On Apr 18, 2010 12:35 AM, "Anupam Pandey" <my.oralce@xxxxxxxxx> wrote:
> But this should not be the problem because I can have multiple databases
> running on same host
> and using the same port (say 1521 ) for listener .
> So the same port can be re-used by multiple database listeners.
> Thanks And Regards,
>    Anupam Pandey
> On Fri, Apr 16, 2010 at 9:49 PM, Jared Still <jkstill@xxxxxxxxx> wrote: >
> > On Thu, Apr 15, 2010 a...

Other related posts: