Autoupgrade fails with error unable to open file LOGIN.SQL

 Recently I faced one error while upgrading oracle database 11.2.0.4 to 19.3.0 using auto upgrade utility.

I checked the status of the job and found it was errored out.

So I quickly gone through the log files as mentioned in above and found few error messages like

2021-12-09 20:27:53.940 ERROR Database Upgrade Error in File [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl6.log] on Database [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl6.log] - CatctlThread.catctl

2021-12-09 20:27:54.202 ERROR

DATABASE NAME: orcl

         CAUSE: ERROR at Line 58498 in [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl7.log]

        REASON: SP2-0310: unable to open file "LOGIN.SQL"

        ACTION: [MANUAL]

        DETAILS:   - CheckForErrors.checkForErrors

Solution:-

Perform the below solution:

1. Set SQLPATH (and ORACLE_PATH) variable to desired directory path.

2. Move login.sql to the directory defined in SQLPATH (and ORACLE_PATH)

NOTE: If you do not have a login.sql file, then perform any ONE of the following :

a. if you have a backup of the original installation, check there and see if you can retrieve the login.sql if it existed.

-or-

b. try obtaining it from another similar/like installation and modify if needed.

-or-

c. create one:

 

Reference:- SP2-0310: Unable To Open File "LOGIN.SQL"(Doc ID 2277751.1)

How to determine if any certificates used by the OMS in OEM 13c

 

How to determine if any certificates used by the OMS

 

1.Run the command below to check the status of the OMS and gather its details for hostnames and ports and SLB/virtual hostname details

Login to OMS server

$export ORACLE_HOME=<%MIDDLEWARE_HOME%>
Example:
$export ORACLE_HOME= /data2/app/oracle/middleware

[oem@ccuine25 middleware]$ cd $ORACLE_HOME/bin

[oem@ccuine25 bin]$ ./emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 5 Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host        : ccuine25.xyz.co.in HTTP Console Port          : 7788 HTTPS Console Port         : 7803 HTTP Upload Port           : 4889 HTTPS Upload Port          : 4903 EM Instance Home           : /data2/app/oracle/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /data2/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://ccuine25.xyz.co.in:7803/em Upload URL: https://ccuine25.xyz.co.in:4903/empbs/upload   WLS Domain Information Domain Name            : GCDomain Admin Server Host      : ccuine25.xyz.co.in Admin Server HTTPS Port: 7102 Admin Server is RUNNING   Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: ccuine25.xyz.co.in WebTier is Up Oracle Management Server is Up JVMD Engine is Up

 

 

 

 

 2. If the OMS is running, then the certificates used by the OMS can be checked using any of the below procedures.

 

2a.    Verifying with "emctl secdiag" command.
    
        In Issuer field, if it is showing the OMS hostname and the certificate validity is 10 years, then it is Domo certificate.
To verify,

[oem@ccuine25 bin]$ ./emctl secdiag openurl -url https://ccuine25.xyz.co.in:4903/empbs/upload Oracle Enterprise Manager Cloud Control 13c Release 5 Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.   Log file: /tmp/OpenPage_2021_12_06_13_23_497868447601063284563.log   Opening page: https://ccuine25.xyz.co.in:4903/empbs/upload Using non-validating trust manager; all certificates will be blindly accepted. Proxy server is not set Using protocol: TLSv1   Negotiated protocol: TLSv1   Getting the certificate chain   Details of cert# 1 in chain: Subject: CN=ccuine25.xyz.co.in Issuer: CN=ccuine25.xyz.co.in, C=US, ST=CA, L=EnterpriseManager on ccuine25.xyz.co.in, OU=EnterpriseManager on ccuine25.xyz.co.in, O=EnterpriseManager on ccuine25.xyz.co.in Valid from: Fri Nov 26 12:23:32 IST 2021 Valid till: Tue Nov 25 12:23:32 IST 2031 Serial#: -1562215274281161665 Public key: Sun RSA public key, 1024 bits   params: null   modulus: 115776305526868774367344434524839482517685951325472324400167322766776075414308990760886761862848426323857328397387316124782891769368223780434083793913289701480931965560434252568637538653810794338946757805777495146784750664597087203172476664248076937258722119323874400428320431663792757454380232885358450306227   public exponent: 65537 Signature algorithm: SHA512withRSA   Details of cert# 2 in chain: Subject: CN=ccuine25.xyz.co.in, C=US, ST=CA, L=EnterpriseManager on ccuine25.xyz.co.in, OU=EnterpriseManager on ccuine25.xyz.co.in, O=EnterpriseManager on ccuine25.xyz.co.in Issuer: CN=ccuine25.xyz.co.in, C=US, ST=CA, L=EnterpriseManager on ccuine25.xyz.co.in, OU=EnterpriseManager on ccuine25.xyz.co.in, O=EnterpriseManager on ccuine25.xyz.co.in Valid from: Fri Nov 26 12:23:32 IST 2021 Valid till: Tue Nov 25 12:23:32 IST 2031 Serial#: 28927599574933379200 Public key: Sun RSA public key, 1024 bits   params: null   modulus: 137261211539843504670622418187766808702599679284971506435071556027263289359546098536039368340742298948567040033910861434050027205919002583115809760212060733257289863786523160874210003867026089884047769780727525741437911092772616647738894839923266126650810544284334240152637157515395133646710028090924769802959   public exponent: 65537 Signature algorithm: SHA512withRSA   Following headers are present in the response: Date : Mon, 06 Dec 2021 07:53:50 GMT X-ORACLE-DMS-RID : 0:1:1 Content-Length : 305 X-Content-Type-Options : nosniff X-XSS-Protection : 1; mode=block X-ORACLE-DMS-ECID : 6e4738a3-125a-4155-99a6-cf6ce1401fe0-00000002 X-ORCL-EMOA : true Content-Type : text/html     Response saved at : /tmp/ccuine25.xyz.co.in_4903_2021_12_06_13_23_507464916505254990497.html

In the above output we can see the hostname of OMS server and certificates’validy is of 10 years. This confirms OMS server uses a demo certificate.  

2b. We can also verify using “openssl ” command

 In Issuer field with i:, if it is showing the OMS hostname and the certificate then it is Domo certificate.

