Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about migrating + upgrade from win to OEL

user6387903Dec 2 2010
Hello,
I apparently completed with success this procedure.
But I would like to share the method
Source: 11.2.0.1 on win32 with compatible set to 10.0.0
Target: 11.2.0.2 on OEL 5.5 64 bit

I used first part of this:
http://blogs.oracle.com/AlejandroVargas/2008/10/database_migration_from_window.html
Inside the transport script I had to add "UPGRADE" option at the end of this statement:
ALTER DATABASE OPEN RESETLOGS
otherwise I got:
...
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 24412
Session ID: 191 Serial number: 3

Also, the last STARTUP for the utlrp.sql had to be specified again with "UPGRADE" option but the sql then failed because of:
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SQLTUNE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE"
ORA-06512: at "SYS.UTL_RECOMP", line 783
ORA-06512: at line 4

(some notes I found on metalink about dropping two synonyms didn't help)
I supposed this was due to internally still 11.1 structure of db .
So I left the DB open upgrade and started DBUA to upgrade it.
All went smooth and I only have now 1 invalid object (that is an application object, so to analyze at app level)
(I also tried then to re-run utlirp.sql and utlrp.sql scripts with the same positive final result)

Some questions:
- Any comments on the procedure itself?
- Can I go with similar scenario in case I have to migrate from
Source: 11.1.0.6 on win32 with compatible set to 11.1.0.0
Target: 11.2.0.2 on OEL 5.5 64 bit
And after steps above, can I set compatible to 11.2.0.0 and shutdown / start?

And latest:
- if I want to get occasion to defragment DB and merge some current datafiles in only one datafile in new DB, can I follow same approach with further steps or different switches in rman command, without going through datapump exp/imp? The DB is about 150GB big...

Thanks in advance,
Gianluca
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2010
Added on Dec 2 2010
0 comments
279 views