This post covers step by step instructions of How to Start/Stop services in Oracle Applications R12. These steps are from Online Oracle Apps DBA (11i /R12) training here (This is interactive online course over weekend with hands on exercises on installation, patching, cloning during weekdays)
Assumptions
Application Tier O.S. User : avisr12 (usually applmgr)
Database Tier O.S. User : ovisr12 (usually oracle)
R12 install base : /oracle/apps/r12/visr12
Database SID : visr12
Database Version : 11.1.0
Hostname : focusthreadr12
Operating System : Unix/Linux
Apps Schema Password : apps (apps is default password)
.
Start-Up/Shutdown order
If you are starting services then first start Database Tier services and then Application Tier Services.
If you are shutting down services then first stop Application Tier services and then Database Tier Services.
1. Startup
1.1 Start Database Tier
1.1.1 Login as database tier user (ovisr12)
1.1.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/db/tech_st/11.1.0
—- cd /oracle/apps/r12/visr12/db/tech_st/11.1.0
—- . visr12_focusthreadr12.com (note: dot in front)
1.1.3 Start database
—- sqlplus “/as sysdba”
—- SQL> startup
1.1.4 Start Database Listener (lsnrctl start $SID)
—- lsnrctl start visr12
.
.
1.2 Start Application Tier
1.2.1 Login as application tier user (avisr12)
1.2.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/apps/apps_st/appl
—- cd /oracle/apps/r12/visr12/apps/apps_st/appl
—- . visr12_focusthreadr12.com (note: dot in front)
1.2.3 Start Application Tier (adstrtal.sh apps/$apps_password)
—- cd $ADMIN_SCRIPTS_HOME
—- ./adstrtal.sh apps/apps
.
.
2. Shutdown Services
2.1 Shutdown Application Tier
2.1.1 Login as application tier user (avisr12)
2.1.2 Set environment variable by running $SID_hostname.env from $INSTALL_BASE/apps/apps_st/appl
—- cd /oracle/apps/r12/visr12/apps/apps_st/appl
—- . visr12_focusthreadr12.com (note: dot in front)
2.1.3 Stop Application Tier (adstpall.sh apps/$apps_password)
—- cd $ADMIN_SCRIPTS_HOME
—- ./adstpall.sh apps/apps
.
2.2 Shutdown Database Tier
2.2.1 Login as database tier user (ovisr12)
2.2.2 Set environment variable by running $SID_hostname.env from $INSTALL_BASE/db/tech_st/11.1.0
—- cd /oracle/apps/r12/visr12/db/tech_st/11.1.0
—- . visr12_focusthreadr12.com (note: dot in front)
2.2.3 Stop database
—- sqlplus “/as sysdba”
—- SQL> shutdown immediate
2.2.4 Stop Database Listener (lsnrctl start $SID)
—- lsnrctl stop visr12
.
- For startup/shutdown in Oracle Applications 11i check here and here
- For start/stop services in Oracle Application Server (10g) click here
- For start/stop services in WebLogic (Fusion Middleware 11g) click here
.
To register for Oracle Apps DBA training (11i & R12) click here [next batch starting 17th April]
Related Posts for Startup Shutdown
- Start-up Shutdown Scripts in Oracle Apps R12
- Startup Shutdown Application Server – Bounce Services
- Startup Shutdown Apps Services
- ADAPCCTL.SH : EXITING WITH STATUS 150 , 204 : Apache Logs in R12
- adoacorectl.sh , adformsctl.sh , adoafmctl.sh – exiting with status 204
- How to Start / Stop services in Oracle Applications R12 ( Application / Database Tier)
Oracle WebLogic Administrator [USD 399]- 03rd Dec, 2011
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny 
20 users commented in " How to Start / Stop services in Oracle Applications R12 ( Application / Database Tier) "
Follow-up comment rss or Leave a TrackbackHi Atul,
In case, if databsae comes down when all services are up/running,
will everything be fine, if i simply startup the database again, or should I have to restart all application services as well.
This scenario might comes in case of any hardware cluster implemented for database node which runs on virtual IP/hostname, when everything gets mounted to failover node due to database is down, and database services will be restarted by the cluster scripts.
So what happens to the application node. should we have to restart the services there manually. (N.B – Not using RAC/TAF)
-Famy
@ Famy
In case, if databsae comes down when all services are up/running, will everything be fine, if i simply startup the database again, or should I have to restart all application services as well.
Ans : Restart Application Tier services as well (OC4J use connection pool)
I n case of database it is OK sqlplus is running , but in Application tier
when run command sqlplus apps/apps
ERROR:
ORA-01034: ORACLE not available
ORA -27123: unable to allocate to shared memeory segment
Linux error 13 : Permission denied
plzzzzzzz help
On Application Tier ensure environment variable is set properly.
Check $ORACLE_HOME and $TWO_TASK value from application tier
ORACLE_HOME should point to 806 ORACLE_HOME(in 11i) or 10.1.2 (in R12) forms and report home
TWO_TASK should point to your SID and there should be entry in tnsnames.ora in Application Tier ORACLE_HOME network directory
Hi,
I have recently bought r12 virtual machine and trying to start database lsnr..
I get the following error.
Starting /oracle/apps/r12/visr12/db/tech_st/11.1.0/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.1.0.7.0 – Production
System parameter file is /oracle/apps/r12/visr12/db/tech_st/11.1.0/network/admin/visr12_focusthreadr12/listener.ora
Log messages written to /oracle/apps/r12/visr12/db/tech_st/11.1.0/log/diag/tnslsnr/focusthreadr12/visr12/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=focusthreadr12.com)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above…
@ Padmaja,
This means listener is already running.
check status of listener using
lsnrctl status visr12
It seems you bought it from FocusThread so if you hit issues drop me a mail on my ID and I should be able to look at it by logging on to your machine remotely over weekend.
Hi
I have installed R12.1.1 on windows XP machine successfully. Immediately after installation I was able to login to the application.
After restarting the machine I’m unable to start the DB and application services on windows XP.
Step 1) cd D:\oracle\PRODHOME\db\tech_st\11.1.0
Step 2) PRODHOME_oraclealister.cmd
Step 3) sqlplus “/as sysdba” –> This gives the error “No TNS Listner”
Then I tried starting the lisnter using:
lsnrctl start PRODHOME –> This was successful
Now I tried Step 3) again, but it gives the error “ORA-12518: TNS:listener could not hand off client connection”
Regards,
John
@ John,
This could be because of Not enough memory on system
Check how much is free memory on system, check alert log and listener log of DB
Hi,
I have installed R12 on windows 7 which is bought by focusthread successfully. After installation I was able to login to the application.
I am getting below error after restarting my PC. Please let me know what wrong I am doing? I have followed all steps correctly from this article.
“Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, ohs_admin@com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
@ padmajabodla,
Download setup guide from http://81.143.3.107/r12vmware/
Ensure that all OC4Js are up and running
For steps on how to check OC4J status go to section under troubleshooting.
If you can’t fix this issue contact Focusthread Support team and they will fix issue remotely.
Database Tier O.S. User = oracle
Application Tier O.S. User = oracle
Database Version : 11.1.0
Database SID : VIS
hostname = oel
i have recently installed EBS R12.1.1 on OEL 5.
i have performed express installation of EBS.
After installation i was able to login to application but after restarting my pc em not able to logged in to application.
i performed following steps:
1- cd /d01/oracle/VIS/db/tech_st/11.1.0
2- ./VIS_oel.env
after performing these steps when i run lsnrctl start it results in an error
lsnrctl command not found.
please help me out how i overcome this problem.
Thank You
Saeed
@ Saeed
On point 2 run
. VIS_oel.env (dot then space and then env file)
After executing env file see if your ORACLE_HOME & ORACLE_SID are set by
a) running “env” (without quotes)
or
b) echo $ORACLE_HOME
thanks a lot Atul Kumar
now its working.
can u plz tell me how to explore HR in EBS.
thanks again
Saeed
Hi,
How can I clear AME cache? We are in the UAT phase and go live is on Monday.
Whenever I compile AME custom package (which is a copy of AME_UTIL), AME displace invalid object error in ame_exceptions_log. It worked some times when we ran the utlrp.sql script with SYSDBA privilege. Can you please help me to find out the where to clear cached object.
Thanks in advance,
Padmaja
Atul,
I have bought the virtual machine from Focusthread some time back but never used it actively as old PC was not powerful enough. Now I have bought a new laptop and put all the files on C drive. I have followed all the steps but getting error TNS-12560: TNS:protocol adapter error.
[ovisr12@focusthreadr12 ~]$ lsnrctl start visr12
LSNRCTL for Linux: Version 11.1.0.7.0 – Production on 19-SEP-2011 14:21:18
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Starting /oracle/apps/r12/visr12/db/tech_st/11.1.0/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.1.0.7.0 – Production
System parameter file is /oracle/apps/r12/visr12/db/tech_st/11.1.0/network/admin /visr12_focusthreadr12/listener.ora
Log messages written to /oracle/apps/r12/visr12/db/tech_st/11.1.0/log/diag/tnsls nr/focusthreadr12/visr12/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=focusthreadr12.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=focusthreadr12.com)(PORT =1521)))
TNS-12571: TNS:packet writer failure
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
Linux Error: 110: Connection timed out
In one of the reply you mentioned that listner must already be running but looks like its not. Here is the output of the status command. Your help is really appreciated.
[ovisr12@focusthreadr12 ~]$ lsnrctl status visr12
LSNRCTL for Linux: Version 11.1.0.7.0 – Production on 19-SEP-2011 14:56:54
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=focusthreadr12.com)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
Linux Error: 110: Connection timed out
[ovisr12@focusthreadr12 ~]$
Please help me out here. I had sent email to your support team but never got any response.
@ Hitesh,
Contact them on their support address and they will sort this out for you.
On R12, Clear middle tier cache is
Navigate to Functional Administrator responsibility > Core Services >
Caching Framework > Global Configuration > Clear cache
Is clearing $COMMON_TOP/_pages file not certified method for R12?
Thanks
Dilip
How to start, stop the r12 on windows
How to start, stop oracle apps r12 on windows
@ Musab,
Use widnows service or same command but with .bat extension
Leave A Reply