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<LANG>.MSB to KUP<LANG>.MSB. Bak
3. Copy <us> version over current <lang> Copy of Kup MSB file.
CP KUPUS.MSB to KUP<LANG>.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