Re: Error TNS already in use during datamart ETL
- From: Anupam Pandey <my.oralce@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Sun, 18 Apr 2010 10:05:11 +0530
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:
