Perform these tasks to complete an out-of-place upgrade:
When upgrading from Oracle Fusion Middleware 11g or a previous 12c release to 12c (12.2.1.1), schemas and domain directory upgrades are performed “in-place" which updates the existing 11g or 12c files during the upgrade.
If you prefer to leave your 11g domain directory intact, you can perform an out-of-place domain directory upgrade using a new domain directory on the same - or different - host using the steps described in this chapter.
Caution:
When performing an out-of-place domain directory upgrade, it is important to note that the 11g and 12c (12.1.3 and 12.2.1.0) schemas will be upgraded in-place. Your pre-upgrade environment must be shut down during the out-of-place domain directory upgrade process.
Perform the following tasks to complete the out-of-place domain directory upgrade on the same host at the existing 11g domain:
Note:
If you are upgrading domain that is on a different host, see Performing an Out-of-Place Domain Directory Upgrade on a Different Host.
Note:
The Fusion Middleware 12c certification matrix includes 12.1 databases. Hence, the reference to 11 in these procedures is to the Fusion Middleware 11g schemas and not to the Oracle 11g database version.
You must stop all processes, including the Administration Server, Managed Servers, and Node Manager, if they are started on the host. For example, to stop the Administration Server:
DOMAIN_HOME/bin/stopWebLogic.sh username password [admin_url]
Make sure that you have created a complete backup of your entire 11g deployment before you begin the upgrade process. These files can be used if there is an issue during the migration and you have to restart the process.
For more information on backing up your files, see "Backing Up Your Environment" in the Oracle® Fusion Middleware Administrator's Guide.
During the upgrade you must have “read" access to the files in the backup storage:
11g Domain Home
The /nodemanager
directory located in the MW_HOME/wlserver_10.3/common/
For more information, see "Backing Up Your Environment" in the Oracle® Fusion Middleware Administrator's Guide. Do not proceed with the upgrade until you have a complete backup.
Copy the files you backed up in Task 2: Backup all files from the 11g domain. to a new location using the same directory structure that was used for the existing 11g environment. The directory structure you create for the upgrade must be identical to the structure used for the original 11g environment.
You will point to this location in Task 5: Upgrade the cloned environment using the standard upgrade procedures..
You must obtain, install and configure the 12c (12.2.1) product distributions for the components you will be upgrading.
For detailed instructions, see Planning an Installation of Oracle Fusion Middleware and the component-specific installation guides for the component(s) you are installing.
Perform the upgrade on the domain you created in Task 3: Restore the 11g domain backup files to a new location..
Each component has an upgrade guide that describes the procedures required to upgrade from your Oracle Fusion Middleware 11g or previous 12c infrastructure topology to the new 12c (12.2.1.1) topology. The guides are located in the Upgrade tab of the Oracle Fusion Middleware 12c (12.2.1) online library.
Oracle recommends that you create a non-SYSDBA user to run the Upgrade Assistant. The user created using this procedure has the privileges required to complete the upgrade.
SYS
. Access to a default schema can be a very powerful privilege. For example, when you connect as user SYS
, you have unlimited privileges on data dictionary tables. Therefore, Oracle recommends that you create a non-SYSDBA user to upgrade the schemas. The privileges listed in this topic must be granted before starting the Upgrade Assistant.
Note:
Thev$xatrans$
table does not exist by default. You must run the XAVIEW.SQL
script to create this table before creating the user. Moreover, grant on v$xatrans$
table is required only for Oracle Identity Manager. If you do not require Oracle Identity Manager for configuration or if you do not have the v$xatrans$
table, then remove the following line from the script:
grant select on v$xatrans$ to FMW with grant option;
Note:
If you are upgrading anORASDPM
schema that was created using RCU 11g (11.1.1.1.4 or earlier), and you subsequently upgraded ORASDPM
to 11g (11.1.1.6 or later), the FMW user will need to grant the CREATE TABLE
privilege to user prefix_ORASDPM
before upgrading to 12c (12.2.1.1).
grant CREATE TABLE to prefix_ORASDPM;
Where prefix
is the name given to the schema when it was created.
welcome1
is the password. Make sure that you specify your actual password when granting privileges.
create user FMW identified by welcome1; grant dba to FMW; grant execute on DBMS_LOB to FMW with grant option; grant execute on DBMS_OUTPUT to FMW with grant option; grant execute on DBMS_STATS to FMW with grant option; grant execute on sys.dbms_aqadm to FMW with grant option; grant execute on sys.dbms_aqin to FMW with grant option; grant execute on sys.dbms_aqjms to FMW with grant option; grant execute on sys.dbms_aq to FMW with grant option; grant execute on utl_file to FMW with grant option; grant execute on dbms_lock to FMW with grant option; grant select on sys.V_$INSTANCE to FMW with grant option; grant select on sys.GV_$INSTANCE to FMW with grant option; grant select on sys.V_$SESSION to FMW with grant option; grant select on sys.GV_$SESSION to FMW with grant option; grant select on dba_scheduler_jobs to FMW with grant option; grant select on dba_scheduler_job_run_details to FMW with grant option; grant select on dba_scheduler_running_jobs to FMW with grant option; grant select on dba_aq_agents to FMW with grant option; grant execute on sys.DBMS_SHARED_POOL to FMW with grant option; grant select on dba_2pc_pending to FMW with grant option; grant select on dba_pending_transactions to FMW with grant option; grant execute on DBMS_FLASHBACK to FMW with grant option; grant execute on dbms_crypto to FMW with grant option; grant execute on DBMS_REPUTIL to FMW with grant option; grant execute on dbms_job to FMW with grant option; grant select on pending_trans$ to FMW with grant option; grant select on dba_scheduler_job_classes to fmw with grant option; grant select on SYS.DBA_DATA_FILES to FMW with grant option; grant select on SYS.V_$ASM_DISKGROUP to FMW with grant option; grant select on v$xatrans$ to FMW with grant option; grant execute on sys.dbms_system to FMW with grant option; grant execute on DBMS_SCHEDULER to FMW with grant option; grant select on dba_data_files to FMW with grant option; grant execute on UTL_RAW to FMW with grant option; grant execute on DBMS_XMLDOM to FMW with grant option; grant execute on DBMS_APPLICATION_INFO to FMW with grant option; grant execute on DBMS_UTILITY to FMW with grant option; grant execute on DBMS_SESSION to FMW with grant option; grant execute on DBMS_METADATA to FMW with grant option; grant execute on DBMS_XMLGEN to FMW with grant option; grant execute on DBMS_DATAPUMP to FMW with grant option; grant execute on DBMS_MVIEW to FMW with grant option; grant select on ALL_ENCRYPTED_COLUMNS to FMW with grant option; grant select on dba_queue_subscribers to FMW with grant option; grant execute on SYS.DBMS_ASSERT to FMW with grant option;
Note:
Oracle Database 11.2.0.3 Database Users ONLY: You must apply Oracle Patch 13036331 before you begin the upgrade. Go to My Oracle Support to download the patch.
If you do not apply this patch, then you will have to grant additional privileges for some schemas.
For most components, the Upgrade Assistant can be run in -readiness mode to perform a read-only, pre-upgrade check on your domain. If issues are detected, you can correct them before starting the actual upgrade.
-readiness
mode:The screens you see will vary depending on the upgrade options you select. Consult your component-specific upgrade documentation for complete details.
Perform the usual administration tasks using the new domain and verify that the components work as expected.
You do not need to decommission the 11g Oracle home, however if you would like to remove it, see Deinstalling the 11g Applications (Optional).
Perform these steps to compete an out-of-place upgrade on a different host.
The Fusion Middleware 12c certification matrix includes 12.1 databases, therefore, the reference to 11 in this chapter is to the Fusion Middleware 11g schemas and not to the Oracle 11g database version.
You must stop all processes, including the Administration Server, Managed Servers, and Node Manager, if they are started on the host. For example, to stop the Administration Server:
DOMAIN_HOME/bin/stopWebLogic.sh username password [admin_url]
Make sure that you have created a complete backup of your entire 11g deployment before you begin the upgrade process. These files can be used if there is an issue during the migration and you have to restart the process.
For more information on backing up your files, see "Backing Up Your Environment" in the Oracle® Fusion Middleware Administrator's Guide.
During the upgrade you must have “read" access to the files in the backup storage:
11g Domain Home
The /nodemanager
directory located in the MW_HOME/wlserver_10.3/common/
The host name and IP address of the target machine (Host B) must be made identical to the source host (Host A). This will require you to change the IP address and name of the source machine or decommission the source machine to avoid conflicts in the network.
The process of changing an IP address and host name vary by operating system. Consult your operating system's administration documentation for more information.
Restore the files you backed up in Task 2: Backup all files from the host machine. (Host A) using the same directory structure that was used in 11g. The directory structure on Host B must be identical to the structure used on Host A.
For detailed information about restoring your files to the target machine, see "Recovering Your Environment" in Oracle® Fusion Middleware Administrator's Guide.
You must obtain, install and configure the 12c (12.2.1) product distributions for the components you will be upgrading.
For detailed instructions, see Planning an Installation of Oracle Fusion Middleware and the component-specific installation guides for the component(s) you are installing.
Each 12c (12.2.1) component has an upgrade guide that describes the procedures required to move from your 11g (11.1.1.6 or 11.1.1.7) or 12c (12.1.2 or 12.1.3) infrastructure topology to the new 12c (12.2.1) topology. The guides are located in the Upgrade tab of the Oracle Fusion Middleware 12c (12.2.1) online library.
The Node Manager upgrade procedure requires access to the original Node Manager files. Use the 11g Node Manger files that were backed up from the source machine as part of Task 3: Set up the target machine (Host B) with the 11g host name and IP address..
Perform the usual administration tasks using the new domain and verify that the components work as expected.
You do not need to decommission the 11g Oracle home, however if you would like to remove it, see Deinstalling the 11g Applications (Optional).
While not required, you can use these steps to deinstall the 11g application and domain setup after the upgrade. Do not deinstall a domain that is still being referenced by a non-upgraded component. If you are unsure, leave the domain intact.
Note:
The commands mentioned in this section must be run from the 11g Oracle Home that you are removing and not from the new home that was created as part of the 12c upgrade process.