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

From: Daniel Ford <dmford_at_worldnet.att.net>
Date: 1997/12/18
Message-ID: <67apvd$ir@mtinsc04.worldnet.att.net>#1/1

Disable your IPC and set sqlnet.expire_time=0 in sqlnet.ora this sometimes occurs when sqlnet.expire_time trips a probe to validate the connection. The ownership of the port is in use by SYS not oracle.

Vinatha.Pattisapu_at_Airtouch.com wrote in message <881873426.1974403073_at_dejanews.com>...
>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
Received on Thu Dec 18 1997 - 00:00:00 CST