Q
Problem solve Get help with specific problems with your technologies, process and projects.

Java not working after installation of patch 9.2.0.7

I installed patch 9.2.0.7 and Java is not working anymore.

I installed patch 9.2.0.7 and Java is not working anymore. When running script catpatch.sql on post-installation steps, I got this error:
BEGIN dbms_java.set_output(10000); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7: 
PLS-00201: identifier 'DBMS_JAVA.SET_OUTPUT' must be declared
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 

BEGIN dbms_java.loadjava('-force -synonym -schema 
ORDSYS -resolve -grant PUBLIC ord/jlib/ordimsvr.jar'); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7: 
PLS-00201: identifier 'DBMS_JAVA.LOADJAVA' must be declared
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored
Also errors about missing oracle/aurora/jvm/OracleRuntime. Can you give me any advice?

My first question would be whether catpatch.sql had been run as the SYS user. The script must be run as SYS. Another...

possibility is that the JAVA_POOL_SIZE is not sized sufficiently, or that not enough physical resources have been allocated to the database for this upgrade to complete successfully.

There are reported problems with the JVM and running the January 2006 CPU catcpu.sql script, but I have not encountered the problem you describe above while applying the 9.2.0.7 patchset.

You could try reloading the JVM to see if that clears up the problem (take a database backup first!). There is a document on Oracle's Metalink Web site (Doc ID: 209870.1) which details how to do this. Note that this is a highly destructive procedure and should not be undertaken without some expertise. Prior to doing this, I would contact Oracle support about your problem and open an iTAR.

This was last published in July 2006

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close