Start-up Shutdown Scripts in Oracle Apps R12

This Post covers Start-up Shutdown scripts in Oracle Applications Release 12, If you wish to know more about Startup/Shutdown scripts in Oracle Apps 11i click here

Order of Startup Shutdown
————————————–
As in Oracle Apps 11i order for startup is
A) Start Database Tier Services
–Start Database Listener
–Start Database
Then
B) Start Application/Middle Tier Services
— adstrtal.sh

Order for shutdown in Oracle Apps R12 is
A) Stop Application/Middle Tier Services
— adstpall.sh
Then
B) Stop Database Tier Services
–Stop Database
–Stop Database Listener

Database Tier Scripts in R12
————————————–
For Database tier you need to start database and database listener. Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME– For Database
Use script addbctl.sh

– For Database Listener
Use script addlnctl.sh

or alternatively you can use
lsnrctl startstop listener_name (For Database Listener)
sqlplus “/as sysdba”
SQL> startup shutdown immediate

Middle/Application Tier Scripts in R12
————————————————-

Scripts for Application Tier services in R12 are located in “Install_base/inst/apps/$CONTEXT_NAME/admin/scripts
where CONTEXT_NAME is of format SID_HOSTNAME

i) adstrtal.sh
Master script to start all components/services of middle tier or application tier. This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)

ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.

iii) adalnctl.sh
Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )

iv) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs
like opmnctl stopproc ohs .

(In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl. In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)

v) adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )

vi) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4j instancename=forms

vii) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12

viii) adoacorectl.sh
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oacore

ix) adoafmctl.sh
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm

x) adopmnctl.sh
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped abnormally opmn will/should start them automatically.

xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.

xii) mwactl.sh
To start / stop mwa telnet server where mwa is mobile application.

Log File Location for Startup Shutdown Services in R12
———————————————————————-
Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
(adalnctl.txt, adapcctl.txt, adcmctl.txt, adformsctl.txt, adoacorectl.txt, adoafmctl.txt, adopmnctl.txt, adstrtal.log, jtffmctl.txt )

–Are you facing any issues in startup/shutdown scripts ?
–Should Oracle Create single script which should start/stop entire application including database ?

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

55 comments
Arunkumar says June 12, 2007

Nice basic info Atul.

However,
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

should read

$INST_TOP/logs/appl/admin/log

as INST_TOP is

“Install_base/inst/apps/$CONTEXT_NAME

Reply
Rashmi says June 12, 2007

Hi

There is going to be a Blogcamp in India on 16th of June. Around 250 bloggers will be taking part in the event.

This is what they say on their blog: “The way unconferences work is that, you don’t have an agenda, rather we will put up a white board, where participants will themselves add the topics they are interested to speak upon. Depending upon the number of speakers we will go for multiple threads. There will be some intense discussions, we will have a lot of fun and yes there will be blogging, video blogging, photo blogging, podcasting … everything under the blogger sun.”

The registrations have started. We are planning to have 250 participants from all over the country. There are some people taking part virtually, using youtube, slideshare, skype etc. if you are interested please add your name to the wiki.

Check the:
wiki: http://barcamp.org/BlogCampPune
official blog: http://www.blogcamppune.blogspot.com

rashmi

Reply
Atul Kumar says June 12, 2007

Thanks Arun for correcting it and apologies to my readers.

Thanks once again, I’ll change them soon

Reply
abhishek says January 19, 2008

How to bounce concurrent manager in R12

thanks
Abhi

Reply
abhishek says January 19, 2008

For bounce concurrent manager we have to run this script only.
adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh.
Nothing more requires ?

Reply
abhishek says January 19, 2008

Hi Atul,

For bounceing the concurrent manager in R12 we need only to run this script.
v) adcmctl.sh
Script to start / stop concurrent manager,

Nothing more requires ?

with Thanks
Abhishek

Reply
Atul says January 19, 2008

Yes adcmctl.sh is enough to bounce CM

Reply
crazydba says July 3, 2008

