Help - Search - Members - Calendar
Full Version: extproc.ora config on 11gR2
Oracle DBA Forums > Oracle > Oracle Forum
tomtom75
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
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
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
Hi Tom,

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

Gee, that was easy!

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

Glad I could help . . .
btidba
Hi,

You said :"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" ,i run the procedure under sys user but i got the same error.

I used the existing sample from the %ORACLE_HOME%\RDBMS\extproc ,find attached the scripts and files.
I added the .so path in the listner.ora and define the exproc in tnsnames.ora.

Please advice. I've Oracle server 11g R2 installed under Windows.

Thanks

burleson
Hi,

Why the heck did you re-open a thread that is several years old????

>> Please advice.

Sorry, this is no longer a question, it has become a request for suppor services!

You need to log a service request on MOSC:

http://support.oracle.com

Let us know your final solution!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.