{"id":8384,"date":"2026-03-14T14:20:36","date_gmt":"2026-03-14T17:20:36","guid":{"rendered":"https:\/\/executestep.com\/?p=8384"},"modified":"2026-05-19T00:10:00","modified_gmt":"2026-05-19T03:10:00","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- Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">O erro ORA-01400 \u00e9 gen\u00e9rico- 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 class=\"wp-block-paragraph\">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 wp-block-paragraph\"><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- 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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">Quando o <code>datapatch<\/code> aplica um Release Update, ele executa o script <strong><code>catmacd.sql<\/code><\/strong>&#8211; 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 class=\"wp-block-paragraph\">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>&#8211; sem DV, o schema DVSYS nem existe<\/li>\n\n\n\n<li><strong>Saltos grandes de vers\u00e3o<\/strong>&#8211; 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>&#8211; 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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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- 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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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- 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 class=\"wp-block-paragraph\">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- Verificar o resultado<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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- 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 class=\"wp-block-paragraph\">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- 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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">Essa flag \u00e9 <strong>suportada e documentada pela Oracle<\/strong>&#8211; 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 class=\"wp-block-paragraph\">Em ambientes RAC com Database Vault, execute o datapatch <strong>a partir de um \u00fanico n\u00f3<\/strong>&#8211; 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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><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- 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- 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 do<\/p>\n","protected":false},"author":1,"featured_media":8299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,29],"tags":[256,237,257,255,233,236,113],"class_list":["post-8384","post","type-post","status-publish","format-standard","has-post-thumbnail","category-oracle","category-troubleshooting","tag-database-vault","tag-datapatch","tag-dvsys","tag-ora-01400","tag-oracle","tag-patching","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - 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-05-19T03:10:00+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- Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch\",\"datePublished\":\"2026-03-14T17:20:36+00:00\",\"dateModified\":\"2026-05-19T03:10:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\\\/\"},\"wordCount\":842,\"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-05-19T03:10:00+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- 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-05-19T03:10:00+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- Como Corrigir &#8220;Cannot Insert NULL into DVSYS.REALM_OBJECT$&#8221; no Datapatch","datePublished":"2026-03-14T17:20:36+00:00","dateModified":"2026-05-19T03:10:00+00:00","mainEntityOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-01400-cannot-insert-null-dvsys-realm-object-datapatch\/"},"wordCount":842,"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-05-19T03:10:00+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- 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":1,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8384\/revisions"}],"predecessor-version":[{"id":9216,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8384\/revisions\/9216"}],"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}]}}