IC79353: SRA FAILS TO CONNECT TO ORACLE DATABASE DUE TO LANGUAGE CONFIGURATION SETTINGS

4.2.2 Fix Pack 7 (July 2014) for Tivoli Storage Productivity Center
4.2.2 Interim Fix 2 (December 2012) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 8 (March 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 9 (May 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 10 (August 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 3 (October 2012) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• /opt/ibm/tpcagent/agent/bin/execSqlPlus.sh
  ---------------
  When the database is configured with Hungarian Language
  environment variables the TPC (SRA) agent could not connect to
  database because the date format not valid for it:
  
  SQL> select thread#, ((startup_time -
  to_date('01-JAN-1970','DD-MON-YYYY')) * 86400 * 1000) from v$ins
  tance;
  select thread#, ((startup_time - to_date('01-JAN-1970','DD-MON-Y
  YYY')) *
  86400 * 1000) from v$instance
  
  Hiba a(z) 1. sorban:
  ORA-01843: rvnytelen hnap
  
  In english:
  
  (Error in 1. line:
  ORA-01843: invalid month)
  
  
  RECREATE STEPS: From TPC, set to English Environment Variables,
  attempt to monitor Oracle Database from SRA using NON English
  language variables
  
  
  
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TC300
  Server/Manager build/release (TPC):   4.2.1.152
  Agent build/release (TPC):    N/A
  Server/Manager (OS):     N/A
  Agent (OS):       N/A
  ________________________________________________________________
  Problem as described by customer: Unable to Monitor Oracle
  Database
  Initial customer impact (low/med/high):  Low
  

Local fix

• Contact Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC users monitoring Oracle databases        *
  *                 configured for non-English operation         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SQLPlus script used with TPC is     *
  *                      expecting English formatted months      *
  *                      from result sets. If the user is        *
  *                      operating in a different language,      *
  *                      an error is encountered.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• his APAR fix corrects the script to set the NLS month output
  to English for the purposes of TPC queries.  The fix for this
  APAR is targeted for the following maintenance package:
  
  | fix pack | 4.2.2-TIV-TPC-FP0002 - target April 2012
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix packs do not represent a formal
  commitment by IBM. The dates are subject to change without
  notice.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R42A PSY

     UP

• R42H PSY

     UP

• R42L PSY

     UP

• R42S PSY

     UP

• R42W PSY

     UP