For media server operations, the Oracle database may take some time to change states, such as from open to shut down, from shut down to mount, and so on. A SQLplus script in Backup Exec allows a default time-out of 10 minutes to handle the changing database state. For Oracle Real Application Cluster (RAC), a srvctl script is used.

The time-out for database state change is named SqlplusTimeout.

You may need to change the length of the default time-out if the following error message appears:

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.

Try shutting down the database. If you succeed, then the SQLplus time-out is too short. Change the default time-out appropriately, based on how long it took to shut down the database. If you cannot shut down the database, contact your DBA to troubleshoot the database.

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.