ORA-00942 while Upgrade readiness tool

Products

• Data Loss Prevention Core Package

Issue/Introduction

Running the Update Readiness Tool (URT) in preparation for an upgrade fails with the following Oracle error: ORA-00942: table or view does not exist

 

Same error is found in URT output files

Cause

 While running URT command follow option were used .

"--skip_export; and '--skip_import' 

These are optional parameter 

Resolution

 Execute URT with Standard Syntax for linux.

"/opt/AdoptOpenJRE/<JRE version>/bin/java" UpdateReadinessTool
--username <schema user name>
--password <password>
--readiness_username <readiness_username>
--readiness_password <readiness_password>
--service_name <database service name>
--target_version <upgrade target>

 

 Execute URT with Standard Syntax for winodws

"C:\Program Files\AdoptOpenJRE\<JRE version>\bin\java" UpdateReadinessTool
--username <schema user name>
--password <password>
--readiness_username <readiness_username>
--readiness_password <readiness_password>
--service_name <database service name>
--target_version <upgrade target>

 

Additional Information

Also Verify / Grant Oracle Database Privileges (Permissions) to Protect User