Help! ORA-28575 calling external proc
From: Michael Wilson <mwilson_at_raytheon.com>
Date: 1999/11/19
Message-ID: <3835784A.F2C71F1E_at_raytheon.com>#1/1
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
)
)
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
# SERVICE :
###########
CALLOUT_LISTENER =
(ADDRESS_LIST =
)
SID_LIST_CALLOUT_LISTENER =
(SID_LIST =
(SID_DESC =
)
)
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
# Installation Generated Net8 Configuration
# Version Date: Sep-23-99 Initial Installation
# Filename: Tnsnames.ora
)
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_key)) (CONNECT_DATA = (SID = extproc_agent) )
Date: 1999/11/19
Message-ID: <3835784A.F2C71F1E_at_raytheon.com>#1/1
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
################################################################## ############ NETWORK :
# FILENAME: listener.ora
# 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.comReceived on Fri Nov 19 1999 - 00:00:00 CET