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:/ 



Posted by 1 comment:
Labels: , ,

How to find out uncommitted transactions in oracle 19c

 

V$TRANSACTION lists the active transactions in the database


 Use following query to find out uncommitted active transactions in database

  

select t.start_time,a.sid,a.serial#,a.username,a.status,a.schemaname,

a.osuser,a.process,a.machine,a.terminal,a.program,a.module,to_char(a.logon_time,'DD/MON/YY HH24:MI:SS') logon_time

from v$transaction t, v$session a

where a.saddr = t.ses_addr

order by start_time;

 

 

To find out sql statement of uncommitted transaction

SELECT a.SID, a.SERIAL#, a.USERNAME, a.OSUSER, a.PROGRAM, a.EVENT

  ,TO_CHAR(a.LOGON_TIME,'YYYY-MM-DD HH24:MI:SS')

  ,TO_CHAR(T.START_DATE,'YYYY-MM-DD HH24:MI:SS')

  ,a.LAST_CALL_ET, a.BLOCKING_SESSION, a.STATUS

  ,(

    SELECT Q.SQL_TEXT

    FROM V$SQL Q

    WHERE Q.LAST_ACTIVE_TIME=T.START_DATE

    AND ROWNUM<=1) AS SQL_TEXT

FROM V$SESSION a,

  V$TRANSACTION T

WHERE a.SADDR = T.SES_ADDR;

.

 

To find out if your current session has any uncommitted transaction

SELECT COUNT(*) FROM v$transaction t, v$session s, v$mystat m WHERE t.ses_addr = s.saddr AND s.sid = m.sid AND ROWNUM = 1;

 

If the output is zero it means it has no uncommitted transaction.

If output is 1, it states session has uncommitted transactions.

Posted by No comments:
Labels: ,

Shell script to stop weblogic , forms, reports , ohs instance in 12.2.1.4

 

Create an env file with following details.

 Note: It is assumed that boot.properties file is configured with weblogic username and password. Otherwise the script will prompt for username and password.

cat /home/oracle/app_env

ORACLE_BASE=/d01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12.2.1.4; export ORACLE_HOME

MW_HOME=$ORACLE_HOME ; export MW_HOME

WLS_HOME=$MW_HOME/wlserver; export WLS_HOME

WL_HOME=$WLS_HOME  ;export WLS_HOME

DOMAIN_HOME=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain; export DOMAIN_HOME

JAVA_HOME=/usr/java/jdk1.8.0_231-amd64; export JAVA_HOME

export OHS_INST=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain/config/fmwconfig/components/OHS/instances/ohs1 ;export OHS_INST

PATH=$JAVA_HOME/bin:$PATH ; export PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export FORMS_PATH=/d01/app/oracle/product/12.2.1.4/forms; export FORMS_PATH

 

Here, ORACLE_BASE stands for oracle base

ORACLE_HOME stands for middleware home

MW_HOME also stands for middleware home

DOMAIN_HOME stands for domain home

OHS_INST stands for Oracle HTTP Server instance home

 

Now create shell script

vi stop_services.sh

# Start NodeManager

#!/bin/bash

. /home/oracle/app_env

 

echo "*************************Stopping Ohs Instance ********************************"

 

# Stop the web tier.

$DOMAIN_HOME/bin/stopComponent.sh ohs1

 

sleep 5

 

echo "*************************Stopping Standalone Report Server ********************************"

 

$DOMAIN_HOME/bin/stopComponent.sh rep_server1_prod

 

sleep 5

echo "*************************Stopping Forms Services ********************************"

 

# Stop the managed Servers

$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS

 

sleep 5

 

echo "*************************Stopping Reports Services ********************************"

 

$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS

 

sleep 5

 

echo "*************************Stopping WebLogic********************************"

 

# Stop the WebLogic Domain

$DOMAIN_HOME/bin/stopWebLogic.sh

 

sleep 5

echo "*************************Stopping NodeManager********************************"

 

$DOMAIN_HOME/bin/stopNodeManager.sh

 

echo "*************************All Services are stopped now!********************************"

 

 

Posted by No comments:
Labels: , ,

Shell script to start weblogic , forms, reports , ohs instance in 12.2.1.4

Create an env file with following details.

 Note: It is assumed that boot.properties file is configured with weblogic username and password. Otherwise the script will prompt for username and password.

cat /home/oracle/app_env

ORACLE_BASE=/d01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12.2.1.4; export ORACLE_HOME

MW_HOME=$ORACLE_HOME ; export MW_HOME

WLS_HOME=$MW_HOME/wlserver; export WLS_HOME

WL_HOME=$WLS_HOME  ;export WLS_HOME

DOMAIN_HOME=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain; export DOMAIN_HOME

JAVA_HOME=/usr/java/jdk1.8.0_231-amd64; export JAVA_HOME

export OHS_INST=/d01/app/oracle/product/12.2.1.4/user_projects/domains/prod_domain/config/fmwconfig/components/OHS/instances/ohs1 ;export OHS_INST

PATH=$JAVA_HOME/bin:$PATH ; export PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export FORMS_PATH=/d01/app/oracle/product/12.2.1.4/forms; export FORMS_PATH

 

Here, ORACLE_BASE stands for oracle base

ORACLE_HOME stands for middleware home

MW_HOME also stands for middleware home

DOMAIN_HOME stands for domain home

OHS_INST stands for Oracle HTTP Server instance home

 

Now create shell script

vi start_services.sh

# Start NodeManager

#!/bin/bash

. /home/oracle/app_env

echo "*************************Starting NodeManager********************************"

nohup $DOMAIN_HOME/bin/startNodeManager.sh > /dev/null 2>&1 &

 

sleep 10

echo "*************************Starting WebLogic********************************"

 

# Start WebLogic Domain

nohup $DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 &

 

sleep 60

 

echo "*************************Starting Forms Services ********************************"

 

# Start the managed Servers

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_FORMS > /dev/null 2>&1 &

 

sleep 10

 

echo "*************************Starting Reports Services ********************************"

 

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS > /dev/null 2>&1 &

 

sleep 10

 

echo "*************************Starting Ohs Instance ********************************"

 

# Start the web tier.

$DOMAIN_HOME/bin/startComponent.sh ohs1 > /dev/null 2>&1 &

 

sleep 10

 

echo "*************************Starting Standalone Report Server ********************************"

 

$DOMAIN_HOME/bin/startComponent.sh rep_server1_prod > /dev/null 2>&1 &

 

sleep 10

 

echo "*************************All Services are running. Run this url to check http://192.168.23.12:9001/forms/frmservlet?config=cspprd ********************************"


#chmod 775  start_services.sh


Posted by No comments:
Labels: , ,
Subscribe to: Posts (Atom)