Expansion of the database is a manual library with scripts, In the run a development provided by the stored procedures, throw the following error: ORA-29538: Javanotinstalled below record the entire process:
Expansion library is a manual library with scripts, In the run a development provided by the stored procedure, throw the following error: ORA-29538: Java not installed below to record the entire process:
A script is used to manually create a database for expansion. when running the stored procedure provided by R & D, the following error is thrown:
ORA-29538: Java not installed
The entire process is recorded below:
SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production
PL/SQL Release 11.1.0.7.0-Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0-Production
NLSRTL Version 11.1.0.7.0-Production
SQL> select * from v $ option t where t. PARAMETER = 'java ';
PARAMETER VALUE
--------------------------------------------------------------------------------------------------------------------------------
Java TRUE
SQL> select distinct owner, name from dba_source where lower (NAME) = 'dbms _ Java ';
OWNER NAME
------------------------------------------------------------
SYS DBMS_JAVA
SQL> select owner, status, count (*) from all_objects where object_type like '% JAVA %' group by owner, status;
No rows selected
Therefore, you need to install JVM:
@? /Javavm/install/initjvm. SQL
SQL> select owner, status, count (*) from all_objects where object_type like '% JAVA %' group by owner, status;
Owner status count (*)
-------------------------------------------------------
Sys valid 19662
SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
-------------------------------------------------------------------------------------
Oracle Workspace Manager 11.1.0.7.0 VALID
Oracle Database Catalog Views 11.1.0.7.0 VALID
Oracle Database Packages and Types 11.1.0.7.0 VALID
JServer JAVA Virtual Machine 11.1.0.7.0 VALID
@? /Xdk/admin/initxml. SQL
SQL> select owner, count (*) from all_objects where object_type like '% JAVA %' group by owner;
Owner count (*)
----------------------------------------
SYS 20738
@? /Rdbms/admin/catjava. SQL
SQL> select owner, count (*) from all_objects where object_type like '% JAVA %' group by owner;
Owner count (*)
----------------------------------------
SYS 21097
@? /Rdbms/admin/catexf. SQL
@? /Xdk/admin/xmlja. SQL
SQL> select owner, count (*) from all_objects where object_type like '% JAVA %' group by owner;
Owner count (*)
----------------------------------------
EXFSYS 44
SYS 21097
Additional:
Reinstall JVM on oracle11gr1
(1) shut down the database and run the following script to delete the existing JVM:
-- Start of File full_rmjvm. SQL
Spool full_rmjvm.log
Set echo on
Connect/as sysdba
Startup mount
Alter system set "_ system_trig_enabled" = false scope = memory;
Alter system enable restricted session;
Alter database open;
@? /Rdbms/admin/catnoexf. SQL
@? /Rdbms/admin/catnojav. SQL
@? /Xdk/admin/rmxml. SQL
@? /Javavm/install/rmjvm. SQL
Truncate table java $ jvm $ status;
Select * from obj $ where obj # = 0 and type # = 0;
Delete from obj $ where obj # = 0 and type # = 0;
Commit;
Select owner, count (*) from all_objects
Where object_type like '% JAVA %' group by owner;
Select obj #, name from obj $
Where type # = 28 or type # = 29 or type # = 30 or namespace = 32;
Select o1.name from obj $ o1, obj $ o2
Where o1.type # = 5 and o1.owner # = 1 and o1.name = o2.name and o2.type # = 29;
Shutdown immediate
Set echo off
Spool off
Exit
-- End of File full_rmjvm. SQL
Note: This step may cause some bugs. Please use it with caution!
(2) JVM installation script:
-- Start of File full_jvminst. SQL
Spool full_jvminst.log;
Set echo on
Connect/as sysdba
Startup mount
Alter system set "_ system_trig_enabled" = false scope = memory;
Alter database open;
Select obj #, name from obj $
Where type # = 28 or type # = 29 or type # = 30 or namespace = 32;
@? /Javavm/install/initjvm. SQL
Select count (*), object_type from all_objects
Where object_type like '% JAVA %' group by object_type;
@? /Xdk/admin/initxml. SQL
Select count (*), object_type from all_objects
Where object_type like '% JAVA %' group by object_type;
@? /Xdk/admin/xmlja. SQL
Select count (*), object_type from all_objects
Where object_type like '% JAVA %' group by object_type;
@? /Rdbms/admin/catjava. SQL
Select count (*), object_type from all_objects
Where object_type like '% JAVA %' group by object_type;
@? /Rdbms/admin/catexf. SQL
Select count (*), object_type from all_objects
Where object_type like '% JAVA %' group by object_type;
Shutdown immediate
Set echo off
Spool off
(3) Check the status of JVM and some installation packages.
Connect/as sysdba
Spool jvm_stats.log
Set serveroutput on
Set echo on
Set pagesize500
Set linesize 100
Column comp_name format a40
Select comp_name, version, status from dba_registry;
Select owner, status, count (*) from all_objects
Where object_type like '% JAVA %' group by owner, status;
Select owner, object_type, count (*) from all_objects
Where object_type like '% JAVA %' and status <> 'valid' group by owner, object_type;
Select owner, status, object_type, object_name from all_objects
Where object_name like '% DBMS_JAVA % ';
Select owner, status, object_type, object_name from all_objects
Where object_name like '% INITJVMAUX % ';
Select role from dba_roles where role like '% JAVA % ';
Select * from v $ sgastat where POOL = 'java pool 'or NAME = 'free memory ';
Show parameter pool_size
Show parameter target
Show parameter sga
Select owner, object_type, status, dbms_java.longname (object_name) from all_objects
Where object_type like '% JAVA %' and status <> 'valid ';
Spool off
/