Error: ORA-04095 or ORA-01403 when creating or upgrading OAE agent

Products

• Automic Applications Manager

Issue/Introduction

When upgrading the Oracle Applications Extension (OAE) agent to version 9.5.1 or creating a new agent on Oracle 19c, jobs fail with missing table errors or the upgrade script fails. 

Symptoms:

• Jobs fail with one or more of the below errors: 

  Error during Job Launch java.sql.SQLException: ORA-20096: ORACLE error -942 in SUBMIT: others

  Cause: SUBMIT: others failed due to ORA-00942: table or view does not exist.

  The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.

Environment

Applications Manager 9.5.x and above

Cause

A product defect (DE203969) prevents the standard setup script from granting necessary permissions to the OAE user (e.g., OAEUSER).

Resolution

Workaround:

1. Download the attached OAE_user_setup_with_fixes.sql (contains missing grants)
   
   
2. Replace running OAE_user_setup.sql with OAE_user_setup_with_fixes.sql.

Solution:

Updated sql will be included in the next version of Applications Manager 9.6.3 or 9.7/10.0 (version number has not been finalized).

Additional Information

Additional Information For standard OAE setup steps, see Installing and Upgrading the OAE Extension.