Hi Atul,
Have you still faced any bug with adstpall.sh or adstrtal.sh scripts in R12i where script doesn;t validate the apps password passed with the scripts, if yes, is there any work around known without changing the scripts.

thnks.

Reply
vasavi says November 19, 2008

Hi Atul/all,

When i am starting Apps by using ./adstrtal most of the application are showing that status 2. when i saw in log files it showing that opmn is not started.I started all the listener and sqlplus all the thing.

Can any help regarding this one.

Vasavi

Reply
Atul Kumar says November 19, 2008

Vasavi,
You have to check opmn log file to find that why opmn is not starting ..

Update output from opmn.log under 10.1.3 in INST_TOP

Reply
vasavi says November 19, 2008

Hi Atul,

i checked in the opmn.log resides under 10.1.3 in INST_TOP but i didn’t find any thing related to this.last log changed on long back.

Can u help me any other way?

thanks & regards
Vasavi

Reply
vasavi says November 20, 2008

Hi Atul/All,

I found that running the autoconfig script is the problem for this one.I tried to run but it is giving that sutoconfig is compelted with error.in the log file it is showing that spl is failed to start at this time timed out it is showing.

really i need it.can any one help me regarding this one.

thanks & regards

Vasavi

Reply
Atul Kumar says November 20, 2008

Is database and database listener up ?

Can you do sqlplus apps/apps@[SID] from middle tier ?

Post log file output for autoconfig

Reply
vasavi says November 20, 2008

Hi Atul,

I statred the listener and databae in the oracle user and both are started adn up.And i then come to applmgr user and i am trying to start the adstrtal.sh it is giving the status 2.Then start the adautoconf.sh file in the log file

when i started the sqlplus apps/apps@SID it is showing that timed out

getConnectionUsingAppsJDBCConnector() –>
APPS_JDBC_URL=”
Trying to get connection using SID based connect descriptor
getConnection() –>
sDbHost : apps12
sDbDomain : us.oracle.com
sDbPort : 1521
sDbSid : VIS
sDbUser : APPS
Trying to connect using SID…
getConnectionUsingSID() –>
JDBC URL: jdbc:oracle:thin:@apps12.us.oracle.com:1521:VIS
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() –>
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=
(PROTOCOL=tcp)(HOST=apps12.us.oracle.com)(PORT=1521))(
CONNECT_DATA=(SERVICE_NAME=VIS)))
Exception occurred: java.sql.SQLException: Io exception:
The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() –>
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PRO
TOCOL=tcp)(HOST=apps12.us.oracle.com)(PORT=1521)
)(CONNECT_DATA=(SERVICE_NAME=VIS.us.oracle.com)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Connection could not be obtained; returning null

——————-ADX Database Utility Finished—————

Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database

StackTrace:
java.sql.SQLException: Could not get connection to the database
at oracle.apps.ad.tools.configuration.CVMHelper.
processNewContextFile(CVMHelper.java:787)
at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1718)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1520)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:684)

can you help me regarding this one

thanks & regards
Vasavi

Reply
Atul says November 20, 2008

Problem is that you can’t do
sqlplus apps/apps@SID

Is DB & middle tier on same machine ?
If they are on different node, is there any firewall between middle tier and db tier ?

On DB Node
lsnrctl status
netstat -an | grep

On Application Node
telnet

Reply
vasavi says November 20, 2008

Hi Atul,

both the DB and Middle tier in the same machine.But both are in different user.

I tried to find the status of the lsnrctl it showing connection timed out.

Thanks & regards

Vasavi

Reply
vasavi says November 20, 2008

Hi Atul,

Sorry for the above post.I found that my lsnrctl is up. and dba also i am able to run in oracle user in the same computer. and i am not able to connect to the dba from the another user (applmgr) in the same machine.
i think no firewall b/n two users in the same machine

thanks & regards

Vasavi

Reply
crazydba says November 21, 2008

Hello Vasavi,
Please paste the content of sqlnet.ora file.

Warm Regards,
CrazyDBA

Reply
vasavi says November 21, 2008

Hi CrazyDBA,

this is the content of sqlnet.ora

# $Header: sqlnet.ora 120.0 2005/06/20 15:31:53 appldev noship $
# $AutoConfig$
#
# stored in %s_tools_oh%/net80/admin/%s_contextname%

#NAMES.DEFAULT_DOMAIN = default.com

SQLNET.AUTHENTICATION_SERVICES= NONE
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME=%s_sqlnet_expire_time%


Can u help me regarding this one

thanks & regards
Vasavi

Reply
Atul Kumar says November 21, 2008

Vasavi,
Check listener log to find why listener is not starting

check $TNS_ADMIN/../$SID.log

Reply
brian says December 23, 2008

Hi Atul,

I’m running R12 under VMWare using OEL 5.2.

Starting the database using addbctl.sh takes about 15 minutes. The same goes for stopping the database.

Is this normal? The virtual machine has been assigned 3GB RAM and one core of my 2.5GHz core 2 duo processor.

If not, do you have an idea how to speed things up?

Regards,
Brian

Reply
Vasishta says March 2, 2009

Hi Athul I recently installed R12 Business suite with VISION data base on Suse11.1.
When I try to open System profiles ,I get this error:

Unknow plugin(applicaiton/x-java-applet;jpi-version=1.5.0_13)

I try installing 1.5.0_13 ,I could not get this version
Can you le

Reply
Vasishta says March 2, 2009

Hi Athul I recently installed R12 Business suite with VISION data base on Suse11.1.
When I try to open System profiles ,I get this error:

Unknow plugin(applicaiton/x-java-applet;jpi-version=1.5.0_13)

I try installing 1.5.0_13 ,I could not get this version
Can you let me know how can get out of this proble

Thanks

Reply
Atul Kumar says March 2, 2009

You need JRE 1.5.13 on client machine for browser. Download and install from

http://java.sun.com/javase/downloads/index_jdk5.jsp

Reply
Vasishta says March 4, 2009

I could get it running now with little struggle with libXm.so.2.
I used jdk1.6.0_12 , and changed all the references

Thanks

Reply
» How to Upgrade Oracle Application server 10g (10.1.3) in R12 (12i/EBS) Online Apps DBA: One Stop Shop for Apps DBA’s says March 17, 2009

[…] 1. Apply Oracle E-Business Suite Patches (at-least 12.0.3, autoconfig template patch to support latest OAS i.e. 10.1.3.4) 2. Apply 10.1.3.4 patchset to 10.1.3 Oracle Home using runInstaller (10.1.3.4 is latest certified patchset as of 12 Mar 09). Ensure Oarcle Home is set to 10.1.3 (Not 10.1.2) 3. Run Autoconfig 4. Apply additional patches to 10.1.3 oracle home (using opatch and not adpatch) 5. Regenerate appsborg.zip and appsborg2.zip files using adadmin 6. Restart application tier services for r12 , click here for how to start/stop services on R12 […]

Reply
Ash says April 22, 2009

Hi Atul,

Do i need to set any env parameter before starting database listerner.

the above said procedure is not working….

some services failed to start… following is the small subset of log

Web Entry Point Services Oracle HTTP Server APP_apps17 adapcctl.sh Started
Web Application Services OACORE OC4J Instance APP_apps17 adoacorectl.sh Failed
Web Application Services FORMS OC4J Instance APP_apps17 adformsctl.sh Failed
Web Application Services OAFM OC4J Instance APP_apps17 adoafmctl.sh Failed

Thanks

Ash

Reply
Amit says April 22, 2009

Atul,

when i am starting listener its giving me mesage:

Logfile: /erpdb/db/tech_st/10.2.0/appsutil/log/APP_apps17/addlnctl.txt
Starting listener process APP …
addlnctl.sh: exiting with status 1

i checked logfile: the error message line is

/erpdb/db/tech_st/10.2.0/bin/tnslsnr: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
the tnslsnr file exists.

Thanks

Amit

Reply
Atul Kumar says April 22, 2009

@ ASH,
Yes you need to set environment variable before starting/stopping services.

Reply
Ash says April 23, 2009

