Upgrade Oracle 9i to 10g

5 pts.
Tags:
Oracle 10g
Oracle 9i
Oracle upgrades
Solaris
Hi All, Software:- Oracle 9i,Oracle 10g OS - Solaris 9. We have 5 databases in our development environment. All the databases(9i) are running on Solaris 9 OS. I have given responsibility to install oracle 10g on Solaris box(development environment). Once the 10g gets install then upgrade one of the database running on the 9i to 10g. i.e. migrate all the database objects, and others stuff. I am Oracle Developer and have never involved in Administration role. I have referred few document over the net to get head-up. 1. Oracle 10g Install guide on Solaris 2. Oracle Database Upgrade Oracle 10g. After reading the document I feel I still don't have enough information on some of issue which I think it may arise. 1. approach for installing 10g 2. How to mitigation data from 9i to 10g 3. What issues does arises during installation/post installation and so on. 4. Any risk? 5. Back out strategy I would like to know 1. Install guide for Oracle on Solaris box. What precaution to take care if there is old version of database running? 2. Regarding backup and transferring data to 10g Should I just copy the data file and other files to some directory and once 10g is install copy them to 10g respective folder? 3. How would I point the old instance running on 9i database to 10g. 4. Any changes required in .profile, environment file 5. How do I make sure the upgrade of database should not affect other instance?. 6. Any link which give me further head-ups on the current project Many thanks 7. What strategy should I use to proceed further? Any suggestion are most welcome.

Software/Hardware used:
oracle 10g,solaris

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I'm not a DBA either, but I think the Official upgrade guide should answer many of your questions.
    69,590 pointsBadges:
    report
  • Rahsb
    i want to conver 6i to 10g
    10 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following