2.2.2 About EXTPROC Configuration for OML4R

OML4R uses the default configuration of extproc.

The extproc agent is spawned directly by Oracle Database, and no configuration changes are required to either listener.ora or tnsnames.ora. If extproc is configured on the database listener, it overrides the default settings.

The extproc agent is spawned directly by Oracle Database, and the configuration changes are not required for listener.ora and tnsnames.ora. If extproc is configured on the database listener, it overrides the default settings and prevents the functioning of OML4R external procedures.

By default, extproc supports external procedure calls if the libraries used are in $ORACLE_HOME/bin or $ORACLE_HOME/lib.

The following statement on a Linux or UNIX system sets EXTPROC_DLLS to run only external procedures for OML4R:

SET EXTPROC_DLLS=ONLY:$ORACLE_HOME/lib/ore.so

To allow extproc to service any external procedure, set EXTPROC_DLLS to ANY or simply leave it blank (the default).

Enable extproc tracing by doing the following:

1. To your /extproc.ora file, add the following statement:

   SET TRACE_LEVEL=ON

2. Restart the database.

   Traces for all extproc operations are now recorded in the log files in the $ORACLE_HOME/hs/log directory.

See Also:

"Default Configuration for External Procedures" in Oracle Database Net Services Administrator's Guide for details