{"id":182,"date":"2007-10-09T02:54:32","date_gmt":"2007-10-09T06:54:32","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/"},"modified":"2007-10-09T03:42:58","modified_gmt":"2007-10-09T07:42:58","slug":"1z0-233-dump-or-interview-questions-for-oracle-apps-dba","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/","title":{"rendered":"1Z0-233 Dump or Interview Questions for Oracle Apps DBA"},"content":{"rendered":"

Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and Maintain Applications<\/strong> dump for certification.<\/p>\n

These question are submitted by our reader Jaya Kumar<\/strong>, Working as a “Oracle Apps DBA” in Chennai for “Savant Technologies<\/strong>” (www.savantit.com<\/a>) . If you wish to share question, script or any other useful information for Apps DBA’s then send it via Contact Us<\/strong> page on this site or send a mail to me at atul @ onLine Apps DBA .com<\/strong>Q. Explain Oracle Applications architecture \u2013 Components?
\n\u00a0
\n\u00a0\u00a0\u00a0 Desktop tier
\n\u00a0\u00a0\u00a0 Application EBS (Forms, Reports, Concurrent Processing, Web, Admin, Disc)<\/strong>Q. Find application server version ?
\n<\/strong>\u00a0
\n\u00a0\u00a0\u00a0 FND_PRODUCT_GROUPS<\/p>\n

<\/strong>Q. How will\u00a0you find the Apache, forms, reports version in an EBS suite?<\/strong><\/p>\n

\u00a0\u00a0\u00a0 http \u2013v \u2013 Apache
\n\u00a0\u00a0\u00a0 f60gen \u2013 Forms
\n\u00a0\u00a0\u00a0 ar60run \u2013 Reports<\/p>\n

Q. Find jinitiator version?
\n<\/strong>\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 Client side \u2013 Control panel
\n\u00a0\u00a0\u00a0 Server side \u2013 SID_hostname.xml (s_jinit_ver_)
\n\u00a0\u00a0\u00a0\u00a0
\nQ. Whatis\u00a0US directory in $AD_TOP or under various product TOP’s .
\n<\/strong>US directory is default language directory in Oracle Applications. If you have multiple language Installed in your Applications then you will see other language directories beside US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.<\/p>\n

Q.\u00a0Whats main concurrent Manager types.
\n<\/strong>\u00a0\u00a0 ICM – Internal Concurrent Manager which manage concurrent Managers
\n\u00a0\u00a0 Standard Managers – Which Manage processing of requests.
\n\u00a0 CRM – Conflict Resolution Managers , resolve conflicts in case of incompatibility.<\/p>\n

Q. Where is Concurrent Manager log file location ?
\n<\/strong>By default standard location is $APPLCSF\/$APPLLOG , in some cases it can go to $FND_TOP\/log as well.<\/p>\n

Q. List some ad utilities and their functions?
\n<\/strong>adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker<\/p>\n

Q. List out the modules related to oracle Apps DBA ?<\/strong>
\n\u00a0
\n\u00a0FND \u2013 Application Object Library, AU \u2013 Application Utilities, AD \u2013 Application DBA<\/p>\n

Q. What are profile options, what are various type of profile options ?<\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0 User, application, responsibility and site<\/p>\n

Q. List some profile options with their function?<\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 ICX: Session timeout, ICX: Forms Launcher, ICX: Limit Connect<\/p>\n

Q. How will you take the forms trace?
\n<\/strong>\u00a0
\n\u00a0\u00a0\u00a0\u00a0 http:\/\/hostname:port\/dev60cgi\/f60cgi?play=&record=collect&log=filename<\/a><\/p>\n

Q. How you put Applications 11i in Maintenance mode ? <\/strong><\/p>\n

Use adadmin to change Maintenance mode is Oracle Apps. With AD.I you need to enable maintenance mode in order to apply apps patch via adpatch utility. If you don’t want to put apps in maintenance mode you can use adpatch options=hotpatch feature.<\/p>\n

Q. What are the different types of oracle patches available ?<\/strong><\/p>\n

\u00a0 One-off, mini, diagnostics, cu, rup, language, help, platform specific, OS, OPatch,\u00a0\u00a0
\n\u00a0 Interoperability, family pack and maintenance pack.
\n\u00a0<\/p>\n

Q. What are the different patch drivers available?
\n<\/strong>\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 C driver,\u00a0 D driver, G driver and U driver.<\/p>\n

Q. Explain the steps for applying apps patch and database patch ?
\n<\/strong>\u00a0\u00a0
\nQ. What is autoconfig?<\/strong><\/p>\n

Q. How will you find the autoconfig is enabled?<\/strong><\/p>\n

Q. List out the following logfile locations?
\n<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 Patch log, autoconfig log, reports output, reports log and Concurrent manager log.<\/p>\n

Q. List out the important env files?
\n<\/strong>\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0 Appsora.env, appsSID_hostname.env, adovars.env, APPSSID_hostname<\/p>\n

Q. How to enable diagnostics for oracle applications?
\n<\/strong>\u00a0
\n\u00a0\u00a0\u00a0\u00a0 FND: Enable Diagnostics.. Tell about RDA and its use?<\/p>\n

Q. Describe about Discoverer Configuration and Oracle 10g AS installation ?
\n<\/strong><\/p>\n

So start sharing information which can be useful to others like scripts, document by clicking on Contact Us form or drop me a mail at atul @ onLine Apps DBA .com<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and […]<\/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":[48,98,46],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-1z0-233","tag-dump","tag-interview-question"],"yoast_head":"\n1Z0-233 Dump or Interview Questions for Oracle Apps DBA -<\/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\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"1Z0-233 Dump or Interview Questions for Oracle Apps DBA -\" \/>\n<meta property=\"og:description\" content=\"Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/\" \/>\n<meta property=\"article:published_time\" content=\"2007-10-09T06:54:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-10-09T07:42:58+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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/\",\"name\":\"1Z0-233 Dump or Interview Questions for Oracle Apps DBA -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2007-10-09T06:54:32+00:00\",\"dateModified\":\"2007-10-09T07:42:58+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"1Z0-233 Dump or Interview Questions for Oracle Apps DBA\"}]},{\"@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":"1Z0-233 Dump or Interview Questions for Oracle Apps DBA -","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\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/","og_locale":"en_US","og_type":"article","og_title":"1Z0-233 Dump or Interview Questions for Oracle Apps DBA -","og_description":"Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/","article_published_time":"2007-10-09T06:54:32+00:00","article_modified_time":"2007-10-09T07:42:58+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/","url":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/","name":"1Z0-233 Dump or Interview Questions for Oracle Apps DBA -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2007-10-09T06:54:32+00:00","dateModified":"2007-10-09T07:42:58+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/10\/09\/1z0-233-dump-or-interview-questions-for-oracle-apps-dba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"1Z0-233 Dump or Interview Questions for Oracle Apps DBA"}]},{"@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\/182","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=182"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}