• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • How to Start / Stop services in Oracle Applications R12 ( Application / Database Tier)

    Posted by "" in "r12" on 2010-03-16

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    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]

    22 Responses to “How to Start / Stop services in Oracle Applications R12 ( Application / Database Tier)”

    1. Famy says:

      Hi 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

    2. Atul Kumar says:

      @ 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)

    3. Furqan says:

      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

    4. Atul Kumar says:

      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

    5. padmajabodla says:

      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…

    6. Atul Kumar says:

      @ 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.

    7. John says:

      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

    8. Atul Kumar says:

      @ 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

    9. padmajabodla says:

      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.

    10. Atul Kumar says:

      @ 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.

    11. Saeed says:

      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

    12. Atul Kumar says:

      @ 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

    13. Saeed says:

      thanks a lot Atul Kumar
      now its working.
      can u plz tell me how to explore HR in EBS.
      thanks again :-)

      Saeed

    14. padmajabodla says:

      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

    15. Hitesh says:

      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.

    16. Atul Kumar says:

      @ Hitesh,
      Contact them on their support address and they will sort this out for you.

    17. dilipkumar.patel@gmail.com says:

      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

    18. musab says:

      How to start, stop the r12 on windows

    19. musab says:

      How to start, stop oracle apps r12 on windows

    20. Atul Kumar says:

      @ Musab,
      Use widnows service or same command but with .bat extension

    21. Junaid says:

      Dear Kumar,
      While stopping services of APPS through adstpall.sh

      At the end of script, I am receiving error “Exiting with Status 1″.

      When I reviewed the log file, I have come to know that adoacorectl.sh Failed.

      Can you help me in this regard to diagnose the problem.

      Thanks and Regards,

      Junaid

    22. Penta says:

      Dear apps dba,

      For security reasons,
      Can we start/stop the oracle apps services using non ‘apps’ user ?

      Because, if we write the password in the .sh file, we worry it’ll be read by others, so we want to create another user in the database.

      Please help, thanks for your info.

      Rgd,
      Penta

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP