Home » RDBMS Server » Server Administration » upgrading 32 bit 10g to 64bit
icon13.gif  upgrading 32 bit 10g to 64bit [message #204437] Mon, 20 November 2006 14:12 Go to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
I want to move database to new server. Took cold backup
from old server, moved files to new . Old database version is 10.1.0.4.0 (32 bit)and new one is 10.2.0.1.0. (64 bit) .Opened database on new server with startup upgrade option. Listener shows restricted session. Can connect only as sysdba.
When tried to complete upgrade by running catalog.sql script , it gives
error ORA-03114: not connected to ORACLE and disconnects from sqlplus session.
Tried running catupgrd.sql before gave error
CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],[]
ORA-06553: PLS-801: internal error [56319]
What is correct method of finishing this upgrade.
Re: upgrading 32 bit 10g to 64bit [message #204438 is a reply to message #204437] Mon, 20 November 2006 14:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>What is correct method of finishing this upgrade.
A question you are supposed to ask before doing the upgrade.
What made you think that just copying the files should ***always*** work?
It is all accounted in documentation.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/intro.htm#sthref34

[Updated on: Mon, 20 November 2006 14:30]

Report message to a moderator

Re: upgrading 32 bit 10g to 64bit [message #204439 is a reply to message #204438] Mon, 20 November 2006 15:00 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
Thanks much for the reply,
tell me if I am wrong, I need to run script utlip.sql in 10.1 environment before taking cold backup
Re: upgrading 32 bit 10g to 64bit [message #204442 is a reply to message #204439] Mon, 20 November 2006 15:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As said before, just copying the files is not always the solution.
You need to install 64 bit software in old server and mount the old database.
Then copy those files to the new server with 64 bit binaries.

You have'nt mentioned the OS you are using.
Everything is already documented like this.
For windows
http://download-east.oracle.com/docs/cd/B19306_01/win.102/b15688/create.htm#CHDCDAGE
Re: upgrading 32 bit 10g to 64bit [message #204635 is a reply to message #204442] Tue, 21 November 2006 08:00 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
I want to move database from old server which is 32 bit to new one which is 64 bit. Both are on linux.
Thanks for the document link, I could not find similar one for linux.
Re: upgrading 32 bit 10g to 64bit [message #204656 is a reply to message #204635] Tue, 21 November 2006 09:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same concepts apply to unix also
Re: upgrading 32 bit 10g to 64bit [message #204682 is a reply to message #204656] Tue, 21 November 2006 12:34 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
The Database upgrade guide 10g Release 2 (10.2) says
"The process is not automatic for the release 1 to release 2 upgrade, but is automatic for all other upgrades. This is because the utlip.sql script is not run during the release 1 to release 2 upgrade to invalid all PL/SQL objects. You must run the utlip.sql script as the last step in the release 10.1 environment, before upgrading to release 10.2."
The document you have mentioned 'Migrating an Oracle Database 10g Release 2 (10.2) Database' tells to run utlirp.sql
I have both scitps in /usr1/oracle/product/rdbms/admin.
What is the difference between utlip.sql and utlirp.sql, and which one should be used?
Do I need to run utlip.sql in 10.1- 32 bit database before backing it up?
Re: upgrading 32 bit 10g to 64bit [message #204685 is a reply to message #204682] Tue, 21 November 2006 12:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>What is the difference between utlip.sql and utlirp.sql, and which one should be used?
Your questions are answered inside utlirp.sql.
Did you care to open and read it? Smile
utlirp will call utlip and utlrp.
So just execute utlirp.
>>Do I need to run utlip.sql in 10.1- 32 bit database before backing it up?
Ask the question yourself.
if something goes wrong, you should be in a position to go back before you did any changes. Right?
So the obvious choice is to backup before applying the scripts.
Usually these scripts are harmless (drop and recompile).
The importance here is becuase of swithing from 32-bit to 64 bit.
Re: upgrading 32 bit 10g to 64bit [message #204693 is a reply to message #204685] Tue, 21 November 2006 13:31 Go to previous message
pmaora
Messages: 16
Registered: October 2006
Junior Member
Thanks much for your help.
Previous Topic: UNDO vs. Rollback Segments
Next Topic: Archive log in Replication Server
Goto Forum:
  


Current Time: Wed Dec 07 10:54:58 CST 2016

Total time taken to generate the page: 0.13588 seconds