Re: Error TNS already in use during datamart ETL

The parameter queue_size didnt work. And the ETL is failing again.

On Sun, Apr 18, 2010 at 12:33 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 at 7:55 PM, Saad Khan <saad4u@xxxxxxxxx> wrote:
>>
>>>
>>> Any expert opinion folks??
>>>
>>>
>> I am not going to claim expert status on this - I've never seen the error.
>>
>> The context of the error though tells me that some process is attempting
>> start the listener on port 1526, and there is already a process using port
>> 1526 - probably the listener that is already running.
>>
>> Verify what processes are attached to the port with fuser.
>> This must be run as root:
>>     fuser -v -n tcp 1526
>>
>> example:
>>
>>  fuser -v -n tcp 1521
>> here: 1521
>>
>>                      USER        PID ACCESS COMMAND
>> 1521/tcp             oracle    16134 f....  tnslsnr
>>
>>
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>> Oracle Blog: http://jkstill.blogspot.com
>> Home Page: http://jaredstill.com
>>
>>
>>
>

Other related posts: