OraFAQ Forum: Server Administration » Database Upgradation from Oracle 9i R1 to 10g R2

Home » RDBMS Server » Server Administration » Database Upgradation from Oracle 9i R1 to 10g R2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Upgradation from Oracle 9i R1 to 10g R2 [message #175150]

Thu, 01 June 2006 01:32

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

i am going to upgrade 9i R1 DB to 10G R2 DB.
Is it good to use the Database Upgrade Assistant (DBUA).

If DBUA is not good can any can give me the steps to upgrade.
I'm in a difficult situation.

please help.

Regards
SALIH KM

Report message to a moderator

Re: Database Upgradation from Oracle 9i R1 to 10g R2 [message #175177 is a reply to message #175150]

Thu, 01 June 2006 03:36

orausern
Messages: 826
Registered: December 2005

Senior Member

You have an authentic resource for all the details- refer to oracle's upgrade guide:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

Also once you have gone through it, try that upgrade process in a test database and check if things go fine and then go for the actual upgrade.-It can help you avoid surprises by trying out on test database first.

also i read a few places that for some application, performance may actuallly reduce after the upgrade..so benchmark the performance -how it is in existing 9i and compare with that after upgrade.

Report message to a moderator

Re: Database Upgradation from Oracle 9i R1 to 10g R2 [message #175231 is a reply to message #175177]

Thu, 01 June 2006 06:39

kmsalih
Messages: 197
Registered: March 2006

Senior Member

hi

thanks for your reply.

Is it good to use DBUA?

Thanks & Regards
SALIH

Report message to a moderator

Re: Database Upgradation from Oracle 9i R1 to 10g R2 [message #175234 is a reply to message #175231]

Thu, 01 June 2006 06:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Why would DBUA be not a good product?
It is the Oracle's native tool.
In some cases, you can even just export and import. But, using DBUA is the proper path.
The best resource is ofcourse the documentation as pointed earlier.

Report message to a moderator

Re: Database Upgradation from Oracle 9i R1 to 10g R2 [message #175244 is a reply to message #175234]

Thu, 01 June 2006 06:57

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Thanks niravshah and Mahesh

Report message to a moderator

Previous Topic:	Database slow down
Next Topic:	Operating system authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:34:27 CDT 2024