Oracle-L: RE: 8.1.7 to 8.1.7.4 database migration

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Fri, 17 Oct 2003 11:09:30 -0800
Message-ID: <F001.005D3809.20031017110930@fatcity.com>

Thanks for all the help. I was under a bit of time pressure and it was a small database, so a just created a new database on the 8.1.7.4 (AIX 5.2) system and imported my tables.

Something was seriously wrong with the upgrade script, because the java migration step ran all night and still had not finished.

Peter Schauss

-----Original Message-----

Sent: Thursday, October 16, 2003 4:44 PM To: Multiple recipients of list ORACLE-L

It may take a while to run (1/2 hour), how long has it been running?

There are some issues with reloading java on an upgrade. I just went through
the same thing, but on AIX 4.3.3. I don't have the metalink note in front of
me, I will be able to pass it on tomrrow. Some things from memory are:

You had to run rmjvm.sql and then initjvm.sql from $ORACLE_HOME/javavm/install. Make sure that you back up any java objects that you put in the DB first as rmjvm.sql does what the name implies.
The initjvm.sql script appears to hang right around the spot were it mentions something about javadebug, my guess is it is reloading java objects, it was over 6k in our case, should take around 15 minutes to 1/2 hour.
java_shared_pool had to be 100000000 or greater.

I will send you the metalink note tomorrow if it isn't too late.

HTH,
Mike

                      "Schauss, Peter"

                      <peter.schauss_at_ng        To:       Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>               
                      c.com>                   cc:

                      Sent by:                 Subject:  8.1.7 to 8.1.7.4
database migration - step 10 hangs                       
                      ml-errors_at_fatcity

                      .com

 

 

                      10/16/2003 04:14

                      PM

                      Please respond to

                      ORACLE-L

Environment:

AIX 5.2
Oracle 8.1.7.4

I copied a database from an 8.1.7.0 environment and am going through the procedure to migrate it to 8.1.7.4. My Oracle home has already been patched.

When I get to step 10 in the procedure where it says:

SQL> create or replace java system
/

sqlplus hangs.

Has anyone else had this problem?

Is there a workaround?

Thanks,

Peter Schauss
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Schauss, Peter
INET: peter.schauss_at_ngc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Michael Boligan
INET: michael.boligan.b_at_bayer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Schauss, Peter
INET: peter.schauss_at_ngc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs