{"id":8530,"date":"2026-04-03T11:05:57","date_gmt":"2026-04-03T14:05:57","guid":{"rendered":"https:\/\/executestep.com\/?p=8530"},"modified":"2026-04-03T11:05:59","modified_gmt":"2026-04-03T14:05:59","slug":"ora-12547-tns-lost-contact","status":"publish","type":"post","link":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/","title":{"rendered":"ORA-12547 \u2014 TNS:lost contact ao conectar com sqlplus"},"content":{"rendered":"\n<p>Ao tentar abrir uma sess\u00e3o local com <code>sqlplus \/ as sysdba<\/code>, o Oracle encerra a conex\u00e3o antes mesmo de autenticar:<\/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(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\nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 2 01:54:17 2023\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nERROR:\nORA-12547: TNS:lost contact\n\n\nEnter user-name: ^C<\/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 <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">as<\/span><span style=\"color: #D8DEE9FF\"> sysdba<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SQL*<\/span><span style=\"color: #D8DEE9FF\">Plus: Release <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\"> Production <\/span><span style=\"color: #81A1C1\">on<\/span><span style=\"color: #D8DEE9FF\"> Sat <\/span><span style=\"color: #81A1C1\">Dec<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">01<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">54<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">17<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2023<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Version<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Copyright (c) <\/span><span style=\"color: #B48EAD\">1982<\/span><span style=\"color: #D8DEE9FF\">, <\/span><span style=\"color: #B48EAD\">2019<\/span><span style=\"color: #D8DEE9FF\">, Oracle.  All rights reserved.<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ERROR:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ORA<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">12547<\/span><span style=\"color: #D8DEE9FF\">: TNS:lost contact<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Enter user<\/span><span style=\"color: #81A1C1\">-name<\/span><span style=\"color: #D8DEE9FF\">: ^C<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O impacto \u00e9 imediato: <strong>o DBA perde acesso local ao banco<\/strong>. Sem uma sess\u00e3o <code>sysdba<\/code>, startup, shutdown e qualquer opera\u00e7\u00e3o administrativa de emerg\u00eancia ficam indispon\u00edveis.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Por Que Acontece<\/h2>\n\n\n\n<p>O ORA-12547 em uma conex\u00e3o local (<code>\/<\/code>) indica que o processo Oracle foi iniciado \u2014 ou tentou ser iniciado \u2014 mas a comunica\u00e7\u00e3o via IPC (bequeath pipe) falhou imediatamente. As causas mais comuns s\u00e3o:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ORACLE_HOME<\/code> com path incorreto (trailing slash, diret\u00f3rio inexistente ou vari\u00e1vel de ambiente desatualizada)<\/li>\n\n\n\n<li>Permiss\u00f5es erradas no bin\u00e1rio <code>$ORACLE_HOME\/bin\/oracle<\/code><\/li>\n<\/ul>\n\n\n\n<p>O Oracle n\u00e3o consegue localizar ou executar o bin\u00e1rio corretamente, e o TNS interpreta isso como &#8220;lost contact&#8221;.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Diagn\u00f3stico R\u00e1pido<\/h2>\n\n\n\n<p>Antes de aplicar qualquer solu\u00e7\u00e3o, identifique a causa verificando o <code>ORACLE_HOME<\/code> que o processo est\u00e1 usando de fato e as permiss\u00f5es do bin\u00e1rio:<\/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>ps -ef | grep pmon\noracle   42456     1  0 Dec01 ?        00:00:01 asm_pmon_+ASM\noracle   51812     1  0 02:35 ?        00:00:00 ora_pmon_scprbr07\noracle   55320 43687  0 02:42 pts\/0    00:00:00 grep --color=auto pmon\n\nxargs -0 -L1 -a \/proc\/51812\/environ | grep ORACLE_HOME\nORACLE_HOME=\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_1\/<\/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\">ps <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">ef | grep pmon<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">oracle   <\/span><span style=\"color: #B48EAD\">42456<\/span><span style=\"color: #D8DEE9FF\">     <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> Dec01 ?        <\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">01<\/span><span style=\"color: #D8DEE9FF\"> asm_pmon_<\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\">ASM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">oracle   <\/span><span style=\"color: #B48EAD\">51812<\/span><span style=\"color: #D8DEE9FF\">     <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">02<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">35<\/span><span style=\"color: #D8DEE9FF\"> ?        <\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\"> ora_pmon_scprbr07<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">oracle   <\/span><span style=\"color: #B48EAD\">55320<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">43687<\/span><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">02<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">42<\/span><span style=\"color: #D8DEE9FF\"> pts<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">00<\/span><span style=\"color: #D8DEE9FF\"> grep <\/span><span style=\"color: #616E88\">--color=auto pmon<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">xargs <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">L1 <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">a <\/span><span style=\"color: #81A1C1\">\/proc\/<\/span><span style=\"color: #B48EAD\">51812<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">environ | grep ORACLE_HOME<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ORACLE_HOME<\/span><span style=\"color: #81A1C1\">=\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_1<\/span><span style=\"color: #81A1C1\">\/<\/span><\/span><\/code><\/pre><\/div>\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>ls -l $ORACLE_HOME\/bin\/oracle\n-rwxr-xr-x 1 oracle oinstall 441253104 Dec 2 02:03 oracle<\/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\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">l $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">rwxr<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">xr<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">x <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> oracle oinstall <\/span><span style=\"color: #B48EAD\">441253104<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">Dec<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">02<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">03<\/span><span style=\"color: #D8DEE9FF\"> oracle<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Se o <code>ORACLE_HOME<\/code> terminar com <code>\/<\/code> ou apontar para um diret\u00f3rio inexistente, v\u00e1 para as Solu\u00e7\u00f5es 1 ou 2. Se as permiss\u00f5es do bin\u00e1rio n\u00e3o forem <code>-rwsr-s--x<\/code>, v\u00e1 para a Solu\u00e7\u00e3o 3.<\/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 1 \u2014 Trailing Slash no <code>\/etc\/oratab<\/code><\/h2>\n\n\n\n<p>Um <code>\/<\/code> extra ao final do caminho do <code>ORACLE_HOME<\/code> no <code>\/etc\/oratab<\/code> faz o <code>oraenv<\/code> montar a vari\u00e1vel com um separador duplicado, quebrando a resolu\u00e7\u00e3o de bin\u00e1rios.<\/p>\n\n\n\n<p><strong>Verifique:<\/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>cat \/etc\/oratab\n+ASM:\/u01\/app\/19.0.0.0\/grid:N\nscprbr07:\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_1\/:N<\/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\">cat <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">etc<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oratab<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\">ASM:<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">grid:N<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">scprbr07:<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">:N<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Corrija<\/strong> removendo o <code>\/<\/code> final, recarregue o ambiente e teste:<\/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(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>. oraenv\nORACLE_SID = &#91;scprbr07&#93; ? scprbr07\nThe Oracle base remains unchanged with value \/u01\/app\/oracle\n\nsqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 2 02:06:33 2023\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL><\/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\">. oraenv<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ORACLE_SID <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> &#91;scprbr07&#93; ? scprbr07<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">The Oracle base remains unchanged <\/span><span style=\"color: #81A1C1\">with<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">value<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">sqlplus <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">as<\/span><span style=\"color: #D8DEE9FF\"> sysdba<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SQL*<\/span><span style=\"color: #D8DEE9FF\">Plus: Release <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\"> Production <\/span><span style=\"color: #81A1C1\">on<\/span><span style=\"color: #D8DEE9FF\"> Sat <\/span><span style=\"color: #81A1C1\">Dec<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">02<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">06<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">33<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2023<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Version<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Copyright (c) <\/span><span style=\"color: #B48EAD\">1982<\/span><span style=\"color: #D8DEE9FF\">, <\/span><span style=\"color: #B48EAD\">2019<\/span><span style=\"color: #D8DEE9FF\">, Oracle.  All rights reserved.<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Connected <\/span><span style=\"color: #81A1C1\">to<\/span><span style=\"color: #D8DEE9FF\">:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Oracle <\/span><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> 19c Enterprise <\/span><span style=\"color: #81A1C1\">Edition<\/span><span style=\"color: #D8DEE9FF\"> Release <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\"> Production<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Version<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SQL&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Se o banco estiver registrado no <code>srvctl<\/code> (ambientes RAC ou Grid Infrastructure)<\/strong>, o srvctl mant\u00e9m um registro pr\u00f3prio do <code>ORACLE_HOME<\/code> \u2014 corrija l\u00e1 tamb\u00e9m:<\/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(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>srvctl config database -d scprbr07\nDatabase unique name: scprbr07\nDatabase name:\nOracle home: \/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_1\/\nOracle user: oracle\nSpfile: +DATA\/SCPRBR07\/PARAMETERFILE\/spfile.257.1145122115\nPassword file: +DATA\/SCPRBR07\/PASSWORD\/pwdscprbr07.278.1088971723\nDomain:\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nDisk Groups: DATA\nServices: scprbr07_serv\nOSDBA group:\nOSOPER group:\nDatabase instance: scprbr07<\/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\">srvctl config <\/span><span style=\"color: #81A1C1\">database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">d scprbr07<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">unique<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">name<\/span><span style=\"color: #D8DEE9FF\">: scprbr07<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">name<\/span><span style=\"color: #D8DEE9FF\">:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Oracle home: <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_1<\/span><span style=\"color: #81A1C1\">\/<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Oracle user: oracle<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Spfile: <\/span><span style=\"color: #81A1C1\">+DATA\/<\/span><span style=\"color: #D8DEE9FF\">SCPRBR07<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">PARAMETERFILE<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">spfile.257.<\/span><span style=\"color: #B48EAD\">1145122115<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Password<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">file<\/span><span style=\"color: #D8DEE9FF\">: <\/span><span style=\"color: #81A1C1\">+DATA\/<\/span><span style=\"color: #D8DEE9FF\">SCPRBR07<\/span><span style=\"color: #81A1C1\">\/PASSWORD\/<\/span><span style=\"color: #D8DEE9FF\">pwdscprbr07.278.<\/span><span style=\"color: #B48EAD\">1088971723<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Domain:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Start<\/span><span style=\"color: #D8DEE9FF\"> options: <\/span><span style=\"color: #81A1C1\">open<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Stop<\/span><span style=\"color: #D8DEE9FF\"> options: <\/span><span style=\"color: #81A1C1\">immediate<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">role<\/span><span style=\"color: #D8DEE9FF\">: <\/span><span style=\"color: #81A1C1\">PRIMARY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Management <\/span><span style=\"color: #81A1C1\">policy<\/span><span style=\"color: #D8DEE9FF\">: <\/span><span style=\"color: #81A1C1\">AUTOMATIC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Disk<\/span><span style=\"color: #D8DEE9FF\"> Groups: <\/span><span style=\"color: #81A1C1\">DATA<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Services: scprbr07_serv<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">OSDBA group:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">OSOPER group:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> instance: scprbr07<\/span><\/span><\/code><\/pre><\/div>\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>srvctl modify database -d scprbr07 -o \/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_1<\/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\">srvctl <\/span><span style=\"color: #81A1C1\">modify<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">d scprbr07 <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">o <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_1<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Ap\u00f3s corrigir no <code>srvctl<\/code>, fa\u00e7a stop\/start do banco para ele subir com o <code>ORACLE_HOME<\/code> 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 2 \u2014 <code>ORACLE_HOME<\/code> Incorreto no Ambiente do Shell<\/h2>\n\n\n\n<p>O <code>\/etc\/oratab<\/code> pode estar correto, mas o <code>ORACLE_HOME<\/code> definido no <code>.bash_profile<\/code> ou <code>.bashrc<\/code> pode apontar para um diret\u00f3rio inexistente \u2014 situa\u00e7\u00e3o comum ap\u00f3s patches que alteram o path do Oracle Home.<\/p>\n\n\n\n<p><strong>Verifique:<\/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>echo $ORACLE_HOME\n\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_INEXISTENTE\n\nls -d $ORACLE_HOME\nls: cannot access '\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_INEXISTENTE': No such file or directory<\/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\">echo $ORACLE_HOME<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_INEXISTENTE<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">d $ORACLE_HOME<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ls: cannot access <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_INEXISTENTE<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">: <\/span><span style=\"color: #81A1C1\">No<\/span><span style=\"color: #D8DEE9FF\"> such <\/span><span style=\"color: #81A1C1\">file<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">or<\/span><span style=\"color: #D8DEE9FF\"> directory<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Corrija<\/strong> o <code>.bash_profile<\/code> com o path real, ou use o <code>oraenv<\/code> para redefinir corretamente:<\/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>. oraenv\nORACLE_SID = &#91;scprbr07&#93; ? scprbr07\nThe Oracle base remains unchanged with value \/u01\/app\/oracle<\/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\">. oraenv<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ORACLE_SID <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> &#91;scprbr07&#93; ? scprbr07<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">The Oracle base remains unchanged <\/span><span style=\"color: #81A1C1\">with<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">value<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Confirme o path correto<\/strong> localizando o bin\u00e1rio Oracle instalado:<\/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>find \/u01 -name \"oracle\" -type f -perm \/u+x 2>\/dev\/null\n\/u01\/app\/oracle\/product\/19.3.0.0\/dbhome_1\/bin\/oracle<\/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\">find <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01 <\/span><span style=\"color: #81A1C1\">-name<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">oracle<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-type<\/span><span style=\"color: #D8DEE9FF\"> f <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">perm <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u<\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\">x <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #81A1C1\">&gt;\/<\/span><span style=\"color: #D8DEE9FF\">dev<\/span><span style=\"color: #81A1C1\">\/null<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">u01<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">app<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">product<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">dbhome_1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/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\">Solu\u00e7\u00e3o 3 \u2014 Permiss\u00f5es Incorretas no Bin\u00e1rio oracle<\/h2>\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\">\u26a0\ufe0f <strong>Aten\u00e7\u00e3o:<\/strong> o comando abaixo altera permiss\u00f5es de um bin\u00e1rio cr\u00edtico do Oracle. Execute como <code>root<\/code> ou com <code>sudo<\/code>. Em ambientes RAC, aplique em todos os n\u00f3s.<\/p>\n<\/blockquote>\n\n\n\n<p>O bin\u00e1rio <code>$ORACLE_HOME\/bin\/oracle<\/code> precisa ter os bits <code>setuid<\/code> e <code>setgid<\/code> ativos (permiss\u00e3o <code>6751<\/code>) para que o Oracle consiga escalar privil\u00e9gios internamente. Se essas permiss\u00f5es foram removidas por hardening, deploy incorreto ou reinstala\u00e7\u00e3o, a conex\u00e3o local falha com ORA-12547.<\/p>\n\n\n\n<p><strong>Verifique:<\/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>ls -l $ORACLE_HOME\/bin\/oracle\n-rwxr-xr-x 1 oracle oinstall 441253104 Dec 2 02:03 oracle<\/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\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">l $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">rwxr<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">xr<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">x <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> oracle oinstall <\/span><span style=\"color: #B48EAD\">441253104<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">Dec<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">02<\/span><span style=\"color: #D8DEE9FF\">:<\/span><span style=\"color: #B48EAD\">03<\/span><span style=\"color: #D8DEE9FF\"> oracle<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Corrija e confirme:<\/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>chmod 6751 $ORACLE_HOME\/bin\/oracle\n\nls -l $ORACLE_HOME\/bin\/oracle\n-rwsr-s--x 1 oracle oinstall 441253104 Dec 2 02:03 oracle<\/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\">chmod <\/span><span style=\"color: #B48EAD\">6751<\/span><span style=\"color: #D8DEE9FF\"> $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">l $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">rwsr<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">s<\/span><span style=\"color: #616E88\">--x 1 oracle oinstall 441253104 Dec 2 02:03 oracle<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Teste a conex\u00e3o:<\/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>sqlplus \/ as sysdba\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL><\/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 <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">as<\/span><span style=\"color: #D8DEE9FF\"> sysdba<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Connected <\/span><span style=\"color: #81A1C1\">to<\/span><span style=\"color: #D8DEE9FF\">:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Oracle <\/span><span style=\"color: #81A1C1\">Database<\/span><span style=\"color: #D8DEE9FF\"> 19c Enterprise <\/span><span style=\"color: #81A1C1\">Edition<\/span><span style=\"color: #D8DEE9FF\"> Release <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\"> Production<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Version<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">19<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #B48EAD\">0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SQL&gt;<\/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<\/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>ps -ef | grep pmon | grep -v grep\nxargs -0 -L1 -a \/proc\/&lt;PID>\/environ | grep ORACLE_HOME\n\ncat \/etc\/oratab | grep -v \"^#\"\n\nls -d $ORACLE_HOME\n\nls -l $ORACLE_HOME\/bin\/oracle\n\nchmod 6751 $ORACLE_HOME\/bin\/oracle\n\n. oraenv\nsqlplus \/ as sysdba<\/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\">ps <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">ef | grep pmon | grep <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">v grep<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">xargs <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">L1 <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">a <\/span><span style=\"color: #81A1C1\">\/proc\/&lt;<\/span><span style=\"color: #D8DEE9FF\">PID<\/span><span style=\"color: #81A1C1\">&gt;\/<\/span><span style=\"color: #D8DEE9FF\">environ | grep ORACLE_HOME<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">cat <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">etc<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oratab | grep <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">v <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">^#<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">d $ORACLE_HOME<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">ls <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">l $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">chmod <\/span><span style=\"color: #B48EAD\">6751<\/span><span style=\"color: #D8DEE9FF\"> $ORACLE_HOME<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">bin<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">oracle<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">. oraenv<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">sqlplus <\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">as<\/span><span style=\"color: #D8DEE9FF\"> sysdba<\/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\">Erros Conhecidos<\/h2>\n\n\n\n<p><strong>ORA-12547 persiste ap\u00f3s corrigir o <code>oratab<\/code> em ambiente RAC<\/strong> O srvctl mant\u00e9m um registro pr\u00f3prio do <code>ORACLE_HOME<\/code>. Corrija com <code>srvctl modify database -d <db> -o <path><\/path><\/db><\/code> e fa\u00e7a stop\/start do banco.<\/p>\n\n\n\n<p><strong><code>chmod 6751<\/code> falha com &#8220;Operation not permitted&#8221;<\/strong> O comando precisa ser executado como <code>root<\/code>. Em sistemas com SELinux ou pol\u00edticas de hardening de SO, pode ser necess\u00e1rio ajustar pol\u00edticas antes de alterar permiss\u00f5es de setuid.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Refer\u00eancias<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/errmg\/ORA-12500.html#GUID-DCB76678-1AE5-4D41-B8C5-B94F2E0F040C\">Oracle Database Error Messages 19c \u2014 ORA-12547<\/a><\/li>\n\n\n\n<li>Oracle Support Doc ID 1093611.1 \u2014 Permissions and Ownership for Oracle Binaries (acesso via MOS)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Ao tentar abrir uma sess\u00e3o local com sqlplus \/ as sysdba, o Oracle encerra a conex\u00e3o antes mesmo de autenticar: O impacto \u00e9 imediato: o DBA perde acesso local ao banco. Sem uma sess\u00e3o sysdba, startup, shutdown e qualquer opera\u00e7\u00e3o administrativa de emerg\u00eancia ficam indispon\u00edveis. Por Que Acontece O ORA-12547 em uma conex\u00e3o local (\/)<\/p>\n","protected":false},"author":1,"featured_media":8536,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"ORA-12547","_yoast_wpseo_title":"ORA-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep","_yoast_wpseo_metadesc":"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.","footnotes":""},"categories":[34,174],"tags":[313,322,320,321,190],"class_list":{"0":"post-8530","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-oracle","9":"tag-lab","10":"tag-listener","11":"tag-ora-12547","12":"tag-tns","13":"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-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep<\/title>\n<meta name=\"description\" content=\"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.\" \/>\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-12547-tns-lost-contact\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep\" \/>\n<meta property=\"og:description\" content=\"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/\" \/>\n<meta property=\"og:site_name\" content=\"Execute Step\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-03T14:05:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-03T14:05:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\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=\"3 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-12547-tns-lost-contact\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/\"},\"author\":{\"name\":\"Henrique\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"headline\":\"ORA-12547 \u2014 TNS:lost contact ao conectar com sqlplus\",\"datePublished\":\"2026-04-03T14:05:57+00:00\",\"dateModified\":\"2026-04-03T14:05:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/\"},\"wordCount\":505,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/ora-12547-1.png\",\"keywords\":[\"lab\",\"listener\",\"ORA-12547\",\"tns\",\"troubleshooting\"],\"articleSection\":[\"Oracle\",\"Oracle\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/\",\"name\":\"ORA-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/ora-12547-1.png\",\"datePublished\":\"2026-04-03T14:05:57+00:00\",\"dateModified\":\"2026-04-03T14:05:59+00:00\",\"description\":\"ORA-12547 ao conectar com sqlplus \\\/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#primaryimage\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/ora-12547-1.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/ora-12547-1.png\",\"width\":640,\"height\":360,\"caption\":\"ora-12547\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/ora-12547-tns-lost-contact\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-12547 \u2014 TNS:lost contact ao conectar com sqlplus\"}]},{\"@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-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep","description":"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.","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-12547-tns-lost-contact\/","og_locale":"pt_BR","og_type":"article","og_title":"ORA-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep","og_description":"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.","og_url":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/","og_site_name":"Execute Step","article_published_time":"2026-04-03T14:05:57+00:00","article_modified_time":"2026-04-03T14:05:59+00:00","og_image":[{"width":640,"height":360,"url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png","type":"image\/png"}],"author":"Henrique","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Henrique","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#article","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/"},"author":{"name":"Henrique","@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"headline":"ORA-12547 \u2014 TNS:lost contact ao conectar com sqlplus","datePublished":"2026-04-03T14:05:57+00:00","dateModified":"2026-04-03T14:05:59+00:00","mainEntityOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/"},"wordCount":505,"commentCount":0,"publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png","keywords":["lab","listener","ORA-12547","tns","troubleshooting"],"articleSection":["Oracle","Oracle"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/","url":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/","name":"ORA-12547 \u2014 TNS:lost contact no sqlplus | ExecuteStep","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#primaryimage"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png","datePublished":"2026-04-03T14:05:57+00:00","dateModified":"2026-04-03T14:05:59+00:00","description":"ORA-12547 ao conectar com sqlplus \/ as sysdba? Veja como diagnosticar e corrigir: oratab com trailing slash, ORACLE_HOME inv\u00e1lido e permiss\u00f5es do bin\u00e1rio.","breadcrumb":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#primaryimage","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/04\/ora-12547-1.png","width":640,"height":360,"caption":"ora-12547"},{"@type":"BreadcrumbList","@id":"https:\/\/executestep.com\/pt-br\/oracle\/ora-12547-tns-lost-contact\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/executestep.com\/pt-br\/"},{"@type":"ListItem","position":2,"name":"ORA-12547 \u2014 TNS:lost contact ao conectar com sqlplus"}]},{"@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\/8530","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=8530"}],"version-history":[{"count":0,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8530\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media\/8536"}],"wp:attachment":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media?parent=8530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/categories?post=8530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/tags?post=8530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}