Getting "An attempt by Backup Exec to change the state of the database timed out" message while trying to access the oracle database from Backup Exec .

Article:TECH146200  |  Created: 2010-12-14  |  Updated: 2011-05-11  |  Article URL http://www.symantec.com/docs/TECH146200
Article Type
Technical Solution



Problem



Getting "An attempt by Backup Exec to change the state of the database timed out" message while trying to access the oracle database from Backup Exec .
 


Error



An attempt by Backup Exec to change the state of the database timed out. For details, refer to the Database Script output section in the job log. Contact your database administrator to change the state of the database.
 


Cause



While Accessing the Oracle database , Oracle database may take some time to change status. (for eg. From open to shut down ,from shut down to mount and so on). Backup Exec uses a SQLplus script which has a 10 minutes of default time-out to handle the changing database state. Oracle Real Application Cluster (RAC) Uses a srvctl script.
 


Solution



Change the default time-out appropriately, based on how long it took to shut down the Oracle database .Contact Oracle database administrator to check the time database takes to shut down. If the time-out is too short, then restore jobs and offline backups may fail with a time-out error. If the time-out is too long, and the database does not respond to the state change request, the job takes longer to fail. 

The following table describes how to change the SQLplus time-out.

For Oracle on Windows

  • Open Regedit

    Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.
  • Go to HKLM\ SOFTWARE\Symantec\Backup Exec\Engine\Agents\XBSA\Oracle RMAN Agent\SqlplusTimeout
  • Create a new DWORD value Sqlplus Timeout
  • Set the value as 300 seconds (this is equal to 5 minutes)
     

For Oracle on Linux

  • Open a Terminal Window
  • Type the following command vi etc/VRTSralus/ralus.cfg
  • Create the following entry Software\Symantec\Backup Exec\Engine\Agents\XBSA\Oracle RMAN Agent\SqlplusTimeout
  • Set the value as 300 (this is equal to 5 minutes)



Article URL http://www.symantec.com/docs/TECH146200


Terms of use for this information are found in Legal Notices