28 | 03 | 2024
Latest Articles
Popular Articles

RMAN

Move to another OS and upgrade at the same time

User Rating:  / 2
PoorBest 

Move to another OS and upgrade at the same time.


1. You need to move your database to another OS ( with this example from Linux 64 bit to Windows 32 bit )
2. You need to upgrade your database ( with this example from 10.2.0.3 to 11.2.0.3  )
3. your database schema structure is complex, you use advanced features like Oracle Text, Oracle Spatial, Advanced Queueing
4. You tried to export your source database and import it into the target database but you run into issues. ( with AQ tables, invalid domain indexes, ...  )

In short you wonder whether you can' t restore a database backup image on the other os and open the database in upgrade mode ?

From 10G R1 onwards

1. you can convert your entire database files to be "compatible" with another OS using RMAN assuming the endian format is identical.
2. You then restore your database on the target platform using RMAN and
3. You open the database with the "alter database open resetlogs upgrade" command
4. You then start with the upgrade as documented in the upgrade guide ( catupgrd.sql + pre & post upgrade steps )


If the endian format is not identical your options are limited to cross platform transportable tablespace technology


Both Linux and Microsoft have the same endian format thus we can convert the database files for cross platform migrations.


SQL> column platform_name format a40
SQL> select * from v$transportable_platform;

PLATFORM_ID PLATFORM_NAME                            ENDIAN_FORMAT
---------------- ---------------------------------------- --------------
1 Solaris[tm] OE (32-bit)                  Big
2 Solaris[tm] OE (64-bit)                  Big
7 Microsoft Windows IA (32-bit)            Little
10 Linux IA (32-bit)                       Little
6 AIX-Based Systems (64-bit)               Big
3 HP-UX (64-bit)                           Big
5 HP Tru64 UNIX                            Little
4 HP-UX IA (64-bit)                        Big
11 Linux IA (64-bit)                       Little
15 HP Open VMS                             Little
8 Microsoft Windows IA (64-bit)            Little
9 IBM zSeries Based Linux                  Big
13 Linux x86 64-bit                        Little
16 Apple Mac OS                            Big
12 Microsoft Windows x86 64-bit            Little
17 Solaris Operating System (x86)          Little
18 IBM Power Based Linux                   Big
19 HP IA Open VMS                          Little
20 Solaris Operating System (x86-64)       Little
21 Apple Mac OS (x86-64)                   Little

20 rows selected.



Here is the how to ?



STEP1 : on the source Platform ( this example uses Linux )



SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
SILVER

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2072352 bytes
Variable Size             704643296 bytes
Database Buffers          503316480 bytes
Redo Buffers               14704640 bytes
Database mounted.
SQL> alter database open read only;

Database altered.



set serveroutput on
declare
db_ready boolean;
begin
db_ready := dbms_tdb.check_db('Microsoft Windows IA (32-bit)');
end;
/


PL/SQL procedure successfully completed.


declare
external boolean;
begin
external := dbms_tdb.check_external;
end;
/

The following directories exist in the database:
SYS.ABC_DIR, SYS.EXPORT, SYS.DEF_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR, SYS.DATA_PUMP_DIR

PL/SQL procedure successfully completed.



[oracle@myhost SILVER]$ $ORACLE_HOME/bin/rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Dec 5 10:46:46 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: SILVER (DBID=1566114764)


[oracle@myhost SILVER]$ $ORACLE_HOME/bin/rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Dec 5 10:46:46 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: SILVER (DBID=1566114764)

RMAN> convert database new database 'SILVER'
2> transport script '/u01/oradata/SILVER/windows_files/transport.sql'
3> to platform 'Microsoft Windows IA (32-bit)'
4> db_file_name_convert '/u01/oradata/SILVER' '/u01/oradata/SILVER/windows_files';

Starting convert at 05-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK

Directory SYS.ABC_DIR found in the database
Directory SYS.EXPORT found in the database
Directory SYS.DEF_DIR found in the database
Directory SYS.WORK_DIR found in the database
Directory SYS.ADMIN_DIR found in the database
Directory SYS.DATA_PUMP_DIR found in the database


User SYS with SYSDBA and SYSOPER privilege found in password file
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00010 name=/u01/oradata/SILVER/MYAPP_EWB_LOB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_LOB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:05:35
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00009 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_SUB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_SUB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00002 name=/u01/oradata/SILVER/undotbs01.dbf
converted datafile=/u01/oradata/SILVER/windows_files/undotbs01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00012 name=/u01/oradata/SILVER/MYAPP_EWB_CORE_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CORE_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00005 name=/u01/oradata/SILVER/MYAPP_EWB_CORE_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CORE_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00026 name=/u01/oradata/SILVER/MYAPP_DW_LOB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_LOB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00023 name=/u01/oradata/SILVER/MYAPP_IS_LOB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_IS_LOB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00029 name=/u01/oradata/SILVER/MYAPP_SA_LOB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_SA_LOB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00027 name=/u01/oradata/SILVER/MYAPP_DW_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00003 name=/u01/oradata/SILVER/sysaux01.dbf
converted datafile=/u01/oradata/SILVER/windows_files/sysaux01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00008 name=/u01/oradata/SILVER/MYAPP_EWB_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00001 name=/u01/oradata/SILVER/system01.dbf
converted datafile=/u01/oradata/SILVER/windows_files/system01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00025 name=/u01/oradata/SILVER/MYAPP_EWB_DW_DATA_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DW_DATA_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00035 name=/u01/oradata/SILVER/MYAPP_DW_MAX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_MAX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00028 name=/u01/oradata/SILVER/MYAPP_EWB_SA_DATA_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SA_DATA_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00004 name=/u01/oradata/SILVER/users01.dbf
converted datafile=/u01/oradata/SILVER/windows_files/users01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00036 name=/u01/oradata/SILVER/MYAPP_EWB_LOB_DATA_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_LOB_DATA_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00015 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_SUB_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_SUB_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00021 name=/u01/oradata/SILVER/MYAPP_EWB_CXTA_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CXTA_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00022 name=/u01/oradata/SILVER/MYAPP_EWB_IS_DATA_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_IS_DATA_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00024 name=/u01/oradata/SILVER/MYAPP_IS_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_IS_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00006 name=/u01/oradata/SILVER/MYAPP_EWB_DICT_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DICT_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00007 name=/u01/oradata/SILVER/MYAPP_EWB_SEC_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SEC_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00011 name=/u01/oradata/SILVER/MYAPP_EWB_SEC_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_SEC_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00013 name=/u01/oradata/SILVER/MYAPP_EWB_DICT_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_DICT_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00014 name=/u01/oradata/SILVER/MYAPP_EWB_CDC_PUB_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_EWB_CDC_PUB_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00016 name=/u01/oradata/SILVER/MYAPP_01_01_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_01_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00017 name=/u01/oradata/SILVER/MYAPP_01_04_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_04_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00018 name=/u01/oradata/SILVER/MYAPP_01_07_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_07_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00019 name=/u01/oradata/SILVER/MYAPP_01_10_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_01_10_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00020 name=/u01/oradata/SILVER/MYAPP_MAX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_MAX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00030 name=/u01/oradata/SILVER/MYAPP_SA_INDX_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_SA_INDX_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00031 name=/u01/oradata/SILVER/MYAPP_DW_01_01_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_01_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00032 name=/u01/oradata/SILVER/MYAPP_DW_01_04_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_04_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00033 name=/u01/oradata/SILVER/MYAPP_DW_01_07_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_07_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00034 name=/u01/oradata/SILVER/MYAPP_DW_01_10_2008_TS.DBS
converted datafile=/u01/oradata/SILVER/windows_files/MYAPP_DW_01_10_2008_TS.DBS
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
Run SQL script /u01/oradata/SILVER/windows_files/transport.sql on the target platform to create database
Edit init.ora file /u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora. This PFILE will be used to create the database on the target platform
To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform
To change the internal database identifier, use DBNEWID Utility
Finished backup at 05-DEC-11



Important here is the script /u01/oradata/SILVER/windows_files/transport.sql
We will edit this file on the target platfrom to reflect the right directories.

We off course move this script togther with the converted data files towards the target platform

 

STEP2 : on the target Platform ( this example uses Microsoft )

 

1. We prepare a parameter file
2. we startup nomount the database instance ( not shown )
3. We edit the script transport.sql
3.1 we change the os path to reflect the directory structure
3.2 we replace the command "alter database open resetlogs" with "alter database open resetlogs upgrade"

####################################################################################################
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.

-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE

--STARTUP NOMOUNT PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora'
CREATE CONTROLFILE REUSE SET DATABASE "SILVER" RESETLOGS  NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 'D:\oracle\oradata\SILVER\redo01.rdo'  SIZE 50M,
GROUP 2 'D:\oracle\oradata\SILVER\redo02.rdo'  SIZE 50M,
GROUP 3 'D:\oracle\oradata\SILVER\redo03.rdo'  SIZE 50M
DATAFILE
'd:\oracle\oradata\SILVER\system01.dbf',
'd:\oracle\oradata\SILVER\undotbs01.dbf',
'd:\oracle\oradata\SILVER\sysaux01.dbf',
'd:\oracle\oradata\SILVER\users01.dbf',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CORE_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_DICT_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_SEC_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_SUB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_LOB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_SEC_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CORE_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_DICT_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_PUB_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CDC_SUB_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_01_01_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_01_04_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_01_07_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_01_10_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_MAX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_CXTA_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_IS_DATA_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_IS_LOB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_IS_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_DW_DATA_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_LOB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_SA_DATA_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_SA_LOB_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_SA_INDX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_01_01_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_01_04_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_01_07_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_01_10_2008_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_DW_MAX_TS.DBS',
'd:\oracle\oradata\SILVER\MYAPP_EWB_LOB_DATA_TS.DBS'
CHARACTER SET AL32UTF8
;

-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS UPGRADE;

-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE 'd:\oracle\oradata\SILVER\temp01.dbf'
SIZE 369098752  AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
-- End of tempfile additions.
--

set echo off
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
prompt * Your database has been created successfully!
prompt * There are many things to think about for the new database. Here
prompt * is a checklist to help you stay on track:
prompt * 1. You may want to redefine the location of the directory objects.
prompt * 2. You may want to change the internal database identifier (DBID)
prompt *    or the global database name for this database. Use the
prompt *    NEWDBID Utility (nid).
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--SHUTDOWN IMMEDIATE
--STARTUP UPGRADE PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora'
--@@ ?/rdbms/admin/utlirp.sql
--SHUTDOWN IMMEDIATE
--STARTUP PFILE='/u01/app/oracle/product/10.2.0/db_2/dbs/init_00mtekh4_1_0.ora'
-- The following step will recompile all PL/SQL modules.
-- It may take serveral hours to complete.
--@@ ?/rdbms/admin/utlrp.sql
--set feedback 6;


####################################################################################################

4. Once this script adjusted we run it as SYS ( note thet the database instance must be in nomount stage for this )
4.1 controlfiles will be created
4.2 the database will be opened in upgrade mode
4.3 we can proceed with the upgrade as documented in the upgrade guide ( catupgrd.sql + pre & post upgrade steps )


SQL > start transport.sql