Startup Shutdown Apps Services

Startup / Shutdown Apps

In our next topic in learning Oracle Apps DBA , this post covers startup & shutdown of Oracle Application DBA

As you are aware by now there is Database Tier ( Database & DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server )

Order of StartUp of Services Should be
First DB Listener, Database & then Application Tier Services

Order of ShutDown of Services Should be
First Application Tier Services then Database & DB Listener

Database Startup/Shutdown Scripts
Depending on your AD Version these will be in ORACLE_HOME / appsutil/scripts /SID_hostname
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script

Where

AD is for Application DBA
DB is for database
DLN is database listener
CTL is control

Isn’t this easy to remeber ( Thanks to Oracle for naming convention)

—–
Application Tier Startup/Shutdown Scripts
Depending on your AD Version these will be in

OAD_TOP/admin/scripts/ SID_hostname

adalnctl.sh Apps Listener Control Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier

Where AD & CTL you already know now :) isn’t it

adl stand for Apps Listener
apc stand for Apache
cm Concurrent Manager
dis Discoverer
frm forms
rep report

Do you know whats Use of Apps Listener ? Check else I will post it in future post .
Check what Advertisers has to say on your right side of page .

Learn Oracle Apps DBA
Free Apps DBA Training

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

65 comments
Anonymous says August 3, 2006

Good resource….helping me in slowly getting the feel of Apps.

–Rachna

Reply
Anonymous says August 4, 2006

Thanks Rachna,
If you are like it keep checking what our sponsors have to say on right side or top of this page in pinnk . You might find jobs as well in our sponsors site .

Check similar at Advanced Apps DBA

Reply
Anonymous says September 22, 2006

Hey Atul,

Good material and thanks for providing the information

Regards,
Raghav

Reply
Atul Kumar says September 22, 2006

Thanks , cheers

Atul

Reply
Anonymous says October 6, 2006

Hai Atul,
Thanks a lot for providing such beautiful information about Apps dba.
Troubleshooting about concurrent managers,jserv,Apache is really helpful for us for attending interviews.
I also requst you to share some of the problems you had faced while patching,cloning or any other such situations and also how u solved it.It also helps us a lot.
Thank you once again
kiran

Reply
Atul Kumar says October 6, 2006

Kiran,
I can do that but I suppose lot of guys will use this information during interview & interviewer can easily undersatnd if you really faced issue or you have read it on some site so I prefer you or any other person not to mug up such issues.

I am planning to update on How to troubleshoot apache & other components soon.

Atul

Reply
Anonymous says October 7, 2006

Atul,

Awesome work Atul..Im finding Apps very intersesting and simple to learn now.
Thanks!

-Sandeep

Reply
Atul Kumar says October 7, 2006

Sandeep,
Thanks a lot for our feedback. This was my motto when I first thought of writing on How to become Apps DBA. Discovering Oracle Apps DBA in simple words.

Atul

Reply
subba reddy says October 15, 2006

hi atul,

That was enough information u posted & Iam working as sys admin & I know basic programming & Oracle with D2K. I want to be a DBA, kindly mail me some good material on DBA to subbareddyvs@gmail.com

Reply
Anonymous says November 3, 2006

hi atul,

this is Kenny again. I had been
reading a bit on how to write
startup/shutdown script for the
middle-tier.

In most of the scripts, the apps
userid/password is supplied in the
scripts. Is this a standard practise?

Is there anyway to secure it? If a
person knows the apps userid/password,
how does it affect the security of
the system?

Hope to hear from you soon.

thanks
Kenny

Reply
Atul Kumar says November 3, 2006

Kenny,
Apps username password is required only to start concurrent manager i.e. adcmctl.sh
If you are using adstrtal.sh to start all services which in turn calls CM so you need apps password here as well.

Apps password is quite important & end user should not have access to unix/windows middle tier as that has apps password stored in file system. Only authorized user should have access.

There is dedicated forum for Apps DBA’s at http://teachmeoracle.com/forum

Reply
Upender says November 8, 2006

hi atul
this is upender, i notices a minute mistake in this post… cm is called concurrent manager in adcmctl.sh, where as u mentioned it as cmc… plz check it out

and ur efforts are good…. keep going

Reply
Atul Kumar says November 9, 2006

Hi Upendra,
Thanks for pointing out , changed :)

Atul

Reply
Anand says January 7, 2007

Hi Atul,

Anand here, There is a small mistake in the post as upendra said.. aln is for Application listener (adalnctl.sh) not adl.:)

Reply
Atul Kumar says January 7, 2007

Thanks Anand for correcting it

Atul

Reply
Anonymous says January 19, 2007

Thanks for refreshing my memory from Oracle Apps 10.7 days

Reply
sandeep says February 7, 2007

hello atul
thanks for providing good material.iam just learning from ur site.can u please help me.
sandeep

Reply
Atul Kumar says February 7, 2007

Sandeep,
Feel free to raise any questions/doubts at forum dedicated to apps dba’s http://teachMeOracle.com/forum and Guys there will be able to help you

Reply
Vignesh says February 11, 2007

Hi Atul,

Thanks a lot for you. These guidlines and stream of my self study make me an APPS DBA.

Regards
Vignesh

Reply
Atul Kumar says February 11, 2007

Thanks Vignesh, A lot depends on your self study & hands on ..

Reply
Fendy says March 11, 2007

Hi Atul,

Thanks for the valuable resource…
I’ve face the problem when uploading file from attachment window from Apps. I’ve also stop and start the apache server and retest the uploading process.But, the error.log produce the error like this :
File does not exist: /u0/oracle/prod1ora/iAS/Apache/Apache/htd ocs/discwb4/applet/dummyT
oClearIE404Error
[Mon Mar 12 09:39:09 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/jav
a/awt/KeyboardFocusManager.class
[Mon Mar 12 09:39:10 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/
prod1comn/java/oracle/a pps/fnd/formsClient
/FormsLauncherBeanInfo.class
How do I troubleshoot this problem ?

Reply
Atul Kumar says March 12, 2007

Fendy,
Can you please put navigation path and which version of apps you are on…

Atul

Reply
irfan says March 15, 2007

Hi Atul

Inforamtion u provided is very useful for a beginner like me … we installed Oracle Apps …. how can we change the passwd for super user or any other user . for shutting down or bringing up we have to login as super user ,, and it prompts for password , how can we change the paswd … if so we have forgot the password

Thanks
Ian

Reply
irfan says March 15, 2007

Hi Atul

Inforamtion u provided is very useful for a beginner like me … we installed Oracle Apps …. how can we change the passwd for super user or any other user . for shutting down or bringing up we have to login as super user ,, and it prompts for password , how can we change the paswd … if so we have forgot the password

Thanks
Ian

Reply
Atul Kumar says March 19, 2007

Ian ,
If this is application user password check

http://becomeappsdba.blogspot.com/2007/01/change-oracle-apps-password-fndcpass.html

Reply
Anonymous says April 3, 2007

Does anyone here know how to change the OID password? We don’t have the current OID Password, to reset it to a new password. any help is appreciated.

Thanks
Sunitha

Reply
Atul Kumar says April 3, 2007

Sunitha,
You want to change user password stored in oid then you oiddas screen

http://infra_host:http_port/oiddas

You can also use GUI oidadmin from oid server to change user passwords stored in OID but make sure these passwords are synched with application (if any) associated with that OID

Reply
Anonymous says April 3, 2007

I am trying to logon to Oracle Internet directory but i don’t have a userid or password. How to i find out what the userid or password is as a super user.

Reply
Anonymous says April 3, 2007

Atul,

I am trying to find out the suer user userid and password for Oracle internet Directory. We currently do not know what it is. is there a way to reset the super user password and find out what user name was used.

Thanks
Sunitha

Reply
Atul Kumar says April 4, 2007

Super user is orcladmin , password is same as ias_admin or ods .

There is ods password stored in oidstats.sh file check if that works.

Reply
ankush says June 5, 2007

hi
if in any case we lose the startup script of any services eg adapcctl.sh is there any way to create it. u can also reply me at
ankushchawla03@gmail.com

Reply
ankush says June 5, 2007

hi
if in any case we lose the script to start the services eg.adapcctl.sh then how we can create it.please help urgent

regards
Ankush

Reply
Atul Kumar says June 5, 2007

Run Autoconfig, This will create new startup/shutdown script

Reply
ankush says June 11, 2007

hi atul ,

do we need to bring down the apps Tier before running autoconfig

regards
Ankush

Reply
ankush says June 11, 2007

what all checks a APPS DBA need to perform to check that everything is working fine.

regards
Ankush

Reply
Atul Kumar says June 11, 2007

Ankush,
Check health check list which one should check to confirm everything is working fine

http://www.teachmeoracle.com/healthcheck.html

Reply
Paven says June 20, 2007

Hi Atul,

Your blog is really useful for newbie AppsDBA as me. I want to write some scripts for auto shutdown EBS 11i(apps + db) at night for backup as:

adstpall.sh apps/xxx
sleep time
addbctl.sh stop immediate

Please help me set time for ensuring all services shutdowned? And how to check log or send mail when they have errors?

Thks,
Paven

Reply
Paven says June 20, 2007

Hi Atul,

Your blog is really useful for newbie AppsDBA as me. I want to write some scripts for auto shutdown EBS 11i(apps + db) at night for backup as:

adstpall.sh apps/xxx
sleep time
addbctl.sh stop immediate

Please help me set sleep time for ensuring all services shutdowned? And how to check log or send mail when they have errors?

Thks,
Paven

Reply
sheetal says June 22, 2007

Hi atul…
u haven’t mentioned about the script that is used for apache in restricted mode??
it was asked in one of my intervew..
waiting to hear from u….

..sheetal

Reply
Atul Kumar says June 22, 2007

Thanks sheetal for reminding that..Yes I missed it from my list

Reply
Anonymous says June 28, 2007

as far as i know it’s not adstrtall.sh but adstrtal.sh …;)

Reply
Atul Kumar says June 29, 2007

Thanks for correcting typo

Reply
Anonymous says August 5, 2007

Hai,
How to start Adminserver..?
Regards
Jagadeesh

Reply
history's says September 4, 2007

Hi Atul,

I’m really happy to see such a good web site for learning Oracle-Apps Database Admin.It becomes very easy for readers like us to clarfiy their doubts via this.

Thanks a lot for developing this.

Keep it up Atul.

Yo,
Sundar

Reply
Noor says November 14, 2007

Hey Atul,

You are exclent.
Thanks from all of us, who all access this site but could not thanks.

Regards,
Noor Shaikh

Reply
Atul says November 14, 2007

Thanks a lot

Reply
paulofp says January 22, 2008

The directory where i find the “Application Tier Startup/Shutdown Scripts
” ins’t in “$COMMON_TOP/admin/scripts/CONTEXT_NAME” ????

Tks,
Paulo.

Reply
paulofp says January 22, 2008

Ops! Sorry, i found that $OAD_TOP is the same as $COMMON_TOP.

Tks,
Paulo.

Reply
Madhu says February 14, 2008

I have 20 application environments. every week we have maintainace activity, we need to bring all the 20 applications down. each application has its own unix id.

my question is
I am thinking to have one common id which can stop the all the applications at same time. I no need to connect 20 times to 20 environments to stop the applications.

or is there any way I can achive this

thanks in Advance

Reply
Rutvi says August 20, 2008

Hi,

I need some materials to become ORACLE DBA & also want to give certification for that so pls kindly help me to ahieve this…!!
IMP THING…………..
Give me your email id as well as.

Thanks,
Rutvi Patel

Reply
kuruvan says January 24, 2009

Hi Athul

This is first time i am posting.we have installing 11.5.10.2 in test instance but while shutdown the apps Tier the apps password should be entered.regarding this the password know everybody kindly guide us for how hide password while shutdown the application.
<>
we have changed the apps password in cm script and ias_oracle_home and cfg files.

Regards
Kuruvan

Reply
Niranjan says January 6, 2010

Hi Athul,

I want to be a DBA, Please send some good material which will help me to gain knowledge in that field. Am a fresher to this field . Please help me.

Regards ,

Niranjan

Reply
mohammed azam aslam says February 13, 2010

Hi, Atul
How are you. Please reply my query. when i was trying to update some user info in oracle application R12 in Guest user i change the end date from old enddate like 01-10-1951 to 01-Jan-2010 will that effect the application, since the production about to go live. we are facing some problem in opening of web page in application. can u guide us.

take care
regards,
Azam

Reply
Atul Kumar says February 15, 2010

@Azam,
You should never disable or enddate GUEST account or infact any account whose ID < 10 (in FND_USERS table owned by apps)

Reply
Ather Hussain says March 11, 2010

Dear Atul

What to do if start/stop or listener is deleted accidently in 11i or R12.

Thanks
Ather Hussain
atherhussain9@yahoo.com

Reply
Lalit says October 20, 2010

Hi,
I am trying to generate a wsdl file using Generate Wsdl button in the integration repository. While doing so i am getting below exception “SOA Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: IRepAccessError: IRepAccessError: Incorrect Class Id.’ when attempting to perform ‘GENERATE’. Please contact your System Administrator.
I am using SYSADMIN as the user. I have made the required changes which were documented about ASADMIN user.
Any help would be highly appreciated

Reply
Atul Kumar says October 21, 2010

@ Lalit,
Run diagnostic test as mentioned in 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12

Reply
Lalit says October 21, 2010

Hi,
I dont have a metalink account. So i would highly appreciate your help if you could list down the steps i need to follow to trouble shoot this issue.

Reply
Lalit says October 25, 2010

Hi Atul,
Awaiting your response…

Reply
Atul Kumar says October 26, 2010

@ Lalit, Apologies as this is protected document and I can’t share or copy paste it

Reply
Lalit says October 26, 2010

No problem, i understand.
Anyways i have one more query regarding Xml Gateway Message Designer. I have it installed on my machine but i am not sure how can i start that tool. Is there any menu in the workflow which i need to click or i need to run some script ?
Could you please help me in these.
Thanks

Reply
pathan says January 29, 2011

hi
i started db-tier successfully and iam getting a error like “fatal error, JAVA_TOP is not a directory that does not exits” when iam starting appstier
even run “. PROD.env”.
can any one please tell me how can i start appstier.

thanks in advance

Reply
ramappsdba says April 25, 2011

Hi ,

When I shutDown Application Services, Concurrent Manager is not getting shutdown…What Might be the Possible reasons for this …Can U suggest me in this condition for proper shutdown of Application Services….

Reply
Atul Kumar says April 25, 2011

@ ramappsdba,
Which script you are using to stop application services ?

Did you try adcmctl.sh to adstpall.sh ?

Check CM log file to see why CM’s are not stopping .

Reply
Add Your Reply