[oem@ccuine25 bin]$ openssl s_client -connect ccuine25.xyz.co.in:4903 CONNECTED(00000003) depth=1 O = EnterpriseManager on ccuine25.xyz.co.in, OU = EnterpriseManager on ccuine25.xyz.co.in, L = EnterpriseManager on ccuine25.xyz.co.in, ST = CA, C = US, CN = ccuine25.xyz.co.in verify error:num=19:self signed certificate in certificate chain --- Certificate chain  0 s:/CN=ccuine25.xyz.co.in    i:/O=EnterpriseManager on ccuine25.xyz.co.in/OU=EnterpriseManager on ccuine25.xyz.co.in/L=EnterpriseManager on ccuine25.xyz.co.in/ST=CA/C=US/CN=ccuine25.xyz.co.in  1 s:/O=EnterpriseManager on ccuine25.xyz.co.in/OU=EnterpriseManager on ccuine25.xyz.co.in/L=EnterpriseManager on ccuine25.xyz.co.in/ST=CA/C=US/CN=ccuine25.xyz.co.in    i:/O=EnterpriseManager on ccuine25.xyz.co.in/OU=EnterpriseManager on ccuine25.xyz.co.in/L=EnterpriseManager on ccuine25.xyz.co.in/ST=CA/C=US/CN=ccuine25.xyz.co.in --- Server certificate -----BEGIN CERTIFICATE----- MIICwTCCAiqgAwIBAgII6lHlfCnILD8wDQYJKoZIhvcNAQENBQAwgeExNTAzBgNV BAoTLEVudGVycHJpc2VNYW5hZ2VyIG9uIGNjdWluZTI1LmV2ZXJlYWR5LmNvLmlu MTUwMwYDVQQLEyxFbnRlcnByaXNlTWFuYWdlciBvbiBjY3VpbmUyNS5ldmVyZWFk eS5jby5pbjE1MDMGA1UEBxMsRW50ZXJwcmlzZU1hbmFnZXIgb24gY2N1aW5lMjUu ZXZlcmVhZHkuY28uaW4xCzAJBgNVBAgTAkNBMQswCQYDVQQGEwJVUzEgMB4GA1UE AxMXY2N1aW5lMjUuZXZlcmVhZHkuY28uaW4wHhcNMjExMTI2MDY1MzMyWhcNMzEx MTI1MDY1MzMyWjAiMSAwHgYDVQQDFBdjY3VpbmUyNS5ldmVyZWFkeS5jby5pbjCB nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEApN71Yh+N2IJXKw2LUApvpzVqG979 G1xKxqmZui/F6Acwz+cfdmBjzqfR5OwRoEHjnpEvnqVQLczAWL3Wb7jcFmDA9X0i Rw83zh7nyN0O830NSjEIJPwQ5NRRX6o7+QgZhNZzXUPz4/1hViISS3rw2Ct2Zp1J 8FuWrVrYMcUB7LMCAwEAAaNAMD4wDAYDVR0TAQH/BAIwADAPBgNVHQ8BAf8EBQMD B+gAMB0GA1UdDgQWBBTIGix4h0S0W22LzqNX21Vvh4j0ajANBgkqhkiG9w0BAQ0F AAOBgQBqCQbGKb+so6mXmtyoWvJ9w4gr8r5HKTShW03DGMokspZ2wFXKf/7/0XKs dom19rMwhzTjYFyLVxPpF2JaeQw2je9o0RwmNHI5YdHaCB66hdcwb4xK8e5NrmcU f6TH/V5wAHQqvZMiJseyKa6w/LNDegAysBAX2FJ13FSyki8BZA== -----END CERTIFICATE----- subject=/CN=ccuine25.xyz.co.in issuer=/O=EnterpriseManager on ccuine25.xyz.co.in/OU=EnterpriseManager on ccuine25.xyz.co.in/L=EnterpriseManager on ccuine25.xyz.co.in/ST=CA/C=US/CN=ccuine25.xyz.co.in --- No client certificate CA names sent Peer signing digest: SHA384 Server Temp Key: ECDH, P-256, 256 bits --- SSL handshake has read 1957 bytes and written 415 bytes --- New, TLSv1/SSLv3, Cipher is ECDHE-RSA-AES256-GCM-SHA384 Server public key is 1024 bit Secure Renegotiation IS supported Compression: NONE Expansion: NONE No ALPN negotiated SSL-Session:     Protocol  : TLSv1.2     Cipher    : ECDHE-RSA-AES256-GCM-SHA384     Session-ID: CD135D17211057A2A2C8D090D6A539295AD8A463A48048ABF4102D16032F7C3D     Session-ID-ctx:     Master-Key: 77B489903B3E69A8ED19AC202FDB96F77905B85FB22EE76386CE9A6C46EC925427E453F2FED2B07889B833A294EBECF6     Key-Arg   : None     Krb5 Principal: None     PSK identity: None     PSK identity hint: None     Start Time: 1638777708     Timeout   : 300 (sec)     Verify return code: 19 (self signed certificate in certificate chain) --- closed

 

 

2c.   Verifying the existing certificates are using SAN or not.
    
        If there is no SAN certificate below command will not return any results.

[oem@ccuine25 bin]$ openssl s_client -connect ccuine25.xyz.co.in:4903 </dev/null 2>/dev/null | openssl x509 -noout -text | grep DNS

 

      If  SAN certificates in use below command will return results like.

$ openssl s_client -connect <OMS_HOSTNAME>.<DOMAIN_NAME>:4903  </dev/null 2>/dev/null | openssl x509 -noout -text | grep DNS         DNS:<OMS_HOSTNAME>.<DOMAIN_NAME>, DNS:<OMS_HOSTNAME2>.<DOMAIN_NAME>, DNS:<SLBOMS_HOSTNAME>.<DOMAIN_NAME>

 

3.    If the OMS is not running, you can check the certificates used by the OMS by reading the contents of the wallet used by the OMS.

    If the Trusted certificate Subject is shows OMS hostname  then it is Domo certificate.

export OMS_INST= /data2/app/oracle/gc_inst cd $ORACLE_HOME/oracle_common/bin [oem@ccuine25 bin]$./orapki wallet display -wallet $OMS_INST/user_projects/domains/GCDomain/config/fmwconfig/components/OHS/ohs1/keystores/upload/ -summary   Oracle PKI Tool : Version 12.2.1.4.0 Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.   Requested Certificates: User Certificates: Subject:        CN=ccuine25.xyz.co.in Trusted Certificates: Subject:        CN=ccuine25.xyz.co.in,C=US,ST=CA,L=EnterpriseManager on ccuine25.xyz.co.in,OU=EnterpriseManager on ccuine25.xyz.co.in,O=EnterpriseManager on ccuine25.xyz.co.in

 

How to mitigate the impact associated with CVE-2021-44228 and CVE-2021-45046 on Oracle Fusion Middleware 12.2.1.4

Recently in Dec2021, a vulnerability was found in Log4j, an open-source logging library commonly used by apps and services across the internet. This vulnerability has shaken the entire world. To mitigate this vulnerability in Oracle Fusion Middleware, Oracle recommends to apply following patches .

Download following patches for WLS Release 12.2.1.4

1.    Download latest Opatch for WLS 28186730

2.    For the WLS and FMW Infrastructure, if you have not been applying quarterly security updates, Coherence Patch 33286160 is a prerequisite.

3.    WLS PATCH SET UPDATE 12.2.1.4.210930 (Patch 33416868)

4.    WLS OVERLAY PATCH FOR 12.2.1.4.0 OCT 2021 PSU (Patch 33671996) for CVE-2021-44228,CVE-2021-45046

I will be applying these patches in windows environment.

SET ORACLE_HOME=D:\app\oracle\product\12.2.1.4

Set JAVA_HOME=D:\app\oracle\jdk

Apply patch 28186730 - This patch installs latest version of Opatch for FMW/WLS

D:\app\oracle\product\12.2.1.4\OPatch>%java_home%\bin\java -jar C:\Users\Administrator\Downloads\6880880\opatch_generic.jar -silent oracle_home=D:\app\oracle\product\12.2.1.4   Launcher log file is C:\Users\Administrator\AppData\Local\Temp\1\OraInstall2021-12-19_05-06-36PM\launcher2021-12-19_05-06-36PM.log. Extracting the installer . . . . Done Checking if CPU speed is above 300 MHz.   Actual 2400    Passed Checking swap space: must be greater than 512 MB    Passed Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required) Checking temp space: must be greater than 300 MB.   Actual 272082 MB    Passed Preparing to launch the Oracle Universal Installer from C:\Users\Administrator\AppData\Local\Temp\1\OraInstall2021-12-19_05-06-36PM Installation Summary …. …. …. The install operation completed successfully.   Logs successfully copied to C:\Program Files\Oracle\Inventory\logs.

Shutdown entire application services(Nodemanager , Weblogic , FORMS, Reports, OHS etc)

Navigate to patch location and apply the patch

unzip p33286160_1221411_Generic.zip

List out the installed components to see the installed Coherence version   C:\Users\Administrator>%ORACLE_HOME%/OPatch/opatch.bat lsinventory -jdk %JAVA_HOME% -inactive Oracle Interim Patch Installer version 13.9.4.2.1 Copyright (c) 2021, Oracle Corporation.  All rights reserved.     Oracle Home       : D:\app\oracle\product\12.2.1.4 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 13.9.4.2.1 OUI version       : 13.9.4.0.0 Log file location : D:\app\oracle\product\12.2.1.4\cfgtoollogs\opatch\opatch2021-12-19_16-18-03PM_1.log     OPatch detects the Middleware Home as "D:\app\oracle\product\12.2.1.4"   Lsinventory Output file location : D:\app\oracle\product\12.2.1.4\cfgtoollogs\opatch\lsinv\lsinventory2021-12-19_16-18-03PM.txt   -------------------------------------------------------------------------------- Local Machine Information:: Hostname: CSAPP2 ARU platform id: 233 ARU platform description:: Microsoft Windows Server 2003 (64-bit AMD)     There are no inactive patches installed in this Oracle Home.   --------------------------------------------------------------------------------   OPatch succeeded.

cd C:\Users\Administrator\Downloads C:\Users\Administrator\Downloads>%ORACLE_HOME%/OPatch/opatch apply 1221411 -jdk %JAVA_HOME% Oracle Interim Patch Installer version 13.9.4.2.1 Copyright (c) 2021, Oracle Corporation.  All rights reserved.     Oracle Home       : D:\app\oracle\product\12.2.1.4 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 13.9.4.2.1 OUI version       : 13.9.4.0.0 Log file location : D:\app\oracle\product\12.2.1.4\cfgtoollogs\opatch\opatch2021-12-19_16-22-18PM_1.log     OPatch detects the Middleware Home as "D:\app\oracle\product\12.2.1.4"   Verifying environment and performing prerequisite checks... OPatch continues with these patches:   1221411   Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Backing up files... Applying interim patch '1221411' to OH 'D:\app\oracle\product\12.2.1.4'   Patching component oracle.coherence, 12.2.1.4.0... Patch 1221411 successfully applied. Log file location: D:\app\oracle\product\12.2.1.4\cfgtoollogs\opatch\opatch2021-12-19_16-22-18PM_1.log   OPatch succeeded.

