Re: SOLVED: ORA-12560 error

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 18 Jan 2001 12:05:38 -0500
Message-Id: <10745.127022@fatcity.com>

It could be that the ip address in the file area you removed is the ip = address for the loopback?
ROR m=AA=BF=AAm

>>> v.schoen_at_inplan.de 01/18/01 08:15AM >>> 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=20
http://www.inplan.de=20

-----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=20
http://www.inplan.de=20

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

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 also send the HELP command for other information (like subscribing).

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

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 - 11:05:38 CST