Re: 8.1.7 to 8.1.7.4 database migration - step 10 hangs

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:

1. 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.
2. 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.
3. 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
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: 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).