ORA-12560 on Win98

From: Reinhard <Reinhard.Wahl_at_gmx.de>
Date: Mon, 19 Nov 2001 20:41:14 +0100
Message-ID: <9tbn9c$er7$02$1@news.t-online.com>

Hi there,

ORA-12560 often was a theme here, but I didn't find the answer for my problem yet.
It rather looks reverse to those here have been discussed. So:
I installed Oracle 8.1.7 Personal Edition from OTN on my Win98 SP2. It works fine without using a connectstring

SQL> connect scott/tiger
Connect durchgeführt.

But with connectstring:

SQL> connect scott/tiger_at_dbfirst.soso2 ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter

(Does not depend on wether listener is running or not)

And this I have to do, when I use a second party tool like TOAD for example.

Oracle says in the Readmedoc.htm:

TCP/IP Support on Windows 98

Oracle TCP/IP support for Windows 98 uses Windows Sockets 2 interfaces. Therefore, you must install Windows Socket 2 Update for Windows 98 before installing Oracle8i Release 3 (8.1.7). Download it from the following Microsoft Web site:

http://www.microsoft.com/windows95/downloads

Ha, when I look on this site, Microsoft says:

NOTE: This download is not intended for use on computers running Microsoft® Windows® 98.

What should I do?
What is wrong?
Do I need IPC/SPX or TCP/IP?
Should I change the registry (LOCAL or ORACLE_SID)? If yes where exactly? I am really

Any help would be appreciated
Reinhard

Please reply to: Reinhard.Wahl_at_gmx.de

My sqlnet.ora:

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) My tnsnames.ora:

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

)
)

DBFIRST.SOSO2 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = soso2)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = DBFIRST.SOSO2)
    )
  )

My listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = soso2)(PORT = 1521))
      )

)
(DESCRIPTION =

      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = soso2)(PORT = 2481))

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\Oracle\Ora817)
      (PROGRAM = extproc)

)
(SID_DESC =

      (GLOBAL_DBNAME = DBFIRST.SOSO2)
      (ORACLE_HOME = c:\Oracle\Ora817)
      (SID_NAME = DBFIRST)

)
) Received on Mon Nov 19 2001 - 13:41:14 CST