Friday, January 22, 2016

Unable to start sqlplus after OS patching in AIX with Could not load module libha_gs_r.a(shr_64.o) message

Noticed following issue after OS patching on a set of RAC standby servers which is running on AIX

 

Issue details

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 21 16:41:36 2016
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Could not load program oraclepcen2:
        Dependent module libha_gs_r.a(shr_64.o) could not be loaded.
Could not load module libha_gs_r.a(shr_64.o).
System error: No such file or directory
ERROR:
ORA-12547: TNS:lost contact


Also noticed following error from oracle relink log output

ld: 0706-006 Cannot find or open library file: -l ha_gs_r
        ld:open(): No such file or directory
make: The error code from the last command is 255.

Oracle running on AIX needs fileset: rsct.basic.rte and probably that fileset is missing in this host and that is the reason for this error.
This package is part of the OS Patch IY98287 which is one of the mandatory required patches to be installed on AIX if we are configuring a 11g RAC environment.

prdxxxx001:oracle:pcen1:/orasw/pcen/app/oracle/product/11.2.0/db/bin: lslpp -l rsct.basic.rte
lslpp: Fileset rsct.basic.rte not installed.

Finally worked with AIX Unix Admin to install missing fileset and we are able to start oracle binary

prdxxxx001:oracle:pcen1:/home/oracle: lslpp -l rsct.basic.rte
  Fileset                      Level  State      Description        
  ----------------------------------------------------------------------------
Path: /usr/lib/objrepos
  rsct.basic.rte             3.2.0.4  COMMITTED  RSCT Basic Function

Path: /etc/objrepos
  rsct.basic.rte             3.2.0.4  COMMITTED  RSCT Basic Function

No comments:

Post a Comment