Oracle World

FORM Compilation UAT to PROD à Copy the given FMB file from UAT to PROD. Goto à AU_TOP/forms /d03/UATAPPL/apps/apps_st/appl/au/12.0.0/forms/US à Uat form location. Copy the .fmb file to PROD. Now à goto PROD. Form location à Cd /ProdApp/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US From root Change the ownership and permission to .fmb file. Chmod –R 777 .fmb Chown –R applprod:dba Su – applprod Now run the form compilation command from AU_TOP/forms Location only In PROD frmcmp_batch userid=apps/oracledba1 module=XXLTCEL_IOT.fmb output_file=$XXLTK_TOP/forms/US/XXLTCEL_IOT.fmx module_type=form batch=no compile_all=yes IN UAT frmcmp_batch userid=apps/apps module=XXLTK_ORDER_SHIP_BILL_DETAILS.fmb output_file=$XXLTK_TOP/forms/US/XXLTK_ORDER_SHIP_BILL_DETAILS.fmx module_type=form batch=no compile_all=yes .Pll file compilation: à [appldev@ltk1 resource]$ ls -ltr JAINTPTY.pll - rwxr-xr-x. 1 appldev dba 147456 Jun 15 08:06 JAINTPTY.pll [applde...

 Changing Weblogic Password in R12.2 Environment.  *Login to primary application Node.  goto cd $FND_TOP/patch/115/bin and run below command. [applmgr@sreeniapps bin]$ perl txkUpdateEBSDomain.pl action=updateAdminPassword Program: txkUpdateEBSDomain.pl started at Thu May  4 21:52:00 2023 AdminServer will be re started after changing WebLogic Admin Password All Mid Tier services should be SHUTDOWN before changing WebLogic Admin Password Confirm if all Mid Tier services are in SHUTDOWN state. Enter "Yes" to proceed or anything else to exit: yes Enter the full path of Applications Context File [DEFAULT - /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/appl/admin/VIS_valiapps.xml]: Enter the WLS Admin Password: Enter the new WLS Admin Password: Enter the APPS user password: Executing: /u01/oracle/VIS/fs2/FMW_Home/webtier/perl/bin/perl /u01/oracle/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl  ebs-get-serverstatus -contextfile=/u01/oracle/VIS/fs2/inst/app...

2.1.1 Steps to Activate Forms Trace using Application Profiles Note:  Forms Trace should only be activated as and when required, and for specific users. Forms Level Activation Sign on to Oracle Applications as a user with the  System Administrator  responsibility. Select the  System Administrator  responsibility. Select the  Profile  ->  System  function (this will launch Forms). Search for the Applications user and the profile option  Forms Runtime Parameters . Add the required parameters, using the syntax:  record=forms tracegroup=<value(s)> . Examples: record=forms tracegroup=0-97 record=forms tracegroup=medium Note the space between the parameter/value pairs. Commit the changes and log out of Applications. Log in to Applications as the user whose  Forms Runtime Parameters  profile option was amended. The forms trace file will be written to the  $FORMS_TRACE_DIR  directory. By default...

Application startup and shutdown scripts [sreenidba@sreenidba scripts]$  cd $ADMIN_SCRIPTS_HOME 1.adalnctl.sh   2.adautocfg.sh         3.adformsctl.sh    4.adoacorectl.sh   5.adopmnctl.sh    6.adstpall.sh  7.adapcctl.sh   8.adcmctl.sh      9.adformsrvctl.sh  10.adoafmctl.sh     11.adpreclone.pl   12.adstrtal.sh  1.adalnctl.sh  : script used to start the application listener services. logfile located in LOG_HOME or INST_TOP/admin/log adalnctl.txt To know the status of apps listner  [sreenidba@sreenidba log]$ adalnctl.sh status adalnctl.sh version 120.3 Checking status for listener process APPS_UAT. LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 30-AUG-2017 12:47:58 Copyright (c) 1991, 2004, Oracle.  All rights reserved. Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=sreenidba)(Port=1600)) STATUS of the ...

Query to find running concurrent programs SQL>SELECT vs.username,  vs.osuser,  vh.sid locking_sid,  vs.status status,  vs.module module,  vs.program program_holding,  jrh.job_name,  vsw.username,  vsw.osuser,  vw.sid waiter_sid,  vsw.program program_waiting,  jrw.job_name,  'alter system kill session ' || ''''|| vh.sid || ',' || vs.serial# || ''';'  "Kill_Command" FROM v$lock vh,  v$lock vw,  v$session vs,  v$session vsw,  dba_scheduler_running_jobs jrh,  dba_scheduler_running_jobs jrw WHERE     (vh.id1, vh.id2) IN (SELECT id1, id2  FROM v$lock  WHERE request = 0  INTERSECT  SELECT id1, id2  FROM v$lock  WHERE lmode = 0)  AND vh.id1 = vw.id1  AND vh.id2 = vw.id2  AND vh.request = 0  AND vw.lmode = 0  AND vh.sid = vs.sid  AND vw.sid = vsw.sid  AND vh.sid = jrh.session_id(+)  AND vw.s...

Query to find table locks SQL>SELECT vs.username,  vs.osuser,  vh.sid locking_sid,  vs.status status,  vs.module module,  vs.program program_holding,  jrh.job_name,  vsw.username,  vsw.osuser,  vw.sid waiter_sid,  vsw.program program_waiting,  jrw.job_name,  'alter system kill session ' || ''''|| vh.sid || ',' || vs.serial# || ''';'  "Kill_Command" FROM v$lock vh,  v$lock vw,  v$session vs,  v$session vsw,  dba_scheduler_running_jobs jrh,  dba_scheduler_running_jobs jrw WHERE     (vh.id1, vh.id2) IN (SELECT id1, id2  FROM v$lock  WHERE request = 0  INTERSECT  SELECT id1, id2  FROM v$lock  WHERE lmode = 0)  AND vh.id1 = vw.id1  AND vh.id2 = vw.id2  AND vh.request = 0  AND vw.lmode = 0  AND vh.sid = vs.sid  AND vw.sid = vsw.sid  AND vh.sid = jrh.session_id(+)  AND vw.sid = jrw.session...