إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

How To Upgrade Database From 9i To 10g


2 رد (ردود) على هذا الموضوع

#1 mohamed22

mohamed22

    عضو

  • الأعضــاء
  • 1 مشاركة

تاريخ المشاركة 03 December 2008 - 01:47 PM

ياريت يجماعة حد يفيدني في هذا الموضوع علي وجة السرعة

عايز اعمل
upgarde database from 9i to 10g


ياريت يجماعة

#2 airtifa

airtifa

    عضو نشط

  • الأعضــاء
  • 379 مشاركة

تاريخ المشاركة 04 December 2008 - 12:49 AM

1-you must upgrade your oracle 9i database to patchset 8 (9.2.8)
2-install oracle 10g release 2 software
3-run database upgrade assistant from Oracle 10g R2 and choose the Oracle 9i (9.2.8) home to upgrade
4-follow steps in the database upgrade assistant
5-it will now be upgraded to Oracle 10g R2
6-compile any invalid objects inside your database.
7-now you can delete your oracle 9i software as it is not needed


Airtifa Senior Oracle DBA

#3 ahmed_vb2001

ahmed_vb2001

    مشترك

  • الأعضــاء
  • 90 مشاركة

تاريخ المشاركة 14 December 2008 - 12:37 AM

applying patchset 9208 is not a must
rdbms have to be atleast 9204

http://download.orac...up.htm#i1007814
Table 2-1 Upgrade Paths

http://download.orac...38/upgrade.htm#
This chapter guides you through the process of upgrading a database to the new Oracle Database 10g release.

>always check/do the following before applying major changes to database

make sure no invalid objects before upgrade
make sure all components in dba_registry with status "valid" only
have a full backup of the database before upgrade