Oracle Technologies Blog

By ASKM

Archive for the ‘E-biz’ Category

Scripts

Posted by Srikrishna Murthy Annam on September 22, 2009

Find trace file for a Concurrent Request :

SQL>

prompt
accept request prompt ‘Please enter the concurrent request id for the appropriate concurrent program:’
prompt

column traceid format a8
column tracename format a80
column user_concurrent_program_name format a40
column execname format a15
column enable_trace format a12
set lines 80
set pages 22
set head off

SELECT ‘Request id: ‘||request_id ,
‘Trace id: ‘||oracle_Process_id,
‘Trace Flag: ‘||req.enable_trace,
‘Trace Name:
‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’,
‘Prog. Name: ‘||prog.user_concurrent_program_name,
‘File Name: ‘||execname.execution_file_name|| execname.subroutine_name ,
‘Status : ‘||decode(phase_code,’R’,’Running’)
||’-‘||decode(status_code,’R’,’Normal’),
‘SID Serial: ‘||ses.sid||’,’|| ses.serial#,
‘Module : ‘||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = &request
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name=’user_dump_dest’
and dbnm.name=’db_name’
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id;

Concurrent Request Status Query :

SQL>
set linesize 300;
set head on;
col sid_serial for a13;
col db_pid for a6;
col CMGR_Program for a65;
col user_name for a13;
col phase for a10;
col status for a10;
col start_time for a11;

break on USER_NAME

SELECT fu.user_name user_name,
TO_CHAR(NVL(cr.actual_start_date, cr.requested_start_date), ‘DD.MM HH24:MI’) start_time,
cr.request_id request_id,
decode(cr.parent_request_id, -1, 0, cr.parent_request_id) par_req_id,
DECODE(cr.phase_code, ‘C’, ‘Completed’, ‘I’, ‘Inactive’, ‘P’, ‘Pending’, ‘R’, ‘Running’, cr.phase_code) phase,
DECODE(cr.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Errored’, ‘F’, ‘Scheduled’,
‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No Manager’, ‘Q’, ‘Standby’, ‘R’, ‘Normal’, ‘S’, ‘Suspended’, ‘T’,
‘Terminating’, ‘U’, ‘Disabled’, ‘W’, ‘Paused’, ‘X’, ‘Terminated’, ‘Z’, ‘Waiting’, cr.status_code) status,
cr.oracle_process_id db_pid,
vs.SID || ‘,’ || vs.serial# sid_serial,
(SELECT SUBSTR(cp.concurrent_program_name || ‘-‘ || cpl.user_concurrent_program_name, 1, 65)
FROM APPS.fnd_concurrent_programs cp,
APPS.fnd_concurrent_programs_tl cpl
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
AND cpl.application_id = cr.program_application_id
AND cpl.concurrent_program_id = cr.concurrent_program_id
AND cpl.LANGUAGE = USERENV(‘LANG’)
) CMGR_Program
FROM APPS.fnd_concurrent_requests cr,
v$process vp,
v$session vs,
APPS.fnd_user fu
WHERE
cr.phase_code <> ‘I’
AND (cr.phase_code < ‘C’ OR cr.phase_code > ‘C’)
AND cr.status_code NOT IN (‘U’, ‘X’, ‘D’, ‘E’, ‘C’, ‘I’)
AND cr.oracle_process_id = vp.spid (+)
AND cr.oracle_session_id = vs.audsid (+)
AND fu.user_id = cr.requested_by
ORDER BY sid_serial,
phase_code desc,
STATUS_CODE,
2 DESC,
1
;

Sample output

USER_NAME     START_TIME  REQUEST_ID PAR_REQ_ID PHASE      STATUS     DB_PID SID_SERIAL    CMGR_PROGRAM
————- ———– ———- ———- ———- ———- —— ————- —————————————————————–
501282944     26.09 21:00   13737882   12462882 Pending    Standby           ,             FNDGSCST-Gather Schema Statistics
SYSADMIN      22.09 01:30   13892885   13694882 Pending    Standby           ,             FNDCPPUR-Purge Concurrent Request and/or Manager Data
21.09 18:39   13921062   13921061 Pending    Standby           ,             FNDOAMCOL-OAM Applications Dashboard Collection

How to Check the Product Installation Status (Installed Modules)

  1. Run the script $AD_TOP/adutconf.sql.
  2. This script will generate a file called adutconf.lst. Find this section in the file “Product Installation Status and other product information.”

Script to extract the information about the nodes

set serveroutput on
set echo on
set timing on
set feedback on
set long 10000
set pagesize 132
set linesize 80
col PLATFORM_CODE form a5
col HOST form a20
col DOMAIN form a30
col WEBHOST form a30
col VIRTUAL_IP form a20
col status form a20
col ConcMgr form a8
col Forms form a8
col WebServer form a8
col Admin form a8
col Database form a8
col last_monitored form a40

select
NODE_NAME,
to_char(CREATION_DATE, ‘DD-MON-RR HH24:MI’) creation_date,
PLATFORM_CODE,
decode(STATUS,’Y’,’ACTIVE’,’INACTIVE’) Status,
decode(SUPPORT_CP,’Y’, ‘ConcMgr’,’No’) ConcMgr,
decode(SUPPORT_FORMS,’Y’,’Forms’, ‘No’) Forms,
decode(SUPPORT_WEB,’Y’,’Web’, ‘No’) WebServer,
decode(SUPPORT_ADMIN, ‘Y’,’Admin’, ‘No’) Admin,
decode(SUPPORT_DB, ‘Y’,’Rdbms’, ‘No’) Database,
to_char(LAST_MONITORED_TIME, ‘DD-MON-RR HH24:MI:SS’) last_monitored,
NODE_MODE,
SERVER_ADDRESS,
HOST,
DOMAIN,
WEBHOST,
VIRTUAL_IP,
SERVER_ID
from fnd_nodes
where node_name != ‘AUTHENTICATION;

Which FND_USER is locking that table

SELECT c.owner
,c.object_name
,c.object_type
,fu.user_name locking_fnd_user_name
,fl.start_time locking_fnd_user_login_time
,vs.module
,vs.machine
,vs.osuser
,vlocked.oracle_username
,vs.sid
,vp.pid
,vp.spid AS os_process
,vs.serial#
,vs.status
,vs.saddr
,vs.audsid
,vs.process
FROM fnd_logins      fl
,fnd_user        fu
,v$locked_object vlocked
,v$process       vp
,v$session       vs
,dba_objects     c
WHERE vs.sid = vlocked.session_id
AND vlocked.object_id = c.object_id
AND vs.paddr = vp.addr
AND vp.spid = fl.process_spid(+)
AND vp.pid = fl.pid(+)
AND fl.user_id = fu.user_id(+)
AND c.object_name LIKE ‘%’ || upper(‘&tab_name_leaveblank4all’) || ‘%’
AND nvl(vs.status
,’XX’) != ‘KILLED’;

To determine what request groups and concurrent program is assigned to

select request_group_name from FND_REQUEST_GROUPS where REQUEST_GROUP_ID =(SELECT request_group_id FROM FND_REQUEST_GROUP_UNITS WHERE REQUEST_UNIT_ID=(select CONCURRENT_PROGRAM_ID from
FND_CONCURRENT_PROGRAMS where CONCURRENT_PROGRAM_NAME ='<report short name>’));

To Check The Profile Value At All Levels

clear col
clear breaks

set pages 9000
set lines 132
set verify off

col pov    format a45 word_wrapped  heading “Profile Value”
col lo     format a5                heading “Level”
col lov    format a40               heading “Value”
col pon    noprint    new_value n_pon
col upon   noprint    new_value n_upon
col sda    noprint    new_value n_sda
col eda    noprint    new_value n_eda
col cd     noprint    new_value n_cd
col cb     noprint    new_value n_cb
col d      format a78 word_wrapped noprint    new_value n_d

break on pon skip page

ttitle –
“Creation Date:   ”      n_cd    ”    Created By: ”          n_cb   –
skip 1 –
“Date Active From:”      n_sda   ”    To:”     n_eda  –
skip 1 –
“Profile Option Name: ”  n_pon   –
skip 1 –
“User Profile Name:   ”  n_upon  –
skip 1 –
“Profile Description: ”          –
skip 1 –
n_d                              –

select        lpad(fpo.profile_option_name,55)         pon
,             lpad(fpot.user_profile_option_name,55)   upon
,             fpot.description                          d
,             lpad(fpo.start_date_active,15)           sda
,             lpad(fpo.end_date_active,15)             eda
,             lpad(fpo.creation_date,15)               cd
,             lpad(fu.user_name,20)                    cb
,             ‘Site’                                   lo
,             ‘SITE’                                   lov
,             fpov.profile_option_value                pov
from       FND_PROFILE_OPTIONS_TL      fpot
,          FND_PROFILE_OPTIONS         fpo
,          FND_PROFILE_OPTION_VALUES   fpov
,          FND_USER                    fu
where    fpot.user_profile_option_name like ‘&&profile_like’
and      fpot.profile_option_name = fpo.profile_option_name
and      fpo.application_id       = fpov.application_id
and      fpo.profile_option_id    = fpov.profile_option_id
and      fpo.created_by           = fu.user_id
and      fpot.language            = Userenv(‘Lang’)
and      fpov.level_id            = 10001                  /* Site Level */
union all
select        lpad(fpo.profile_option_name,55)         pon
,             lpad(fpot.user_profile_option_name,55)   upon
,             fpot.description                          d
,             lpad(fpo.start_date_active,15)           sda
,             lpad(fpo.end_date_active,15)             eda
,             lpad(fpo.creation_date,15)               cd
,             lpad(fu.user_name,20)                    cb
,             ‘Apps’                                   lo
,             fa.application_name                      lov
,             fpov.profile_option_value                pov
from      FND_PROFILE_OPTIONS_TL      fpot
,         FND_PROFILE_OPTIONS         fpo
,         FND_PROFILE_OPTION_VALUES   fpov
,         FND_USER                    fu
,         FND_APPLICATION_TL          fa
where    fpot.user_profile_option_name like ‘&&profile_like’
and      fpot.profile_option_name = fpo.profile_option_name
and      fpo.profile_option_id    = fpov.profile_option_id
and      fpo.created_by           = fu.user_id
and      fpot.language            = Userenv(‘Lang’)
and      fpov.level_id            = 10002                  /* Application Level */
and      fpov.level_value         = fa.application_id
union all
select        lpad(fpo.profile_option_name,55)         pon
,             lpad(fpot.user_profile_option_name,55)   upon
,             fpot.description                          d
,             lpad(fpo.start_date_active,15)           sda
,             lpad(fpo.end_date_active,15)             eda
,             lpad(fpo.creation_date,15)               cd
,             lpad(fu.user_name,20)                    cb
,             ‘Resp’                                   lo
,             frt.responsibility_name                   lov
,             fpov.profile_option_value                pov
from     FND_PROFILE_OPTIONS_TL      fpot
,        FND_PROFILE_OPTIONS         fpo
,        FND_PROFILE_OPTION_VALUES   fpov
,        FND_USER                    fu
,        FND_RESPONSIBILITY_TL          frt
where    fpot.user_profile_option_name like ‘&&profile_like’
and      fpot.profile_option_name        = fpo.profile_option_name
and      fpo.profile_option_id           = fpov.profile_option_id
and      fpo.created_by                  = fu.user_id
and      frt.language                    = Userenv(‘Lang’)
and      fpot.language                   = Userenv(‘Lang’)
and      fpov.level_id                   = 10003                  /* Responsibility Level */
and      fpov.level_value                = frt.responsibility_id
and      fpov.level_value_application_id = frt.application_id
union all
select        lpad(fpo.profile_option_name,55)         pon
,             lpad(fpot.user_profile_option_name,55)   upon
,             fpot.description                          d
,             lpad(fpo.start_date_active,15)           sda
,             lpad(fpo.end_date_active,15)             eda
,             lpad(fpo.creation_date,15)               cd
,             lpad(fu.user_name,20)                    cb
,             ‘User’                                   lo
,             fu2.user_name                            lov
,             fpov.profile_option_value                pov
from     FND_PROFILE_OPTIONS_TL      fpot
,        FND_PROFILE_OPTIONS         fpo
,        FND_PROFILE_OPTION_VALUES   fpov
,        FND_USER                    fu
,        FND_USER                    fu2
where    fpot.user_profile_option_name like ‘&&profile_like’
and      fpot.profile_option_name = fpo.profile_option_name
and      fpo.profile_option_id    = fpov.profile_option_id
and      fpo.created_by           = fu.user_id
and      fpov.level_id            = 10004                  /* User Level */
and      fpov.level_value         = fu2.user_id
and      fpot.language            = Userenv(‘Lang’)
order by upon, lo, lov;

Advertisements

Posted in Oracle Apps R12 | 1 Comment »

FRD – Forms Runtime Diagnostics

Posted by Srikrishna Murthy Annam on September 20, 2009

How To Collect And Use Forms Trace (FRD) in Oracle Applications Release 12:

Forms Runtime Diagnostics (FRD) :

It is a method used to capture all the events that occur in a form session. It is a combination of external user-application interactions and internal Forms processing events.

FRD can be activated in 3 ways ……

  1. Using profile option
  2. Using appsweb.cfg
  3. In an ADHOC way

Action steps for “Using Profile Option” :
1) Login to application as sysadmin user
2) Note the profile value for “ICX: Forms Launcher” at site level
3) Change the profile value for “ICX: Forms Launcher” at user level

 http://hostname.domain:port/forms/frmservlet?record=collect+log=frdtrace.log  --> In servlet mode
 http://hostname.domain:port/OA_HTML/frmservlet?record=collect+log=frdtrace.log --> In socket mode

4) Bounce the apache services
5) Login into Oracle Applications and launch forms via self-service
6) Collect the log file from location $FORMS_TRACE_DIR
NOTE : You can also use the profile “Forms Runtime parameters” to pass the run time parameters.

Action steps for “Using appsweb.cfg” :

1) Edit the appsweb.cfg file pointed by environment variable “FORMS_WEB_CONFIG_FILE”

 record=collect
 log=formstrace.log

Edit in  section with heading “ENVIRONMENT SPECIFIC PARAMETERS ”
2) Bounce the apache services
3) Login into Oracle Applications and launch forms via self-service
4) Collect the log file from location $FORMS_TRACE_DIR

Action steps for “In an ADHOC way”:

1) Access forms using following urls directly and collect the log files in $FORMS_TRACE_DIR

http://hostname.domain:port/forms/frmservlet?record=collect+log=frdtrace.log  –> In servlet mode
http://hostname.domain:port/OA_HTML/frmservlet?record=collect+log=frdtrace.log –> In socket mode

2) Collect the log files from $FORMS_TRACE_DIR

Forms Trace Diagnostics Utility :

Forms Trace allows you to record information about a precisely defined part of forms functionality or a class of user actions. It provides detailed data collection and other features to assist the user in diagnosing and investigating forms runtime problems. Additional to old FRD logging, forms trace promises to have more structured logging with additional event which can be traced.

Action Steps
============

1) Edit the appsweb.cfg file pointed by environment variable “FORMS_WEB_CONFIG_FILE”

 record=collect
 tracegroup=medium

Edit in  section with heading “ENVIRONMENT SPECIFIC PARAMETERS ”

2) Bounce the apache services

3) Login into Oracle Applications and launch forms via self-service

4) Collect the trace file from location $FORMS_TRACE_DIR and convert it either to xml or html file

With ADHOC
==========

1) Access forms using following urls directly and collect the log files in $FORMS_TRACE_DIR

 http://hostname.domain:port/forms/frmservlet?record=forms tracegroup=full  --> In servlet mode
 http://hostname.domain:port/OA_HTML/frmservlet?record=forms tracegroup=full --> In socket mode

2) Collect the trace file from location $FORMS_TRACE_DIR and convert it either to xml or html file

Converting the forms trace file to xml or html format  …..

To convert the binary file into XML format:

<JDK_HOME>/bin/java -cp <10.1.2 ORACLE_HOME>/forms/java/frmxlate.jar
oracle.forms.diagnostics.Xlate datafile=$1.trc outputfile=$1.xml outputclass=WriteOut

To convert the binary file into HTML format:

<JDK_HOME>/bin/java -cp <10.1.2 ORACLE_HOME>/forms/java/frmxlate.jar
oracle.forms.diagnostics.Xlate datafile=$1.trc outputfile=$1.html outputclass=WriteOutHTML

Ref : Note 373548.1

Servlet Logging
===============

1) Edit the appsweb.cfg file pointed by environment variable “FORMS_WEB_CONFIG_FILE”

 serverURL=/forms/lservlet/<parameter>
  Where parameter = /session or /sessionperf or /perf or /debug

2) Collect the log file :
$LOG_HOME/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log

Posted in Oracle Apps R12 | Tagged: , , , , | 1 Comment »

R12 – Apache Troubleshooting

Posted by Srikrishna Murthy Annam on September 20, 2009

Apache Log  Location :  $LOG_HOME/ora/10.1.3/Apache


===================================================================

Following error in apache error_log
[Fri Sep 18 14:37:45 2009] [error] mod_ossl: Unknown error
[Fri Sep 18 14:37:45 2009] [error] mod_ossl: SSL call to NZ function nzos_Handshake failed with error 29040 (server xxxxxxx.domain.com:8000, client xx.xx.xx.xx)

Cause :
This problem is caused because the Wallet does not contain a valid certificate

NOTE : Note 473047.1

Follow the Note 556065.1 to troubleshoot the error.

==============================================================================

[Fri Sep 18 21:28:59 2009] [error] [client xx.xx.xx.xx] mod_security: Access denied with code 405. Pattern match “!(GET|HEAD|POST)” at REQUEST_METHOD. [uri “”] [unique_id SrRB64xX3pMAAEwlcnY]

Verify that the values for  s_webssl_port and s_active_webport in context file.
Both should have same value.

================================================================================

Posted in Oracle Apps R12 | Tagged: , , , , | 1 Comment »

R12 – socket to servlet mode conversion

Posted by Srikrishna Murthy Annam on September 20, 2009

R12 – socket to servlet mode conversion :

Action Steps
=============

1) Source the Env file
2) Stop all the application services.
3) Run the following command to enable Forms Socket Mode:

$FND_TOP/bin/txkrun.pl -script=ChangeFormsMode \
[-contextfile=<CONTEXT_FILE>] \
[-mode=servlet] \
-runautoconfig=<No or Yes> \
-appspass=<APPS password>

 Ex :
 $FND_TOP/bin/txkrun.pl -script=ChangeFormsMode \
 -contextfile=$INST_TOP/appl/admin/mycontext.xml \
 -mode=servlet \
 -runautoconfig=No

4) Run autoconfig in check mode and resolve the differences

5) Run autoconfig in actual mode

4) Start all the application services

Confirmation Checks
===================

1) Access the URL

<web_protocol>://<web_host>.<web_domain>:<web_port>/forms/frmservlet
http://ocvmrh2025.us.oracle.com:8000/forms/frmservlet

2) $INST_TOP/admin/scripts/adformsctl.sh status

3) Open the Java Console and check the “connectMode”

Observations
=============

Following values are modified in context file ….

Updated context Variable s_forms_servlet_serverurl to /forms/lservlet
Updated context Variable s_frmConnectMode to servlet
Updated context Variable s_formsstatus to enabled
Updated context Variable s_formsserver_status to disabled
Updated context Variable s_formslauncher_path to forms/frmservlet

adopmnctl.sh status in servlet mode :

Processes in Instance: VIS_ocvmrh2025.ocvmrh2025.us.oracle.com
——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
OC4J               | oafm               |   26006 | Alive
OC4J               | forms              |   25913 | Alive
OC4J               | oacore             |   25778 | Alive
HTTP_Server        | HTTP_Server        |   25727 | Alive

adopmnctl.sh status in socket mode :

Processes in Instance: VIS_ocvmrh2025.ocvmrh2025.us.oracle.com
——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
OC4J               | oafm               |   25365 | Alive
OC4J               | oacore             |   25279 | Alive
HTTP_Server        | HTTP_Server        |   25226 | Alive

Configuration files effected by this conversion :

socket_servlet_R12

Java Console Output :

Java_console_output_servlet_r12


Posted in Oracle Apps R12 | Tagged: , , , , | 1 Comment »

R12 – servelet to socket mode conversion

Posted by Srikrishna Murthy Annam on September 20, 2009

R12 – servelet to socket mode conversion

Action Steps
============

1) Source the Env file
2) Stop all the application services.
3) Run the following command to enable Forms Socket Mode:

$FND_TOP/bin/txkrun.pl -script=ChangeFormsMode \
[-contextfile=<CONTEXT_FILE>] \
-mode=socket \
[-port=<Forms port number>] \
-runautoconfig=<No or Yes> \
-appspass=<APPS password>

Ex :

 $FND_TOP/bin/txkrun.pl -script=ChangeFormsMode \
 -contextfile=$INST_TOP/appl/admin/mycontext.xml \
 -mode=socket \
 -port=9095 \
 -runautoconfig=No

4) Run autoconfig in check mode and resolve the differences

5) Run autoconfig in actual mode

5) Start all the application services

Confirmation Checks
===================

1) Access the URL

<web_protocol>://<web_host>.<web_domain>:<web_port>/OA_HTML/frmservlet
http://ocvmrh2025.us.oracle.com:8000/OA_HTML/frmservlet

2) $INST_TOP/admin/scripts/adformsrvctl.sh status

3) Open the Java Console and check the “connectMode”

Observations
=============

Following values are modified in context file ….

s_forms_servlet_serverurl to <empty>
s_frmConnectMode to socket
s_formsstatus to disabled
s_formsserver_status to enabled
s_other_service_group_status to enabled
s_formsport to 9095
s_formslauncher_path to OA_HTML/frmservlet

adopmnctl.sh status in servlet mode :

Processes in Instance: VIS_ocvmrh2025.ocvmrh2025.us.oracle.com
——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
OC4J               | oafm               |   26006 | Alive
OC4J               | forms              |   25913 | Alive
OC4J               | oacore             |   25778 | Alive
HTTP_Server        | HTTP_Server        |   25727 | Alive

adopmnctl.sh status in socket mode :

Processes in Instance: VIS_ocvmrh2025.ocvmrh2025.us.oracle.com
——————-+——————–+———+———
ias-component      | process-type       |     pid | status
——————-+——————–+———+———
OC4J               | oafm               |   25365 | Alive
OC4J               | oacore             |   25279 | Alive
HTTP_Server        | HTTP_Server        |   25226 | Alive

Configuration files effected by this conversion :

serv_to_socket_r12

Java Console Output :

Java_console_output_socket_r12

Posted in Oracle Apps R12 | Tagged: , , , , | 1 Comment »

Application R12 Installation

Posted by Srikrishna Murthy Annam on September 19, 2009

R12 Installation

Ref Note : 402310.1

This slideshow requires JavaScript.


Assuming that i am installing applications on linux machine.

1) Check the system requirements

software requirements -> ar , gcc ,g++ , ld , ksh , make , X Display Server
Memory Requirements  -> 1 GB RAM

Disk Space Requirement -> 200 GB

2) Create OS user accounts ( oracle , applmgr )

# id oracle
uid=1000(oracle) gid=1001(dba) groups=1001(dba)
# id applmgr
uid=1003(applmgr) gid=1001(dba) groups=1001(dba)
#

3) Setup Stage area and copy the software to the stage area

# pwd
/u01/stage
# ls
oraAppDB  oraApps  oraAS  oraDB  startCD
#

4) Start the Rapid Install ( as root user)

# cd /u01/stage/startCD/Disk1/rapidwiz
# ./rapidwiz

5) Screen shots.

6) Change the ownership of the directories

#chown -R oracle:dba <database base directory>
#chown -R applmgr:dba <applications base directory>

R12Install_1 R12Install_2

R12Install_3R12Install_4

R12Install_5R12Install_6

R12Install_7R12Install_8

R12Install_9R12Install_10

Then check the Login URL.

Default username and passwords: sysadmin/sysadmin ; apps/apps

Disk space requirement for 11i and R12

For 11i

Applications node file system (includes iAS/8.0.6 ORACLE_HOME, COMMON_TOP, and APPL_TOP) 26 GB
Database tier file system (fresh install with a production database)  OR

Database tier file system (fresh install with a Vision Demo database)31 GB

65 GBTotal space for a single node system, not including stage area57 GB for a fresh Install with a production database
91 GB for a fresh install with a Vision Demo

For R12

Applications node file system (includes OracleAS 10.1.2 ORACLE_HOME, OracleAS 10.1.3 ORACLE_HOME, COMMON_TOP, APPL_TOP, and INST_TOP) 28 GB (40 GB on HP-UX Itanium)
Database node file system (Fresh install) 45 GB
Database node file system (Vision Demo database) 133 GB (145 GB on HP-UX Itanium)

Posted in Oracle Apps R12 | Tagged: , , | Leave a Comment »

R12 FileSystem Architecture

Posted by Srikrishna Murthy Annam on September 19, 2009

R12 FileSystem Architecture

The new file system enables Oracle Applications files to be placed into one of the following categories, and located accordingly:
1) Data
2) Code
3) Configuration

Configuration files are typically modified more frequently than code and data files, so keeping them separate from these other types of file simplifies maintenance

Directory

R11i Location

R12 Location