Unzip patch 33416868

Apply patch

C:\Users\Administrator\Downloads>%ORACLE_HOME%/OPatch/opatch apply 33416868 -jdk %JAVA_HOME%

 

Unzip patch 33671996

 Apply patch

cd C:\Users\Administrator\Downloads\33671996 %ORACLE_HOME%/OPatch/opatch apply

 

Mitigation Plan 

If patching is not possible at this time, you may mitigate the Log4j vulnerabilities with the below steps. This mitigation applies to Log4j v2 prior to 2.16.0, including 2.15. 1. Navigate to the location: ORACLE_HOME/oracle_common/modules/thirdparty/  2. Run the below command for the installed Log4j version 2 files: 12.2.1.3.0: log4j-1.2.17.jar - This is expected to contain a version 2 file 12.2.1.4.0: log4j-2.11.1.jar 14.1.1.0.0: log4j-core-2.11.1.jar and log4j-api-2.11.0.jar Unix: zip -q -d log4j*.jar org/apache/logging/log4j/core/lookup/JndiLookup.class Windows:  Use a zip utility to extract the contents as a .zip, remove JndiLookup.class, and re-zip.

Reference:-Security Alert CVE-2021-44228 / CVE-2021-45046 Patch Availability Document for Oracle WebLogic Server & Fusion Middleware (Doc ID 2827793.1)

The “visiblepw” is not set the sudoers file and as a result, the user will not be able to run sudo over ssh

While installing agent in target host for oracle enterprise manager 13c, following error is observed

Solution:-

This issue has two different solutions

1.       Change the entry “Defaults !visiblepw” to “Defaults visiblepw” in the /etc/sudoers file and re-try Agent Deployment. This needs to be done in host server.

2. You can also set the "oracle.sysman.prov.agentpush.enablePty" property to true in the "/data2/app/oracle/middleware/sysman/prov/agentpush/agentpush.properties" file, which is present on the OMS host,

And  pass -S argument to the sudo command

 /usr/bin/sudo -S -u %RUNAS% %COMMAND%

Now retry again the agent deployment , this time it should succeed. 

Enterprise manager 13c: Error During Agent Installation

While installing agent in target host for oracle enterprise manager 13c, following error is observed

EM 12c, 13c: Error During Agent Installation : Ensure central inventory is owned by install user, has read and write permission

Solution:-

Make sure in inventory_loc in /etc/oraInst.loc file points to a valid inventory location and it is writable by the installing user in the  target host server.

inventory_loc=/DEV/R12DEV/db/tech_st/19.3.0/oraInventory

where <valid inventory location> must be writable by the installing user. 

 

SQL Query to get details of a concurrent process in EBS R12.1.3

 To get forms process id first.

SQL> SET LINES 222

SQL> col MODULE for a40

SQL> col ACTION for a40

select sid,serial#,process,module,action from v$session where process=(SELECT p.os_process_id FROM FND_CONCURRENT_REQUESTS r, FND_CONCURRENT_PROCESSES p 

where r.controlling_manager = p.concurrent_process_id and request_id=211503612)

To get more details of process id and command kill that session:-

select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier , ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram , 'alter system kill session ' || '''' || s.SID || ',' || s.serial# ||',@'|| s.inst_id||''''|| ' immediate;' kill_session from gv$session s ,gv$process p where s.process='32488'  --forms OS process ID --s.program like '%frm%' and p.addr=s.paddr and p.inst_id = s.inst_id ;

How to configure webutil in forms 12.2.1.4

 

1.       Create webutil schema

SQL> create user webutil identified by Concept_ora1;

SQL> grant dba to webutil;

 

Login to application server, and connect to sqlplus

 Cd D:\app\oracle\product\12.2.1.4\bin

D:\weblogic\Middleware\12.2.1.4\bin>sqlplus webutil@PRDPDB

 

