LINUX user required: oracle & applmgr

Oracle database : apps schema

In release 12 (12.1.1) te oracle concurrent manager uses the rwcall to start reports

11i – 3 Oracle homes for Database, PLSQL libraries forms Reports & Application Server

Relase 12 : 10g Database , 10.1.2 PLSQL libraries Forms Reports & 10.1.3 for Apps server

Lats release of 11 is 11.5.10.2

Almost 2500 users set under vision schema. & more than 250 modules under EBS

For NLS support, install new language packs on top of US language pack.

RDF – Rreport defn files : Bin hosts the executables for each module

AU_TOP – Hosts all source files for all module like FMB,

CUSTOM.pll : You have forms on Oracle Apps and any customization wpuld register details at this file

PeopleSoft was integrated as EBS HRMS. Ritek is renamed as Oracle Retail under EBS.

The default programs are called Seeded Programs, Any additons are categorised as Customization.

Maintenanace pack – Major technical stack upgrade ued top move form 12.1.0 to 12..1.1

ad XXX scripts = AD menas Application DBA scripts

FND : Foundation tables . Corruot means u can’t see any forms at all.

Feature called autoconfig : $INST_TOP/appl/admin/SID_hostname.xml can be edieted for any config changes for config files. Under 11i- APPL_TOP/admin . Use config editor (editcontext GUI) to edit this file/ information.

On multi tier apps node hte load balancing is done thru hardware using hte F5 load balancer

[oracle@ebs rapidwiz]$ pwd
/oracle/stage/stageR12/startCD/Disk1/rapidwiz

run adautostg.pl to stage the DVDs on the disks
[oracle@ebs rapidwiz]$ ls -l
total 168
-rwxrwxrwx 1 root root 71859 Nov 23 2008 adautostg.pl
drwxrwxrwx 2 root root 4096 Nov 23 2008 bin
-rwxrwxrwx 1 root root 559 Nov 23 2008 ClientWiz.cmd
[oracle@ebs rapidwiz]$./adautostg.pl

Multinode Install. First create the config file using the rapidwitz and goto next node and select the “Load the following saved configuration” option

How to list users on forms ? Goto Security/ user form – Hit F11 to make form into query mode. When the Filed is BLUE you know it is in Query mode.

Concurrent Manager – Are for every task seperated by the roles. The Actual and target processes should have same concurremt processes.

Any requests which are not assigned to any concurrent type of manager is assigned to a Standard Manager. You will see all concurrent poroceeses under screen above.

Transaction manager : Hih priority programs are categorised into Transaction Manager . Like General Ledger, Reconcillatiosn etc

How to schedule a concurrent request

Cretae new Concurrent requests

Internal concurrent manager – Backbone of all other concurrent processes

The log for this is at directory /oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/conc/log Look for file VIS_%date%.mgr

====================================================================
Starting VIS_0627@VIS Internal Concurrent Manager — shell process ID 31951

logfile=/oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/conc/log/VIS_0627.mgr
PRINTER=noprint
mailto=applmgr
restart=N
diag=N
sleep=30 (default)
pmon=4 (default)
quesiz=1 (default)
Reviver is ENABLED
+—————————————————————————+
Application Object Library: Concurrent Processing version 11.5
+—————————————————————————+
Application Object Library: Concurrent Processing version 11.5

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

Internal Concurrent Manager started : 27-JUN-2009 10:19:47

+—————————————————————————+

Process monitor session started : 27-JUN-2009 10:19:49
Starting RCVOLTM Concurrent Manager : 27-JUN-2009 10:19:49
Starting RCVOLTM14 Concurrent Manager : 27-JUN-2009 10:19:51

Take system out of Maintenance mode