-
steps to upgrade 10.2.0.3 to on new server 10.2.0.4
Hi,
I am preparing for the upgrade on new server.
I have RH Linux 4.X version and OS is upgrading to RH Linux 5.2. I am planning to install fresh oracle 10.2.0.4 on top.
I have old server with Oracle 10.2.0.3 and want to upgrade to 10.2.0.4..
What steps i need to follow? Please advise and guide!!
Thanks
Pat
-
the upgrade guide would be a good start
-
Hi,
I am going through the guide but being new to this need some general steps to get the data file from old server to new server and how i can do with least amount of hassle.
thanks
Pat
-
Moving from one server to another server is not an upgrade but a migration; two questions.
- how big is the database?
- do you have connectivity in between the two servers?
Last edited by PAVB; 01-28-2010 at 01:03 PM.
Reason: type
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hi,
yes i have connectivity with both server:
But:
Server 1 is on RH Linux 4.X and oracle 10.2.0.3
Server 2 will be on RH Linuk 5.2 64 Bits and Oracle 10.2.0.4 64 bits.
Thanks
Pat
Last edited by midora; 01-28-2010 at 03:11 PM.
-
The database is about 20 G on old server.
Thanks
Pat
-
Here is what I would do...
1- Ask systems to lay out file systems on NEW server exactly as they are on OLD one.
2- Install 10.2.0.4 on NEW server
3- Create database on NEW server
4- Export full=y on OLD server
5- FTP dump file from OLD to NEW server
6- Import full=y on NEW server
7- Check constraints, etc are created - recompile invalid objects
8- Gather fresh stats
9- Setup backup strategy on NEW server
10- Done.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|