Oracle Application Architecture

ORACLE APPLICATION ARCHITECTURE ORACLE APPLICATION ARCHITECTURE....................................................................1 KEYWORDS...................................................................................................................2 Node.............................................................................................................................2 Server...........................................................................................................................2 Tier...............................................................................................................................2 DEVELOPMENT TECHNOLOGIES USED.................................................................2 ARCHITECTURE...........................................................................................................2 Desktop Tier.................................................................................................................2 Application Tier...........................................................................................................2 Database Tier:..............................................................................................................5 ORACLE APPLICATION FILE SYSTEM.....................................................................5 Application Tier...........................................................................................................5 Database Tier...............................................................................................................6 What Happens from BACK END....................................................................................6

Prepared by:

Nikhil Rangaraju ORACLE NAIO

KEYWORDS Node Node is a machine or computer Server Server is a collection of one or more computer processes that perform specific function Tier Tier is a Logical grouping of one or more computer processes.

DEVELOPMENT TECHNOLOGIES USED There are 3 development technologies under which Apps was developed:  D2K  Java  HTML.

ARCHITECTURE ORACLE apps is a 3-tier architecture. It consists of  Desktop Tier  Application Tier  Database Tier. Desktop Tier Generally an end user PC doesnot consist of any servers. Rather it consists of web browser that makes use of HTML and JAVA applet to provide the user interface. Application Tier Also called as middle tier. It consists of number of servers. The nodes on which these servers run is referred as application tier server nodes. Servers include  Apache (or) web server  Form server  Concurrent Processing server  Administration server Apache server It listenes request from the URL and routes appropriate server.  Configuration file is httpd.conf  IAS_ORACLE_HOME/Apache/Apache/conf  Adapcctl.shCOMMON_TOP/admin/scripts---to start/stop/status apache server

Ps –ef | grep Apache----To check whether Apache is running or not Lsof | grep <port no>---To check apache is running or not Lsof | grep <port no> | wc –l U can get the port number from httpd.conf (or) contextname.xml file. If any error occurs check access-logs or error-logs located in IAS_ORACLE_HOME/Apache/Apache/logs.  Version of webserver is 1.0.2.2.2 form 11.5.8 to 11.5.10  To find out version go to IAS_ORACLE_HOME/Apache/bin and http - version     

Access-Log: It records all users accessing oracle applications web server. This file is defined in httpd.conf Error-Log: In erro-log is checked to see information regarding error and its occurance. If this Information is not sufficient then edit httpd.conf file and change LOGLEVEL Value=’debug’ and bounce apache server. Also check Jserverlogs where its config file is IAS_ORACLE_HOME/Apache/Jserv/etc Logfile: mod_jserv.logs, jserv.logs located in IAS_ORACLE_HOME/Apache/jserv/logs. Form server: Whenever a user try to access forms, “f60webmx”picks up the file and based on this config file creates a forms session to user/client. Configuration fileappsweb.cfg located in COMMON_TOP/html/bin To start and stop: adfrmctl.sh stop/start/status To check whether it is runnig or not: ps –ef | grep f60webmx Log files location: COMMON_TOP/admin/log//f60svm.txt What it checks in configuration file: it checks for 2 files  plugin=jinitiator/java  connect_mode=socket(default)/servlet

Socket mode: When forms run in socket mode these is dedicated connection between client machine and form server started by adfrmctl.sh

