Upgrade from 7.x to 9i release 2

[Meissner, Christian]

Hi specialists,

I have here a customer, witch runs oracle 7.x on novell.
My tasks are now to upgrade from 7.x to 9ir2 and migrate to RedHat AS.

How i can run this tasks smothly and efficient for me and my customer.

Is there any tool from oracle?

thx Christian

[James Williams]

On Tue, 28 Oct 2003 10:35:42 +0100, "Meissner, Christian"
<meissnerERASECAPITALLETTERS@lampcoders.net> wrote:


IIRC, Oracle doesn't support Novell as an OS anymore. I doubt that
DBUA (database upgrade assistant) is available for this move.

Recommendations:

go to otn.oracle.com and download the Install and Migration Guides
for review.

Create a New database on the 9.2 machine. Then export the Novell
database and import a new database. Since its on Novell I would
imagine its probably not too large.
Hi specialists,I have here a customer, witch runs oracle 7.x on novell.My tasks are now to upgrade from 7.x to 9ir2 and migrate to RedHat AS.How i can run this tasks smothly and efficient for me and my customer.Is there any tool from oracle?thx Christian

[Brian Peasland]

Since you are changing OS platforms, your only course of upgrading is to
use the Export/Import method. Create a dump of your 7.x database with
exp. Then transfer the dump file to the Linux platform and use imp to
import the contents into a prebuilt database. This is fully documented
in the Oracle 9i Migration Guide.

HTH,
Brian

"Meissner, Christian" wrote: Hi specialists, I have here a customer, witch runs oracle 7.x on novell. My tasks are now to upgrade from 7.x to 9ir2 and migrate to RedHat AS. How i can run this tasks smothly and efficient for me and my customer. Is there any tool from oracle? thx Christian

--
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

[mommy dba]

I would also be sure to set the compatibility in the init.ora file prior
to importing the data in.

Brian Peasland wrote:
Since you are changing OS platforms, your only course of upgrading is to use the Export/Import method. Create a dump of your 7.x database with exp. Then transfer the dump file to the Linux platform and use imp to import the contents into a prebuilt database. This is fully documented in the Oracle 9i Migration Guide. HTH, Brian "Meissner, Christian" wrote:Hi specialists,I have here a customer, witch runs oracle 7.x on novell.My tasks are now to upgrade from 7.x to 9ir2 and migrate to RedHat AS.How i can run this tasks smothly and efficient for me and my customer.Is there any tool from oracle?thx Christian

[Van Messner]

You will need to search for Novell information before starting your upgrade.
If memory serves, you had to be at 7.3.4 in Novell before you could do an
upgrade, but you should check that. Unless you're already at 7.3.4.
If you can't get the old docs on this you might have to check with Oracle
support. Take the approach that you're a 9i2 customer who needs help
getting this old data into your new 9i database.

Van



"mommy dba" <mommydba@netscape.com> wrote in message
news:vpthv8fesorq7c@corp.supernews.com... I would also be sure to set the compatibility in the init.ora file prior to importing the data in. Brian Peasland wrote: Since you are changing OS platforms, your only course of upgrading is to use the Export/Import method. Create a dump of your 7.x database with exp. Then transfer the dump file to the Linux platform and use imp to import the contents into a prebuilt database. This is fully documented in the Oracle 9i Migration Guide. HTH, Brian "Meissner, Christian" wrote:Hi specialists,I have here a customer, witch runs oracle 7.x on novell.My tasks are now to upgrade from 7.x to 9ir2 and migrate to RedHat AS.How i can run this tasks smothly and efficient for me and my customer.Is there any tool from oracle?thx Christian

[Brian Peasland]

> You will need to search for Novell information before starting your upgrade. If memory serves, you had to be at 7.3.4 in Novell before you could do an upgrade, but you should check that. Unless you're already at 7.3.4. If you can't get the old docs on this you might have to check with Oracle support. Take the approach that you're a 9i2 customer who needs help getting this old data into your new 9i database.

You won't be able to get 9i running on Novell. The Novell platform was
desupported long before 9i was available. IIRC, 8i isn't even available
on Novell, but I am fuzzy on that....

The OP mentioned moving to RedHat. So he'll have to install 9i on the
RedHat platform. Since the OP will be changing platforms, only two
methods will really work. Either export/import or copy the data over
through a db link. Since 9i has difficulties talking to Oracle 7
databases, that pretty much leaves export/import as the only real
method. I suppose one could dump the data to a comma delimited file and
use SQL*Loader, but that sounds like more trouble than it's worth. You
do not need to be at 7.3.4 to use the export/import method of upgrading.
The only reason to be at 7.3.4 would be if you were upgrading the
database on the same server to 9i by using the mig utility (maybe
through the DBUA). But since you can't run 9i on Novell, the 7.3.4
requirement is not necessary.

HTH,
Brian

--
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

[Daniel Morgan]

Van Messner wrote:
You will need to search for Novell information before starting your upgrade.If memory serves, you had to be at 7.3.4 in Novell before you could do anupgrade, but you should check that. Unless you're already at 7.3.4.If you can't get the old docs on this you might have to check with Oraclesupport. Take the approach that you're a 9i2 customer who needs helpgetting this old data into your new 9i database.Van
The OP said nothing about upgrading on Novell. He just wants to move his
objects and data
from 7.3.4 on Novell to 9i on Linux. There is not need to upgrade anything.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Glen A Stromquist]

Daniel Morgan wrote:
Van Messner wrote: You will need to search for Novell information before starting your upgrade. If memory serves, you had to be at 7.3.4 in Novell before you could do an upgrade, but you should check that. Unless you're already at 7.3.4. If you can't get the old docs on this you might have to check with Oracle support. Take the approach that you're a 9i2 customer who needs help getting this old data into your new 9i database. Van The OP said nothing about upgrading on Novell. He just wants to move his objects and data from 7.3.4 on Novell to 9i on Linux. There is not need to upgrade anything.
I just moved data from 7.2.3 on AIX and 7.3.3 on NT4 to SuSE running
9ir2 with export & import, no problems here...