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 100000000 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).
