Steps to configure WebUtil in your 12c Forms installation.
1. Execute create_webutil_db.sql located in the ORACLE_HOME/forms directory against the application schema in your database.
Ex.
cd /u01/app/oracle/product/12.2.1.3/forms
cat /etc/oratab
------------
#
#
ABC:/u01/app/oracle/product/12.2.0/dbhome_1:N
[oracle@antiquity-app fmwconfig]$ . oraenv
ORACLE_SID = [ABC] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@antiquity-app fmwconfig]$ sqlplus abc/abc@XXX
SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 27 03:24:03 2023
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Wed Sep 27 2023 03:22:55 +00:00
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL>
SQL> @create_webutil_db.sql;
Package created.
Package body created.
-------------------
Disconnected from Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
[oracle@antiquity-app forms]$
------------
2. Download the Jacob file and copy to the server.
https://github.com/freemansoft/jacob-project/releases
3. Unzip the Jacob
[oracle@antiquity-app jacob-1.18]$ unzip jacob-1.18.zip
[oracle@antiquity-app jacob-1.18]$ ll
total 456
drwxr-xr-x. 3 oracle oinstall 4096 Apr 11 2012 docs
-rw-r--r--. 1 oracle oinstall 205312 Aug 5 2015 jacob-1.18-x64.dll
-rw-r--r--. 1 oracle oinstall 167936 Aug 5 2015 jacob-1.18-x86.dll
-rw-r--r--. 1 oracle oinstall 49231 Aug 5 2015 jacob.jar
-rw-r--r--. 1 oracle oinstall 26944 Sep 11 2008 LICENSE.TXT
-rw-r--r--. 1 oracle oinstall 519 Nov 6 2010 README.txt
[oracle@antiquity-app jacob-1.18]$
4. Copy the files to your respective locations as follows.
[oracle@antiquity-app jacob-1.18]$ cp jacob-1.18-x64.dll /u01/app/oracle/product/12.2.1.3/forms/webutil/win64/
[oracle@antiquity-app jacob-1.18]$ cp jacob-1.18-x86.dll /u01/app/oracle/product/12.2.1.3/forms/webutil/win32/
[oracle@antiquity-app jacob-1.18]$ cp jacob.jar /u01/app/oracle/product/12.2.1.3/forms/java
[oracle@antiquity-app jacob-1.18]$
5. Take a backup of your respective sign_webutil.sh file.
Ex.
[oracle@antiquity-app jacob-1.18]$ cd /u01/app/oracle/product/12.2.1.3/user_projects/domains/base_domain/config/fmwconfig/components/FORMS/instances/forms1/bin/
[oracle@antiquity-app bin]$ cp sign_webutil.sh sign_webutil.sh_ORG
6. Amend the values as below in the sign_webutil.sh file.
• weblogic123 is the password of the weblogic
KEYSTORE_PASSWORD=weblogic123
JAR_KEY_PASSWORD=weblogic123
error_text=`/home/oracle/jdk1.6.0_34/bin/keytool -genkey -dname "CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C" \
-alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \
-storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS`
error_text=`/home/oracle/jdk1.6.0_34/bin/jarsigner -keystore $KEYSTORE -storepass $KEYSTORE_PASSWORD -keypass $JAR_KEY_PASSWORD \
$1 $JAR_KEY`
7. sign the Jacob.jar file.
[oracle@antiquity-app bin]$ ./sign_webutil.sh /u01/app/oracle/product/12.2.1.3/forms/java/jacob.jar
WARNING:
Self-signing Jar files is no longer recommended.
Jar files should be digitally signed using a trusted certificate.
Generating a self signing certificate for key=webutil2...
...successfully done.
\n
Backing up /u01/app/oracle/product/12.2.1.3/forms/java/jacob.jar as /u01/app/oracle/product/12.2.1.3/forms/java/jacob.jar.old...
\n
Signing /u01/app/oracle/product/12.2.1.3/forms/java/jacob.jar using key=webutil2...
...successfully done.
[oracle@antiquity-app bin]$
8. sign the frmwebutil.jar
[oracle@antiquity-app bin]$ ./sign_webutil.sh /u01/app/oracle/product/12.2.1.3/forms/java/frmwebutil.jar
WARNING:
Self-signing Jar files is no longer recommended.
Jar files should be digitally signed using a trusted certificate.
Generating a self signing certificate for key=webutil2...
Warning: webutil2 already present in /home/oracle/.keystore
\n
Backing up /u01/app/oracle/product/12.2.1.3/forms/java/frmwebutil.jar as /u01/app/oracle/product/12.2.1.3/forms/java/frmwebutil.jar.old...
\n
Signing /u01/app/oracle/product/12.2.1.3/forms/java/frmwebutil.jar using key=webutil2...
...successfully done.
[oracle@antiquity-app bin]$
9. Amend the extensions.jnlp file in the /u01/app/oracle/product/12.2.1.3/forms/java/
Location as follows.
From : <!-- <jar href="jacob.jar"/> -->
To : <jar href="jacob.jar"/>
10. Add the values as follows to the formsweb.cfg file under your forms URL configuration.
WebUtilArchive=frmwebutil.jar,jacob.jar
basejnlp=webutil.jnlp
11. Check the URL functionality.
No comments:
Post a Comment