RE: Upgrade question

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Fri, 1 Sep 2000 16:49:01 -0700
Message-Id: <10606.116110@fatcity.com>

Koivu,

I did use the same script to upgrade from 8.1.5 to 8.1.6 (Manual Upgrade method), There are some post upgrade steps that needs to be done. I used: JVMU815.sql ($O_H/javavm/install directory). . Then you need to Install ODCI.jar and CartridgeServices.jar using the following commands:

loadjava -user sys/pw -resolve -synonym -grant public -verbose
$O_H/rdbms/jlib/ODCI.jar

loadjava -user sys/pw -resolve -synonym -grant public -verbose
$O_H/rdbms/jlib/CartridgeServices.jar

Then test the # of objects using select count(*) from all_objects where object_type like '%JAVA%'; It should return more than 4000 objects I believe.

My environment is HP-UX 11.0(64bit) and Oracle8.1.6(64bit).

Goodluck,
-- Janardhana Babu

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Thursday, August 31, 2000 3:19 PM
To: Multiple recipients of list ORACLE-L Subject: Upgrade question

Hi all -

I am working through an 8.1.5->8.1.6 upgrade. My first upgrade went fine because no one tested it (though I did ask, and assumed no news was good news.... grrrrrr) Now that we upgraded a database that someone actually wanted to use, I find that all the java classes, system and user, were dropped (rmjvm.sql) in the upgrade. I was looking through the scripts that u0801050.sql calls and found the call to rmjvm.sql.

My questions are this:

How many of you have actually edited these scripts? I do not want to touch it, but dropping all user classes isn't exactly desirable. Maybe it's necessary, I don't know, hence the reason why I don't want to touch it.
Has anyone used the migrate utility for this?

Thanks

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174 
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com <http://www.qode.com>

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." Received on Fri Sep 01 2000 - 18:49:01 CDT