For the upgrade from release 5.2, upgrade the application tier technology stack from version 12.2.1.2 to 12.2.1.3.
Oracle Application Server 12c R2, which includes the Oracle Forms Server and the Oracle Reports Server. Both are required for Oracle Clinical.
WebLogic Server 12c R2 and Oracle Application Developer Framework 12c R2. These are required for RDC.
You can install all components on the same machine or on multiple machines, but you must install all components on all machines and then disable services on the machine(s) where they are not needed.
To ensure high availability of the Reports Server, you can set up and use more than one Reports Server on a subnet and they can access each other. For more information see the Oracle Clinical Administrator's Guide.
This chapter describes how to upgrade Oracle Application Server, which includes the Oracle WebLogic Server, Oracle Fusion Middleware Infrastructure Software, Oracle Forms Server, and the Oracle Reports Server.
For more information, see Oracle Fusion Middleware - Install, Patch, and Upgrade 12.2.1.3.0 at https://docs.oracle.com/middleware/12213/cross/upgrade.htm and Upgrading Oracle Forms from a Previous 12c Release at https://docs.oracle.com/middleware/12213/formsandreports/install-fnr/upgrading-oracle-forms-and-reports.htm#FRINS-GUID-E9D8E1FF-A680-4D68-A8C5-780350309EDD.
This chapter includes:
Install all application tier components using the same user account you had when you installed version 12.2.1.2.
The account must have administrator privileges on the server computer.
Have the following information ready.
Note:
A new ORACLE_HOME needs to be created, the 12.2.1.3 upgrade is an out-of-place upgrade.The existing domains remain in the same place, FRDomain and OPADomain do not change their paths. The domain and component upgrade are in-place as the domain directory remains the same in the initial 12.2.1.2 ORACLE_HOME.
Note:
For OHS 12.2.1.3 on Windows, it is required to have both Microsoft Visual C++ 2010 Redistributable and Microsoft Visual C++ 2012 Redistributable installed. Otherwise, there will be errors when starting the ohs component and trying to access forms. For more information, see Oracle HTTP Server Start Failed With 'exit status = -1073741515' In New Installation of FMW 12.2.1.3 on Windows Server (Doc ID 2314112.1) on My Oracle Support.These libraries may already be installed, In this case, there will be an error message when trying to install them.
Install the 12.2.1.3 Oracle WebLogic Server
Home directory path for FMW 12.2.1.3; for example: C:\Oracle12213\Middleware\Oracle_Home
Email address to receive the security updates specific to your installation
My Oracle Support password if you wish to receive the security updates through My Oracle Support
Install the Oracle Fusion Middleware Infrastructure Software
Home directory path for FMW 12.2.1.3; for example: C:\ Oracle12213\Middleware\Oracle_Home
Email address to receive the security updates specific to your installation
My Oracle Support password if you wish to receive the security updates through My Oracle Support
Install the Oracle Forms and Reports Servers
Home directory path for FMW 12.2.1.3; for example: C:\ Oracle12213\Middleware\Oracle_Home
Restart the computer before starting the upgrade to 12.2.1.3.
Before starting the upgrade to 12.2.1.3, stop all servers and components.
For FRDomian, make sure Admin Server, WLS_FORMS, WLS_REPORTS, OHS, report server instance, and Node Manager are stopped.
For OPADomain, make sure Admin Server, managed server, and Node Manager are stopped.
In the staging area where you downloaded the media pack (see Section 1.7, "Download the Software"), locate the directory where you downloaded Oracle WebLogic Server 12.2.1.3 Generic and Coherence and extract the WebLogic Server .zip file (fmw_12.2.1.3.0_wls_Disk1_1of1.zip) if you have not already done so.
Log in as the user you selected in Section 8.1.1, "Identify a Single Account to Perform All Application Tier Installation Tasks".
Install Oracle WebLogic Server using a Generic Package installer—This type of installer is a .jar file; fmw_12.2.1.3.0_wls.jar.
For instructions, see Oracle® Fusion Middleware Installing and Configuring Oracle WebLogic Server and Coherence for Release 12.2.1.3, at https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/wlsig/installing-oracle-weblogic-server-and-coherence-software.html#GUID-E4241C14-42D3-4053-8F83-C748E059607A.
The complete documentation set for Oracle WebLogic Server 12.2.1.3 is available at: https://docs.oracle.com/middleware/12213/wls/index.html.
You can accept most default values, with the exceptions noted below.
Note:
You can change the default value of the middleware_home directory, which is C:\Oracle\Middleware, if you wish but some code examples in this guide use that value to make it easier to copy and paste, so remember to change these if you change the value.You must NOT change the names for any of the middleware home's subdirectories, including wlserver and oracle_common.
Note:
Make sure you have installed Visual C++ in Microsoft Visual Studio 2012 (x64 distributed). This is required for Oracle WebLogic Server 12c (12.2.1.3) and Oracle Forms and Reports 12c (12.2.1.3) Servers to invoke Data Capture API methods from custom clients.Choose the "WebLogic Server" Install Type
Select WebLogic Server.
This is required in order to create a Node Manager.
Note:
Even if you accept this option you should check My Oracle Support for quarterly Oracle Critical Patch Update (CPU) security patches certified for use with Oracle Clinical.Specify whether you want to register the product installation with My Oracle Support.
If you register, Oracle Health Sciences Support emails you immediately of any security updates that are specific to your installation.
Follow instructions on the screen to register or to reject the option.
Note:
Continue to click Next until you are finished. After the Installation Summary, the processing may take a few minutes. Deselect the Automatically Launch Configuration Wizard check box and click Finish to complete the 12c WebLogic Server installation.In the staging area where you downloaded the media pack (see Section 1.7, "Download the Software"), locate the directory where you downloaded the Oracle Fusion Middleware Infrastructure Software and extract the .zip file (fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip) if you have not already done so.
Log in as the user you selected in Section 8.1.1, "Identify a Single Account to Perform All Application Tier Installation Tasks".
Install the Oracle Fusion Middleware Infrastructure Software using a Generic Package installer—This type of installer is a .jar file; fmw_12.2.1.3.0_infrastructure.jar.
Note:
Use the same install directory that you specified when you installed WebLogic Server in Section 8.4, "Install Oracle WebLogic Server 12.2.1.3".Select "Fusion Middleware Infrastructure" as the installation type.
For instructions, see Oracle® Fusion Middleware Installing and Configuring Oracle WebLogic Server and Coherence for Release 12.2.1.3, at https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/wlsig/installing-oracle-weblogic-server-and-coherence-weblogic-server-mt.html#GUID-2ACC5AA7-8904-430B-B903-8F1EEA578B7A.
In the staging area where you downloaded the media pack (see Section 1.7, "Download the Software"), locate the directory where you downloaded Oracle Forms and Reports 12c (12.2.1.3) for Microsoft Windows (64-bit) and extract the .zip files (fmw_12.2.1.3.0_fr_win64_Disk1_1of2.zip and fmw_12.2.1.3.0_fr_win64_Disk1_2of2.zip) if you have not already done so.
Log in as the user you selected in Section 8.1.1, "Identify a Single Account to Perform All Application Tier Installation Tasks".
Install the Oracle Forms and Reports 12c (12.2.1.3) using a Generic Package installer—This type of installer is an .exe file; setup_fmw_12.2.1.3.0_fr_win64.exe.
When asked, to choose an installation type, select Forms and Reports Deployment.
Note:
Use the same install directory that you specified when you installed WebLogic Server in Section 8.4, "Install Oracle WebLogic Server 12.2.1.3".For instructions, see Oracle® Fusion Middleware Installing Oracle Forms and Reports for Release 12.2.1.3, at https://docs.oracle.com/middleware/12213/formsandreports/install-fnr/installing-and-configuring-oracle-forms-and-reports1.htm#FRINS256.
Once the new 12.2.1.3 ORACLE_HOME is created and Oracle WebLogic Server, Oracle Fusion Middleware Infrastructure Software, and Oracle Forms and Reports Servers are installed, run a pre-upgrade readiness check. You must run this check separately for FRDomain and OPAdomain.
Run the following command to start the pre-upgrade readiness check:
<12.2.1.3_Oracle_Home>\oracle_common\upgrade\bin\ua.bat -readiness
Select the Domain Based option and enter the domain location.
Select the Include checks for all schemas and Include checks for all configurations check boxes.
Enter the WebLogic domain directory where schemas and configurations will be checked. This will be the path to the domains directory from <12.2.1.2_Oracle_Home>. For example, C:\Oracle\Middleware\Oracle_Home\user_projects\domains\FRDomain.
Check schemas and configuration in FRDomain.
Schemas to be checked:
Oracle Platform Security Services – OPSS
Oracle Audit Services – IAU
Common Infrastructure Services – STB
Configuration to be checked:
System Components Infrastructure
Oracle HTTP Server
Oracle JRF
Common Infrastructure Services
Oracle Forms Services
Oracle Reports Services
Check schemas and configuration in OPADomain.
Schemas to be checked:
Oracle Platform Security Services – OPSS
Oracle Audit Services – IAU
Common Infrastructure Services – STB
Configuration to be checked:
System Components Infrastructure
Oracle HTTP Server
Oracle JRF
Common Infrastructure Services
Oracle Forms Services
Enter the database account credentials for the RCU OPSS schema.
Note:
Click Connect to make sure the credentials you entered are valid.Enter the database account credentials for the RCU IAU and STB schemas.
In the Readiness Progress screen, check that all the components should have a green status – upgrade not necessary or ready for upgrade.
For OPADomain in the Readiness Progress screen all the components should have a green status – upgrade not necessary or ready for upgrade; except for Oracle Forms Services. The Oracle Forms Service component for OPADomain will be marked as Failure but this can be ignored as Oracle Forms Service is not a part of OPADomain.
Perform the following steps separately for both the FRDomain and OPADomain in the existing 12.2.1.2 User Projects Home.
Run the following command in the new 12.2.1.3 ORACLE_HOME.
<12.2.1.3_Oracle_Home>\oracle_common\upgrade\bin\ua.bat
Select the All Schemas Used by a Domain check box and provide the domain location.
Upgrade the components in FRDomain/OPADomain.
Oracle Platform Security Services - OPSS
Oracle Audit Services - IAU
Common Infrastructure Services - STB
Create the component whose schema is missing in FRDomain/OPADomain.
Oracle WebLogic Services
Check all prerequisites.
Enter the database system credentials to connect to RCU.
Select the Create missing schemas for specified domain check box and enter the schema password.
Note:
It is recommended to use the same password used for other RCU schema components.In the Examine screen, make sure all the checks should be green and status is not failed.
In the Upgrade Summary screen, make sure all the information is correct.
Click Upgrade.
Run the Reconfiguration Wizard For FRDomain
Open a DOS prompt and run:
<12.2.1.3_Oracle_Home>\oracle_common\common\bin\reconfig.cmd -log <path_to_log_file>\FRDomain_log.txt -log_priority=ALL
You can accept most default values, with the exception noted below.
Select the FRDomain location; for example:
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\FRDomain
Select the RCU data check box under Specify AutoConfiguration Options Using.
Make sure the RCU database is correct.
Click Get RCU Configuration.
Select all RCUs.
Click Next.
Select all check boxes.
Run the Reconfiguration Wizard For OPADomain
Open a DOS prompt and run:
<12.2.1.3_Oracle_Home>\oracle_common\common\bin\reconfig.cmd -log <path_to_log_file>\OPADomain_log.txt -log_priority=ALL
You can accept most default values, with the exception noted below.
Select the OPADomain location; for example:
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\OPADomain
Select the RCU data check box under Specify AutoConfiguration Options Using.
Make sure the RCU database is correct.
Click Get RCU Configuration.
Select all RCUs.
Click Next.
Select all check boxes.
Select the existing data source.
Use a different port number other than the one used for FRDomain. For example, 7575.
Deselect the Configure Domain Frontend Host check box.
Start the upgrade assistant in the new 12.2.1.3 Oracle Home to upgrade the Forms installation.
Run the following command:
<12.2.1.3_Oracle_Home>\oracle_common\upgrade\bin\ua.bat
Select the select the FRDomain.
Upgrade the components in FRDomain:
System Components Infrastructure
Oracle HTTP Server
Oracle JRF
Oracle Forms Services
Oracle Reports Services
In the Prerequisites screen, select all the check boxes.
In the Examine screen, make sure all the checks have the status "ready for upgrade" or "upgrade not necessary".
Click Upgrade.
Start all components for the FRDomain.
If OHS fails to start with exit status = 1 (startComponent ohs1), there is an issue in the httpd.conf files in the FRDomain.
The httpd.conf files can be found under:
<12.2.1.3_Oracle_Home>\user_projects\domains\FRDomain\config\fmwconfig\components\OHS\instances\ohs1\
<12.2.1.3_Oracle_Home>\user_projects\domains\FRDomain\config\fmwconfig\components\OHS\ohs1\
Note:
Make sure the httpd.conf files have only one Listen directive for one specific port.Listen <machine_name>:<port_number>