Transfering database from 11.1.0 wiondows 32 bit to 11.2.0 64 bit windows [message #501625] |
Wed, 30 March 2011 03:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
Hi,
I wanted to transfer my database from Oracle 11.1.0. on windows 2003 server 32 bit to Oracle 11.2.0. windows server 2008 64 bit
i have done following
1)On new server of 11.2.0 windows 2008 64 bit
use rman backup from Oracle 11.1.0. on windows 2003 server 32 bit to restore the database and recover the database
when i try to open the database
Alter database open
it gave me message that i should start my database as upgrade
I start the database with upgrade
STARTUP UPGRADE and then run following
@?/rdbms/admin/utlirp.sql
and then run following
@?/rdbms/admin/utlu112i.sql
and then run
@?/rdbms/admin/catupgrd.sql
during run of catupgrd.sql after around 30 minutes of run, i got error
ORA-03113: end-of-file on communication channel
but i reconnected myself with database again
and shutdown the database and open it in normal mode
and it has opened
there were thousands of uncompiled objects
and i recompiled them.
Only uncompiled objects left 60 are 'OLAPSYS' (Locked user) USER and 30 of PUBLIC user (all Synonyms)
Have i taken correct steps?
What should i do now to check that everything will be alright in future
|
|
|
|
Re: Transfering database from 11.1.0 wiondows 32 bit to 11.2.0 64 bit windows [message #501631 is a reply to message #501625] |
Wed, 30 March 2011 04:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
when i am executting after starting database in normal mode
it is giving me following error
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> spool e:\s1
SP2-0606: Cannot create SPOOL file "e:\s1.LST"
SQL> spool s1
SQL> @E:\app\oracle\product\11.1.0\db_1\RDBMS\ADMIN\utlirp.sql
SQL>
SQL> WHENEVER SQLERROR EXIT;
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if there the database was not opened in UPGRADE mode
DOC>
DOC> If you encounter this error, execute "SHUTDOWN", "STARTUP UPGRADE" and
DOC> re-execute utlirp.sql
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance
2 WHERE status != 'OPEN MIGRATE';
SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance
*
ERROR at line 1:
ORA-01722: invalid number
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
|
|
|
Re: Transfering database from 11.1.0 wiondows 32 bit to 11.2.0 64 bit windows [message #501632 is a reply to message #501631] |
Wed, 30 March 2011 05:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Have you actually read what you posted?
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if there the database was not opened in UPGRADE mode
DOC>
DOC> If you encounter this error, execute "SHUTDOWN", "STARTUP UPGRADE" and
DOC> re-execute utlirp.sql
Also, have you looked at the alert.log and trace files yet?
|
|
|
Re: Transfering database from 11.1.0 wiondows 32 bit to 11.2.0 64 bit windows [message #501635 is a reply to message #501631] |
Wed, 30 March 2011 05:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
I run utlirp.sql After shutting down the database and then do startup upgrade and then run utlirp.sql
after running utlirp.sql in upgrade mode, it invalidates all objects
and then shutdown the database again and startup in normal mode and run it again as required
there is no error in alert log and trace file when i run utlirp.sql
|
|
|
|
|