Oracle DBA Forums > extproc.ora config on 11gR2

Full Version: extproc.ora config on 11gR2

Oracle DBA Forums > Oracle > Oracle Forum

tomtom75

Jan 19 2012, 12:51 PM

Hi all,

I'm struggling with my configuration to be able to run some external procedures.
I'm under 11gR2 and RHEL5 64bits.

Following is my extproc.ora file :

CODE

SET LD_LIBRARY_PATH=/path/to/my/lib
SET EXTPROC_DLLS=lib1:lib2

My LD_LIBRARY_PATH is valid and permissions are 755 but I'm getting this error message:

CODE

DECLARE
*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: lib1: cannot open shared object file: No such file or
directory
ORA-06512: at line 51

Does anyone have an idea ?

Thanks,

Tom

burleson

Jan 19 2012, 07:12 PM

Hi Tom,

Gave you set the extproc in your listener.ora?

CODE

[font="Courier New"] (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ANANDA)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=ANANDA))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\ora9)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ANANDA)
(ORACLE_HOME = d:\ora9)
(SID_NAME = ANANDA)
)
)[/font]

Are you aware of the security issue with extproic?

http://www.rampant-books.com/aud_411.htm

***********************************************
>> No such file or directory

When you create your external library it must be statically linked with all other shared libraries and directories used by extproc.

This is clearly a pathing error, Oracle cannot find the program in the specified directories.

Try adding $ORACLE_HOME/lib to your LD_Library_Path.

And MAKE SURE to export LD_LIBRARY_PATH!

CODE

SET LD_LIBRARY_PATH=/path/to/my/lib; $ORACLE_HOME/lib
export LD_LIBRARY_PATH

http://www.dba-oracle.com/t_extproc_no_suc...r_directory.htm

tomtom75

Jan 23 2012, 10:31 AM

Hi Donald,

First thanks for your answer.
According to the Oracle documentation :

QUOTE

When you use the default configuration for external procedures, the extproc agent is spawned directly by Oracle Database. There are no configuration changes required for either listener.ora or tnsnames.ora. However, you must define the environment variables to be used by external procedures in the extproc.ora file located in the ORACLE_HOME/hs/admin directory.

http://docs.oracle.com/cd/E14072_01/networ...cfg.htm#i443234

In addition, I guess this is not really a path problem but more an access privileges issue to these files since running sqlplus as oracle user solved my problem.

Thanks a lot and I hope it could help.

Tom

burleson

Jan 23 2012, 12:36 PM

Hi Tom,

>> since running sqlplus as oracle user solved my problem.

Gee, that was easy!

******************************
>> thanks for your answer.

Glad I could help . . .

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.