Thanks Atul, for the reply,

Just check the step i am following for starting R12,

1. Login as oracle user
2. set env variables (ORACLE_HOME, LD_LIBRARY_PATH)
3. start db listener (./addlnctl.sh start APP)
– lsnr started with status 0
4. start database (./addbctl.sh start normal)
– database started with status 0
5. login as applmgr
6. start apps (./adstrtall.sh)
– status is 4
– checked logfile: HTTP Server, OCJ4, ICSM services failed to start.

Am i wrong somewhere.

Thank You
Ash

Reply
Ray Kan says June 25, 2009

Demo system fell over, 6am – no apps dba on hand and no sysadmin manuals with me, followed your guide to the scripts, bounced the mid-tier – nothing, bounced the database – still nothing, rebounced the mid-tier started, no concurrent managers, activeated them – nothing, bounced the concurrent managers – GREAT STUFF I’m back and running, Thanks

Reply
» ADAPCCTL.SH : EXITING WITH STATUS 150 , 204 : Apache Logs in R12 Online Apps DBA: One Stop Shop for Apps DBA’s says July 21, 2009

[…] know more about startup services in R12 check here  or Metalink Note […]

Reply
nadiarabiu says September 15, 2009

Please,Atul, I would like to know for browsers’s requirements: I noticed that systems of less than 1GB of memory were unable to access the EBS link. I did all the tricks to get it to connect. At contrary, systems of 1GB and above of memory are able to access the link. What could one do? Is there any way to amend this?Thanks

Reply
Atul Kumar says September 15, 2009

@ Nadiarabiu,
There is no such memory requirement (1GB) for cleints . I can access R12 from laptop with 256 MB RAM without issues

Reply
ambatisk says September 16, 2009

hai atul,

when Concurrent Manager is down,what are precautions have to take.

Reply
Atul Kumar says September 16, 2009

@ambatisk,
I am not clear about your question – what are precautions have to take.

Did you mean how to monitor CM or what what to do once you notice CM is down ?

How to monitor CM – either use custome shell scripts and check for count of FNDLIBR process or monitor CM log file for internal manager.

– use OEM grid control with plugin for oracle apps

What to do if CM is down ? – Check error message in log , fix issue and start CM

Reply
mohammed azam aslam says August 25, 2010

Dear Atul,

Hi,

IE8 is compatible with Oracle 12. since i have windows 7 installed on my pc. I need to access oracle ebs but In order to access this application, you must install the J2SE Plugin version 1.5.0_13. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

Copyright ©1998, 1999, 2000, 2001, 2002 Oracle Corporation

I did the above installation but still i am not able to work on forms and functions and menus were not able opened.

kindly help me.
thanks
Azam

Reply
Atul Kumar says August 25, 2010

@ Azam, Check if there is any popup blocker or any IE plugin which is blocking forms .

What error or message you get when you click on forms ?

Reply
padmajabodla says September 14, 2010

Hi Atul,

I lost the power and needed to restart my r12 database and application tier.

When I ran the “./adstrtal.sh apps/apps” command I get

adstrtal.sh: Exiting with status 4

I am new to these things.

Thanks in advance for any help.
Padmaja

Reply
Atul Kumar says September 15, 2010

@ padmajabodla,
One of our support staff will take control of your machine remotely and fix this for you.

Atul

Reply
padmajabodla says September 15, 2010

Thanks Atul,

I do not know what happened but after couple of times shutting down the DB and restarting it worked fine.

Thanks,
Padmaja

Reply
saptarshi says February 28, 2013

Hi Atul,

If adstpall.sh or adstrtal.sh got removed accidentally for a particular environment ,then is there any way to recover that?

Thanks
Saptarshi

Reply
Abu says April 14, 2014

Hi,

I have query to start WF mailer internal components like “Workflow Agent Listener Service”, “Workflow Document Web Services Service” and “Workflow Mailer Service” to start from API. normail API used to start mailer service itself is calling following package but it is not handling internal components. We want to explicitly restrat component services.

fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);

is for mailer itself, but found no way to start above from this package.

Anybody can revert on this?

Reply
raj says June 15, 2015

Hi Atul
I can see that the query dated back to April 2014th by Abu is not answered. Are you still following this thread?
Well, I am observing a very interesting behavior with one of our cloned instances. I set it up couple of days back and for few reasons I was forced to shutdown the application instance immediately after starting, which starts without throwing any errors. However, while stopping the services I was getting
ERROR : Timed out( 100000 ): Interrupted Exception for oacore, forms and oafm scripts

I attempted almost every possible workaround solutions provided by various bloggers and oracle community seniors, yet not resolving the timed out errors.

Interestingly, I left the instance running over night and the next day tried to stop the instance using the adstpall.sh and within few seconds all the scripts were closed with status 0!

Can you please shed some light in to this particular situation? Does it emphasis towards the resources being too busy to answer the oacore, forms, oafm scripts in a timely manner as the concurrent jobs are triggered and the system is busy?

My current enviornment

IBM 3600 Server with 2xXeon processor
20GB memory, Oracle Linux 7 64bit
EBS R12, 12.0.6 64Bit
Database 10.2.0.3
Single node, using local disks

regards,

Rajesh

Reply
    Atul Kumar says June 15, 2015

    @Rajesh,
    Issue could be because of number of reasons (error message is generic), for actual reason you need to look at component log.

    Reply
raj says June 15, 2015

@Atul

I checked almost all possible log files for oacore, forms & oafm and couldn’t find anything relevant that could help me to resolve the timed out error. Do you have any suggestions?

regards,

Rajesh

Reply
raj says July 1, 2015

Hello Atul
I rectified the issues as following:
OEL/RHEL 7 hosts file entries are formatted in a different way for the localhost, which was the true reason for timeouts while shutting down the services. Once formatted as recommended by Oracle, all the services were shutting down normally.
Hope it helps few others out there.

regards,
Rajesh

Reply
abdul hameed says July 12, 2015

Hi Rajesh,

I am also faced “timeout” issue in a Different application installation process (SAS VA).

You are correct, the SAS support asked me to change the host name format to pass the issue.,..

Thanks for your findings..

Reply
raj says July 16, 2015

Hi Abdul

Just realized that there is a new comment! Anyway, I had kept on reading hundreds of articles about the timed out errors, usually happening due to the lock files. However, as my issues were while shutting down the services, raising Error: Missing Ormi[S]://:

I came across a BI related thread, even though it was not at all related to the topic I was searching for, I noticed that the OP mentioned something like “localhost” and a port number.

It was just pure logic, forced me to check out the hosts file formatting and to my utter surprise, realized for the first time that both EL 6 & EL 7 have a different pattern for the localhost entries.

I knew that I solved the issue, prior restating the server to confirm it!

We had the original deployment of R12 almost 6 years back over RHEL 5 & trust me mate, the same instance provides much better performance over OEL 7, sad that Oracle will NOT support such deployments though.

regards,

Rajesh

Reply
Maheswari says November 4, 2015

When I working on the PC..suddenly laptop got shutdown.so when I connect to the login r12 apps login page,page can’t be displayed error is thrown..If itry to connect apps/apps@vis ,it is showing that oracle intialuzation or shutdown in progress..kindly help me what are all the steps do I need to do..

Reply
Maheswari says November 4, 2015

Even I restarted the services related to vis from services window…and then tried to ligin the r12 login page..page can’t be displayed error..pls guide

Reply
Maheswari says November 5, 2015

Page cant be displayed when i tired to logi n into the R12 page….So when i tried to start the ofcleConcMgrVIS_apps service.Could nt start the oracleConcMgrVIS_apps service on local computer error..R12 is installed in Windows 2003 server….Please guide..

Reply
vipulme says November 22, 2015

Is startup and shutdown scripts are refer to CONTEXT_FILE in execution time ?

Thanks,
Vipul Megharaj

Reply
gaurav Taori says January 22, 2018

Oracle apps dba classes enquiry

Reply
Add Your Reply

Not found