problem 1:
error at line 1: ORA-29538: Java not installed
solution
1. check whether the Java component is installed
select * from V $ option t where T. parameter = 'java';
If the returned row is installed, run Oracle universal installer to install the Java component.
2. if the row is returned in step 1, check whether dbms_java exists in Oracle.
select distinct owner, name from dba_source where lower (name) = 'dbms _ Java';
if no row is returned, perform Step 3.
. log On with sys under sqlplus and run $ ORACLE_HOME/JavaVM/install/initjvm. SQL
SQL> @? /JavaVM/install/initjvm. SQL;
problem 2:
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
solution:
This is because the Oracle user has no permission to access that directory, enter the Source Code in the Oracle-authorized directory
or use the following statement to authorize
exec dbms_java.grant_permission ('oracle _ username ', 'java. io. filepermission ',' * ', 'read');
Question 3:
Error at line 1:
ORA-29913: Error in executing odciexttableopen callout
The ORA-29400: data cartridge Error
KUP-00552: Internal XAD package failed to load
ORA-06512: At "SYS. oracle_loader", line 19
Solution:
This is another new bug in 110202 (External table reading)
Need to replace the language specific (non-English) Kup <Lang>. MSB File
With the English version.
1. CD $ ORACLE_HOME/rdbms/mesg
2. Replace <Lang> with your installed ages 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:
The Directory: $ ORACLE_HOME/rdbms/mesg contains two files:
Kupzhs. MSB and kupus. MSB, which use kupzhs. MSB by default
Now, I rename kupzhs. MSB as kupzhs. MSB. Bak.
After testing, OK: