Re: Oracle Error <ORA-12542: TNS:address already in use>

Vinatha.Pattisapu_at_Airtouch.com wrote:
>
> Hello,
>
> Some of the Pro C programs that I am working on are giving the following
> Oracle error and aborting.
>
> SQL Failed with error message "ORA-12542:TNS:address already in use
>
> This error occurs when the batch process is trying to connect to the
> Oracle Server on a SUN/PYRAMID Database.
>
> Can anybody please post a reply giving a solution to eliminate this error
> and a reason why this error is occurring?
>
> Thank you for your time,
> Vinatha.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Hi
Looks like the port at which the listener is listening is already in use.
Check out your listener.ora file.

-- 
Sanjay T. Mathew
Oracle DBA
Lucent Technologies,
555 Union BLVD,
Allentown 
PA 18103

Phone Number  Office        610 712 5967