ORA-01031: Insufficient Privileges

(Doc ID 2101750.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Insurance Compliance Forms Tracker - Version 6.8 and later
Information in this document applies to any platform.

Symptoms

On:  6.8.2 version, Tracker Database upgrade against Oracle DB engine,

ORA-01031: insufficient privileges error occurs when running the batch script.

Customer is upgrading the Tracker database to Tracker 6.8.2 version from current 6.8.1.1.
They used the batch upgrade option.
We noticed that the instruction in ReadMe_upgrade_Oracle.pdf under "Tracker_CD\Database\Upgrade\ORACLE" does not mention to put DB User account, it just showed the following instruction format to execute the batch script in Command prompt:

[Batch File] [Tracker Database Name] [Tracker Password]

The user executed the script and it generated a log file. The file shows all successful except one failure for Creating/Modifying a VIEW. Details are mentioned in the log file and attached for a review.

ERROR
-----------------------
ERROR at line 1:
ORA-01031: insufficient privileges

When trying to run this SQL script (copied from the SQL file) manually using SQL Developer, it failed to execute showing same privilege error. They used DB User 'Tracker' to run the script.

Note that DBA has revoked rights for DB User 'Tracker' for some internal security reason prior running this batch script.

Now the concern is how to run this script.
Also if 'Tracker' user needs the rights back to have successful functionality for every day task in Tracker and in the SERFF transactions.

STEPS
-----------------------
The issue can be reproduced at will with the following steps in Oracle DB environment:
1. Copy the 'Upgrade' folder and its contents to a Folder in the DB Server
2. From Command prompt, access the folder up to 'Oracle'
3. Run following command:
682ORACLEEXISTINGCUSTOMER.cmd Tracker_DB DB_User_Password
4. It produced a log file named 682ORACLEEXISTINGCUSTOMER.log
5. Notice that it has one failed update for 'Creating/Modifying' a VIEW

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users need instruction on how to execute this failed script.
It is affecting the upgrade in Production.

Changes

DBA has revoked rights for DB User 'Tracker' for some internal security reason.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms