question about migrating + upgrade from win to OEL
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