ORA-29538, ORA-29532, ORA-29913 problem solving

Source: Internet
Author: User

Question one:
ERROR at line 1:ora-29538:java not installed
Workaround
1. Check that there are no Java components installed
SELECT * from V$option t where t.parameter= ' Java ';
If the return line description is installed, if no rows are returned, run Oracle Universal installer install Java components
2. If the row is returned in step 1th, check that there is no Dbms_java in Oracle.
Select distinct owner,name from Dba_source where lower (name) = ' Dbms_java ';
If no rows are returned, perform step 3rd
3. Log in with SYS under Sqlplus, execute $oracle_home/javavm/install/initjvm.sql
sql>@?/javavm/install/initjvm.sql;

Question two:
ERROR at line 1:
Ora-29532:java call terminated by uncaught Java exception:
Java.security.AccessControlException:the Permission (java.io.FilePermission
/home/accmgrctl/src/server read) has not been granted to Sqlview. The PL/SQL to
Grant this is dbms_java.grant_permission (' Sqlview ',
' SYS:java.io.FilePermission ', '/home/accmgrctl/src/server ', ' read ')
Ora-06512:at "Sqlview. Pkg_file_api ", line 1
Workaround:
This is because the Oracle user does not have access to that directory and puts the source code in a directory that Oracle has access to
Or use the following statement to authorize
EXEC dbms_java.grant_permission (' oracle_username ', ' java.io.FilePermission ', ' * ', ' read '); Question three:
ERROR at line 1:
Ora-29913:error in executing odciexttableopen callout
Ora-29400:data Cartridge Error
Kup-00552:internal XAD package failed to load
Ora-06512:at "SYS. Oracle_loader ", line 19
Workaround:
This is a new bug on 110202 (read from external table)
Need to replace the language specific (non-english) KUP<LANG>.MSB file
With the 中文版 version.

1. CD $ORACLE _HOME/RDBMS/MESG
2. Replace <lang> with your installed languages file.
MV KUP&LT;LANG&GT;.MSB to KUP&LT;LANG&GT;.MSB. Bak
3. Copy <us> version over current <lang> Copy of Kup MSB file.
CP KUPUS.MSB to KUP&LT;LANG&GT;.MSB
4. Re-run the select against the external table

My actual operation process is:

This directory: $ORACLE _HOME/RDBMS/MESG has two files:
KUPZHS.MSB and KUPUS.MSB, which use the default KUPZHS.MSB
At this point, I renamed KUPZHS.MSB to Kupzhs.msb.bak
After the test, OK:

ORA-29538, ORA-29532, ORA-29913 problem solving

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.