{"id":2109,"date":"2021-01-28T17:56:08","date_gmt":"2021-01-28T17:56:08","guid":{"rendered":"https:\/\/swiv.com.br\/sample-initialization-pfile-parameter-file\/"},"modified":"2026-05-27T20:02:52","modified_gmt":"2026-05-27T19:02:52","slug":"sample-initialization-pfile-parameter-file","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/01\/28\/sample-initialization-pfile-parameter-file\/","title":{"rendered":"Sample Initialization PFILE (Parameter File)"},"content":{"rendered":"<p>A Oracle possui em suas documenta\u00e7\u00f5es uma amostra simples de um arquivo pfile para caso queiramos tomar por refer\u00eancia (como neste exemplo <a rel=\"\\&quot;noreferrer noopener\" noopener=\"\" href=\"https:\/\/docs.oracle.com\/database\/121\/ADMIN\/create.htm#ADMIN12541\" target=\"\\&quot;_blank\\&quot;\">AQUI<\/a>.)<\/p>\n\n\n<p>Segue abaixo um sem preenchimento e outro com exemplos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n##############################################################################\n# Example INIT.ORA file\n#\n# This file is provided by Oracle Corporation to help you start by providing\n# a starting point to customize your RDBMS installation for your site. \n# \n# NOTE: The values that are used in this file are only intended to be used\n# as a starting point. You may want to adjust\/tune those values to your\n# specific hardware and needs. You may also consider using Database\n# Configuration Assistant tool (DBCA) to create INIT file and to size your\n# initial set of tablespaces based on the user input.\n###############################################################################\n  \n# Change &#039;&amp;lt;ORACLE_BASE&gt;&#039; to point to the oracle base (the one you specify at\n# install time)\n  \ndb_name=&#039;ORCL&#039;\nmemory_target=1G\nprocesses = 150\ndb_block_size=8192\ndb_domain=&#039;&#039;\ndb_recovery_file_dest=&#039;&amp;lt;ORACLE_BASE&gt;\/flash_recovery_area&#039;\ndb_recovery_file_dest_size=2G\ndiagnostic_dest=&#039;&amp;lt;ORACLE_BASE&gt;&#039;\ndispatchers=&#039;(PROTOCOL=TCP) (SERVICE=ORCLXDB)&#039;\nopen_cursors=300 \nremote_login_passwordfile=&#039;EXCLUSIVE&#039;\nundo_tablespace=&#039;UNDOTBS1&#039;\n# You may want to ensure that control files are created on separate physical\n# devices\ncontrol_files = (ora_control1, ora_control2)\ncompatible =&#039;12.0.0&#039;\n<\/pre><\/div>\n\n\n<p>Exemplo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n##############################################################################\n# Example INIT.ORA file\n#\n# This file is provided by Oracle Corporation to help you start by providing\n# a starting point to customize your RDBMS installation for your site. \n# \n# NOTE: The values that are used in this file are only intended to be used\n# as a starting point. You may want to adjust\/tune those values to your\n# specific hardware and needs. You may also consider using Database\n# Configuration Assistant tool (DBCA) to create INIT file and to size your\n# initial set of tablespaces based on the user input.\n###############################################################################\n  \n# Change &#039;&amp;lt;ORACLE_BASE&gt;&#039; to point to the oracle base (the one you specify at\n# install time)\n  \ndb_name=&#039;BSS&#039;\nmemory_target=2G\nprocesses = 150\ndb_block_size=8192\ndb_recovery_file_dest=&#039;\/restore\/BSS&#039;\ndb_recovery_file_dest_size=2G\ndiagnostic_dest=&#039;\/restore\/BSS&#039;\ndispatchers=&#039;(PROTOCOL=TCP) (SERVICE=ORCLXDB)&#039;\nopen_cursors=300 \nremote_login_passwordfile=&#039;EXCLUSIVE&#039;\nundo_tablespace=&#039;UNDOTBS1&#039;\n# You may want to ensure that control files are created on separate physical\n# devices\ncontrol_files = (&#039;\/restore\/BSS\/controlfile.ctl1&#039;, &#039;\/restore\/BSS\/controlfile.ctl2&#039;)\ncompatible =&#039;12.0.0&#039;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>A Oracle possui em suas documenta\u00e7\u00f5es uma amostra simples de um arquivo pfile para caso queiramos tomar por refer\u00eancia (como neste exemplo AQUI.) Segue abaixo um sem preenchimento e outro com exemplos: Exemplo:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[19],"class_list":["post-2109","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2109"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2109\/revisions"}],"predecessor-version":[{"id":9265,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2109\/revisions\/9265"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}