ORA-29538, ORA-29532, ORA-29913 Problem Solving
ORA-29538, ORA-29532, ORA-29913 Problem Solving
Question 1:
ERROR at line 1: ORA-29538: Java not installed
Solution
1. Check whether JAVA components are 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 if no row is returned.
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 rows are returned, perform step 1.
3. log in with sys under sqlplus and run $ ORACLE_HOME/javavm/install/initjvm. SQL
SQL> @? /Javavm/install/initjvm. SQL;
Question 2:
ERROR at line 1:
The 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
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 does not have the permission to access that directory. The source code is stored in the directory that oracle has the permission to access.
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 . Msb file
With the english version.
1. cd $ ORACLE_HOME/rdbms/mesg
2. Replace With your installed ages file.
Mv KUP . Msb to KUP . Msb. BAK
3. Copy Version over current Copy of kup msb file.
Cp kupus. msb to KUP . 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: