Q

Moving an 8i/Solaris database to a 10g/Linux box

I have an existing Oracle 8i database on a Solaris 2.8 box that I MUST get to a Linux (Suse 9.3) Oracle 10g box. How can I get this database to the new machine without reinventing the wheel?

I have an existing Oracle 8i database on a Solaris 2.8 box that I MUST get to a Linux (Suse 9.3) Oracle 10g box. How can I get this database to the new machine without reinventing the wheel?
Because you are essentially upgrading your database and moving to a different platform all at once, I would recommend creating a new Oracle 10g database on your Linux server, exporting your 8i database and then importing it into the 10g database. This accomplishes two things at once: your database upgrade as well as the cross-platform move of your database.

If your database is too large to use the export/import method, you could try another approach, which would be to upgrade your 8i database (assuming it's 8.1.7.4) directly to Oracle 10g on the Solaris server, then use the new 10g cross-platform transportable tablespaces feature to move your database across to the Linux server. Both Solaris and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported...

platforms) but they are of different endianness. Solaris is big endian while Linux is little endian, so there is an additional step involved to convert the tablespaces being transported on either the source or target side.

To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network. The guide can be found here.

This was first published in October 2005
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close