Thursday, 3 May 2018

ORA-01031 occurs during Post Install / De-install steps [or] Oracle DB componenet JAVAVM becomes invalid after patching

While running db post install steps running into below issues and the OJVM component becomes invalid.
 
Error:-

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


Solution:-


cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all

No comments:

Post a Comment