How to upgrade without access to the SYS account

Products

• Data Loss Prevention Enforce

Issue/Introduction

In a lot of instances the person who installs/upgrades DLP does not have access to the SYS account. Only access point is the DBA team.

Resolution

Relevant Versions:  7.0, 7.1 and 7.2

The instructions to upgrade without sys are similar to the ones with sys. There are two differences.

First, there is a script run_as_sys.sql. This script needs to be run by your DBAs before running the upgrader. We will assume that the script is run correctly, because we can not verify without the sys password. So, you need to make sure this is done beforehand.

Second, edit the upgrader.properties file. The last line of the file is:

#bypass.oracle.sys=true

Uncomment this line

bypass.oracle.sys=true

and save the file.

Once you have saved the file, you can follow the instructions for the upgrader. Instead of asking for the sys password, it will give you a warning and tell you that you need to run the script manually. Since you will have done that already, you can just hit return.