Configuring Listener To Spawn EXTPROC Agent Is Not Working in 12.2, EXTPROC_CONNECTION_DATA Is Not Getting Resolved. (Doc ID 2326592.1)

Last updated on JUNE 01, 2023

Applies to:

Symptoms

Oracle listener has been configured to spawn the external procedure agent "extproc" and in tnsnames.ora the service name
being used is "EXTPROC_CONNECTION_DATA". Though the listener is configured properly and "tnsping extproc_connection_data"
gets resolved without any error, still the extproc agent is not spawned by the listener instead extproc agent is spawned by the database.

As a result, the environment variables(e.g. EXTPROC_DLLS, LD_LIBRARY_PATH) configured in the listener.ora is not being
inherited by the extproc agent resulting in unexpected behavior of the external procedure including the error "ORA-28595".

For example, the listener configuration is done with the following entries

Changes

Database has been upgraded to 12.2 or its a new implementation in 12.2 database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.