 upgrading 32 bit 10g to 64bit [message #204437] |
Mon, 20 November 2006 14:12  |
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 #204682 is a reply to message #204656] |
Tue, 21 November 2006 12:34  |
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
