Home » RDBMS Server » Server Administration » Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) (OEL 4)
Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #413974] Sun, 19 July 2009 23:44 Go to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
Hi,

I want to migrate 9i(32bit) to 10g(64bit).Please describe step by step migration from 9i 32bit to 10g 64bit. I have read many documetns but confusing about wordsize change.
Please guide me step by step.

Regards,
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #413975 is a reply to message #413974] Sun, 19 July 2009 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I want to migrate 9i(32bit) to 10g(64bit).
You have to pick of 1 of 2 choices.
1) 32 to 64 bit first & the upgrade 9i to 10g
2) 9i to 10g (32 bit) & then do 32 to 64 bit
Start & end points are fixed; left then down or down then left.
It is your choice.
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #414002 is a reply to message #413975] Mon, 20 July 2009 01:54 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
Please elobrate both step in detail.
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #414011 is a reply to message #414002] Mon, 20 July 2009 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read the documentation and Metalink notes, this is explained in details.

Regards
Michel

[Updated on: Mon, 20 July 2009 02:18]

Report message to a moderator

Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #414227 is a reply to message #414011] Tue, 21 July 2009 02:05 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
Ok fine.
Please tell after the word size change and remove the _system_trig_enables parameter from parameter file.
Is it mandatery to recreate control file in 64-bit.
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #414381 is a reply to message #414227] Tue, 21 July 2009 23:06 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
One more thing .. How to check the current word size of the database.
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #414386 is a reply to message #414381] Tue, 21 July 2009 23:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from v$version where rownum=1;

If it does not mention 64bit then it is 32bit.

Regards
Michel
Re: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #415099 is a reply to message #413974] Fri, 24 July 2009 14:16 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
I do not know about the 9.2 (32-bit) to 10.2 (64-bit) .. but I have done a 8.1.6 (32-bit) to 8.1.7 (64-bit). Make sure you get the correct binaries (one that says 64-bit).

As Michel mentioned, it should say 64-bit when doing

select * from v$version where rownum=1;

One of the main thing I remember is that after the upgrade is over, usually yourun "utlrp.sql" to make all INVALID objects VALID.

When I did mine, it was strongly noted that I have to do "utlirp.sql" instead of "utlrp.sql". This is pretty much same as "utlrp.sql" except utlrp.sql compiles ALL currently invalid objects. utlirp.sql makes all objects INVALID and then compiles them all. VERY IMPORTANT.

Read the doc.
Previous Topic: log file generation in oracle
Next Topic: Database Growth Report
Goto Forum:
  


Current Time: Sun Dec 11 02:22:34 CST 2016

Total time taken to generate the page: 0.07895 seconds