Determine the OS version of a Linux Release/Kernel and Oracle Apps/DB

OS Commands:

[oracle@uswjusvr115 scripts]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.6 (Santiago)

[oracle@uswjusvr115 scripts]$ cat /etc/oracle-release
Oracle Linux Server release 6.6

[oracle@uswjusvr115 scripts]$ cat /proc/version
Linux version 2.6.39-400.17.1.el6uek.x86_64 (mockbuild@ca-build44.us.oracle.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) ) #1 SMP Fri Feb 22 18:16:18 PST 2013

*NOTE: uek = Unbreakable Enterprise Kernel

[oracle@uswjusvr115 scripts]$ getconf LONG_BIT
64

[oracle@uswjusvr115 scripts]$ uname -a
Linux uswjusvr115.affiniagroup.net 2.6.39-400.17.1.el6uek.x86_64 #1 SMP Fri Feb 22 18:16:18 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

[oracle@uswjusvr115 scripts]$ uname -mrs
Linux 2.6.39-400.17.1.el6uek.x86_64 x86_64

[oracle@uswjusvr115 scripts]$ cat /etc/issue
Oracle Linux Server release 6.6
Kernel \r on an \m

SQL Command:

[oracle@uswjusvr115 scripts]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 27 10:15:01 2015
SQL> select banner from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production

SQL> SELECT INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION FROM gv$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION
1 ebsprd uswodsvr115.affiniagroup.net 11.2.0.3.0

SQL> conn apps/apps
Connected.
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3

Posted by

dba365

Posted on

October 7, 2015

Posted under

Form Logging, Form Tracing, Forms Runtime Diagnostics

Comments

Enable Forms Diagnostics, Tracing in R12 using Profile Option

This document shows how to use Forms Runtime Diagnostics using Profile Option at user level.

First verify if Forms using Socket or Servlet.

In Servlet Mode:
serverURL=/forms/lservlet
connectionMode=servlet
In Socket Mode:
serverURL=<blank>
connectionMode=Socket

Enable Forms Runtime Diagnostics (FRD)

FRD can be enabled in one of the following methods:

Option 1: Obtain FRD Trace Using Profile Options
Option 2: Obtain FRD Trace Using Appsweb.cfg
Option 3: Obtain FRD in an ADHOC way

We will be using method “Obtain FRD Trace Using Profile Options” in this example.

To start tracing, please modify Profile Option ‘ICX: Forms Launcher’ at USER level to include the Forms parameters required for FRD logging (Note: This should not set at SITE LEVEL)

2.1: Add the trace value “ ‘?record=collect’ “ to Apps URL for profile option ‘ICX: Forms Launcher’

In Servlet Mode:https://hostname.domain:port/forms/frmservlet?record=collect
in Socket Mode:https://hostname.domain:port/OA_HTML/frmservlet?record=collect