Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle Patch screwed up Java Sources and classes

Posted on 2006-07-15
8
1,362 Views
Last Modified: 2012-06-21
Hi there,

I've got Oracle 10g on Win 2k3.  Last weekend I patched Oracle from version 10.2.0.1 to 10.2.0.2 and since then all my java classes have become unusable. The sources are not listed at all in the web based enterprise manager console (although they are listed in the java enterprise manager tool) and although the classes are listed as valid they are not working.

Running one through SQL Plus using the following commands gives:

connect user/pass@db
execute spname();
/

Connected.

PL/SQL procedure successfully completed.

SP2-0103: Nothing in SQL buffer to run.

I can't delete the java classes in the java enterprise manager becasue I get: VBO - 4569: The java object cannot be dropped. ORA - 29537: class or resource cannot be created or dropped directly.

Trying in the web based tool gives: ORA-29537: class or resource cannot be created or dropped directly

Recompiling gives: oracle.sysman.emSDK.admObj.AdminObjectException: No more data to read from socket

and I have to log back in or else nothing else works.
0
Comment
Question by:djguvnor
8 Comments
 
LVL 19

Expert Comment

by:actonwang
ID: 17114123
issue:

set serveroutput on
exec spname();


to see if it gives what you want.
0
 
LVL 1

Author Comment

by:djguvnor
ID: 17114300
That gives the same as before:

Connected.

PL/SQL procedure successfully completed.

SP2-0103: Nothing in SQL buffer to run

There's not supposed to be any output on screen, the program is supposed to create a file but it's not doing anything.
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 17114687
Run the $ORACLE_HOME/javavm/install/initjvm.sql script AS SYSDBA
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:djguvnor
ID: 17115487
That completed as follows but I'm still getting the same errors.



SQL> @c:/oracle/product/10.2.0/db_1/javavm/install/initjvm.sql

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Package created.


Package body created.

No errors.

Call completed.


Call completed.


Call completed.


Table created.


Table created.


Table created.


Index created.


Index created.


Index created.


Package created.


Package body created.


Package created.


Package body created.


Call completed.

.
###
### Aborting because initjvm.sql has already been run
###
.
declare foo exception;
*
ERROR at line 1:
ORA-29539: Java system classes already installed
ORA-06512: at line 10


Disconnected from Oracle Database 10g Release 10.2.0.2.0 - Production
0
 
LVL 1

Author Comment

by:djguvnor
ID: 17117928
I was suspicious that this error may have been something to do with the connection method I was using in the java class so I tried to create a helloworld java class as follows:

connect sys/pword@db as sysdba
CREATE  
    AND COMPILE   JAVA SOURCE NAMED "DB"."JAVAHELLOWORLD"  AS
    class HelloWorld
{
  public static void main (String args[])
  {
    System.out.println("Hello World");
  }
};
/

and I get the following:

Connected.
CREATE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
0
 
LVL 1

Author Comment

by:djguvnor
ID: 17167147
Thanks for your attempts at help.  It turns out I should have checked the patch log file more closely.  On each instance the catupgrd.sql script had failed to call the other related scripts because the oracle_home in my registry points to the client directory.  The fix was to do: set oracle_home=c:/oracle/blah blah from the command prompt before running SQL+ which overides the oracle home in the registry.

The moral of the story:  Always check the logs!
0
 
LVL 1

Accepted Solution

by:
GhostMod earned 0 total points
ID: 17205963
Closed, 200 points refunded.

GhostMod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query question 8 91
How to Comment Out Lines of Code in a Pass Through Query In MS Access 2016 19 64
Oracle DB monitor SW 21 60
Fill Date time Field 12 23
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question