Applies to:
Oracle Multimedia - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.
Symptoms
Creating a database with template in Oracle Database 11g Release 2 results in errors similar to the below at the step adding Oracle Multimedia:ORA-00604, error occured at recursive SQL Level 1
ORA-04031, unable to allocate 4096 bytes of shared memory("java pool","unknown object",JOXLE^51ea80a3,"SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 655
ORA-06512" at line 1
Cause
Oracle Multimedia uses the JavaVirtual Machine in the database.If the Java pool size is not big enough during installation of Oracle JVM, ORA-04031 errors pointing to the Java Pool will be seen when loading the Java related components of Oracle Multimedia.
Solution
Modify the database template to make sure, you have enough memory in the Java Pool available during database creation.
See Note:396940.1 Troubleshooting and Diagnosing ORA-4031 Error