WebUtil Configuration

 WebUtil Configuration


To configure WebUtil we have to configure a data source with the target database (in this case the target database is not the database we used for the RCU configuration)

Step 1 - Add the correct tns entries of the target database into the tnsnames.ora file of your app server.


[oracle@testserver-k ~]$ vi $ORACLE_HOME network/admin/tnsnames.ora

<tns-alias> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <ip-of-target>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <service-name-of-target-database>)
    )
  )


[oracle@testserver-k ~]$ tnsping <tns-alias>

Step 2 - Connect to the weblogic console to configure a jdbc data source.


http://<ip-address>:7001/console

Navigate to: Services > Data Sources

Select Lock & Edit and create a new Generic Data Source







You can select the necessary components that you need the data source to be configured to.


Save and Activate Changes

Step 3 - As the weblogic user run the 'setWLSEnv.sh' script.


[weblogic@testserver-k ~]$ cd /u01/app/oracle/product/12.2.1/wlserver/server/bin
[weblogic@testserver-k bin]$ source setWLSEnv.sh


Step 4 - Test whether you can connect to the target database from the app server.


[oracle@testserver-k ~]$ . oraenv
ORACLE_SID = [oracle] ? <rcu-db>
[oracle@testserver-k ~]$ sqlplus <user>/<password>@<target-db-ip>:1521/<target-db-SID>

Step 5 - Execute the create_webutil_db.sql script


SQL> @/u01/app/oracle/product/12.2.1/forms/create_webutil_db.sql

Step 6 - Download the Jacob file from the following link and transfer it to a location inside your server.



[weblogic@testserver-k SOFTWARES]$ unzip jacob-1.21.zip

Step 7 - Copy the files to the respective locations as follows


[weblogic@testserver-k softwares]$ cp -r jacob-1.21/jacob-1.21-x64.dll /u01/app/oracle/product/12.2.1/forms/webutil/win64/
[weblogic@testserver-k softwares]$ cp -r jacob-1.21/jacob-1.21-x86.dll /u01/app/oracle/product/12.2.1/forms/webutil/win32/
[weblogic@testserver-k softwares]$ cp -r jacob-1.21/jacob.jar /u01/app/oracle/product/12.2.1/forms/java/

Step 8 - Take a backup of the 'sign_webutil.sh' file


[weblogic@testserver-k ~]$ cd /u01/app/oracle/config/domains/frsdomain/config/fmwconfig/components/FORMS/instances/forms1/bin
[weblogic@testserver-k bin]$ cp sign_webutil.sh sign_webutil.sh_ORG

Step 9 - Append the following values into the 'sign_webutil.sh' file.


KEYSTORE_PASSWORD=<weblogic-password>
JAR_KEY_PASSWORD=<weblogic-password>

Step 10 - Sign the jacob.jar file


[weblogic@testserver-k bin]$ ./sign_webutil.sh /u01/app/oracle/product/12.2.1/forms/java/jacob-1.21/jacob.jar

/u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/keytool: No such file or directory
/u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/jarsigner: No such file or directory
)

To verify whether the signing was successful:

[weblogic@appsvruat bin]$ jarsigner -verify -verbose /U02/app/oracle/product/12.2.1/forms/java/jacob-1.21/jacob.jar

Step 11 - Edit the 'extensions.jnlp' file

[weblogic@testserver-k bin]$ cd /u01/app/oracle/product/12.2.1.3/forms/java/

[weblogic@testserver-k java]$ vi extensions.jnlp

FROM:

<!-- <jar href="jacob.jar"/> -->

TO:

<jar href="jacob.jar"/>

Step 12 - Add the following values below the webutil configuration in your formsweb.cfg file if they are not present.

[weblogic@testserver-k ~]$ cd /u01/app/oracle/config/domains/frsdomain/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_12.2.1/config/

[weblogic@testserver-k config]$ vi formsweb.cfg

[webutil]

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=on

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

archive=frmall.jar

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm


You have successfully conifgured WebUtil!

Follow the below guide to create a reports server:

Configuring a Reports Server in Oracle WebLogic Forms & Reports 12.2.1

Comments

Post a Comment

Popular posts from this blog

Installing Oracle Database 19c on Linux 8 (OL8) Server

Image
Installing Oracle Database 19c on Linux 8 (OL8) Server Step 1 - Install the Relevant Software Install the Oracle Database 19c Enterprise Edition 19.3.0.0.0 from Oracle Software Delivery Cloud or any other method you prefer. (If your server has an internet connection you can use the wget method to install the software) As a best practice create a separate directory named 'SOFTWARES' where you can move installation files. Step 2 - Add the following lines to the ' /etc/sysctl.conf ' file as root user. fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Step 3 - Add the following lines to a file called ' etc/security/lim...
Read more

Solution for [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck'

This error occurs when running an installation wizard in Oracle Linux 8.1 (OL8.1) servers. Edit file ' ORACLE_HOME/cv/admin/cvu_config ' and add a new line ' CV_ASSUME_DISTID=OEL8.1 ', followed by saving the file. [oracle@testserver-k ~]$ vi $ORACLE_HOME/cv/admin/cvu_config #CV_ASSUME_DISTID=OEL5 CV_ASSUME_DISTID=OEL8.1 [oracle@testserver-k ~]$  cat $ORACLE_HOME/cv/admin/cvu_config | grep -i CV_ASSUME_DISTID #CV_ASSUME_DISTID=OEL5 CV_ASSUME_DISTID=OEL8.1 Re-run the installer.
Read more

Graphical Display Not Appearing when Running Install Wizards - Linux

Graphical Display Not Appearing when Running Install Wizards 1. Use MobaXterm which has X display built in to it. 2. Check whether the X11Forwarding parameter is set to yes in the ' sshd_config ' file and restart it. [root@testserver-k ~]# vi /etc/ssh/sshd_config X11Forwarding yes [root@testserver-k ~]# systemctl restart sshd 3. Install the following dependencies. [root@testserver-k ~]# yum install xorg* [root@testserver-k ~]# yum install xclock (We can use xclock to verify if the graphical display works before executing the wizard) 4. Connect to the server directly through the user that is running the wizard not using 'sudo su -' or 'su -' 5. Export the display variable [oracle@testserver-k ~]$ export DISPLAY = :10 6. If the following error occurs do the below mentioned steps: [oracle@testserver-k ~]$ xclock MoTTY X11 proxy: No authorisation provided Error: Can't open display: localhost:10.0 Execute the following command and find a valid port for the displa...
Read more