Re: Error TNS already in use during datamart ETL
- From: Jared Still <jkstill@xxxxxxxxx>
- To: saad4u@xxxxxxxxx
- Date: Fri, 16 Apr 2010 09:19:18 -0700
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:
