IT35791: RESTORE OF CLUSTERED ORACLE RAC DATABASE MESSAGE ORA-27528: TRANSPORT: RDS REQUIRED BY ENGINEERED SYSTEM IS NOT AVAILABLE

APAR status

• Closed as program error.

Error description

• Restoring an Oracle DB to an Oracle Real Application Cluster
  (RAC) can fail when both of these conditions are true:
  
  - The
  CLUSTER_INTERCONNECTS parameter is defined in the backed up
  database's PFILE or SPFILE.
  - Each node in the RAC has a
  different CLUSTER_INTERCONNECTS value.
  
  When the restore issue
  occurs, this message is written to the job log:
  
   ORA-27528:
  Transport: RDS required by Engineered System is not available
  
  
  These messages are written to the database alert log on the
  Oracle server:
  
   Error: IP addresses provided by Cluster
  Interconnects do not support RDS transport required for an
  Engineered system.
   Terminating the instance due to ORA error
  27528
  
  For further details about the underlying Oracle error,
  refer to Oracle Support Doc ID 2693130.1:
  https://support.oracle
  .com/knowledge/Oracle%20Cloud/2693130_1.html
  

Local fix

• 1. Copy the source PFILE parameters into a plain text file,
  such as /home/oracle/template.ora
  2. Edit the file created in
  step 1 and remove the CLUSTER_INTERCONNECTS parameter.
  3. Copy
  the edited file to the nodes where the restore is being
  performed.
  4. In the IBM Spectrum Protect Plus UI restore
  wizard, select option "Init Params -> Template", then specify
  the full path to template.ora in step 3.
  5. Restore the
  database.
  6. After the restore completes successfully, the
  database is started without the CLUSTER_INTERCONNECTS
  parameter. Use standard Oracle commands to configure the
  restored database with the correct CLUSTER_INTERCONNECTS
  parameter.
  
  Additional keywords: SPP TS004745595
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *  Apply the fixing level when available. This problem is      *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.8. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Oracle RAC database restore will complete successfully even if
  cluster_interconnects parameter is specified for the source
  database.
  

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

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels