{"id":2640,"date":"2017-06-07T23:01:11","date_gmt":"2017-06-08T02:01:11","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2640\/"},"modified":"2017-08-01T23:05:35","modified_gmt":"2017-08-02T02:05:35","slug":"ocm-12c-preparation-create-and-manage-database-configuration-files","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/","title":{"rendered":"OCM 12c Preparation &#8211; Create and manage database configuration files"},"content":{"rendered":"<p><strong>&gt; This topic is pretty the same thing as we had in <a href=\"https:\/\/www.dbarj.com.br\/en\/2014\/11\/ocm-11g-preparation-create-manage-database-configuration-files\/\">OCM 11g exam<\/a>. But now as we have a container database scenario, we open more options. &lt;<\/strong><\/p>\n<p>So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and how to use the 260 parameters (not including the hidden ones)?<\/p>\n<p>Off course not. You\u00a0are studying for OCM, not for any memorization championship. But what you must know is how to easily find their syntax, meaning and utilization in the Oracle Documentation.\u00a0Memorize the top 50\u00a0main parameters (that you already may know) and just understand all the others. The more you know, the best for you for gaining time during the exam.<\/p>\n<p>Now in a container database you can change a parameter in CDB or PDB level. <strong>So you can have the same parameter with different values on multiple PDBs<\/strong>. It&#8217;s mandatory to understand those differences<\/p>\n<p>Some items that I recommend studying and memorizing:<\/p>\n<ul>\n<li>New parameters in 12c and in CDB context.<\/li>\n<li>The basic parameters to start a instance (like the ones that DBCA set during a typical database creation)<\/li>\n<li>The parameters to set up\u00a0a\u00a0RAC.<\/li>\n<li>The parameters to set up\u00a0a\u00a0Data Guard.<\/li>\n<li>The parameters that I already commented in other topics, like the memory ones.<\/li>\n<li>How to create spfile from pfile and vice-versa. (I hope you already know that)<\/li>\n<li>How to check session, instance and spfile\u00a0current parameter values.<\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\">Other oracle configuration files are: <strong>orapwfile, listener.ora, sqlnet.ora <\/strong>and<strong> tnsnames.ora<\/strong>.<\/span>\u00a0Do not forget to also read and study about them.<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Initialization Parameters<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 12c Preparation\" href=\"\/?page_id=2255\">Main OCM 12c Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!\n<p><object id=\"__symantecPKIClientMessenger\" style=\"display: none;\" data-install-updates-user-configuration=\"true\" data-supports-flavor-configuration=\"true\" data-extension-version=\"0.5.0.161\"><\/object><\/p>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-2640 jlk' href='javascript:void(0)' data-task='like' data-post_id='2640' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-2640 lc'>0<\/span><\/a><\/div><\/div> <div class='status-2640 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>&gt; This topic is pretty the same thing as we had in OCM 11g exam. But now as we have a container database scenario, we open more options. &lt; So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-2640","post","type-post","status-publish","format-standard","hentry","category-ocm12c-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 12c Preparation - Create and manage database configuration files - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Create and manage database configuration files for Oracle OCM 12c Certification\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 12c Preparation &#8211; Create and manage database configuration files\",\"datePublished\":\"2017-06-08T02:01:11+00:00\",\"dateModified\":\"2017-08-02T02:05:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/\"},\"wordCount\":291,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 12c Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/\",\"name\":\"OCM 12c Preparation - Create and manage database configuration files - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2017-06-08T02:01:11+00:00\",\"dateModified\":\"2017-08-02T02:05:35+00:00\",\"description\":\"Create and manage database configuration files for Oracle OCM 12c Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-database-configuration-files\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 12c Preparation - Create and manage database configuration files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OCM 12c Preparation - Create and manage database configuration files - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Create and manage database configuration files for Oracle OCM 12c Certification","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:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 12c Preparation &#8211; Create and manage database configuration files","datePublished":"2017-06-08T02:01:11+00:00","dateModified":"2017-08-02T02:05:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/"},"wordCount":291,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 12c Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/","url":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/","name":"OCM 12c Preparation - Create and manage database configuration files - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2017-06-08T02:01:11+00:00","dateModified":"2017-08-02T02:05:35+00:00","description":"Create and manage database configuration files for Oracle OCM 12c Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-database-configuration-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 12c Preparation - Create and manage database configuration files"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=2640"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2640\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}