I normally use adrci tool to find any ORA- Error in Alert log and report to DBA's Team if any Error message found in last n hours.
Script fails with following error on AIX environment whereas works fine in HP-UX.
Error :
Could not load program adrci: rtld: 0712-001 Symbol kgeres_where was referenced from module adrci(), but a runtime definition of the symbol was not found. rtld: 0712-001 Symbol skge_sign_fr was referenced from module adrci(), but a runtime definition of the symbol was not found. rtld: 0712-002 fatal error: exiting.
Problem :
As indicated in Error message its not able load one of required library even though LD_LIBRARY_PATH and ORALE_HOME is set up correctly.
Solution:
You would need setting additional parameter LIBPATH for this tool to work.
Example :
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export LIBPATH=$ORACLE_HOME/lib
Thanks Krishan - this has sorted out a problem with our housekeeping scripts.
ReplyDelete