Servlet mode: When forms run in servlet mode, the forms requests are fulfilled by Jserv in apache. There will be additional JVM for forms request in that case and will not start form via adfrmctl.sh Forms runtime diagnostics default location is ORACLE_HOME/forms60/log/ Form server executable name: f60srvm To find out forms version: f60gen Concurrent server It executes tasks parallely. Concurrent manager executes concurrent requests by taking resources from concurrent server. Adcmctl.sh start/stop----- To start and stop concurrent server FNDLIBR---- Executable name Ps –ef | grep FNDLIBR---- Whether concurrent server is running or not. Types of concurrent managers: ICM: Internal concurrent manager which manages other concurrent managers. Standard managers: Which manages processing of requests. If no concurrent manager takes the process, it will handle the process. CRM: Conflict resolution manager resolve conflicts in case of incompatibility. Log files: APPLCSF/ APPLLOG. Outfiles: APPLCSF/APPLOUT. What happens exactly? When you run adcmctl.sh it records execution of this command in text file with name “adcmctl.txt” in directory $COMMON_TOP/admin/log/. Also adcmctl.sh calls another script “startmgr” which inturn calls “batchmgr” in FND_TOP/bin. This is the actual file, which fire up ICM process. How to troubleshoot concurrent manager? If any problems faced while starting CM then look for logfile of ICM located in $APPLCSF/APPLLOG) and format is SID-MMDD.mgr (11.5.10 apps format). Request Log files: Output files:

l<requestid>.req <username>.<req.id> (or) 0<req.id>.out (or) <usernm>.out Concurrnt Manager Log: w<XXXX>.mgr Transaction manager log: t<XXXX>.mgr Conflict Resoiution manager log: c<XXXX>.mgr

Administration Server: When you upgrade your application from one version to another then we use administration server. Report Server: Collection of sql statements (rdf files-executable is rdx) Configuration file: CGIcmd.dat  connect string is there with Apps passwordlocated in (8.0.6 home/report60/server) Database and database listener should be up and running. Discoverer Server: Mainly used for business Intelligence purpose. Used for analysis purpose. We can customize reports and so on with D2K in an appropiate way. Addisctl.sh start/stop  To start and stop discoverer server. (Oracle_home/discwb4/util) Database Tier: It consists of database server, which stores all the application data. Addbctl.sh start/stop database. Addlnctl.sh start/stop listener. Located in ORACLE_HOME/appsutil/scripts/context_name

ORACLE APPLICATION FILE SYSTEM Application Tier It consists of 3 top directories: appl (or) APPL_TOP=contains the product directories and files for Oracle Applications. comn (or) COMMON_TOP=contains directories and files used across products. ORA (or) ORA_DIRECTORY=contains Oracle_Home’s for the Applications technology stack components.

/u01/app/apgcct01

gcct01appl

gcct01comn

gcct01ora

Database Tier Two top-level directories store files related to the Oracle Applications database. db = contains the database ORACLE_HOME DATA = contains the Oracle Applications database files. /u01/app/orgcct01

gcct01db

gcct01data

So,there are 3 Oracle_Home’s in Oracle Apps , two for Application tier and one in Database tier.  8.0.6 directory contains the ORACLE_HOME for the Developer 6i products (Forms, Reports and Graphics).The product libraries in 8.0.6 Oracle_Home are used to relink Oracle Applications executables.  IAS directory contains the Oracle_Home for oracle9i Application server, which includes the Oracle HTTP server.  Oracle_Home on dbTier used by database software usually 8i, 9i or 10g.

What Happens from BACK END  When user makes a request from browser by typing URL, then the request hit to oracle webserver and these requests are recorded in logs.  Webserver checks with http request there is no cookie attached (Cookie is message given by webserver to identify client) and hence user is new it passes login page to User.

 User types his Username/Password in login window and click submit button  Webserver checks the username/password that is needs to authenticate against database FND_USER table, so it needs some user to check client’s username password in database. It uses GUEST/ORACLE user to authenticate user in database. This information is located in FND_TOP/secure/.dbc  Once user is authenticated it checks against FND_RESPONSIBILITY for authorization about users responsibilities and assigned responsibilities back to user.  When webserver tries to connect to database for plsql or any other type of connection it asks IAS_ORACLE_HOME/Apache/modplsql/cfg to fulfill request and connection string information is stored in wdbsvr.app file.  User submits his requests for batch processing or something else etc. These requests are fulfilled by concurrent managers  When user wants to see reports of all these things request is being forwarded to reports server.