{"id":7347,"date":"2019-01-07T10:46:15","date_gmt":"2019-01-07T10:46:15","guid":{"rendered":"https:\/\/dbtut.com\/?p=7347"},"modified":"2019-03-06T20:27:28","modified_gmt":"2019-03-06T20:27:28","slug":"adr-command-interpreteradrci","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/","title":{"rendered":"ADR Command Interpreter(ADRCI)"},"content":{"rendered":"<p>ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases.<\/p>\n<p><strong>With ADRCI;<\/strong><\/p>\n<ul>\n<li>We can see the diagnostic data in the Automatic Diagnostic Repository (ADR).<\/li>\n<li>We can view Health Monitoring reports.<\/li>\n<li>For Oracle Support, we can create packages containing accident and problem information in the form of a zip file.<\/li>\n<\/ul>\n<p>Fault detection data includes information such as accident and problem descriptions, trace files, dumps , health monitoring reports , alert log records.<\/p>\n<h3>Use of ADRCI tool:<\/h3>\n<p><strong>To start ;<\/strong><\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ adrci\n\nADRCI: Release 11.2.0.4.0 - Production on Mon Dec 26 16:22:27 2016\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\n\nADR base = \"\/u01\/app\/oracle\"<\/pre>\n<p>You can view the related incident homes as follows.<\/p>\n<pre class=\"lang:default decode:true \">adrci&gt; show homes\nADR Homes: \ndiag\/asm\/+asm\/+ASM1\ndiag\/clients\/user_oracle\/host_2585172500_11\ndiag\/clients\/user_oracle\/host_2585172500_80\ndiag\/diagtool\/user_oracle\/host_2585172500_11\ndiag\/rdbms\/orcl\/ORCL1\ndiag\/tnslsnr\/oradb1\/listener<\/pre>\n<p>We&#8217;re setting home which concerns our database.<\/p>\n<pre class=\"lang:default decode:true \">adrci&gt; set homepath diag\/rdbms\/orcl\/ORCL1<\/pre>\n<p>List all accidents under this home:<\/p>\n<pre class=\"lang:default decode:true \">adrci&gt; show incident\n\nADR Home = \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1:\n*************************************************************************\nINCIDENT_ID PROBLEM_KEY CREATE_TIME \n-------------------- ----------------------------------------------------------- ---------------------------------------- \n36425 ORA 603 2016-08-27 02:44:06.781000 +03:00 \n36649 ORA 603 2016-08-27 13:38:05.170000 +03:00 \n36481 ORA 603 2016-09-20 17:20:22.191000 +03:00 \n108476 ORA 603 2016-10-06 20:11:17.110000 +03:00 \n300829 ORA 603 2016-12-16 21:02:09.763000 +03:00 \n300861 ORA 603 2016-12-17 22:28:50.895000 +03:00 \n6 rows fetched<\/pre>\n<p>Detailed display is also possible. A detailed display can be provided with the command below.<\/p>\n<pre class=\"lang:default decode:true\">adrci&gt; SHOW INCIDENT -MODE DETAIL<\/pre>\n<p>For detailed information about an accident, we can use the following command.<\/p>\n<pre class=\"lang:default decode:true \">adrci&gt; SHOW INCIDENT -MODE DETAIL -P \"INCIDENT_ID=36425\"\n\nADR Home = \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1:\n*************************************************************************\n\n**********************************************************\nINCIDENT INFO RECORD 1\n**********************************************************\nINCIDENT_ID 36425\nSTATUS ready\nCREATE_TIME 2016-08-27 02:44:06.781000 +03:00\nPROBLEM_ID 1\nCLOSE_TIME &lt;NULL&gt;\nFLOOD_CONTROLLED none\nERROR_FACILITY ORA\nERROR_NUMBER 603\nERROR_ARG1 &lt;NULL&gt;\nERROR_ARG2 &lt;NULL&gt;\nERROR_ARG3 &lt;NULL&gt;\nERROR_ARG4 &lt;NULL&gt;\nERROR_ARG5 &lt;NULL&gt;\nERROR_ARG6 &lt;NULL&gt;\nERROR_ARG7 &lt;NULL&gt;\nERROR_ARG8 &lt;NULL&gt;\nERROR_ARG9 &lt;NULL&gt;\nERROR_ARG10 &lt;NULL&gt;\nERROR_ARG11 &lt;NULL&gt;\nERROR_ARG12 &lt;NULL&gt;\nSIGNALLING_COMPONENT &lt;NULL&gt;\nSIGNALLING_SUBCOMPONENT &lt;NULL&gt;\nSUSPECT_COMPONENT &lt;NULL&gt;\nSUSPECT_SUBCOMPONENT &lt;NULL&gt;\nECID &lt;NULL&gt;\nIMPACTS 0\nPROBLEM_KEY ORA 603\nFIRST_INCIDENT 36425\nFIRSTINC_TIME 2016-08-27 02:44:06.781000 +03:00\nLAST_INCIDENT 300861\nLASTINC_TIME 2016-12-17 22:28:50.895000 +03:00\nIMPACT1 0\nIMPACT2 0\nIMPACT3 0\nIMPACT4 0\nKEY_NAME Client ProcId\nKEY_VALUE oracle@oradb1 (TNS V1-V3).40894802_1\nKEY_NAME ProcId\nKEY_VALUE 53.43\nKEY_NAME PQ\nKEY_VALUE (0, 1472194814)\nKEY_NAME SID\nKEY_VALUE 955.4678\nOWNER_ID 1\nINCIDENT_FILE \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1\/trace\/ORCL1_j000_40894802.trc\nOWNER_ID 1\nINCIDENT_FILE \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1\/incident\/incdir_36425\/ORCL1_j000_40894802_i36425.trc\n1 rows fetched<\/pre>\n<p>We can use the following command to display existing problems.<\/p>\n<pre class=\"lang:default decode:true \">adrci&gt; SHOW PROBLEM\n\nADR Home = \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1:\n*************************************************************************\nPROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME \n-------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- \n1 ORA 603 300861 2016-12-17 22:28:50.895000 +03:00 \n1 rows fetched<\/pre>\n<p>When we open the call for any accidents on the Oracle Support side, they request the package related to the accident. We can create this file as zip in the following steps.<\/p>\n<p>After setting home path for the related database, we list all accidents and determine the id information of the related accident. These processes are described above. Then we create the logical accident package, then physical accident package.<\/p>\n<p>Creating the logical package: We create the package by specifying the Incident ID.<\/p>\n<pre class=\"lang:default decode:true\">adrci&gt; IPS CREATE PACKAGE INCIDENT 36425\nCreated package 1 based on incident id 36425, correlation level typical<\/pre>\n<p>Then we create the physical state of this package. We create the zip file by specifying the directory information to create the files, and the logical packet number with the following command.<\/p>\n<pre class=\"lang:default decode:true  \">adrci&gt; IPS GENERATE PACKAGE 1 IN \/home\/oracle\/ips1\n\nGenerated package 1 in file \/home\/oracle\/ips1\/ORA603_20161226162604_COM_1.zip, mode complete\nAdditional incremental files:\n \/home\/oracle\/ips1\/ORA603_20161226162604_INC_2.zip<\/pre>\n<p>It is possible to use the adrci tool in interactive mode as above, and it can also be used in Batch mode.<\/p>\n<h3>Using ADRCI in Batch Mode:<\/h3>\n<p>It is possible to run in batch mode as follows.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ adrci exec=\"command[; command]...\"<\/pre>\n<p><strong>Example commands:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ adrci exec=\"SHOW HOMES\"\nADR Homes: \ndiag\/asm\/+asm\/+ASM1\ndiag\/clients\/user_oracle\/host_2585172500_11\ndiag\/clients\/user_oracle\/host_2585172500_80\ndiag\/diagtool\/user_oracle\/host_2585172500_11\ndiag\/rdbms\/orcl\/ORCL1\ndiag\/tnslsnr\/oradb1\/listener<\/pre>\n<p>In batch mode, it is possible to run consecutive commands as follows.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ adrci exec=\"SHOW HOMES; SHOW INCIDENT\"\nADR Homes: \ndiag\/asm\/+asm\/+ASM1\ndiag\/clients\/user_oracle\/host_2585172500_11\ndiag\/clients\/user_oracle\/host_2585172500_80\ndiag\/diagtool\/user_oracle\/host_2585172500_11\ndiag\/rdbms\/orcl\/ORCL1\ndiag\/tnslsnr\/oradb1\/listener\n\nADR Home = \/u01\/app\/oracle\/diag\/asm\/+asm\/+ASM1:\n*************************************************************************\nINCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              \n-------------------- ----------------------------------------------------------- ---------------------------------------- \n208001               ORA 445                                                     2016-09-26 14:27:06.598000 +03:00       \n\nADR Home = \/u01\/app\/oracle\/diag\/clients\/user_oracle\/host_2585172500_11:\n*************************************************************************\n0 rows fetched\n\nADR Home = \/u01\/app\/oracle\/diag\/clients\/user_oracle\/host_2585172500_80:\n*************************************************************************\n0 rows fetched\n\nADR Home = \/u01\/app\/oracle\/diag\/diagtool\/user_oracle\/host_2585172500_11:\n*************************************************************************\n0 rows fetched\n     \n\nADR Home = \/u01\/app\/oracle\/diag\/rdbms\/orcl\/ORCL1:\n*************************************************************************\nINCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              \n-------------------- ----------------------------------------------------------- ---------------------------------------- \n36425                ORA 603                                                     2016-08-27 02:44:06.781000 +03:00       \n36649                ORA 603                                                     2016-08-27 13:38:05.170000 +03:00       \n36481                ORA 603                                                     2016-09-20 17:20:22.191000 +03:00       \n108476               ORA 603                                                     2016-10-06 20:11:17.110000 +03:00       \n300829               ORA 603                                                     2016-12-16 21:02:09.763000 +03:00       \n300861               ORA 603                                                     2016-12-17 22:28:50.895000 +03:00      \n\nADR Home = \/u01\/app\/oracle\/diag\/tnslsnr\/oradb1\/listener:\n*************************************************************************\nFirst 0 rows fetched (*** more available ***)<\/pre>\n<p>You may want to read the below article for deleting trace files, listener logs, alert logs.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/06\/how-to-delete-trace-files-listener-log-etc-with-adrci\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Delete Trace Files, listener log etc with ADRCI<\/a>&#8220;<\/p>\n\n\n<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_7347\" class=\"pvc_stats all  \" data-element-id=\"7347\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p><div class=\"pvc_clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in the Automatic Diagnostic Repository (ADR). We can view Health Monitoring reports. For Oracle Support, we can create packages containing accident and problem information in the form of a zip file. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7347\" class=\"pvc_stats all  \" data-element-id=\"7347\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-7347","post","type-post","status-publish","format-standard","","category-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":646,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ADR Command Interpreter(ADRCI) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ADR Command Interpreter(ADRCI)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ADR Command Interpreter(ADRCI) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ADR Command Interpreter(ADRCI)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-07T10:46:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-06T20:27:28+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"ADR Command Interpreter(ADRCI)\",\"datePublished\":\"2019-01-07T10:46:15+00:00\",\"dateModified\":\"2019-03-06T20:27:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\"},\"wordCount\":338,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\",\"name\":\"ADR Command Interpreter(ADRCI) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2019-01-07T10:46:15+00:00\",\"dateModified\":\"2019-03-06T20:27:28+00:00\",\"description\":\"ADR Command Interpreter(ADRCI)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ADR Command Interpreter(ADRCI)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ADR Command Interpreter(ADRCI) - Database Tutorials","description":"ADR Command Interpreter(ADRCI)","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:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/","og_locale":"en_US","og_type":"article","og_title":"ADR Command Interpreter(ADRCI) - Database Tutorials","og_description":"ADR Command Interpreter(ADRCI)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-07T10:46:15+00:00","article_modified_time":"2019-03-06T20:27:28+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"ADR Command Interpreter(ADRCI)","datePublished":"2019-01-07T10:46:15+00:00","dateModified":"2019-03-06T20:27:28+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/"},"wordCount":338,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/","name":"ADR Command Interpreter(ADRCI) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2019-01-07T10:46:15+00:00","dateModified":"2019-03-06T20:27:28+00:00","description":"ADR Command Interpreter(ADRCI)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/07\/adr-command-interpreteradrci\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ADR Command Interpreter(ADRCI)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=7347"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7347\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}