{"id":2066,"date":"2021-01-25T20:14:28","date_gmt":"2021-01-25T20:14:28","guid":{"rendered":"https:\/\/swiv.com.br\/how-to-check-oracle-database-options-installed\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"how-to-check-oracle-database-options-installed","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/01\/25\/how-to-check-oracle-database-options-installed\/","title":{"rendered":"How to check Oracle Database Options installed"},"content":{"rendered":"\n<p>Uma option de banco de dados Oracle, de forma rasa e resumida, seria uma combina\u00e7\u00e3o de c\u00f3digos execut\u00e1veis existentes em uma instala\u00e7\u00e3o, e fatalmente objetos (como tabelas e procedures PL\/SQL) no banco. Essas options n\u00e3o estar\u00e3o habilitadas se estes objetos n\u00e3o foram criados no ambiente. <\/p>\n\n\n\n<p>Para checar quais s\u00e3o as options instaladas, basta rodar o seguinte comando no banco de dados:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SET LIN 300\nSQL&gt; SET PAGES 100\nSQL&gt; COL COMP_NAME FORMAT A40\nSQL&gt; COL VERSION FORMAT 999999999999\nSQL&gt; COL STATUS FORMAT A15\nSQL&gt; SELECT COMP_NAME,VERSION,STATUS FROM DBA_REGISTRY;\n \nCOMP_NAME                                VERSION                        STATUS\n---------------------------------------- ------------------------------ ---------------\nOracle Database Catalog Views            12.2.0.1.0                     VALID\nOracle Database Packages and Types       12.2.0.1.0                     VALID\nJServer JAVA Virtual Machine             12.2.0.1.0                     VALID\nOracle XDK                               12.2.0.1.0                     VALID\nOracle Database Java Packages            12.2.0.1.0                     VALID\nOLAP Analytic Workspace                  12.2.0.1.0                     VALID\nOracle Real Application Clusters         12.2.0.1.0                     OPTION OFF\nOracle XML Database                      12.2.0.1.0                     VALID\nOracle Workspace Manager                 12.2.0.1.0                     VALID\nOracle Text                              12.2.0.1.0                     VALID\nOracle Multimedia                        12.2.0.1.0                     VALID\nSpatial                                  12.2.0.1.0                     VALID\nOracle OLAP API                          12.2.0.1.0                     VALID\nOracle Label Security                    12.2.0.1.0                     VALID\nOracle Database Vault                    12.2.0.1.0                     VALID\n \n15 linhas selecionadas.\n \nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Uma option de banco de dados Oracle, de forma rasa e resumida, seria uma combina\u00e7\u00e3o de c\u00f3digos execut\u00e1veis existentes em uma instala\u00e7\u00e3o, e fatalmente objetos (como tabelas e procedures PL\/SQL) no banco. Essas options n\u00e3o estar\u00e3o habilitadas se estes objetos n\u00e3o foram criados no ambiente. Para checar quais s\u00e3o as options instaladas, basta rodar o [&hellip;]<\/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-2066","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\/2066","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=2066"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2066\/revisions"}],"predecessor-version":[{"id":9268,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2066\/revisions\/9268"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}