{"id":721,"date":"2020-07-13T14:31:16","date_gmt":"2020-07-13T12:31:16","guid":{"rendered":"http:\/\/rootfan.com\/?p=721"},"modified":"2022-04-03T23:50:10","modified_gmt":"2022-04-03T21:50:10","slug":"encontrar-alter-log-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/find-alert-file-location-oracle\/","title":{"rendered":"C\u00f3mo encontrar la ubicaci\u00f3n del alert log en Oracle"},"content":{"rendered":"<p>En las versiones m\u00e1s recientes de Oracle no es obvio d\u00f3nde est\u00e1 el alert file para investigar posibles problemas.<\/p>\n\n\n\n<p>Si quieres saber c\u00f3mo comprobar los errores del alert file en Oracle, sigue leyendo.<\/p>\n\n\n\n<p>Tienes un par de maneras de saber d\u00f3nde se encuentra tu alert file en Oracle.<\/p>\n\n\n\n<p>1. Si la base de datos Oracle est\u00e1 abierta <\/p>\n\n\n\n<p>Puedes utilizar esta consulta despu\u00e9s de conectarte con: sqlplus \/ as sysdba<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect * \nfrom v$diag_info \nwhere NAME = 'Diag Trace';\n<\/pre><\/div>\n\n\n<p>2. Si la base de datos Oracle no est\u00e1 abierta <\/p>\n\n\n\n<p>Puedes utilizar adrci desde la l\u00ednea de comandos<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# adrci\n\nADR base = &quot;\/u01\/app\/oracle&quot;\nadrci&gt; show homes\nADR Homes:\ndiag\/rdbms\/yp001p\/YP001P1\ndiag\/rdbms\/azamoa\/azamoa1\ndiag\/clients\/user_oracle\/host_2133002082_110\ndiag\/tnslsnr\/xm1iddb21\/listener_dg\nadrci&gt;\n<\/pre><\/div>\n\n\n<p>Puedes ver que hay varios homes. <\/p>\n\n\n\n<p>Si quieres comprobar el alert file de la base de datos YP001P1, debes utilizar el ADR base seguido del ADR home (de la salida anterior) y, a continuaci\u00f3n, a\u00f1ade la carpeta trace al final<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncd \/u01\/app\/oracle\/diag\/rdbms\/yp001p\/YP001P1\/trace\n<\/pre><\/div>\n\n\n<p>Una vez en esa carpeta puedes comprobar el alert file<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nls -lrt alert*\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>En las versiones m\u00e1s recientes de Oracle Database no es obvio d\u00f3nde se encuentra el archivo de alertas para investigar cualquier problema potencial. Si quiere saber c\u00f3mo comprobar los errores del registro de alertas en Oracle, siga leyendo. Tiene un par de formas de saber d\u00f3nde se encuentra su archivo de alertas de Oracle. 1. ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/find-alert-file-location-oracle\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"C\u00f3mo encontrar la ubicaci\u00f3n del archivo de registro de alertas en Oracle\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2902,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"how to find alert log file location in oracle","rank_math_title":"","rank_math_description":"Learn how to find the alert log file location in Oracle and troubleshoot your database effectively.","rank_math_robots":null,"rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[36,24],"class_list":["post-721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-alert","tag-debug"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-1605148.jpeg?fit=1880%2C1254&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":16,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"predecessor-version":[{"id":1770,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/721\/revisions\/1770"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2902"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}