{"id":8384,"date":"2026-03-14T14:20:36","date_gmt":"2026-03-14T17:20:36","guid":{"rendered":"https:\/\/executestep.com\/?p=8384"},"modified":"2026-03-14T14:20:38","modified_gmt":"2026-03-14T17:20:38","slug":"ora-01400-cannot-insert-null-dvsys-realm-object-datapatch","status":"publish","type":"post","link":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/","title":{"rendered":"ORA-01400 \u2014 Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch"},"content":{"rendered":"\n<p>Durante a aplica\u00e7\u00e3o de um <strong>Release Update (RU)<\/strong> com o <code>datapatch<\/code>, o processo pode falhar com o seguinte erro:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Patch 35643107 apply: WITH ERRORS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/35643107\/25405995\/35643107_apply_SVHMBR01.log (errors)\n  -> Error at line 239485: script rdbms\/admin\/catmacd.sql\n      - ORA-01400: cannot insert NULL into (\"DVSYS\".\"REALM_OBJECT$\".\"OWNER_UID#\")\n      - ORA-06512: at line 7\n      - ORA-06512: at line 2<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">Patch 35643107 apply: WITH ERRORS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/35643107\/25405995\/35643107_apply_SVHMBR01.log (errors)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">  -&gt; Error at line 239485: script rdbms\/admin\/catmacd.sql<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">      - ORA-01400: cannot insert NULL into (&quot;DVSYS&quot;.&quot;REALM_OBJECT$&quot;.&quot;OWNER_UID#&quot;)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">      - ORA-06512: at line 7<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">      - ORA-06512: at line 2<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O erro ORA-01400 \u00e9 gen\u00e9rico \u2014 significa que um INSERT tentou colocar NULL em uma coluna NOT NULL. Mas <strong>neste contexto espec\u00edfico<\/strong>, ele aparece exclusivamente em bancos com <strong>Oracle Database Vault (DV)<\/strong> habilitado, durante a execu\u00e7\u00e3o do script <code>catmacd.sql<\/code> que atualiza os objetos do DVSYS.<\/p>\n\n\n\n<p>Neste artigo, vou explicar <strong>por que esse erro ocorre<\/strong>, como confirmar que voc\u00ea est\u00e1 no mesmo cen\u00e1rio e como resolver de forma segura e suportada pela Oracle.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-small-font-size\"><strong>\ud83d\udca1 Na pr\u00e1tica:<\/strong> Encontrei esse erro ao aplicar o RU 19.21 em um banco que estava na vers\u00e3o 19.12 \u2014 um salto de 9 Release Updates. O Database Vault estava habilitado e o script de atualiza\u00e7\u00e3o do DVSYS falhava ao tentar popular a coluna <code>OWNER_UID#<\/code>. A solu\u00e7\u00e3o oficial da Oracle \u00e9 executar o datapatch com a flag <code>-ignorable_errors ORA-01400<\/code>.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Por Que o Erro Ocorre<\/h2>\n\n\n\n<p>O Oracle Database Vault (DV) possui tabelas internas no schema <strong>DVSYS<\/strong> que controlam realms, regras de acesso e objetos protegidos. Uma dessas tabelas \u00e9 a <code>DVSYS.REALM_OBJECT$<\/code>, que possui uma coluna <code>OWNER_UID#<\/code> com constraint NOT NULL.<\/p>\n\n\n\n<p>Quando o <code>datapatch<\/code> aplica um Release Update, ele executa o script <strong><code>catmacd.sql<\/code><\/strong> \u2014 respons\u00e1vel por atualizar os metadados do Database Vault. Em certas combina\u00e7\u00f5es de vers\u00e3o, esse script tenta inserir registros onde a coluna <code>OWNER_UID#<\/code> depende de dados que <strong>ainda n\u00e3o foram migrados<\/strong> naquele ponto da execu\u00e7\u00e3o do patching.<\/p>\n\n\n\n<p>O resultado: o INSERT falha com ORA-01400 porque o valor de <code>OWNER_UID#<\/code> \u00e9 NULL no momento da execu\u00e7\u00e3o.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Quando isso acontece<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Bancos com Database Vault habilitado<\/strong> \u2014 sem DV, o schema DVSYS nem existe<\/li>\n\n\n\n<li><strong>Saltos grandes de vers\u00e3o<\/strong> \u2014 ex: 19.3 \u2192 19.21, 19.12 \u2192 19.21 (quanto maior o salto, maior a chance)<\/li>\n\n\n\n<li><strong>Bug na sequ\u00eancia de execu\u00e7\u00e3o do catmacd.sql<\/strong> \u2014 documentado pela Oracle no MOS<\/li>\n\n\n\n<li>Pode ocorrer tanto em <strong>Single Instance<\/strong> quanto em <strong>RAC<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">O que N\u00c3O causa esse erro<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Problemas de permiss\u00e3o ou espa\u00e7o em disco<\/li>\n\n\n\n<li>Falha de SSH ou rede<\/li>\n\n\n\n<li>OPatch desatualizado<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Diagn\u00f3stico<\/h2>\n\n\n\n<p>Antes de aplicar a corre\u00e7\u00e3o, confirme que voc\u00ea est\u00e1 no cen\u00e1rio correto.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Verificar se o Database Vault est\u00e1 habilitado<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlplus \/ as sysdba\n\n-- M\u00e9todo 1: Verificar par\u00e2metro\nSELECT * FROM dba_dv_status;\n\n-- M\u00e9todo 2: Verificar se o schema DVSYS existe\nSELECT username, account_status\nFROM dba_users\nWHERE username = 'DVSYS';\n\n-- M\u00e9todo 3: Verificar componentes registrados\nSELECT comp_name, version, status\nFROM dba_registry\nWHERE comp_name LIKE '%Vault%';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">sqlplus \/ as sysdba<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- M\u00e9todo 1: Verificar par\u00e2metro<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT * FROM dba_dv_status;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- M\u00e9todo 2: Verificar se o schema DVSYS existe<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT username, account_status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE username = &#39;DVSYS&#39;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- M\u00e9todo 3: Verificar componentes registrados<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT comp_name, version, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE comp_name LIKE &#39;%Vault%&#39;;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Se o Database Vault <strong>n\u00e3o estiver habilitado<\/strong> ou o schema DVSYS n\u00e3o existir, o seu erro ORA-01400 tem outra causa \u2014 este artigo n\u00e3o se aplica.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Verificar o estado atual dos patches<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT patch_id, action, status, description\nFROM dba_registry_sqlpatch\nORDER BY action_time DESC\nFETCH FIRST 10 ROWS ONLY;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT patch_id, action, status, description<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry_sqlpatch<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">ORDER BY action_time DESC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FETCH FIRST 10 ROWS ONLY;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Procure por patches com <code>status = 'WITH ERRORS'<\/code>. Esse \u00e9 o RU que falhou.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Verificar o log do datapatch<\/h3>\n\n\n\n<p>O caminho do log \u00e9 mostrado na sa\u00edda do datapatch. Verifique o erro exatamente:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly># Procurar o erro no log\ngrep -n \"ORA-01400\\|DVSYS\\|REALM_OBJECT\\|catmacd\" \\\n  \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/&lt;PATCH_ID>\/*_apply_*.log<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\"># Procurar o erro no log<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">grep -n &quot;ORA-01400\\|DVSYS\\|REALM_OBJECT\\|catmacd&quot; \\<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">  \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/&lt;PATCH_ID&gt;\/*_apply_*.log<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Se o erro estiver em <strong><code>catmacd.sql<\/code><\/strong> referenciando <strong><code>DVSYS.REALM_OBJECT$.OWNER_UID#<\/code><\/strong>, voc\u00ea est\u00e1 no cen\u00e1rio correto.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Solu\u00e7\u00e3o: Executar o Datapatch com -ignorable_errors<\/h2>\n\n\n\n<p>A Oracle documenta essa solu\u00e7\u00e3o na <strong>MOS Note 2949214.1<\/strong>. A flag <code>-ignorable_errors<\/code> instrui o datapatch a <strong>continuar a execu\u00e7\u00e3o mesmo encontrando o erro especificado<\/strong>, e reaplicar os scripts que falharam.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Passo 1 \u2014 Executar o datapatch com a flag<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>$ORACLE_HOME\/OPatch\/datapatch -verbose -ignorable_errors ORA-01400<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">$ORACLE_HOME\/OPatch\/datapatch -verbose -ignorable_errors ORA-01400<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O datapatch vai:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Detectar que o RU anterior falhou com erros<\/li>\n\n\n\n<li>Reaplicar os scripts pendentes<\/li>\n\n\n\n<li>Ignorar o ORA-01400 quando encontrado no <code>catmacd.sql<\/code><\/li>\n\n\n\n<li>Continuar com o restante da aplica\u00e7\u00e3o<\/li>\n\n\n\n<li>Os dados que estavam faltando s\u00e3o populados em etapas posteriores do script<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Passo 2 \u2014 Verificar o resultado<\/h3>\n\n\n\n<p>Na sa\u00edda, procure por:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Patch 35643107 apply: SUCCESS\nPatch 35648110 apply: SUCCESS<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">Patch 35643107 apply: SUCCESS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">Patch 35648110 apply: SUCCESS<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Ambos devem mostrar <strong>SUCCESS<\/strong>, n\u00e3o mais <strong>WITH ERRORS<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Passo 3 \u2014 Validar no banco<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Verificar que os patches est\u00e3o aplicados com sucesso\nSELECT patch_id, action, status, description\nFROM dba_registry_sqlpatch\nORDER BY action_time DESC\nFETCH FIRST 10 ROWS ONLY;\n\n-- Verificar componentes do Database Vault\nSELECT comp_name, version, status\nFROM dba_registry\nWHERE comp_name LIKE '%Vault%';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">-- Verificar que os patches est\u00e3o aplicados com sucesso<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT patch_id, action, status, description<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry_sqlpatch<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">ORDER BY action_time DESC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FETCH FIRST 10 ROWS ONLY;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- Verificar componentes do Database Vault<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT comp_name, version, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE comp_name LIKE &#39;%Vault%&#39;;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O <code>STATUS<\/code> do Database Vault deve ser <strong>VALID<\/strong> e a vers\u00e3o deve corresponder ao RU aplicado.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Passo 4 \u2014 Verificar objetos inv\u00e1lidos<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Verificar objetos inv\u00e1lidos no DVSYS\nSELECT object_name, object_type, status\nFROM dba_objects\nWHERE owner = 'DVSYS' AND status = 'INVALID';\n\n-- Se houver objetos inv\u00e1lidos, recompilar\n@?\/rdbms\/admin\/utlrp.sql<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">-- Verificar objetos inv\u00e1lidos no DVSYS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT object_name, object_type, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_objects<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE owner = &#39;DVSYS&#39; AND status = &#39;INVALID&#39;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- Se houver objetos inv\u00e1lidos, recompilar<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">@?\/rdbms\/admin\/utlrp.sql<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">O Que a Flag -ignorable_errors Realmente Faz<\/h2>\n\n\n\n<p>\u00c9 importante entender que <code>-ignorable_errors<\/code> <strong>n\u00e3o ignora o erro silenciosamente<\/strong>. O que ela faz:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Registra<\/strong> o erro no log normalmente<\/li>\n\n\n\n<li><strong>N\u00e3o interrompe<\/strong> a execu\u00e7\u00e3o do datapatch por causa desse erro espec\u00edfico<\/li>\n\n\n\n<li><strong>Continua<\/strong> aplicando os scripts restantes do RU<\/li>\n\n\n\n<li>Os scripts que dependem dos dados que causaram o ORA-01400 s\u00e3o <strong>executados novamente<\/strong> em uma etapa posterior, quando os dados j\u00e1 est\u00e3o dispon\u00edveis<\/li>\n\n\n\n<li>No final, o resultado \u00e9 <strong>SUCCESS<\/strong> porque todos os objetos foram atualizados corretamente<\/li>\n<\/ol>\n\n\n\n<p>Essa flag \u00e9 <strong>suportada e documentada pela Oracle<\/strong> \u2014 n\u00e3o \u00e9 um hack ou workaround arriscado.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Considera\u00e7\u00f5es para Ambientes RAC<\/h2>\n\n\n\n<p>Em ambientes RAC com Database Vault, execute o datapatch <strong>a partir de um \u00fanico n\u00f3<\/strong> \u2014 ele se propaga para o banco compartilhado:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly># De qualquer n\u00f3 do RAC\n$ORACLE_HOME\/OPatch\/datapatch -verbose -ignorable_errors ORA-01400<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\"># De qualquer n\u00f3 do RAC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">$ORACLE_HOME\/OPatch\/datapatch -verbose -ignorable_errors ORA-01400<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Ap\u00f3s a execu\u00e7\u00e3o, verifique o estado em <strong>todas as inst\u00e2ncias<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Conectar em cada inst\u00e2ncia e verificar\nSELECT instance_name FROM v$instance;\n\nSELECT patch_id, action, status\nFROM dba_registry_sqlpatch\nORDER BY action_time DESC\nFETCH FIRST 5 ROWS ONLY;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">-- Conectar em cada inst\u00e2ncia e verificar<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT instance_name FROM v$instance;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT patch_id, action, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry_sqlpatch<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">ORDER BY action_time DESC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FETCH FIRST 5 ROWS ONLY;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Checklist R\u00e1pido de Diagn\u00f3stico<\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- 1. Database Vault est\u00e1 habilitado?\nSELECT * FROM dba_dv_status;\n\n-- 2. Quais patches falharam?\nSELECT patch_id, action, status, description\nFROM dba_registry_sqlpatch\nWHERE status = 'WITH ERRORS'\nORDER BY action_time DESC;\n\n-- 3. Verificar o erro no log (executar no shell)\n-- grep -n \"ORA-01400\\|DVSYS\\|REALM_OBJECT\" \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/&lt;PATCH_ID>\/*_apply_*.log\n\n-- 4. Ap\u00f3s a corre\u00e7\u00e3o: tudo com SUCCESS?\nSELECT patch_id, action, status\nFROM dba_registry_sqlpatch\nORDER BY action_time DESC\nFETCH FIRST 10 ROWS ONLY;\n\n-- 5. Database Vault VALID?\nSELECT comp_name, version, status\nFROM dba_registry\nWHERE comp_name LIKE '%Vault%';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">-- 1. Database Vault est\u00e1 habilitado?<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT * FROM dba_dv_status;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- 2. Quais patches falharam?<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT patch_id, action, status, description<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry_sqlpatch<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE status = &#39;WITH ERRORS&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">ORDER BY action_time DESC;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- 3. Verificar o erro no log (executar no shell)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- grep -n &quot;ORA-01400\\|DVSYS\\|REALM_OBJECT&quot; \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/&lt;PATCH_ID&gt;\/*_apply_*.log<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- 4. Ap\u00f3s a corre\u00e7\u00e3o: tudo com SUCCESS?<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT patch_id, action, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry_sqlpatch<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">ORDER BY action_time DESC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FETCH FIRST 10 ROWS ONLY;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\"><\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">-- 5. Database Vault VALID?<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT comp_name, version, status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">FROM dba_registry<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">WHERE comp_name LIKE &#39;%Vault%&#39;;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclus\u00e3o<\/h2>\n\n\n\n<p>O erro <strong>ORA-01400: cannot insert NULL into DVSYS.REALM_OBJECT$.OWNER_UID#<\/strong> durante o <code>datapatch<\/code> \u00e9 um <strong>bug conhecido<\/strong> que afeta bancos com <strong>Oracle Database Vault<\/strong> habilitado, especialmente em saltos grandes de vers\u00e3o de Release Update.<\/p>\n\n\n\n<p>O diagn\u00f3stico correto segue esta ordem:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Confirmar<\/strong> que o Database Vault est\u00e1 habilitado (<code>dba_dv_status<\/code>)<\/li>\n\n\n\n<li><strong>Verificar<\/strong> que o erro \u00e9 no <code>catmacd.sql<\/code> referenciando <code>DVSYS.REALM_OBJECT$<\/code><\/li>\n\n\n\n<li><strong>Executar<\/strong> <code>datapatch -verbose -ignorable_errors ORA-01400<\/code><\/li>\n\n\n\n<li><strong>Validar<\/strong> que todos os patches est\u00e3o com <code>SUCCESS<\/code><\/li>\n\n\n\n<li><strong>Verificar<\/strong> que o Database Vault est\u00e1 <code>VALID<\/code> e sem objetos inv\u00e1lidos<\/li>\n<\/ol>\n\n\n\n<p>A flag <code>-ignorable_errors<\/code> \u00e9 a solu\u00e7\u00e3o oficial da Oracle, documentada na MOS Note 2949214.1, e n\u00e3o apresenta riscos ao banco.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Refer\u00eancias:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2949214.1\">MOS Note 2949214.1 \u2014 ORA-01400 Cannot Insert NULL Into DVSYS.REALM_OBJECT$.OWNER_UID# During Datapatch<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/dvadm\/\">Oracle Database Vault Administrator&#8217;s Guide 19c<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sbydb\/using-datapatch.html\">Oracle OPatch and Datapatch Documentation<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Durante a aplica\u00e7\u00e3o de um Release Update (RU) com o datapatch, o processo pode falhar com o seguinte erro: O erro ORA-01400 \u00e9 gen\u00e9rico \u2014 significa que um INSERT tentou colocar NULL em uma coluna NOT NULL. Mas neste contexto espec\u00edfico, ele aparece exclusivamente em bancos com Oracle Database Vault (DV) habilitado, durante a execu\u00e7\u00e3o<\/p>\n","protected":false},"author":1,"featured_media":8299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"ORA-01400","_yoast_wpseo_title":"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ %%sep%% %%sitename%%","_yoast_wpseo_metadesc":"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.","footnotes":""},"categories":[34,29],"tags":[256,237,257,255,233,236,113],"class_list":{"0":"post-8384","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-oracle","8":"category-troubleshooting","9":"tag-database-vault","10":"tag-datapatch","11":"tag-dvsys","12":"tag-ora-01400","13":"tag-oracle","14":"tag-patching","15":"tag-troubleshooting"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step<\/title>\n<meta name=\"description\" content=\"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step\" \/>\n<meta property=\"og:description\" content=\"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/\" \/>\n<meta property=\"og:site_name\" content=\"Execute Step\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-14T17:20:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-14T17:20:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1408\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Henrique\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Henrique\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\"},\"author\":{\"name\":\"Henrique\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"headline\":\"ORA-01400 \u2014 Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch\",\"datePublished\":\"2026-03-14T17:20:36+00:00\",\"dateModified\":\"2026-03-14T17:20:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\"},\"wordCount\":833,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/default_image.png\",\"keywords\":[\"database-vault\",\"datapatch\",\"dvsys\",\"ora-01400\",\"oracle\",\"patching\",\"troubleshooting\"],\"articleSection\":[\"Oracle\",\"Troubleshooting\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\",\"name\":\"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/default_image.png\",\"datePublished\":\"2026-03-14T17:20:36+00:00\",\"dateModified\":\"2026-03-14T17:20:38+00:00\",\"description\":\"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#primaryimage\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/default_image.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/default_image.png\",\"width\":1408,\"height\":768,\"caption\":\"Default Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-01400 \u2014 Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\",\"name\":\"Execute Step\",\"description\":\"Execute with precision. Step by step.\",\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\",\"name\":\"Henrique\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"width\":182,\"height\":173,\"caption\":\"Henrique\"},\"logo\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\"},\"sameAs\":[\"https:\\\/\\\/executestep.com\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/henrique-soares-da-silva\\\/\",\"#\"],\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/author\\\/ricuxo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step","description":"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.","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:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/","og_locale":"pt_BR","og_type":"article","og_title":"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step","og_description":"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.","og_url":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/","og_site_name":"Execute Step","article_published_time":"2026-03-14T17:20:36+00:00","article_modified_time":"2026-03-14T17:20:38+00:00","og_image":[{"width":1408,"height":768,"url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png","type":"image\/png"}],"author":"Henrique","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Henrique","Est. tempo de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#article","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/"},"author":{"name":"Henrique","@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"headline":"ORA-01400 \u2014 Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch","datePublished":"2026-03-14T17:20:36+00:00","dateModified":"2026-03-14T17:20:38+00:00","mainEntityOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/"},"wordCount":833,"commentCount":0,"publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png","keywords":["database-vault","datapatch","dvsys","ora-01400","oracle","patching","troubleshooting"],"articleSection":["Oracle","Troubleshooting"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/","url":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/","name":"ORA-01400 - Cannot Insert NULL into DVSYS.REALM_OBJECT$ | Execute Step","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#primaryimage"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png","datePublished":"2026-03-14T17:20:36+00:00","dateModified":"2026-03-14T17:20:38+00:00","description":"Corrija o ORA-01400 no datapatch com Database Vault. Solu\u00e7\u00e3o oficial com -ignorable_errors para DVSYS.REALM_OBJECT$.OWNER_UID#.","breadcrumb":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#primaryimage","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/default_image.png","width":1408,"height":768,"caption":"Default Image"},{"@type":"BreadcrumbList","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/executestep.com\/pt-br\/"},{"@type":"ListItem","position":2,"name":"ORA-01400 \u2014 Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch"}]},{"@type":"WebSite","@id":"https:\/\/executestep.com\/pt-br\/#website","url":"https:\/\/executestep.com\/pt-br\/","name":"Execute Step","description":"Execute with precision. Step by step.","publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/executestep.com\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa","name":"Henrique","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","width":182,"height":173,"caption":"Henrique"},"logo":{"@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png"},"sameAs":["https:\/\/executestep.com","https:\/\/www.linkedin.com\/in\/henrique-soares-da-silva\/","#"],"url":"https:\/\/executestep.com\/pt-br\/author\/ricuxo\/"}]}},"_links":{"self":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/comments?post=8384"}],"version-history":[{"count":0,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8384\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media\/8299"}],"wp:attachment":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media?parent=8384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/categories?post=8384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/tags?post=8384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}