Home » RDBMS Server » Server Administration » Validating external libraries in oracle 11g - AIX
Validating external libraries in oracle 11g - AIX [message #657387] Mon, 07 November 2016 11:03 Go to next message
kurki
Messages: 11
Registered: December 2013
Junior Member
Hi All,

Can you please help me on how to check if "External libraries" are set up correctly in oracle 11g - AIX.
Like calling external PLSQL libraries/functions in oracle.

Thanks & Regards,
Rama K Kurapati
Re: Validating external libraries in oracle 11g - AIX [message #657388 is a reply to message #657387] Mon, 07 November 2016 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

By default, external procedure access is done via extproc agent, you can see this using:
lsnrctl status [<listener_name>]
and see if you have something like with extproc in the description

But the best (and correct) way is to ask your DBA.

Re: Validating external libraries in oracle 11g - AIX [message #657431 is a reply to message #657388] Tue, 08 November 2016 08:14 Go to previous messageGo to next message
kurki
Messages: 11
Registered: December 2013
Junior Member
Thanks for your reply,

Yes. I have updated the listener with extproc details and when I start listener it is showing extproc service as started.
but when I validate the functions it is giving the same error.


Thanks,
Re: Validating external libraries in oracle 11g - AIX [message #657433 is a reply to message #657431] Tue, 08 November 2016 08:17 Go to previous messageGo to next message
cookiemonster
Messages: 12990
Registered: September 2008
Location: Rainy Manchester
Senior Member
Same error?
You haven't mentioned any error.
Re: Validating external libraries in oracle 11g - AIX [message #657434 is a reply to message #657431] Tue, 08 November 2016 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What error? You didn't previously talk about any error!
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read How to use [code] tags and make your code easier to read.

Re: Validating external libraries in oracle 11g - AIX [message #657435 is a reply to message #657434] Tue, 08 November 2016 08:20 Go to previous messageGo to next message
kurki
Messages: 11
Registered: December 2013
Junior Member
Sorry I missed to post the error message.

Below is the error and I tried it on AIX - Oracle 11g

==================
SQL> select OptimMaskNStr('340042404908916','pro=ccn,flddef1=(name=c1,dt=wchar)') from dual;
select OptimMaskNStr('340042404908916','pro=ccn,flddef1=(name=c1,dt=wchar)') from dual
*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: 0509-022 Cannot load module
/optimapp/IBM/Infosphere/Optim/dp/bin/libODPPORAUdf.11.3.a(libODPPORAUdf.so.11.3
).
0509-150 Dependent module libODPPDataCnvLib.11.3.a(libODPPDataCnvLib.so.11.3)
could not be loaded.
0509-022 Cannot load module
libODPPDataCnvLib.11.3.a(libODPPDataCnvLib.so.11.3).
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module
/optimapp/IBM/Infosphere/Optim/dp/bin/libODPPORAUdf.11.3.a(libODPPORAUdf.so.11.3
).
0509-150 Dependent module
/optimapp/IBM/Infosphere/Optim/dp/bin/libODPPORAUdf.11.3.a(libODPPORAUdf.so.11.3
) could not be loaded.
===================
Re: Validating external libraries in oracle 11g - AIX [message #657436 is a reply to message #657435] Tue, 08 November 2016 08:22 Go to previous messageGo to next message
cookiemonster
Messages: 12990
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you checked that /optimapp/IBM/Infosphere/Optim/dp/bin/libODPPORAUdf.11.3.a(libODPPORAUdf.so.11.3) actually exists and that the oracle user has permissions on it?
Re: Validating external libraries in oracle 11g - AIX [message #658175 is a reply to message #657436] Tue, 06 December 2016 04:25 Go to previous messageGo to next message
kurki
Messages: 11
Registered: December 2013
Junior Member
Sorry for the delayed response,

Yes, it is there and have given 777 permissions on Linux.
but still unable to load the module.

Thanks & Regards,
Rama K Kurapati
Re: Validating external libraries in oracle 11g - AIX [message #658178 is a reply to message #658175] Tue, 06 December 2016 04:34 Go to previous messageGo to next message
cookiemonster
Messages: 12990
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is the error message the same?
Re: Validating external libraries in oracle 11g - AIX [message #658183 is a reply to message #658178] Tue, 06 December 2016 07:05 Go to previous messageGo to next message
kurki
Messages: 11
Registered: December 2013
Junior Member
Yes.. Still getting the same error message.

I have check LIBPATH and all other environment variables.
listener is up and running with EXTPROC entries and tnsnames.ora also has extproc_connection_data alias with extproc settings.

but still getting the same error and all the library files has 777 permissions.

I am using this to call ODPP (Optim Data privacy provider) functions.

Thanks & Regards,
Kishore
Re: Validating external libraries in oracle 11g - AIX [message #658189 is a reply to message #658183] Tue, 06 December 2016 08:48 Go to previous message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
post results of following OS commands below

ls -l /optimapp/IBM/Infosphere/Optim/dp/bin/libODPPORAUdf.11.3.a
ls -ld /optimapp/IBM/Infosphere/Optim/dp/bin/
ls -ld /optimapp/IBM/Infosphere/Optim/dp/
ls -ld /optimapp/IBM/Infosphere/Optim/
ls -ld /optimapp/IBM/Infosphere/
ls -ld /optimapp/

Read & Execute mask must exist from / through every directory to SO file
Previous Topic: Oracle .trc files consuming large amounts of disc space
Next Topic: Is there a optimal size for file next extent size?
Goto Forum:
  


Current Time: Thu Jan 18 09:03:16 CST 2018

Total time taken to generate the page: 0.01840 seconds