Skip to Content
author's profile photo Former Member
Former Member

Oracle Upgrade 8.1.7.4 to 10g in Red hat linux

Dear All,

We are planning to upgrade our oracle database from 8i to 10g along with the Redhat linux upgrade from 2.4.9-e 27 ent to Red Hat Linux 5. In my study and also from Installation guides and oracle upgrade guides I made sure that its possible to upgrade our database from 8.1.7.4.

So I have planned the below options to do the same and not sure about the possibilities. If anyone have thoughts and idea on the same please suggest me.

We dont have plan to migrate the development hardware and the sap version is 4.7E

Option 1: Upgrade the Linux to 5 and then upgrading the database to 10g usign upgrade assistant tool

Option 2: Export the database using sapinst tool and then crashing the server. Installing linux5 and importing the database using sapinst tool.(I am aware this is not a good idea since there is no migration in hardware but it will be helpful in production since we are migrating the production system).

Option 3: Performing DBUA assistant in development and sapinst method in production.(helpful in disaster recovery)

Could you please suggest on the same?

My query is that.

If i am performing oracle export from 8.1.7.4 and if i am import the same in oracle 10g using the sapinst tool. Will this work? or it will create a problem in table level. I am looking for answers for this Question. Kindly explain me on this.

Regards

Vijay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 08, 2009 at 01:22 PM

    yes, this will work. SAPINST will export in a non-DB dependant format, so, you can import in any other database make or version as you want.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.