OraFAQ Forum: Server Administration » Problem with initjvm.sql and rmjvm.sql

Home » RDBMS Server » Server Administration » Problem with initjvm.sql and rmjvm.sql (Oracle 8.1.7.4 Aix 4.3.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with initjvm.sql and rmjvm.sql [message #340347]

Tue, 12 August 2008 07:30

thorin666
Messages: 144
Registered: March 2007

Senior Member

Hi, i have a problem.
when i try to install jvm i get this error.


drop role javauserpriv
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.HTTP_SECURITY_CASCADE" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3


create role javauserpriv
            *
ERROR at line 1:
ORA-01921: role name 'JAVAUSERPRIV' conflicts with another user or role name

after that, in the same log i can read the same msg

create or replace java system;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [16500], [kqdobu], [U], [0], [1],
[sun/security/x509/AlgIdDSA], [], []

and after that

    select SEQ from dba_java_policy where GRANTEE = 'JAVA_DEPLOY' ;
                    *
ERROR at line 6:
ORA-06550: line 6, column 21:
PLS-00201: identifier 'DBA_JAVA_POLICY' must be declared
ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 12:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 11, column 5:
PL/SQL: SQL Statement ignored


begin if :jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'DOWNGRADE_8.1.7_TO_8.1.6' then
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed,  does not exist
ORA-04067: not executed, package body "SYS.HTTP_SECURITY_CASCADE" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.INITJVMAUX", line 18
ORA-06512: at line 4


begin if :jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'DOWNGRADE_8.1.6_TO_8.1.5' then
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed,  does not exist
ORA-04067: not executed, package body "SYS.HTTP_SECURITY_CASCADE" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.INITJVMAUX", line 18
ORA-06512: at line 9

That database was 8.1.7.0 and i patched to 8.1.7.4 but the problem continue.

I tried to uninstall jvm using but i get a lot of this msg

SQL> @ rmjvm.sql

PL/SQL procedure successfully completed.

SP2-0042: unknown command "@@jvmrm" - rest of line ignored.
Usage: VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR (n) | VARCHAR2 (n) |
                               NCHAR | NCHAR (n) | NVARCHAR2 (n) |
                               CLOB | NCLOB | REFCURSOR ] ]

JVMRMACTION
--------------------------------
FULL_REMOVAL

initjvmaux.drp('drop role javauserpriv');
*
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00201: identifier 'INITJVMAUX.DRP' must be declared
ORA-06550: line 3, column 1:

i tried to drop manually this roles
JAVAUSERPRIV JAVAIDPRIV JAVASYSPRIV JAVADEBUGPRIV JAVA_ADMIN JAVA_DEPLOY
but i get this message

SQL> drop role JAVAUSERPRIV;
drop role JAVAUSERPRIV
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.HTTP_SECURITY_CASCADE" does not
exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3

Does anyone have an idea about what i can do?
thank you in advance

Report message to a moderator