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

Want to upgrade in Oracle database from 9i to 10g

Hello Gurus

I want to update my oracle database from 9i to 10g

can any body help me to guide me the process

server details

Oracle 9i - 9.2.0.4.0

Windows Server 2003

SAP Version - 640

Thanks & Regards

Shishir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 06:50 AM

    HI,

    check

    service.sap.com/instguides -> Installation & Upgrade Guides -> Other Documentation -> Database Upgrades -> Oracle

    or

    https://websmp101.sap-ag.de/~sapdownload/011000358700003520252006E/WIN_ORA_UPG_GUIDE_vers40.pdf

    regards,

    kaushal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 07:22 AM

    Hello Kaushal

    Many thanks for your early reply

    Can you tell me step by step process If you have done Oracle upgradation orelse can you guide me is there any recommendation before upgrade i.e. kernel level, support packs etc etc

    waiting for your answer

    Thanks & Regards

    Shishir

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 08:26 AM

    You read the above mentioned guide and the notes mentioned in it, also you may find some use information in the Related Notes as well.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 10:48 AM

    Hi Shashi,

    you need to do following steps

    Oracle Database Upgrade

    Installing the Oracle Database Software

    Installing the Oracle 10g Server Software

    Installing the Oracle 10g Client Software

    Copying and Adapting the SQL*Net Files

    Saving Archive Log Files

    Changing the Environment for User <dbsid>adm

    Performing the Database Upgrade

    Post-Upgrade Steps

    Creating the Oracle TNSListener Service

    Changing Environment Variables

    Setting Up a Shared Database-Directory in Oracle Home

    Changing the Registry Value of Oracle Autostart

    Starting the Oracle Services

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 06:00 AM

    Thanks

    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.