PJ33988: PE/IS: $ORACLE_HOME/LIB32/CLNTSH.O LIBRARY IS NOT CREATED BY THE IS FOR ORACLE 10 ON AIX , THE PE SOFTWARE CREATES A LI

APAR status

• Closed as program error.

   

Error description

• ***PLEASE PROVIDE THE FOLLOWING INFORMATION
  THIS FIELD IS REQUIRED.***
  Description of Problem (full details)
  Configuration: AIX on Oracle 10
  A bug in ucommon.c causes "fn_util linkrdb" to read the
  Oracle version incorrectly on AIX and therefore create a link
  from /fnsw/lib/shobj/oracle.so to $ORACLE_HOME/lib32/clntsh.o
  with Oracle 10 instead of to $ORACLE_HOME/lib32/libclntsh.so.
  PE software creates a link for library
  /fnsw/lib/shobj/liboracle.so to $ORACLE_HOME/lib32/clntsh.o
  With Oracle10 the IS does not use the Oracle client utilities
  to create clntsh.o as in Oracle9.
  /fnsw/lib/shobj/liboracle.so, used for stored procedure
  execution, has a link to a library that does not exist. In
  Oracle 10, it should link to /$ORACLE_HOME/lib32/libclntsh.so
  How long has the problem been occurring (recent changes)? :
  Since Oracle 10 support
  Does this occur on more than one station / server? :
  AIX servers with Oracle10
  Is there a workaround? :
  Yes, remove the existing link liboracle.so and create a new
  one to libclntsh.so
  As fnsw user:
  rm /fnsw/lib/shobj/liboracle.so
  ln -s $ORACLE_HOME/lib32/libclntsh.so liboracle.so
  What is the impact to the customer/system? :
  Cannot run stored procedures if link is not created
  Can the problem be replicated on an internal system?  Y or N
  By Who (L3, Support, etc..)
  BPM QA team
  Steps to Reproduce:
  1 run the dbinstruction test from the PE test suite
  2
  3
  Actual Results:
  The test fails as Pe software is not able to locate the library
  required to run the stored procedure calls
  Expected Results:
  Test should pass with no failures
  Are there any similar or related Defects? If Y provide ECMDB #s
  No
  What logs were collected and where are they located?
  Configuration/Environment :
  Server OS : AIX
  Client OS :
  Database : Oracle 10
  Network:
  App Server :
  Browser :
  Note if non US Language:
  Other Product Component Versions:
  Non Web Environment  Y or N
  N
  

   

Local fix

•  

Problem summary

• IS users using Oracle 10gWas returning a bad value for oracle_ve
  

   

Problem conclusion

• In get_oracle_version_from_CDB (about line 424), the code was in
  correctly trying to read 'version' as an integer.  This fix now
  correctly reads it as a string.