Home » RDBMS Server » Server Administration » Need Help
Need Help [message #196040] Tue, 03 October 2006 15:44 Go to next message
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.

Re: Need Help [message #196043 is a reply to message #196040] Tue, 03 October 2006 15:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: Need Help [message #196046 is a reply to message #196043] Tue, 03 October 2006 16:10 Go to previous messageGo to next message
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

Re: Need Help [message #196047 is a reply to message #196046] Tue, 03 October 2006 16:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: Need Help [message #196048 is a reply to message #196047] Tue, 03 October 2006 16:20 Go to previous messageGo to next message
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

Re: Need Help [message #196051 is a reply to message #196048] Tue, 03 October 2006 17:46 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
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:
  


Current Time: Fri Dec 02 20:43:26 CST 2016

Total time taken to generate the page: 0.05847 seconds