OraFAQ Forum: Server Administration » Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit)

Home » RDBMS Server » Server Administration » Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) (OEL 4)

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

Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit) [message #413974]

Sun, 19 July 2009 23:44

smunir362
Messages: 310
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,

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

smunir362
Messages: 310
Registered: September 2007

Senior Member

Please elobrate both step in detail.

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

smunir362
Messages: 310
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.

Report message to a moderator

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

smunir362
Messages: 310
Registered: September 2007

Senior Member

One more thing .. How to check the current word size of the database.

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	log file generation in oracle
Next Topic:	Database Growth Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:29:29 CDT 2024