Re: ORA-12560 on Win98

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Mon, 19 Nov 2001 23:34:41 +0100
Message-ID: <iq1jvtgr5pq52rpaavbmgqbl5cvuqfvcc4@4ax.com>

On Mon, 19 Nov 2001 20:41:14 +0100, "Reinhard" <Reinhard.Wahl_at_gmx.de> wrote:

>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)
> )
> )
>

These are my files, they work.
Your problem is a service_name in tnsnames.ora must match a service_name in init<sid>.ora (you don't define service_name in listener.ora), and it can't match a sid_name

# LISTENER.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

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

    )
    (DESCRIPTION =

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

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

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

    )

#    (SID_DESC =
#      (GLOBAL_DBNAME = oracle)
#      (ORACLE_HOME = c:\Oracle\Ora81)
#      (SERVICE_NAME = oracle)
#    )

  )
trace_level_listener=off

# SQLNET.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

TRACE_DIRECTORY_CLIENT = c:\oracle\ora81\network\admin

TRACE_UNIQUE_CLIENT = on

SQLNET.AUTHENTICATION_SERVICES= (none)

TRACE_LEVEL_CLIENT = off

SQLNET.EXPIRE_TIME = 0
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES)
#NAMES.DEFAULT_DOMAIN =
#NAME.DEFAULT_ZONE =
SQLNET.CRYPTO_SEED = "465052705-556207268"

#NAMES.PREFERRED_SERVERS =
#      (ADDRESS_LIST =
#        (ADDRESS =
#          (COMMUNITY = TCP.world)
#          (PROTOCOL = TCP)
#          (Host = hpro03)
#          (Port = 1527)
#        )
#        (ADDRESS =
#          (COMMUNITY = TCP.world)
#          (PROTOCOL = TCP)
#          (Host = hpal01)
#          (Port = 1529)
#        )
#      )

# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

ORACLE1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = NMP)(SERVER = 13382)(PIPE = ORAPIPE))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (ORACLE_HOME = c:\oracle\ora81)

    )
  )

ORACLEIPC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))     )
    (CONNECT_DATA =

      (service_name = oracle)
#      (ORACLE_HOME = c:\oracle\ora81)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

ORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =
      (service_name = oracle)
    )
  )

oraclebeq =
(description =

  (ADDRESS=(PROTOCOL=BEQ)
           (PROGRAM=oracle80)
           (ARGV0=oracle80orcl)
           (ARGS='(DESCRIPTION=(LOCAL=YES) (ADDRESS=(PROTOCOL=beq)))')
  )
        (connect_data = (sid = ORCL))

)

trace_unique_listener=true
trace_directory_listener=c:\oracle\ora81\network\admin

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 19 2001 - 16:34:41 CST