Re: Error TNS already in use during datamart ETL

From: Anupam Pandey <my.oralce_at_gmail.com>
Date: Sun, 18 Apr 2010 10:05:11 +0530
Message-ID: <q2g706e34231004172135r5e0b656s1a24b58ef2633e37_at_mail.gmail.com>

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_at_gmail.com> wrote:
>
>> On Thu, Apr 15, 2010 at 7:55 PM, Saad Khan <saad4u_at_gmail.com> 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
>>
>>
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 17 2010 - 23:35:11 CDT