This content has been marked as final. Show 8 replies
Andes wrote:Depends on how big your database you can use Exp Imp to upgrade and change the bit version at the same time. I would suggest go to 11.2 version rather go to 10.2
Could you tell me how to upgrade/migrate Oracle 10.1.x 32bit into Oracle 10.2.x 64bit ? or share document related with my question, really appreciate.
or are below steps correct ?
I have 2 servers Linux, source is 32bit and target is 64bit.
1) on 32bit server, clone 10.1.x into new oracle 10.2.x 32bit home then do upgrade
2) clone oracle 10.2 32bit into Oracle 10.2.x 64bit(server 64bit) then,
- do startup upgrade then,
- run utlirp.sql
is there any steps that i missed ?
Thanks for the response.
My database size is about 500gb. what methods that you recommend most ? as this is from 32bit machine migrate to 64bit machine then the database version also different, 10.1 to 10.2 ?
we will upgrade into 11.2 in next project, as right now we'd like to see the impact from application side..
could you share me 'how to step' or is there any documentation related my queries.
Edited by: Andes on Aug 30, 2012 1:25 AM
I suggest you to broke the task into two:
1) Change WordSize from 32-bit to 64bit on 10.1.
2) After successful oonversion Upgrade database to 10.2.
There is no significant impact of Database Size during wordsize change, because only Data Dictionary objects has been recreated.
Pl see if this MOS Doc can help
Can you / How to Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA) [ID 757245.1]
The process to upgrade a database using export/import is documented
Thanks for the input.
but, how about using transportable tablespace, what i heard this step is less easy, isn't it ?
I'm interested to use tts method. can i have links or doc that discuss about transportable tablespace. Thanks
Pl see this MOS Doc
Upgrading a Database Using Transportable Tablespaces (TTS) [ID 1457743.1]
I would say that exp/imp on a 500GB would take a few (long hours).
so that may be not such a great idea.
But don't forget:
- testing, testing, testing :)
@Srini, Thanks for Doc ID
@Pinela, so what is your sugestion, please if you okay share with doc or if don't mind step by step, Thanks.