Monday, July 4, 2011

Avoid library file locking errors (libjox)

Hi,
When applying CPU or Patchsets you may encounter some errors with regards to files being locked or opatch being unable to copy files even though the databases, listeners and any other Oracle processes associated with the ORACLE_HOME to be patched were stopped. If you will apply patchset or CPU patches in Silent mode you cannot see Linking errors.

Work around:
we should following things while installing patchset

We should run slibclean as root user
genld -l grep /u01/app/oracle/product/10.2(Oralce_home)
genkld grep /u01/app/oracle/product/10.2(Oracle_Home)

If genld returns data then a currently executing process has something open in ORACLE_HOME directory, please terminate the process as required/recommended.

If genkld command returns a list of shared objects currently loaded onto the OS system cache then please remove the entries from the OS system cache by running the slibclean command as root;
/usr/sbin/slibclean

Prease verify once installation completed

Please Verify libjox file is updated or not
cd $ORACLE_HOME/lib
ls -lrt libj*
-rw-r----- 1 oracle dba 0 Aug 10 2005 libjox10.so
-rw-r--r-- 1 oracle dba 23177425 Mar 25 2008
libjmisc.so
-rw-r--r-- 1 oracle dba 4070303 May 10 2008 libjox10oraawt.so
-rw-r--r-- 1 oracle dba 13257611 May 10 2008 libjox10.a


so you will face following errors when running Catupgrd.sql script if libjox file not upadated

Error:
grant select on ALL_JOBS to public with grant option
*ERROR at line 1:ORA-03113: end-of-file on communication channel
and subsequently all the following sql statements fail
ERROR:ORA-03114: not connected to ORACLE


Please Refer Metalink Doc. ID 739963.1

No comments: