{"id":817,"date":"2008-09-10T14:57:31","date_gmt":"2008-09-10T18:57:31","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/"},"modified":"2008-09-11T05:40:06","modified_gmt":"2008-09-11T09:40:06","slug":"interview-questions-for-oracle-apps-dbas-11ir12-part-9","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/","title":{"rendered":"Interview Questions for Oracle Apps DBA’s (11i\/R12) – Part 9"},"content":{"rendered":"

Few more Interview questions for Apps DBA’s<\/p>\n

Q. I am applying database patch using\u00a0opatch. I don’t have oraInventory, can I apply database patch ?<\/strong>
\nNo, you can’t apply a database patch using opatch if Inventory<\/strong> is missing.
\nRegister ORACLE_HOME with global Inventory (in case inventory is missing) using steps mentioned here<\/a>\u00a0 “3.6.2 Creating the Central Inventory<\/strong>”<\/p>\n

Q. How many concurrent mangers can be used ? what is the limit ?<\/strong>
\nThere is no such documented limit on number of concurrent managers, as long as you have enough operating system resource (memory).<\/p>\n

Q. Suppose my concurrent manager status is showing Inactive ? what is the reason ?
\n<\/strong>This could be because of multiple reasons, to name few<\/p>\n

a)<\/strong> Processes value for Concurrent Manager is 0\u00a0 (System Administrator > Concurrent > Manager > Define > search for Manager > Click on the Work Shifts button and check value of Processes)<\/p>\n

b) <\/strong>Concurrent Manager was shut down by some one (Check using System Administrator > Concurrent > Manager > Administer)<\/p>\n

c) <\/strong>There is no workshift<\/strong> defined against Concurrent Manager (or workshift removed from Manager)<\/p>\n

.<\/p>\n

Q. What is transaction manager ? what is the significance ?
\n<\/strong>Normal\/Standard concurrent manager execute long running, data-intensive application program asynchronously<\/strong>, where as transaction manager support “synchronous<\/strong>” processing of particular requests.<\/p>\n

For more info and significance of transaction manager Check Oracle Applications System Administrator’s Guide – Configuration (zipped)<\/font>\u00a0 Here <\/a>\u00a0\u00a0\u00a0 (Page 176)<\/p>\n

Q. My cloning is successfully completed but my apps listener is not getting up ? What\u00a0is the problem ?<\/strong>
\nFirst check log file of apps listener to find root cause at
\n1. $OAD_TOP\/admin\/log\/$CONTEXT_NAME\/adalnctl.txt<\/strong>
\n2. $ORACLE_HOME\/network\/admin\/apps_$SID.log<\/strong>\u00a0 (on Middle Tier)<\/p>\n

To name few
\n1. Failure to create proper apps listener file via adgentns.sh<\/strong>\u00a0during Rapid Clone process
\n2. FNDSM (Service Manager issues)<\/p>\n

Q. How frequently do you preform patching ? (For work ex < 1.5 yrs)<\/strong>
\nPatching is done mainly to fix existing problem (bug) or for new features (enhancements). Frequency of patching vary from company to company and implementation stage.<\/p>\n

Q. How frequently you perform cloning ? (For work ex < 1.5 yrs)
\n<\/strong>This again vary from company to company. Frequency ranging from every few days or every few weeks to every few months.<\/p>\n

Q. How much time it will take to complete cloning ?
\n<\/strong>Cloning time depends<\/strong> on
\n– <\/strong>Network speed to copy various tops (APPL_TOP, COMMON_TOP.., DATA_TOP)
\n– <\/strong>Customizations (printer setting and any post clone issue)
\n– <\/strong>Topology (Number of middle tier, is system integrated with OID & SSO, Database is RAC or not, DMZ setup)<\/p>\n

Time for Rapid clone for single node<\/strong>
\nApprox. 30 Minutes for pre-clone
\nApprox. 1-2 hours for post clone on database tier
\nApprox. 1-2 hours for Middle tier
\n+
\nTime to copy files from source instance to target Instance<\/p>\n

Q. What\u00a0 is the purpose of the appsutil folder in ORACLE_HOME in database tier ?<\/strong>
\nappsutil directory in database ORACLE_HOME is place holder for Autoconfig<\/strong> and Rapid Clone<\/strong> related files on database Node.<\/p>\n

Q. After cloning my oraInventory got corrupted ? can I apply my Opatch?<\/strong>
\nNo, you can’t apply database patch using opatch (Though you can apply apps patch using adpatch). Recreate inventory as mentioned above.<\/p>\n

Q. what command is used to kill the process which is using largest memory ?
\n<\/strong>Vary as per operating system if you wish to kill o.s. process (kill -9 <pid>)<\/p>\n

Q. I am applying patch can I open another session and run adadmin ?<\/strong> (Thanks to Amit Pancholia for pointing this out<\/font>)
\nYes<\/strong> & No<\/strong> (depends on stage of patching), you can run adadmin<\/strong> if FND_INSTALL_PROCESSES<\/strong> is NOT<\/strong> locked (in use) by adpatch session. If this table is in use by adpatch session then you can’t<\/strong> run adadmin at same time.<\/p>\n

Q. I am applying patch can I open another session in another node and run adpatch ?
\n<\/strong>Well, question is tricky. If you are using shared appl_top<\/strong> (application tier) and using distributed patching<\/strong> (a.k.a. Distributed AD) feature then yes you can start patch from one node giving total number of workers and start X number of workers from node1 , then start another adpatch session<\/strong> from second node mentioning remaining workers to start from second node. (More on distributed patching in shared application tier <\/strong>environment coming soon …).
\nQ. I am not able to start concurrent manager ? What is the problem ?<\/strong>
\nThis could again be for various reasons, to check root cause of problem check log file at
\n$APPLCSF\/$APPLLOG\/$SID_MMDD.mgr<\/strong> (where MM is month & DD is Date on which Concurrent Manager was started)<\/p>\n","protected":false},"excerpt":{"rendered":"

Few more Interview questions for Apps DBA’s Q. I am applying database patch using\u00a0opatch. I don’t have oraInventory, can 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-817","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nInterview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -<\/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\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -\" \/>\n<meta property=\"og:description\" content=\"Few more Interview questions for Apps DBA’s Q. I am applying database patch using\u00a0opatch. I don’t have oraInventory, can I […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-09-10T18:57:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-09-11T09:40:06+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=\"4 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\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/\",\"name\":\"Interview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-09-10T18:57:31+00:00\",\"dateModified\":\"2008-09-11T09:40:06+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interview Questions for Oracle Apps DBA’s (11i\/R12) – Part 9\"}]},{\"@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":"Interview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -","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\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/","og_locale":"en_US","og_type":"article","og_title":"Interview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -","og_description":"Few more Interview questions for Apps DBA’s Q. I am applying database patch using\u00a0opatch. I don’t have oraInventory, can I […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/","article_published_time":"2008-09-10T18:57:31+00:00","article_modified_time":"2008-09-11T09:40:06+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/","name":"Interview Questions for Oracle Apps DBA's (11i\/R12) - Part 9 -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-09-10T18:57:31+00:00","dateModified":"2008-09-11T09:40:06+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/10\/interview-questions-for-oracle-apps-dbas-11ir12-part-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Interview Questions for Oracle Apps DBA’s (11i\/R12) – Part 9"}]},{"@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\/817","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=817"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}