{"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":"trouver-lemplacement-du-fichier-dalerte-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/find-alert-file-location-oracle\/","title":{"rendered":"Comment trouver l'emplacement du fichier journal d'alerte dans Oracle"},"content":{"rendered":"<p>Dans les versions plus r\u00e9centes d'Oracle Database, il n'est pas \u00e9vident de savoir o\u00f9 se trouve le fichier d'alerte permettant d'enqu\u00eater sur les probl\u00e8mes potentiels.<\/p>\n\n\n\n<p>Si vous voulez savoir comment v\u00e9rifier les erreurs du journal d'alerte dans Oracle, continuez \u00e0 lire.<\/p>\n\n\n\n<p>Vous disposez de plusieurs moyens pour savoir o\u00f9 se trouve votre fichier d'alerte Oracle.<\/p>\n\n\n\n<p>1. Si la base de donn\u00e9es Oracle est ouverte <\/p>\n\n\n\n<p>Vous pouvez utiliser cette requ\u00eate apr\u00e8s vous \u00eatre connect\u00e9 avec : 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 donn\u00e9es Oracle n'est pas ouverte <\/p>\n\n\n\n<p>Vous pouvez utiliser adrci \u00e0 partir de la ligne de commande<\/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>Vous pouvez voir qu'il y a plusieurs maisons. <\/p>\n\n\n\n<p>Si vous souhaitez v\u00e9rifier le fichier d'alerte pour la base de donn\u00e9es YP001P1, vous devez utiliser l'ADR base suivi de l'ADR home (\u00e0 partir de la sortie ci-dessus) et ajouter le dossier trace \u00e0 la fin.<\/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>Une fois dans ce dossier, vous pouvez v\u00e9rifier le fichier d'alerte<\/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>Dans les versions plus r\u00e9centes d'Oracle Database, il n'est pas \u00e9vident de savoir o\u00f9 se trouve le fichier d'alerte permettant d'enqu\u00eater sur les probl\u00e8mes potentiels. Si vous voulez savoir comment v\u00e9rifier les erreurs du journal d'alerte dans Oracle, continuez \u00e0 lire. Il existe plusieurs fa\u00e7ons de savoir o\u00f9 se trouve votre fichier d'alerte Oracle. 1. ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/find-alert-file-location-oracle\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Comment trouver l'emplacement du fichier journal d'alerte dans 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\/fr\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":16,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"predecessor-version":[{"id":1770,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/721\/revisions\/1770"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2902"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}