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

–Rachna

Hey Atul,

Good material and thanks for providing the information

Regards,
Raghav

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

Atul,

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

-Sandeep

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

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 Upendra,
Thanks for pointing out , changed

Atul

Thanks Anand for correcting it

Atul

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

Hi Atul,

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

Regards
Vignesh

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 ?

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

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

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

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

Run Autoconfig, This will create new startup/shutdown script

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

regards
Ankush

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

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

Hai,
How to start Adminserver..?
Regards
Jagadeesh

Hey Atul,

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

Regards,
Noor Shaikh

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

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 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, 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

Dear Atul

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

Thanks
Ather Hussain
atherhussain9@yahoo.com