Oracle Aesthete: Upgrade Forms/Report from 12.2.1.4 to 12.2.1.19

=================================================================

Setup Environment for 12.2.1.4

=================================================================

Install certified java (jdk,jre) : 
	Installed Version	:	jdk-8u241-windows-x64 :	
	JDK Location		: 	E:\XWEBLOGIC\Java\jdk1.8.0_241
	JRE Location		:	E:\XWEBLOGIC\Java\jre1.8.0_241

Install Oracle_FMW_Infra_12.2.14_win64
        set JAVA_HOME=E:\XWEBLOGIC\Java\jdk1.8.0_241
        set PATH=%JAVA_HOME%\bin;%PATH%
        cd E:\XWEBLOGIC\Softwares\Oracle_FMW_Infra_12.2.14_win64
        java -jar fmw_12.2.1.4.0_infrastructure.jar

	ORACLE_HOME	:	E:\XWEBLOGIC\middleware\Oracle_Home
Install Forms and Reports 12.2.1.4
Create repository RCU.bat
	E:\XWEBLOGIC\middleware\Oracle_Home\oracle_common\bin\rcu.bat
	
Create domain
	E:\XWEBLOGIC\middleware\Oracle_Home\oracle_common\common\bin\config.cmd
	Domain		:	FR_Domain
	PORT		    :	7001
	Login		    :	weblogic / weblogic123
Check All services

==========================================================================

TEST JAVA UPGRADE

==========================================================================

Current Setup	
		Installed Version	:	jdk-8u241-windows-x64 :	
		JDK Location		: 	E:\XWEBLOGIC\Java\jdk1.8.0_241
		JRE Location		:	E:\XWEBLOGIC\Java\jre1.8.0_241

Stop All Services

Backup Existing HOME / JDK_HOME

 Rename existing Java Folders
	E:\XWEBLOGIC\Java\jdk1.8.0_241 to E:\XWEBLOGIC\Java\jdk1.8.0_241_old
	E:\XWEBLOGIC\Java\jre1.8.0_241 to E:\XWEBLOGIC\Java\jre1.8.0_241_old

 Install New JAVA and select Location for JDK and JRE , same as original location.
JDK Location		: 	E:\XWEBLOGIC\Java\jdk1.8.0_241
JRE Location		:	E:\XWEBLOGIC\Java\jre1.8.0_241

Start Services

========================================================================= Login to EM console fails after upgrading JAVA

=========================================================================

Caused by: java.lang.IllegalArgumentException: Malformed IPv6 address at index 8: ldap://[172.xx.xx.xx]:7001
		at java.net.URI.create(URI.java:852)
		at com.sun.jndi.ldap.LdapURL.validateURI(LdapURL.java:215)
		at com.sun.jndi.ldap.LdapURL.fromList(LdapURL.java:192)
		at com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:76)

Enterprise Manager Fusion Middleware Control Login Fails after Installing or Upgrading to Java 8u331 (or later - April 2022 CPU or later) (Doc ID 2865508.1)
	12.2.1.4: Patch 33903365
        
set ORACLE_HOME=E:\XWEBLOGIC\middleware\Oracle_Home
set PATH=%ORACLE_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\opatch;%path%
cd E:\XWEBLOGIC\Softwares\33903365
E:
opatch apply

==========================================================================

CREATE REPORT SERVER / OHS CONFIGURATION - to verify later after Upgrade

==========================================================================

Create reports tools and reports server by executing following commands:
cd E:\XWEBLOGIC\middleware\Oracle_Home\oracle_common\common\bin\
Wlst.cmd
connect("weblogic","weblogic123","localhost:7001")
createReportsToolsInstance(instanceName='MCBreptools1',machine='AdminServerMachine')
createReportsServerInstance(instanceName='MCBrepserver1',machine='AdminServerMachine')
exit()

                    -- startComponent MCBrepserver1
                    -- stopComponent MCBrepserver1
                    -- Restart WLS_REPORTS from console
                    -- startComponent MCBrepserver1


FR_domain\config\fmwconfig\components\ReportsServerComponent\MCBrepserver1\rwserver.conf
	
Add "!--" at the beginning and "--" at the end, in order oracle.reports.server.RWJAZNSecurity is commented:
	<!--security class="oracle.reports.server.RWJAZNSecurity" id="rwJaznSec"/-->
	and delete securityId="rwJaznSec" in jobType="report":
			<job jobType="report" engineId="rwEng"/>

		Old Value:	<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>
		New Value:	<job jobType="report" engineId="rwEng"/>

FR_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwservlet.properties
<?xml version="1.0" encoding="UTF-8"?>
<rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <server>rep_wls_reports_test-orcltest03</server>
   <singlesignon>no</singlesignon>
   <inprocess>no</inprocess>
<webcommandaccess>L2</webcommandaccess>
</rwservlet>
	

         -- Restart WLS_REPORTS
	     -- stopComponent MCBrepserver1
	     -- startComponent MCBrepserver1

            http://test-orabackup:9002/reports/rwservlet/
            http://test-orabackup:9002/reports/rwservlet/showjobs?server=MCBrepserver1



OHS CONFIGURATION
Login to http://lcalhost:7001/em
	        OHS ==>> Administration  ==>> mod_wl_ohs_configuration ==>> Locations
	         ==>> Lock & edit
		        /em		         test-orabackup	7001
		        /forms	         test-orabackup	9001
		        /reports	     test-orabackup	9002


Check the URL's
http://test-orabackup:7777
http://test-orabackup:7777/reports/rwservlet/showjobs?server=MCBrepserver1
http://test-orabackup:7777/forms

==========================================================================

UPGRADE FORMS and REPORTS from 12.2.1.14 to 12.2.1.19

IN PLACE UPGRADE APPROACH

==========================================================================

Backup Oracle_HOME, zip backup preferred.

 Backup Domain Separately to copy on Target, zip backup preferred

 Stop all services

 Verify the database client Version on Existing Home.
                 cd E:\XWEBLOGIC\middleware\Oracle_Home\bin
                sqlplus /nolog
		            SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 13 11:47:11 2024

Rename existing ORACLE_HOME

Install Oracle_FMW_Infra_12.2.14_win64 	on the same Path E:\XWEBLOGIC\middleware\Oracle_Home as ORIGINAL*******
        
        set JAVA_HOME=E:\XWEBLOGIC\Java\jdk1.8.0_241
        set PATH=%JAVA_HOME%\bin;%PATH%
        cd E:\XWEBLOGIC\Softwares\Oracle_FMW_Infra_12.2.14_win64
            java -jar fmw_12.2.1.4.0_infrastructure.jar

ORACLE_HOME	:	E:\XWEBLOGIC\middleware\Oracle_Home

Install Forms and Reports 12.2.1.19	on the same Path E:\XWEBLOGIC\middleware\Oracle_Home as ORIGINAL

If the WLS Domains directory (user_projects) and its subdirectories are located within the old Oracle Home, copy these directories to the new Oracle Home in the same location as they were previously.
	Make a zip backup of user_projects from old_home and unzip to New_home, to avoid any files missing due to windows permission issues.

Verify the database client version under new Oracle_home
cd E:\XWEBLOGIC\middleware\Oracle_Home\bin
sqlplus /nolog
		SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 13 14:51:17 2024
		Version 19.14.0.0.0

Clear all the logs from Weblogic Servers, to capture fresh log.

Start Services

--> Compile all Forms and Libraries to be compatible with new version of 12.2.1.19

==========================================================================

Apply July 2024 FMW Patches

==========================================================================

    Required July 2024 Patches
	36822778 - WLS patch
	36769312 - OWSM bundle Patch
	36747799 - OHS DB19c Native Patch
	36392269 - DB19c Client UPgrade for FMW 12.2.1.4


        set ORACLE_HOME=E:\XWEBLOGIC\middleware\Oracle_Home
        set PATH=%ORACLE_HOME%\bin;%PATH%
        set PATH=%ORACLE_HOME%\opatch;%path%
        set JAVA_HOME=E:\XWEBLOGIC\Java\jdk1.8.0_241
        set PATH=%JAVA_HOME%\bin;%PATH%

E:
cd E:\XWEBLOGIC\Softwares\Patches\WLS_SPB_12.2.1.4.240710\tools\opatch\generic\6880880
java -jar opatch_generic.jar -J-Doracle.installer.oh_admin_acl=true -silent oracle_home=E:\XWEBLOGIC\middleware\Oracle_Home

cd E:\XWEBLOGIC\Softwares\Patches\WLS_SPB_12.2.1.4.240710\binary_patches
opatch napply -report -oh E:\XWEBLOGIC\middleware\Oracle_Home -phBasefile windows64_patchlist.txt
opatch napply -oh E:\XWEBLOGIC\middleware\Oracle_Home -phBasefile windows64_patchlist.txt

cd E:\XWEBLOGIC\Softwares\Patches\36392269
sqlplus /nolog	--> Verify current client Version -->	19.14.0.0.0

    opatch rollback -id 35522383  [ 19.14 patchset coming with default ]
    opatch apply

sqlplus /nolog	--> Verify upgraded client Version -->	19.23.0.0.0

    ----------------------------------------------------------------------------------------------------

cd E:\XWEBLOGIC\Softwares\Patches\36769312
opatch apply

    ----------------------------------------------------------------------------------------------------

cd E:\XWEBLOGIC\Softwares\Patches\36747799
opatch appl

Oracle Aesthete

Sunday, 13 October 2024

Upgrade Forms/Report from 12.2.1.4 to 12.2.1.19

No comments:

Post a Comment

Popular Posts