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
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