The Update Readiness Tool for Symantec Data Loss Prevention confirms that the Oracle database is ready to upgrade to the latest version of Symantec Data Loss Prevention. Before you upgrade, you can run the tool to test the appropriateness of items such as:
Other potential issues, such as numeric overflow
This article provides information about the current versions of the Update Readiness Tool, and provides details about certain results of the Update Readiness Tool tests.
IMPORTANT: This article will be updated when there is a new release of the tool, and will also be updated as needed to explain certain tool results. Click "Subscribe to this Article" in the box at the right to be automatically notified when there are updates to this article.
In addition, before you run the tool, you need to stop Oracle database jobs. See Stopping Oracle database jobs in this article for the steps to stopping the database jobs.
Stopping Oracle database jobs
If your database has scheduled jobs, you must unschedule them and clear the jobs queue before you run the Update Readiness Tool and start the migration process. After the jobs are unscheduled and the jobs queue is clear, you can run the URT and continue your migration.
To unschedule jobs:
Log in to SQL*Plus using the Symantec Data Loss Prevention database user name and password.
Run the following:
BEGIN FOR rec IN (SELECT * FROM user_jobs) LOOP dbms_job.broken( rec.job, true); dbms_job.remove( rec.job); END LOOP; END; /
Verify all jobs are unscheduled by running the following:
Select count(*) from user_jobs;
Confirm that the count is zero. If the count isn’t zero, run the command to clear the queue again; if a job is running when you attempt to clear the queue, the job will continue to run to completion and will not be cleared. For long running jobs, Symantec recommends that you wait for the job to complete instead of terminating the job.
Run the Update Readiness Tool on Oracle RDS
Refer to the following KB article for steps to run the Update Readiness Tool on Oracle RDS: