http://onlineAppsDBA.com

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,

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/htdocs/discwb4/applet/dummyToClearIE404Error
[Mon Mar 12 09:39:09 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/java/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/apps/fnd/formsClient/FormsLauncherBeanInfo.class
How do I troubleshoot this problem ?

 

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/htdocs/discwb4/applet/dummyToClearIE404Error
[Mon Mar 12 09:39:09 2007] [error] [client 170.1.61.11] File does not exist: /u0/oracle/prod1comn/java/java/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/apps/fnd/formsClient/FormsLauncherBeanInfo.class
How do I troubleshoot this problem ?

TIA,
Fendy

 

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

 

hi,
it really a good site for new oracle apps dba, it helps a lot

Regards,
Brij

 

Hi atul,

I am apps techno func consultant have good exposure to appsdba on windows platform i can start services n stop all services as and when need on window. i would like to know how to start the servies at linux i know the command from your blog example
adapcctl.sh
adcmctl.sh
it will be great help if you let us know how to run from linux. like log into linux and go..like that..

Thanks
SA

 

Hi attul,

Thankyou, soon apps no more alien to me.