ORA-01031 during Post Install / De-install for Database PSU or OJVM PSU with Data Vault installed (Doc ID 1935120.1)

Last updated on MAY 31, 2017

Applies to:

Oracle Database - Personal Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database - Standard Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

ORA-01031 occurs during Post Install / De-install steps for Database PSU or "Oracle JavaVM Component Database PSU" (OJVM PSU) in a system that has Data Vault installed.
eg:

SQL> BEGIN
  2
  3      initjvmaux.drop_sros();
  4
  5      EXECUTE IMMEDIATE 'create or replace java system';
  6
  7      update dependency$
  8        set p_timestamp=(select stime from obj$ where obj#=p_obj#)
  9        where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and
10              (select type# from obj$ where obj#=p_obj#)=29  and
11              (select owner# from obj$ where obj#=p_obj#)=0;
12
13  -- Check the validity of JAVAVM and let the registry be updated accordingly.
14
15      initjvmaux.validate_javavm;
16
17  -- Add a row in registry$history to indicate this script was run.
18
19      EXECUTE IMMEDIATE 'insert into registry$history
20                         (action_time, action, namespace, version, id, comments)
21                         values(SYSTIMESTAMP, ''jvmpsu.sql'', ''SERVER'',
22                                ''11.2.0.4.1OJVMBP'', 0, ''APPLIED jvmpsu.sql'')';
23
24  END;
25  /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.INITJVMAUX", line 535
ORA-06512: at line 3

 

Errors during the execution of applications (i.e. accessing a wallet) could be the following indicating the Post Install steps did not complete successfully:

ERROR at line 1:
ORA-28374: typed master key not found in wallet
ORA-06512: at "SYS.DBMS_REGISTRY", line 207
ORA-06512: at "SYS.DBMS_REGISTRY", line 357
ORA-06512: at "SYS.INITJVMAUX", line 144
ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable
ORA-06512: at line 10

 

Changes

You are running post install steps (or post deinstall steps) of a Database PSU (or equivalent bundle patch) or an OJVM PSU.

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