This document describes how to turn off Fault Tolerance on the database.
The procedure described in this document requires the assistance of a qualified DBA with access to the Scheduler database. (For Oracle this is the ‘tidal’ schema. For SQL Server, this is the ‘Admiral’ database.) Cisco recommends that you back up your database before you complete the procedure described in this document and before you run any SQL commands against the database.
The information in this document is based on these software and hardware versions:
Cisco Tidal Enterprise Scheduler release 5.3.1.x
SQL Database 2005-2008
Oracle 10g-11g SQL*Plus
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
Refer to Cisco Technical Tips Conventions for information on document conventions.
In order to turn off fault tolerance on the database, complete these steps:
Access the Scheduler database from SQL*Plus or SQL Server Management Studio.
Run this command:
UPDATE sysval SET sysval_string = 'N' WHERE (sysval_id=21);