RE: Error running catxsu.sql SUMMARY

http://home.clara.net/dwotton/dba/jsp_impl.htm Section "Grant read permission on the input file" solved the problem.

-----Original Message-----
Sent: Wednesday, February 06, 2002 5:38 PM To: Kirsch, Walter J (Northrop Grumman)

FWIW - On a couple of occasions when I've seen errors like this, the solution was to "drop" & reinstall the JVM inside Oracle. The down side is that after dropping the JVM, the instance needs to be bounced.

YMMV & HTH HAND! "Kirsch, Walter J (Northrop Grumman)" wrote:
>
> HP-UX 11.0 32-bit running 8.1.7.0.0
> While trying to install the XML-XSU Utility, I followed the instructions
in
> "Using XML-SQL Utility (XSU)" after step (1) loadjar'ing the xmlparser2, I
> ran step (2) sqlplus'ing the file catxsu.sql with the following result:
> ---------------------------------------------------
> ptmp:/opt/oracle/817/rdbms/admin> sqlplus system/x @catxsu
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Wed Feb 6 11:13:59 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> call sys.dbms_java.loadjava ('-v -r -grant PUBLIC rdbms/jlib/xsu12.jar')
> *
> ERROR at line 1:
> ORA-29532: Java call terminated by uncaught Java exception:
> java.security.AccessControlException: the Permission
(java.io.FilePermission
> /opt/oracle/817/rdbms/jlib/xsu12.jar read) has not been granted by
> dbms_java.grant_permission to
> SchemaProtectionDomain(SYSTEM|PolicyTableProxy(SYSTEM))
>
> --the rest of the script ran without error.
> ---------------------------------------------------------------------
>
> Advice, anyone?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kirsch, Walter J (Northrop Grumman)
> INET: walter.kirsch-eds_at_eds.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler                              Maintenance Warehouse  
charliem_at_mwh.com                             10641 Scripps Summit Ct.
858-831-2229                                 San Diego, CA 92131    
You can lead some people to knowledge, but you can't make them think!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsch, Walter J (Northrop Grumman)
  INET: walter.kirsch-eds_at_eds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).