Reprinted with Permission by RevealNet, Inc.  July  2001

Upgrading Oracle 8.1.5 to 8.1.7

 

Topic:

Oracle Upgrade from 8.1.5 to 8.1.7 (1 of 5), Read 66 times

Conf:

FAQ Area

From:

Anonymous  

Date:

Thursday, June 07, 2001 05:28 PM

Hello,

We have Oracle 8.1.5.1 running on SUN Solaris 2.6 and we have to upgrade to 8.1.7. I have downloaded the Upgrade manual from Metalink and am struggling through it to come up with a list of steps to follow to complete the upgrade. I don't have a lot of time to prepare this. So I would really appreciate it if someone, who has already gone through this situation, please post a thorough, step by step procedure to successfully complete the upgrade process. Thanks much in advance.

Topic:

Oracle Upgrade from 8.1.5 to 8.1.7 (2 of 5), Read 50 times, 1 File Attachment

Conf:

FAQ Area

From:

John Eliou jeliou@msa.com

Date:

Friday, June 08, 2001 06:51 AM

I wrote the attached procedure to upgrade a database from 805 to 816 but it should work for 815 to 817. Just substitute 816 for 805 & 817 for 816.

John

UPGRADING DATABASE(1).DOC (22KB)

Topic:

Oracle Upgrade from 8.1.5 to 8.1.7 (3 of 5), Read 35 times

Conf:

FAQ Area

From:

Zhuang Li

Date:

Thursday, June 21, 2001 06:25 AM

Is it OK to use the utility "odma" to upgrade from 8.1.5 to 8.1.7?

Zhuang

On 6/8/01 6:51:00 AM, John Eliou wrote:
>I wrote the attached procedure
>to upgrade a database from 805
>to 816 but it should work for
>815 to 817. Just substitute
>816 for 805 & 817 for 816.
>
>John

Topic:

Oracle Upgrade from 8.1.5 to 8.1.7 (4 of 5), Read 30 times

Conf:

FAQ Area

From:

John Eliou jeliou@msa.com

Date:

Thursday, June 21, 2001 08:47 AM

I guess you could but the Migration Assistant is usually used to "migrate" from one release (7.x) to another (8.x). I believe going from 8.1.5 to 8.1.7 is considered an "upgrade". I've had some pretty bad experiences with the Migration Assistant so I try not to use it if at all possible.

John

Topic:

Oracle Upgrade from 8.1.5 to 8.1.7 (5 of 5), Read 31 times

Conf:

FAQ Area

From:

Brian Peasland oracle_dba@qwest.net

Date:

Thursday, June 21, 2001 08:56 AM

>Is it OK to use the utility
>"odma" to upgrade from 8.1.5
>to 8.1.7?

Yes, you can use the ODMA utility to perform your upgrade. But personally, I'd use the $ORACLE_HOME/rdbms/admin/u0801050.sql script in the new Oracle Home. (I hate wizards!!!!)

HTH,
Brian

===================================
Brian Peasland
Database Administrator
OCP DBA (7,8,8i)