{"id":446,"date":"2008-04-16T11:16:38","date_gmt":"2008-04-16T15:16:38","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/"},"modified":"2008-04-16T11:16:38","modified_gmt":"2008-04-16T15:16:38","slug":"startstop-oracle-apps-instance-is-it-that-simple","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/","title":{"rendered":"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!!"},"content":{"rendered":"

Start\/Stop Oracle Apps Instance.
\nThis looks very simple, hah I know this is just run adstrtal.sh\/adstpall.sh, addbctl.sh and addlnctl.sh. I used to think like this, then after gaining experience I came with my own steps.<\/p>\n

In previous approach, Did I took adequate step for checking any running concurrent requests .. did I took enough precaution to check what critical happenings going on in database like hot backup.. Now we shall take care \ud83d\ude42<\/p>\n

I assume you know the script location, I shall cover, if you still suggest me to include.<\/p>\n

Starting is Simple.<\/p>\n

    \n
  1. addbctl.sh start<\/li>\n
  2. addlnctl.sh start SID<\/li>\n
  3. adstrtal.sh apps\/password<\/li>\n<\/ol>\n

    Stoping is also fairly simple but “small care<\/strong>” needs to be taken to avoid critical issues.<\/p>\n

    I start my preparation sometime before the downtime scheduled, to let the concurrent request finish. Following are the steps to bring down middle-tier services<\/strong><\/p>\n

      \n
    1. Bring down the concurrent manager before maintenance say 20 mins before.
      \nadcmctl.sh stop apps\/Password<\/li>\n
    2. Check if any concurrent reqeust is running. if running, check what it is doing, like sql, session is active.<\/li>\n
    3. Check previous execution of similar program took how much time.Is it worth to wait or cancel the request<\/li>\n
    4. If it is affecting downtime then login from front-end and terminate the concurrent program, and make a note of request id(communicate to user who submitted this request so they can submit again)<\/li>\n
    5. Check the OS process id, whether it got terminated or not. If running then its a runaway process kill it. I dont like killings but…
      \nSQL> select oracle_process_id from fnd_concurrent_requests where request_id=&Request_id;<\/li>\n<\/ol>\n

      For bringing down database tier.<\/strong><\/p>\n

        \n
      1. Check if hot backup is going on or not..
        \nTo check, go to alert log file $ORACLE_HOME\/admin\/CONTEXT_NAME\/bdump\/alert_sid.log
        \nand also from sqlplus
        \nSQL> select distinct status from v$backup;
        \nIf it returns row containing “ACTIVE” then hot back is in progress.
        \nWait till it gets over.
        \nOtherwise next startup shall create problem. Though we have ways and means to overcome but why do that.<\/li>\n
      2. Conditional – If you are using DR<\/strong>, pls take care of following steps\n
          \n
        1. Check which archive dest state refer for DR, enable it .
          \nFrom show parameter log_archive_dest.. you may come to know..
          \nsay if you are using 3rd then run the sql
          \nSQL>alter system set log_archive_dest_state_3=enable;<\/li>\n
        2. Check if standby is performing managed recovery.
          \nSQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;PROCESS STATUS
          \n——- ————
          \nARCH CLOSING
          \nARCH CONNECTED
          \nMRP0 WAIT_FOR_LOG
          \nRFS WRITING
          \nRFS RECEIVING
          \nRFS RECEIVING<\/li>\n
        3. Cancel managed recovery operations.
          \nSQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;<\/li>\n
        4. Shut down the standby database.
          \nSQL> SHUTDOWN IMMEDIATE;<\/li>\n<\/ol>\n<\/li>\n
        5. Stop database<\/li>\n
        6. Now stop the listener<\/li>\n
        7. If still database is not going down, check in alert log , what exactly is going on.<\/li>\n
        8. Check if any processes are running having local=NO is running. If yes, kill..<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

          Start\/Stop Oracle Apps Instance. This looks very simple, hah I know this is just run adstrtal.sh\/adstpall.sh, addbctl.sh and addlnctl.sh. I […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-446","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nStart\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -\" \/>\n<meta property=\"og:description\" content=\"Start\/Stop Oracle Apps Instance. This looks very simple, hah I know this is just run adstrtal.sh\/adstpall.sh, addbctl.sh and addlnctl.sh. I […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-04-16T15:16:38+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/\",\"name\":\"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-04-16T15:16:38+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/","og_locale":"en_US","og_type":"article","og_title":"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -","og_description":"Start\/Stop Oracle Apps Instance. This looks very simple, hah I know this is just run adstrtal.sh\/adstpall.sh, addbctl.sh and addlnctl.sh. I […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/","article_published_time":"2008-04-16T15:16:38+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/","name":"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!! -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-04-16T15:16:38+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/16\/startstop-oracle-apps-instance-is-it-that-simple\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Start\/Stop Oracle Apps Instance. Is it that simple !!!!!!!!!!"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=446"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/446\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}