APPL_TOP $HOME/appl $HOME/apps/apps_st/appl
COMMON_TOP $HOME/comn $HOME/apps/apps_st/comn
ORACLE_HOME $HOME/ora/8.0.6 $HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME $HOME/ora/iAS $HOME/apps/tech_st/10.1.3
ORACLE_HOME $HOME/db/10.2.0 $HOME/db/tech_st/10.2.0
ORADATA $HOME/data $HOME/db/apps_st/data
INST_TOP N/A $HOME/inst/apps/context_name

Imp PATHS Comparision
====================

File or Variable R11i R12
Environment

Source File

APPSORA.env APPS.env, which executes:

$ORA_CONFIG_HOME/10.1.2/$TWO_TASK.env

$APPL_CONFIG_HOME/$TWO_TASK.env

Context File $APPL_TOP/admin/$TWO_TASK.xml $APPL_CONFIG_HOME/admin/$TWO_TASK.xml
OA_HTML $COMMON_TOP/html $COMMON_TOP/webapps/oacore/html
JAVA_TOP, OA_JAVA $COMMON_TOP/java $COMMON_TOP/java/classes
AF_JLIB N/A $COMMON_TOP/java/lib
JAVA_BASE N/A $COMMON_TOP/java/
FND_SECURE $FND_TOP/secure/<SID>/ $INST_TOP/apps/fnd/12.0.0/secure/
ADMIN_SCRIPTS_HOME $COMMON_TOP/admin/scripts// $INST_TOP/admin/scripts/
LOG_HOME $APPL_TOP/admin//logs/ $INST_TOP/logs
FORMS_WEB_CONFIG_FILE N/A $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg

R12 File system architecture_1
Scripts :
=======

Script Function
adautocfg.sh Run AutoConfig
adstpall.sh Stop all services
adstrtal.sh Start all services
adapcctl.sh Start/stop/status Apache
adformsctl.sh Start/stop/status OC4J Forms
adoacorectl.sh Start/stop/status OC4J oacore
adopmnctl.sh Start/stop/status OPMN
adalnctl.sh Start/stop RPC listeners (FNDFS/FNDSM)
adcmctl.sh Start/stop Concurrent Manager
gsmstart.sh Start/stop FNDSM
jtffmctl.sh Start/stop Fulfillment Server
adpreclone.pl Cloning preparation script
adoafmctl.sh Start/stop/status of OC4J
adexecsql.pl Execute SQL scripts that update profiles in AutoConfig run
java.sh Used to call Java with additional arguments (OPMN, CM)

LogFiles and Loc :
==============

Log File Name Log File Location
AD script log files (e.g.from adapcctl.sh) $INST_TOP/logs/appl/admin/log
CM Log Files ($APPLCSF/$APPLLOG) $INST_TOP/logs/appl/conc/log
AD tools log files (e.g. ADPATCH) $APPL_CONFIG_HOME/admin/$TWO_TASK/log
OPMN Log Files (text and ODL) $ORA_CONFIG_HOME/10.1.3/opmn/logs (may move to  $INST_TOP/logs/10.1.3/opmn)
Apache Log Files (text and ODL) $INST_TOP/logs/10.1.3/Apache/
OC4J Log Files (text) $INST_TOP/logs/10.1.3/j2ee/oacore/
OC4J Log Files (ODL) $INST_TOP/logs/10.1.3/j2ee/oacore/log/oacore_default_group_1/oc4j

Important configuration files :

Opmn.xml — > Details of all OC4J instances deployed and also log location.
$ORA_CONFIG_HOME/10.1.3/opmn/conf

Server.xml — > Details of all applications deployed under OC4J.
Paths to J2EE logging , RMI config files , JMS config files.
$ORA_CONFIG_HOME/10.1.3/J2EE/oacore/config

orion-applications.xml — > Details of all web modules deployed under that application.
$ORA_CONFIG_HOME/10.1.3/J2EE/oacore/applications-deployment/oacore

orion-web.xml — > Details of all servlets aliases and their mapping to servlets classes.
$ORA_CONFIG_HOME/10.1.3/J2EE/oacore/applications-deployment/oacore/html.

Appsweb.cfg — > $ORA_CONFIG_HOME/10.1.2/forms/server

Posted in Oracle Apps R12 | Tagged: , , , , , , , | Leave a Comment »

R12 Applications Architecture

Posted by Srikrishna Murthy Annam on September 19, 2009

R12 Applications Architecture

R12 Applications architecture is a three tiered architecture.

The Desktop Tier
The Application Tier
The Database Tier

