SOLVED: ORA-12560 error

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 18 Jan 2001 14:15:13 +0100
Message-Id: <10745.126979@fatcity.com>

Hi list,

I solved the above problem. What I have done? I have deleted the = following
entries in listener.ora and everything works fine. But I can't = understand
what happens, cause this configuration runs about 1.5 year. What = shalls,
everbody is happy.

        (ADDRESS=3D


          (PROTOCOL=3D IPC)

          (KEY=3D ORCL)

        )
        (ADDRESS=3D


          (COMMUNITY=3D NMP.world)

          (PROTOCOL=3D NMP)

          (SERVER=3D ORASERVER)

          (PIPE=3D ORAPIPE)

        )
        (ADDRESS=3D


          (COMMUNITY=3D TCP.world)

          (Host =3D 127.0.0.1)

          (PROTOCOL=3D TCP)

          (Port=3D 1521)

        )

Thanks for all replies

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Schoen Volker=20
Gesendet: 17. January 2001 11:56
An: Multiple recipients of list ORACLE-L Betreff: URGENT: ORA-12560 error

Hi list,

I have a curious problem.
I have installed Oracle 7.3.4.5.0 and Oracle 8.1.5 on same NT 4.0 = Server,
SP5. I have two listeners, one for Oracle 7 and one for Oracle 8. This configuration works fine since 1,5 years, but today, after rebooting = the NT
server, I got the following problem:

When I start the Oracle 7 instance and listener I can connect one time = to
the database, but only once. If I restart sqlplus and try to connect = the
second time to Oracle 7 instance, I get ORA-12560 error.

At the NT server I get know error in listener.log, alert.log, event = protocol
or system protocol.

This is very urgent, cause users are waiting for this instance.

TIA Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Schoen Volker
INET: v.schoen_at_inplan.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Thu Jan 18 2001 - 07:15:13 CST