Re: Error TNS already in use during datamart ETL

From: Anupam Pandey <my.oralce_at_gmail.com>
Date: Sun, 18 Apr 2010 10:03:26 +0530
Message-ID: <t2j706e34231004172133ue1fa9e91h55eda5bdf0d0f345_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:33:26 CDT