RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs
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: 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 1 or greater. I will send you the metalink note tomorrow if it isn't too late. HTH, Mike Schauss, Peter [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: 8.1.7 to 8.1.7.4 database migration - step 10 hangs [EMAIL PROTECTED] .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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
8.1.7 to 8.1.7.4 database migration - step 10 hangs
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs
SQLPlus probably doesn't hangit take a long time to create or replace JAVA on some systems. -Original Message- Sent: Thursday, October 16, 2003 3:14 PM To: Multiple recipients of list 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Odland, Brad INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 1 or greater. I will send you the metalink note tomorrow if it isn't too late. HTH, Mike Schauss, Peter [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: 8.1.7 to 8.1.7.4 database migration - step 10 hangs [EMAIL PROTECTED] .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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs
Peter, First, are you sure it is hanging? It does take quite awhile to finish. Secondly, did you up the Jave_Shared_Pool param to a decent value (I think the migration doc says 4Meg, but increase it to 8 and try it again). and finally, if you are not using Java in the database, it really is not needed. But it would be nice to follow the instructions and have everything work. good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 16, 2003 4:14 PM To: Multiple recipients of list 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
