{"id":3146,"date":"2018-09-21T12:40:13","date_gmt":"2018-09-21T12:40:13","guid":{"rendered":"http:\/\/dbtut.com\/?p=3146"},"modified":"2018-11-24T20:22:27","modified_gmt":"2018-11-24T20:22:27","slug":"reconfiguring-grid-infrastructure-components","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/","title":{"rendered":"Reconfiguring Grid Infrastructure Components"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css asm db will not open, you can reconfigure them with the following steps.<\/p>\n<p>Let&#8217;s first clear the existing configuration:<\/p>\n<p>&nbsp;<\/p>\n<p><strong>With root:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">&lt;$GRID_HOME&gt;\/crs\/install\/rootcrs.pl -deconfig -force<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Reconfigure:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">&lt;$GRID_HOME&gt;\/root.sh<\/pre>\n<p>&nbsp;<\/p>\n<p>If you see an output as follows after these operations, we will need to add some services for Oracle Restart.<\/p>\n<pre class=\"lang:default decode:true \">crs_stat -t\r\n\r\nName\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Type\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Target\u00a0 \u00a0 State\u00a0 \u00a0 \u00a0Host\r\n------------------------------------------------------------\r\nora.cssd\u00a0 \u00a0 \u00a0 \u00a0ora.cssd.type\u00a0 OFFLINE\u00a0 \u00a0 OFFLINE\r\nora.diskmon\u00a0 \u00a0 ora....on.type OFFLINE\u00a0 \u00a0OFFLINE\r\nora.evmd\u00a0 \u00a0 \u00a0 \u00a0ora.evm.type\u00a0 \u00a0ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.ons\u00a0 \u00a0 \u00a0 \u00a0 ora.ons.type\u00a0 \u00a0OFFLINE\u00a0 \u00a0OFFLINE<\/pre>\n<p>&nbsp;<\/p>\n<p>In addition, because the ora.cssd service does not start automatically, it needs to be set to start automatically.<\/p>\n<p>With the following command, the target status for ora.cssd can do ONLINE.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>With the Grid user (or after installing the grid variables)<\/strong><\/p>\n<pre class=\"lang:default decode:true \">crsctl modify resource ora.cssd -attr AUTO_START=always<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>After<\/strong><\/p>\n<pre class=\"lang:default decode:true \">crsctl stop has\r\ncrsctl start has<\/pre>\n<p>&nbsp;<\/p>\n<p>We need to add new services for Oracle Restart:<\/p>\n<p>&nbsp;<\/p>\n<p><strong>With the Grid user (or after installing the grid variables):<\/strong><br \/>\n<strong>To add an ASM source:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">srvctl add asm -p +DATA\/asm\/asmparameterfile\/registry.253.892568385 -d '\/dev\/sd*'<\/pre>\n<p>&nbsp;<\/p>\n<p>The &#8220;-p&#8221; parameter specifies the spfile for asm instance and the disk string parameter for -d.<\/p>\n<p>All disk groups will be mounted automatically if the authorizations of the disks in the directory specified by the disk string are correct and the header information of the disks is correct.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>To add a Listener resource:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">srvctl add listener -p 1521 -o $ORACLE_HOME<\/pre>\n<p>The &#8220;-p&#8221; parameter specifies the port -o with grid_home.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Setting the added services to start automatically:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">crsctl modify resource ora.LISTENER.lsnr -attr AUTO_START=always\r\ncrsctl modify resource ora.asm -attr AUTO_START=always<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>With the Oracle user (or after loading the database variables):<\/strong><\/p>\n<pre class=\"lang:default decode:true \">srvctl add database -d ORCL -o $ORACLE_HOME -a \"DATA,FRA\"<\/pre>\n<pre class=\"lang:default decode:true \">-d -&gt; db_name -o\r\n\r\n-o -&gt; db_home\r\n\r\n-a -&gt;\u00a0dependent disk groups<\/pre>\n<p>&nbsp;<\/p>\n<p>The database will not open without mount disk groups.<\/p>\n<p>Changing the local listener of the database. (You may not always need it)<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter system\u00a0 set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1521))' scope=both;<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Final Status:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">crs_stat -t\r\n\r\nName\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Type\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Target\u00a0 \u00a0 State\u00a0 \u00a0 \u00a0Host\r\n------------------------------------------------------------\r\nora.DATA.dg\u00a0 \u00a0 ora....up.type ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.FRA.dg\u00a0 \u00a0 \u00a0ora....up.type ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora....ER.lsnr ora....er.type ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.asm\u00a0 \u00a0 \u00a0 \u00a0 ora.asm.type\u00a0 \u00a0ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0oradb\r\nora.cssd\u00a0 \u00a0 \u00a0 \u00a0ora.cssd.type\u00a0 ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.diskmon\u00a0 \u00a0 ora....on.type OFFLINE\u00a0 \u00a0OFFLINE\r\nora.evmd\u00a0 \u00a0 \u00a0 \u00a0ora.evm.type\u00a0 \u00a0ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.hope.db\u00a0 \u00a0 ora....se.type ONLINE\u00a0 \u00a0 ONLINE\u00a0 \u00a0 oradb\r\nora.ons\u00a0 \u00a0 \u00a0 \u00a0 ora.ons.type\u00a0 \u00a0OFFLINE\u00a0 \u00a0OFFLINE<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3146\" class=\"pvc_stats all  \" data-element-id=\"3146\" 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},"excerpt":{"rendered":"<p>&nbsp; If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css asm db will not open, you can reconfigure them with the following steps. Let&#8217;s first clear the existing configuration: &nbsp; With root: &lt;$GRID_HOME&gt;\/crs\/install\/rootcrs.pl -deconfig -force &nbsp; Reconfigure: &lt;$GRID_HOME&gt;\/root.sh &nbsp; If &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3146\" class=\"pvc_stats all  \" data-element-id=\"3146\" 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-3146","post","type-post","status-publish","format-standard","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reconfiguring Grid Infrastructure Components - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Reconfiguring Grid Infrastructure Components\" \/>\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\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconfiguring Grid Infrastructure Components - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Reconfiguring Grid Infrastructure Components\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-21T12:40:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T20:22:27+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Reconfiguring Grid Infrastructure Components\",\"datePublished\":\"2018-09-21T12:40:13+00:00\",\"dateModified\":\"2018-11-24T20:22:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\"},\"wordCount\":259,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\",\"name\":\"Reconfiguring Grid Infrastructure Components - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-09-21T12:40:13+00:00\",\"dateModified\":\"2018-11-24T20:22:27+00:00\",\"description\":\"Reconfiguring Grid Infrastructure Components\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reconfiguring Grid Infrastructure Components\"}]},{\"@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":"Reconfiguring Grid Infrastructure Components - Database Tutorials","description":"Reconfiguring Grid Infrastructure Components","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\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/","og_locale":"en_US","og_type":"article","og_title":"Reconfiguring Grid Infrastructure Components - Database Tutorials","og_description":"Reconfiguring Grid Infrastructure Components","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-21T12:40:13+00:00","article_modified_time":"2018-11-24T20:22:27+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Reconfiguring Grid Infrastructure Components","datePublished":"2018-09-21T12:40:13+00:00","dateModified":"2018-11-24T20:22:27+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/"},"wordCount":259,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/","name":"Reconfiguring Grid Infrastructure Components - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-09-21T12:40:13+00:00","dateModified":"2018-11-24T20:22:27+00:00","description":"Reconfiguring Grid Infrastructure Components","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/reconfiguring-grid-infrastructure-components\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Reconfiguring Grid Infrastructure Components"}]},{"@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\/3146","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=3146"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3146\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}