IT09143: FLASHCOPY MANAGER FOR ORACLE BACKUPS TERMINATE WITH MISLEADING FMM9227E ERROR WHEN THE ASM_INSTANCE_ID IS INCORRECT

Download Information: Version 4.1.3 IBM Spectrum Protectâ„¢ Snapshot

APAR status

• Closed as program error.

Error description

• When using Tivoli Storage FlashCopy Manager to backup an Oracle
  database, the backup may terminate with the following error:
  FMM9227E The ASM diskgroup 'diskgroup' has not been found.
  Ensure that it is available.
  even though the diskgroup exists when the value defined for
  ASM_INSTANCE_ID is incorrect. ASM_INSTANCE_ID is defined in the
  FlashCopy Manager for Oracle profile.
  Versions Affected: 3.2, 4.1
  Customer/L2 Diagnostics (If Applicable)
  When the ASM_INSTANCE_ID is incorrect, SQL error messages are
  treated as ASM disk group names as seen the FlashCopy Manager
  trace output shown below:
  18:03:20.234   400 (102) esd-system.cpp:1613 before 'setuid':
  real uid = 1000 effective uid = 0
  18:03:20.234   400 (102) esd-system.cpp:1622 after 'setuid':
  real uid = 0 effective uid = 0
  18:03:20.355   400 (102) esd-oracleasmctl.cpp:174 '/usr/bin/su -
  oracle -c "grep 'ERROR at line'
  /tmp/fcmNrZqak > /dev/null "'
  18:03:20.406   400 (102) esd-system.cpp:1655 before 'setreuid':
  real uid = 0 effective uid = 0
  18:03:20.406   400 (102) esd-system.cpp:1665 after 'setreuid':
  real uid = 1000 effective uid = 0
  18:03:20.406   400 (102) esd-oracleasmctl.cpp:185 rc = 0
  ----- file "/tmp/fcmNrZqak" -----
  ERROR:
  ORA-27271: szingroup: group lookup failure
  IBM AIX RISC System/6000 Error: 3: No such process
  Additional information: 869
  SP2-0640: Not connected
  Initial Impact:
  Low
  Additional Keywords:
  ASM_INSTANCE_ID
  

Local fix

• Correct the ASM_INSTANCE_ID
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of IBM Tivoli Storage FlashCopy Manager for Unix   *
  * v3.2, v4.1.0, v4.1.1 performing Oracle databases backup      *
  * operation when incorrect ASM_INSTANCE_ID value was specified *
  * in the Tivoli Storage FlashCopy Manager profile.             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available.                           *
  ****************************************************************
  

Problem conclusion

• IBM FlashCopy Manager for Unix will be fixed to show the correct
  error message.
  

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:

Modules/Macros

• backup
  

Fix information

• Fixed component name

  FLSHCPY ORACLE

• Fixed component ID

  5608AC6OS

Applicable component levels

• R32L PSN

     UP

• R41L PSY

     UP

• R32A PSN

     UP

• R41A PSY

     UP