OraFAQ Forum: Server Administration » Validating external libraries in oracle 11g

Home » RDBMS Server » Server Administration » Validating external libraries in oracle 11g - AIX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Validating external libraries in oracle 11g - AIX [message #657387]

Mon, 07 November 2016 11:03

kurki
Messages: 17
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

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657388 is a reply to message #657387]

Mon, 07 November 2016 13:02

Michel Cadot
Messages: 67640
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.

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657431 is a reply to message #657388]

Tue, 08 November 2016 08:14

kurki
Messages: 17
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,

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657433 is a reply to message #657431]

Tue, 08 November 2016 08:17

cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester

Senior Member

Same error?
You haven't mentioned any error.

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657434 is a reply to message #657431]

Tue, 08 November 2016 08:18

Michel Cadot
Messages: 67640
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.

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657435 is a reply to message #657434]

Tue, 08 November 2016 08:20

kurki
Messages: 17
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.
===================

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #657436 is a reply to message #657435]

Tue, 08 November 2016 08:22

cookiemonster
Messages: 13895
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?

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #658175 is a reply to message #657436]

Tue, 06 December 2016 04:25

kurki
Messages: 17
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

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #658178 is a reply to message #658175]

Tue, 06 December 2016 04:34

cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is the error message the same?

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #658183 is a reply to message #658178]

Tue, 06 December 2016 07:05

kurki
Messages: 17
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

Report message to a moderator

Re: Validating external libraries in oracle 11g - AIX [message #658189 is a reply to message #658183]

Tue, 06 December 2016 08:48

BlackSwan
Messages: 26757
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 05:14:49 CST 2021