Re: ORA-12542 Failsafe

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 20 Apr 1999 08:58:19 -0700
Message-ID: <371CA41B.EE1563FE@us.oracle.com>

Oliver

My apologies I don't speak or read German, so I have no idea what the words before the Oracle errors mean. But at least I can make some suggestions on those:

What port is the listener listening on? Is that port possibly used by something else?
If there are multiple address for 'PROTOCOL=IPC' in the same LISTENER.ORA file for a listener, make sure none of the 'KEY' parameter values are duplicated.
Are there two databases attempting to use the same SID?

In regards to your question on what FailSafe does, it's an automated way of failing over a single instance database (i.e. not Parallel Server) from one node of an NT cluster to another.

HTH. Pete

Oliver Gassner wrote:

> Hey Folks,
> we have the Oracle Failsafe 2.1.3.0.0 on an NT 4.0 SP4 Cluster. Sometimes we
> have following Error in the NT Eventlog :
>
> Die Beschreibung der Ereignis-ID ( 1 ) in Quelle ( OracleFailSafe ) konnte
> nicht gefunden werden. Sie enthält folgende
> Einfügezeichenkette(n):ORA-12542: TNS:address already in use
> or
> Die Beschreibung der Ereignis-ID ( 1 ) in Quelle ( OracleFailSafe ) konnte
> nicht gefunden werden. Sie enthält folgende
> Einfügezeichenkette(n):ORA-12203: TNS:unable to connect to destination
>
> The Database is only on one Machine at one time. I did not understand this
> Message.
> What does Failsafe do ??
>
> Regard
> Oliver Gassner PSE GmbH

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Apr 20 1999 - 10:58:19 CDT