Startup Shutdown Apps Services

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

–Rachna

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

Hey Atul,

Good material and thanks for providing the information

Regards,
Raghav

Thanks , cheers

Atul

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

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

Atul,

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

-Sandeep

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

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

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

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

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

Hi Upendra,
Thanks for pointing out , changed 🙂

Atul

Hi Atul,

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

Thanks Anand for correcting it

Atul

Thanks for refreshing my memory from Oracle Apps 10.7 days

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

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

Hi Atul,

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

Regards
Vignesh

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

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 ?

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

Atul

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

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

Ian ,
If this is application user password check

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

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

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

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.

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

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.

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

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

Run Autoconfig, This will create new startup/shutdown script

hi atul ,

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

regards
Ankush

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

regards
Ankush

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

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

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

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

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

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

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

Thanks for correcting typo

Hai,
How to start Adminserver..?
Regards
Jagadeesh

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

Hey Atul,

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

Regards,
Noor Shaikh

Thanks a lot

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

Tks,
Paulo.

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

Tks,
Paulo.

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

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

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

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

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

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

Dear Atul

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

Thanks
Ather Hussain
atherhussain9@yahoo.com

[…] startup/shutdown in Oracle Applications 11i check here  and […]

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

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

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.

Hi Atul,
Awaiting your response…

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

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

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

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….

@ 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 .