Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Monday, 5 January 2015

Schedule R12.2 start/stop scripts in crontab

Question regarding scheduling of starting/stopping EBS R12.2 Application services  has been asked several times on forums. So i decided to write a quick post for demonstrating it.

In Oracle EBS there are consolidated scripts for starting  and stopping of multiple Application services. "adstrtal.sh" is used for starting all application services and "adstpall.sh" is used for stopping of other services.

These script will call other scripts Internally to perform start/stop operation.

Prior to EBS R12.2  you only need apps username and password to run this script. In EBS R12.2 you need a additional password parameter for weblogic admin server to start/stop of  EBS application services.

In EBS 11i/R12.1 script usage:

adstrtal.sh apps/apps  - Stop services
adstpall.sh apps/apps - Start services

In EBS R12.2 additional weblogic admin password should be provided:


- Similarly for stopping of services also you need to provide the weblogic admin server password.

Scheduling shutdown/startup in script:

We need to create a below small shell script to schedule it in a crontab for starting/stopping of services automatically.

You need to add web logic admin password in a new line to execute script successfully.



These scripts can be scheduled in  crontab as below for starting/stopping of services automatically:



Hope its helpful. 

thanks for reading :)

regards,
X A H E E R


2 comments:

Jean Farmer said...

Thank you for this, super helpful.
Do you get an error at all though?
I'm getting this in my script output:
stty: standard input: Inappropriate ioctl for device

Enter the WebLogic Server password: stty: standard input: Inappropriate ioctl for device

The script keeps on trucking and it seems like it works. Do you know if this is an actual error or just something that I should expect?
-jean

PRAD said...

Same issue with me. Can someone help me with this.