Friday, November 5, 2021

How to Generate fmx from fmb in R12

 1) Login to application server.

2) Go to the directory $AU_TOP/forms/US
3) Place “.fmb” file in binary mode or search for existing --> ls -ltrh *.fmb
4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EBS R12.2 Log file locations

EBS R12.2 Log file locations

$INST_TOP/logs/appl/admin/log-------Start/Stop Logfiles

$IAS_ORACLE_HOME/ instances//diagnostics/logs-------Log files for OPMN and OHS processes

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log --------Weblogic Nodemanager

$IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log------Apache Logs

$IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/----OPMN Logs

$IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager
$EBS_DOMAIN_HOME/servers/oa/logs/
$EBS_DOMAIN_HOME/servers/forms/logs/
$EBS_DOMAIN_HOME/servers/AdminServer/logs/*
$EBS_DOMAIN_HOME/sysman/log/*         -------------------Weblogic Logs

How to get weblogic url in EBS R 12.2

 [oracle@Ranesh logs]$ grep -i "wls_admin" $CONTEXT_FILE

         <s_wls_admin_console_access_nodes oa_var="s_wls_admin_console_access_nodes">0.0.0.0/0</s_wls_admin_console_access_nodes>

         <wls_admin_host oa_var="s_wls_admin_host">Ranesh</wls_admin_host>

         <wls_admin_sslEnabled oa_var="s_wls_admin_sslEnabled">false</wls_admin_sslEnabled>

         <wls_admin_domain oa_var="s_wls_admin_domain">ranesh.oraclevcn.com</wls_admin_domain>

         <wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>

         <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7001</wls_adminport>

         <wls_admin_sslport oa_var="s_wls_admin_sslport" oa_type="PORT" base="17001" step="1" range="-1" label="WLS Admin Server SSL Port">17001</wls_admin_sslport>


We can also find out the url using command


[oracle@Ranesh logs]$ echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console"

http://Ranesh.ranesh.oraclevcn.com:7001/console

Tuesday, November 2, 2021

Upload to oracle Support

 cURL is a command-line tool and application library used to transfer data to or from a server.


curl -T  /u01/app/oracle/ranesh.zip -o output.log  -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/SR NUMBER/"


 curl -T AdminServer.log -o xplorer -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/3-26712853041/"

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...