RE:8.0.5 to 8i upgrade

[GANTI . SIVA]

Hi man,

during migration you just follow these steps.I didn't read any document.The
migration typically takes 2-3 hours on each database (You have to upgrade your
replication also if it is there).It depends on your machine RAM etc ofcourse

1) run u0800050.sql in $ORACLE_HOME/rdbms/admin directory

2) Run catrep.sql to install new replication objects

3)Run r0800050.sql  on top of catrep.This'll update any replication objects

Revalidate all objects using utlrp.sql

don't forget to read these scripts before mig.. Take backup of existing
databases

Enjoy man

Cheers
Ganti



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.0.5 to 8i upgrade

[Kimberly Smith]

I did an 8.0.something(4 or 5) upgrade to 8.1.6.  First I had to 
reinstall the OS (well actually the sys. admin. dudes did 
that) from 10.20 to 11.  They reinstalled instead of upgrade
because it went from 32-bit to 64-bit.  Then we put the logical
mounts for the database back in and did the upgrade.  That
really did not take long.  Make sure you increase the size
of the system tablespace first as 8i needs a bigger one.
Also, I am not sure which option puts in the u805.sql script
in but I did not have it in there and I had to call 
Oracle and get them all shipped to me.  Make sure you have
it there first.  I have a feeling its the migration portion
although that is not the case with 8.0.6.

-Original Message-
Sent: Wednesday, March 07, 2001 6:06 AM
To: Multiple recipients of list ORACLE-L



We want to do an 8.0.5 to 8i upgrade (HPUX).  There are six databases
on the system where the upgrade is required.  How long does the
upgrade typically take?  What kind of downtime should be expected?
 Are there any major "gotchas" of doing the 8.0.5 to 8i upgrade?

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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