DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error in running InitJVM.SQL

  1. #1
    Join Date
    Aug 2004
    Location
    hyderabad
    Posts
    1

    Error in running InitJVM.SQL

    I have run 2 procedures(INITJVM.SQL AND INITPLSJ.SAL) to send e-mail .
    They have been successfully deployed. I am able to send Mails from stored procedures successfully. But, by mistake somehow its not sending e-mails at all. Again i ran the 2procedures but, when i am running the first procedure, its not running succesfully now, its saying so many errors like the below

    drop role javauserpriv
    *
    ORA-00604: error occurred at recursive SQL level 1
    ORA-29540: class oracle/aurora/mts/http/security/RdbmsHttpPolicy does not exist
    ORA-06512: at "SYS.HTTP_SECURITY_CASCADE", line 0
    ORA-06512: at line 3
    create role javauserpriv
    *
    ORA-01921: role name 'JAVAUSERPRIV' conflicts with another user or role name
    Statement processed.
    drop role javaidpriv
    *
    ORA-00604: error occurred at recursive SQL level 1

    When i am dropping the above roles its not allowing me from SQLPLUS too.

    please anyone can tell me the solution as my work got struck due to this severe problem

    Regards
    Vinod

  2. #2
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    you cannot re-execute 'initjvm', you have to remove it first using 'rmjvm'. Then after that you can again execute 'initjvm'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width