Various scripts --11i how to use.

In this post I would like to write about the various scripts available for starting and shutting down the apps services.

Normally 11i will be installed with two OS accounts . one for oracle db and one for oracle apps tier. normally --applmgr(or) appl sid .

after logging into apps user you should source the APPSORA.env env file under APPL_TOP. This sets your environment. you can confirm whether it has been setup by echoing the TWO_TASK. like-- $echo $TWO_TASK which will show you the SID.

now you are ready to execute scripts.


Generally the scripts are under $COMMON_TOP/admin/scripts.

here you will find the following scripts.

adstrtal.sh --- used for starting the apps tier..

usage--- adstrtal.sh apps/apps password.

adstpall.sh --- used for stopping the apps tier..

usage---adstpall.sh apps/apps password.

adapcctl.sh start/stop --- used for starting and stopping the apache/web server.

adalnctl.sh start/stop --- used to start stop the apps listener.

adfrmctl.sh start/stop --used to start stop forms server.

adcmctl.sh start apps/apps

adcmctl.sh stop apps/apps ----used for starting and stopping the concurrent managers.

addisctl.sh start/stop --- used for starting stopping the discoverer.


any comments/questions kindly post.

--Vivek

	Enter your search terms Submit search form
	Web virtualappsdba.blogspot.com onlineappsdba.com practicalappsdba.wordpress.com

Various TOP's in Oracle Apps

In this post I will discuss about the various TOP(physical structure)'s of the Oracle 11i(E-Business Suite).

They are.

DataBase Oracle Home.

DATA_TOP (where oracle dbf's are stored).


APPL_TOP(Application's Top) where all the relevant modules files are stored(e.g forms,reports,pl/sql stored procedures etc of a GL (General Ledger Module).

COMMON_TOP--- various admin scripts and other necessary files are stored.

OA_HTML---where the .jsp files are stored.

IAS_ORACLE_HOME---Apache,Jserver components are stored here.

806_ORACLE_HOME--- The necessary pl/sql libraries are stored here.

JAVA_TOP and JDK_HOME.

In my next post I will discuss about the various scripts used in the applications.

--Vivek

More About Middle Tier Components.

Lets see the purpose of the middle tier components

1.Web Server

This is Apache server which brings you the webpages of the application.

2.Forms Server

Here You should know that 11i consists of three oracle home's

a)Database Oracle Home. b) 8.0.6 Oracle Home c) IAS Oracle Home

so the forms server is part of IAS Oracle Home.--which brings you the forms of 11i--E-business suite.

3. Reports Server.

This is also a part of IAS Oracle Home-- used for running reports against the 11i database.


4.Concurrent Processing Server.

Used for processing the concurrent requests.

5. Admin Server.

This is used for admin purpose.

6.Discoverer Server.

This is optional.This brings you the discoverer integrated with 11i.

more posts are coming up. come back to this site.

--Vivek

Apps DBA BASICS

Hi All,
I am going to start a new series --Learn Apps DBA on Your Own. Here is my first post.

Architecture of 11i Oracle E-Business Suite.
----------------------------------------------

11i Architecture is a 3 Tier Architecture.

1.DataBase Tier.
2.Middle Tier.
3.Client or Desktop Tier.

DataBase tier consits of the database to which 11i stores the data. this can be separate node or on the same node where middle tier is.


Middle Tier consists of the following components.

1.Web Server.
2.Forms Server.
3.Reports Server
4.Concurrent Processing Server.
5.Admin Server
6.Discoverer Server.

This tier can be distributed(load balanced) into multiple nodes.


Desktop Tier --which is the client pc used for accessing the applications. The components include a web browser ,Oracle Jinitiator.

Any questions or comments kindly post in this blog.

--Vivek

RAC or RAC with DataGuard

The latest technology in the market is catching up the speed.but why DG with RAC . why not RAC. RAC is also a trusted High Availability feature --which comes to our mind immediately.Even in RAC --availability of db is 99% only. but RAC with Data Guard combination gives you the 99.99999999% guarantee for your Oracle DataBase.You can automate the failover(Fast Start Fail over).For further enquires like testing this in a single box contact me.
--Vivek

Scale Your Performance of E-Business Suite on RAC

Is Your Data Growth Large in Your E-Business Suite?.Does Your End Users face drastical Performance Degradation in accessing the applications?.E-Business suite with RAC provides the solution.when RAC scales your perfomance PCP combination will give you a better and speedy experience.To further improve the performance you can implement the Load balancing(HTTP). I am sure that , you will experience a great difference in performance.For enquires mail me @ vivekanandan.rajendran@gmail.com.
--Vivek