Help! ORA-28575 calling external proc

From: Michael Wilson <mwilson_at_raytheon.com>
Date: Fri, 19 Nov 1999 10:18:18 -0600
Message-ID: <3835784A.F2C71F1E@raytheon.com>

We are trying to configure a separate listener to handle the external procedure processing for our system, but we are getting ORA-28575. We have gone through the troubleshooting document several times. Any help is greatly appreciated! Here's the listener.ora and tnsnames.ora files:

###########


# FILENAME: listener.ora


# NETWORK :


# SERVICE :


# AUTHOR  : Martin Yen


# DATE    : 09/23/99          Init. added plfd01


###########
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= plfd01))
        (ADDRESS= (PROTOCOL= TCP)(Host= explfd)(Port= 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= plfd01.rsc.raytheon.com)
      (ORACLE_HOME= /apps/oracle/product/8.0.6)
      (SID_NAME = plfd01)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = user
#TRACE_LEVEL_LISTENER = admin
#TRACE_LEVEL_LISTENER = off
TRACE_FILE_LISTENER = listener.trc
TRACE_DIRECTORY_LISTENER = /db2/oradata/logs/network LOG_FILE_LISTENER = listener.log
LOG_DIRECTORY_LISTENER = /db2/oradata/logs/network

##################################################################
###########


# FILENAME: listener.ora

# NETWORK :
# SERVICE :

###########
CALLOUT_LISTENER =
  (ADDRESS_LIST =

      (ADDRESS=
         (PROTOCOL= IPC)
         (KEY= extproc_key)
      )

  )
SID_LIST_CALLOUT_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = extproc_agent)
      (ORACLE_HOME= /apps/oracle/product/8.0.6)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_CALLOUT_LISTENER = 0
CONNECT_TIMEOUT_CALLOUT_LISTENER = 10
TRACE_LEVEL_CALLOUT_LISTENER = user
#TRACE_LEVEL_CALLOUT_LISTENER = admin
#TRACE_LEVEL_CALLOUT_LISTENER = off
TRACE_FILE_CALLOUT_LISTENER = callout_listener.trc TRACE_DIRECTORY_CALLOUT_LISTENER = /db2/oradata/logs/network LOG_FILE_CALLOUT_LISTENER = callout_listener.log LOG_DIRECTORY_CALLOUT_LISTENER = /db2/oradata/logs/network

TNSNAMES.ORA:

#

# Installation Generated Net8 Configuration
# Version Date: Sep-23-99 Initial Installation
# Filename: Tnsnames.ora

#


# ######################################################################


# 11/18/99                         Added a new service name


#                                  extproc_connection_data for extproc


# ######################################################################


#
plfd01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= explfd.rsc.raytheon.com)(Port= 1521))
    (CONNECT_DATA = (SID = plfd01))

  )
extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_key))     (CONNECT_DATA = (SID = extproc_agent)   )

--
===== R a y t h e o n S y s t e m s C o m p a n y =====   Michael Wilson
  Enterprise Applications

  972-344-3094
  972-344-2627 (fax)
  888-740-5671 (pager) or 8887405671_at_skytel.com

Received on Fri Nov 19 1999 - 10:18:18 CST