SQL> @D:\app\oracle\product\12.2.1.4\forms\create_webutil_db.sql

SQL> create public synonym webutil_db for webutil.webutil_db;

 

2.       Download the jacob version 1.2 and unzip it in the directory of your choice - https://github.com/freemansoft/jacob-project/releases

 

unzip jacob-1.20.zip

cd jacob-1.20

copy Jacob.jar D:\app\oracle\product\12.2.1.4\forms\java\

copy jacob-1.20-x86.dll D:\app\oracle\product\12.2.1.4\forms\webutil\win32

copy jacob-1.20-x64.dll D:\app\oracle\product\12.2.1.4\forms\webutil\win64

 

edit below file

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\bin\sign_webutil.bat

 

replace “D:\app\oracle\product\12.2.1.4\jdk\bin” with “D:\app\oracle\product\12.2.1.4\oracle_common\jdk\bin”

and edit following parameters

SET JAR_KEY_PASSWORD=xyz123

SET KEYSTORE_PASSWORD=xyz123

SET VALIDDAYS=3600

 

Use sign_webutil.bat to sign Jacob.jar using following command:

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\bin\sign_webutil.bat D:\app\oracle\product\12.2.1.4\forms\java\jacob.jar

 

3.       Download webutil_demo form from the following link and place the webutil_demo.fmb form in the path D:\app\oracle\product\12.2.1.4\forms

https://www.dropbox.com/s/mdkhjh7997r8arh/webutil_demo.fmb?dl=0

 

4.     Compile webutil.pll to create webutil.plx

 

Open forms compiler

D:\app\oracle\product\12.2.1.4\bin\frmcmp.exe

Navigate to path D:\app\oracle\product\12.2.1.4\forms

 and compile webutil_demo.fmb

Double click on webutil_demo.fmb and connect to database and compile forms.

 

1.       Make the following modifications to the [webutil] configuration of the formsweb.cfg file,

Edit formsweb.cfg in

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

 

In [default]

section search for archive and add Jacob.jar , frmwebutil.jar

archive=frmall.jar,frmwebutil.jar,jacob.jar

[wutil]

WebUtilArchive=frmwebutil.jar,jacob.jar

baseSAAfile=webutilsaa.txt

archive=frmall.jar,jacob.jar,frmwebutil.jar

form=D:\app\oracle\product\12.2.1.4\forms\webutil_demo.fmx

WebUtilMaxTransferSize=24573

 

5.       Modify webutil.cfg file

In following location D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\components\FORMS\instances\forms1\server

 

Change following parameters

 

transfer.database.enabled=FALSE

to

transfer.database.enabled=TRUE

 

transfer.appsrv.enabled=FALSE

to

transfer.appsrv.enabled=TRUE

 

transfer.appsrv.accessControl=TRUE

to

transfer.appsrv.accessControl=FALSE

 

 

Also change following ,

From

install.syslib.0.0.7.1=jacob-1.18-M2-x86.dll|167424|1.18-M2|true

To

install.syslib.0.0.7.1=jacob-1.20-x86.dll|189440|1.20|true

 

From

install.syslib.0.1.7.1=jacob-1.18-M2-x64.dll|204800|1.18-M2|true

To

install.syslib.0.1.7.1=jacob-1.20-x64.dll|227328|1.20|true

 

 transfer.appsrv.read.1=c:\temp

#List transfer.appsrv.write.<n> directories

transfer.appsrv.write.1=c:\temp

Note: verify name, size  ,version of jacob-1.18-M2-x64.dll and jacob-1.18-M2-x86.dll. 

 

Edit default.env in

D:\app\oracle\product\12.2.1.4\user_projects\domains\prd\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

and add following in CLASSPATH variable in following location

 CLASSPATH= D:\app\oracle\product\12.2.1.4\forms\java\jacob.jar

 

Open webutil form from browser.

Note: Make sure end user has jre 1.8 32bit installed to open the form window without any issue.

URL: http://csapp2:9001/forms/frmservlet?config=wutil

 

Provide username:webtuil

Password: xyz123

Database: PRDPDB

 

If DOWNLOAD/UPLOAD features don’t work,

open the webutil_demo.fmb through forms compiler and check program units section.

Look for DOWNLOAD_AS and UPLOAD_AS section and make sure its path is pointing to c:/temp path and temp directory exists inside C:/