The Oracle Applications Architecture is a framework for multi-tiered, distributed computing that supports Oracle Applications products. In this model, various servers or services are distributed among three levels, or tiers.

Let us first clarify ourself the important difference b/n the words

SERVER , NODE , MACHINE , TIER

Server : Server is a process or group of processes that run on a single machine and provide a particular functionality.

Tier : A tier is a logical group of services , potentially spread across more than one physical machine.

Machine or node : A machine may be referred to as a node, particularly in the context of a group of computers that work closely together in a cluster.

Desktop Tier :

The Forms client applet must run within a Java Virtual Machine (JVM) on the desktop client. The Sun J2SE Plug-in component allows use of the Oracle JVM on web clients, instead of the browser’s own JVM. This is implemented as a browser plug-in.

( In 11i , we use Jinitiator for the for the JVM )

The Application Tier :

Web services
Forms services and framework services
Concurrent processing server
Admin server

Application tier uses two different ORACLE_HOMEs ,

8.0.6 ( 11i) — > 10.1.2 ( R12 ) AS
8.1.7 ( 11i) — > 10.1.3 ( R12) AS

Web Services :

Web Services includes the following components
Web listener
Java Servlet Engine ( OC4J)
Oracle Process Manager (OPMN)

Q) What are self service applications :
Oracle HTML based applications are known as self service applications

Q)What is the diff b/n selfservice applications and applications frame work ?

The oracle applications framework is the development platform for self service applications ( HTML based application )

Forms Services :
Forms services in R12 are provided by the forms listener servlet , which is a more secure deployment over the internet.
Forms listener servlet mediates the communication b/n the desktop client and the oracle database server.

Q) What is forms socket mode ? Does R12 support the socket mode ?
Ans : R12 uses the forms listener servlet mode by default. Howewer , socket mode is still fully supported.

Note : 384241.1

Concurrent Processing Server :
Concurrent Processing is an Oracle Applications feature that allows non–interactive and potentially long-running functions to be executed efficiently alongside interactive operations.
Processes that run on the Concurrent Processing server are called concurrent requests.

When you submit such a request, either through HTML-based or Forms-based Applications, a row is inserted into a database table specifying the program to be run. A concurrent manager then reads the applicable requests in the table, and starts the associated concurrent program.

More detailed explanation on CM characteristics , Types of CMs , setting up the CMs and its architecture will be discussed in a saperate article.

Admin Server :

The Admin (Administration) server is located on the node where you maintain the data model and data in your Oracle Applications database.

Ex : Applying database patches to Oracle Applications , using adadmin to update database tables etc .

Database Tier :

The database tier contains the Oracle database server, which stores all the data maintained by Oracle Applications.

Q) What is oracle applications technology layer ?

The Oracle Applications technology layer lies between the Oracle Applications technology stack and the Oracle Applications product-specific modules. It provides features common to all Oracle Applications products.

This technology layer includes :

Oracle applications DBA ( AD ) — >used for installing, upgrading, maintaining, and patching the Oracle Applications system.

Oracle applications object library ( FND ) — >consists of a collection of reusable code, programs, and database objects that provides common functionality across all products.

Oracle applications utilities ( AU ) — >used to store the files from other products as generating forms and reports may require access to shared PL/SQL libraries.

Oracle common modules ( AK ) — > used to develop inquiry applications for the HTML-based Applications, without the need for any programming.

Oracle Workflow ( WF ) — >

Oracle Alerts ( ALR) — >

Oracle Applications Framework ( FWK ) — >

Oracle XML Publisher ( XDO ) — > uses data definitions and templates to produce output reports in the desired format.

Posted in Oracle Apps R12 | Leave a Comment »

R12 FAQs

Posted by Srikrishna Murthy Annam on September 2, 2009

Q) How to check the forms servlets mode or socket mode ?

Open the appsweb.cfg file pointed by environment variable “FORMS_WEB_CONFIG_FILE” and check the values for following parameters:

* serverURL=
* connectMode=

In servlet mode
serverURL=/forms/lservlet
connectMode=servlet

In Socket mode
serverURL=(should be blank)
connectMode=Socket

Q) How to compile forms in R12 ?

frmcmp_batch module=XXXXX.fmb userid=apps/apps output_file=XXXXX.fmx compile_all=special batch=yes

Posted in FAQs, Oracle Apps R12 | Leave a Comment »

 
%d bloggers like this: