-
Migration to 64 bit
We have a new 64 bit server.
We want to move a test database
from:
Oracle 10.1.0.4.0 32 bit running on RHEL4
to:
Oracle 10.2.0.3 64 bit on Oracle entreprise Linux.
Question:
Anyone has Oracle entreprise Linux?
Anyone has opinion on Oracle entreprise Linux vs RHEL4?
Is there issue i need to be careful with or script i need to run to go from a 32bit database to a 64bit database?
Plan:
Install oracle "10.2.0.1" 64 bit on the new machine.
Patch the new machine to 10.2.0.3.
Copy the old database onto the new server.
Run the migration assistant.
Will the migration assistant do something special since the old database was 32bit?
-
Originally Posted by steeve123
Anyone has Oracle entreprise Linux?
Anyone has opinion on Oracle entreprise Linux vs RHEL4?
My opinion is why have two different versions of Linux in your enterprise? I'm going to run my webservers on RHEL4 and my DB on OEL that I know will be a version behind? No thanks.
Is there issue i need to be careful with or script i need to run to go from a 32bit database to a 64bit database?
Plan:
Install oracle "10.2.0.1" 64 bit on the new machine.
Patch the new machine to 10.2.0.3.
Copy the old database onto the new server.
Run the migration assistant.
You can do it that way.
Will the migration assistant do something special since the old database was 32bit?
Special, not really. The only thing that you have to do is rerun your catalog and recompile all your packages. The migration assistant basically takes care of this for you.
Jeff Hunter
-
there s a script (utlirp.sql) which changes wordsize from 32 bit to 64 bit, in 8i you had to run that mnaully but I think on 10g it's automatic
-
as a note, utlirp.sql invalidates your packages and recompiles everything. You still need to run catalog.sql and catproc.sql as some of the data dictionary structures change (like in v$session).
Jeff Hunter
-
Will i have problem with the dbua?
Since the source database is 10.1.0.4.0.
and the new server has 10.2.0.3?
My plan:
install 10.2.0.1 on new machine
patch to 10.2.0.3
copy database
run dbua
Ive been told to to the following in case problems arise with the dbua:
install 10.1.0.4.0 on new machine.
copy the database
install patch 10.2.0.3
run dbua.
The second path means il have 2 oracle home: not cool
-
yup, you got to have both $OH for dbua to work. How about install 10.2.0.3 on your old box and do the upgrade there and then move it?
Jeff Hunter
-
i was not able to run dbua indeed.
I ran catupgrd.sql instead and it went well.
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
|