OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Need Help

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

Need Help [message #196040]

Tue, 03 October 2006 15:44

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Hi ALl,

Very soon we are going to upgrade our existing production system from 9i Rel 2(Non-RAC) to 10g.
I would like to know what are the options available to upgrade it to 10g Clusters environment with mininum or no downtime and how to go about it.
If some one has already done it please share your experience with me

Thanks in advance.

Report message to a moderator

Re: Need Help [message #196043 is a reply to message #196040]

Tue, 03 October 2006 15:52

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

Senior Member
Account Moderator

You should use the search features available here.
Just a few postings down,
http://www.orafaq.com/forum/t/70309/42800/
The difference is
>>options available to upgrade it to 10g Clusters environment
All information you need is available in 10g upgrade manual.
Do you already have a 10g RAC?

Report message to a moderator

Re: Need Help [message #196046 is a reply to message #196043]

Tue, 03 October 2006 16:10

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Thanks Mahesh for your reply,
Infact i was going thru your other response for similar Q. No I donot have 10g RAC installed. First we have to get the server ready then migrate the database or upgrade. What is the best solution for upgrading to 10g with mininal/nodown time.
We are haveing 270G of production data.
Thanks

Report message to a moderator

Re: Need Help [message #196047 is a reply to message #196046]

Tue, 03 October 2006 16:15

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

Senior Member
Account Moderator

how minimal is 'minimal' for you? Smile

It all depends on your complexity.
As said all information is in documentation.
This could be a path.
First upgrade to 10g single instance in the present node.
Install, configure a 10g RAC with your customizations.
Since both OS are same, just do a file copy (to RAC) and create a
database in single instance mode.
Edit the parameter files and create/mount other instances in other nodes.

Report message to a moderator

Re: Need Help [message #196048 is a reply to message #196047]

Tue, 03 October 2006 16:20

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Sorry i didnot mention that we are currently using Sun Solaris 8 and the new servers would be Solaris 10.
Thanks Again

Report message to a moderator

Re: Need Help [message #196051 is a reply to message #196048]

Tue, 03 October 2006 17:46

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

Senior Member
Account Moderator

Still, it is same OS.
It should work.
Even if it is not, not problem. You can use transportable tablespaces.

Report message to a moderator

Previous Topic:	Method to upgrade a 9i Database to 10g on a very large Database
Next Topic:	ORA-01652 unable to extend temp segment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:18:27 CDT 2024