Help Needed External Procs ORA-28575

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/05/23
Message-ID: <392AEF9D.BD45942B@0800-einwahl.de>#1/1

Linux SuSE 6.3, Oracle 8.1.5 EE. I want to use an external procedure and defined the library, compiled and linked it and now get ORA-28575 on each try to use it. The docs say the listener may be misconfigured. Can please someone hint me on what is wrong?

tnsping devdb works fine, as well as normal activities by sqlplus xxx/yyy_at_devdb.

Thanks in advance. Martin

tnsnames.ora:

DEVDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = martin)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = DEVDB.dev.world)

                (SRVR = DEDICATED)
    )
  )
extproc_connection_data.dev.world = (

	DESCRIPTION = (
		(
			ADDRESS = (
				PROTOCOL = ipc
			)
			(
				KEY = EXTPROC0
			)
			(
				CONNECT_DATA = (SID = extproc)
			)
		)
	)

)

listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

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


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = martin)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = martin)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /oracle/8.1.5)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = DEVDB)
(ORACLE_HOME = /oracle/8.1.5)
(SID_NAME = DEVSID)

    )
  ) Received on Tue May 23 2000 - 00:00:00 CDT