{"id":2107,"date":"2011-01-12T15:57:00","date_gmt":"2011-01-12T14:57:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/"},"modified":"2011-01-12T15:57:00","modified_gmt":"2011-01-12T14:57:00","slug":"how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/","title":{"rendered":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?"},"content":{"rendered":"<p>Well, I have read many posts about this, but was unable to find a suitable solution up to now \u2026 Google was not my friend\u00a0 \ud83d\ude25<\/p>\n<p>The most popular answers featured only the first part of the code,<br \/>\nthe connection set-up:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">use DBI;\n#\n# some code\n#\nmy $dbh = DBI-&gt;connect(\"dbi:Oracle:\",\"$Usr\",\"$Pwd\",\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {ora_session_mode =&gt; ORA_SYSDBA});<\/pre>\n<p>&nbsp;<\/p>\n<p>Unfortunately, leaving the variable $User and $Pwd empty did not do the trick, see error below.<\/p>\n<p><code>DBI connect('','',...) failed: ORA-01017: invalid username\/password; logon denied (DBD ERROR: OCISessionBegin)<\/code><\/p>\n<p>Ok, but what about internal connection sqlplus &#8216;\/ as sysdba&#8217;?<br \/>\nAfter some research in the documentation, I came across two important points which we should keep in mind:<\/p>\n<ul>\n<li>DBI is a database independent, generic interface module!<\/li>\n<li>DBD::Oracle is the Oracle specific module for Oracle.<\/li>\n<\/ul>\n<p>The DBD::Oracle documentation (available on <a href=\"http:\/\/search.cpan.org\">http:\/\/search.cpan.org<\/a>)\u00a0 and some other sources offered the solution:<\/p>\n<p>In Perl special constants are defined in the database driver module DBD::Oracle. These constants have to be passed as part of the connect options to make connecting as SYSDBA or SYSOPER possible for members of the operating system groups OPER,DBA (works also for the windows members of the ORA_DBA group, under condition that the SQLNET.ORA parameter SQLNET.AUTHENTICATION SERVICES are set to NTS):<\/p>\n<p><code>use DBD::Oracle qw(:ora_session_modes); # imports SYSDBA or SYSOPER<\/code><\/p>\n<p>Et voil\u00e0, simply add the above line in your code and enjoy. Cool!<\/p>\n<p>In the demo presented below, we connect as a non-privileged user, that means not using the SYSDBA or SYSOPER privileges. The special constant :ora_session_modes won&#8217;t be imported, however we want the Unix user &#8220;oracle&#8221; to be able to connect without password. Therefore, we create the appropriate database user with prefix ops$ :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt;\u00a0 SHOW PARAMETER os_authent_prefix\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n------------------------------------ ----------- ------------------------------\nos_authent_prefix\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 ops$\nSQL&gt; CREATE USER ops$oracle IDENTIFIED EXTERNALLY;\nSQL&gt; GRANT CONNECT TO ops$oracle;<\/pre>\n<p>&nbsp;<\/p>\n<p>In a second step, we must\u00a0login as Unix user:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmtestora:\/home\/oracle\/ [DB11] id oracle\nuid=500(oracle) gid=500(oracle) groups=500(oracle),502(dba)\noracle@vmtestora:\/home\/oracle\/ [DB11] sqlplus \/\nConnected.<\/pre>\n<p>&nbsp;<\/p>\n<p>With this few code we just fetch the sysdate from the database using the &#8220;ops$&#8221; identification:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">#!\/u00\/app\/oracle\/product\/11.2.0\/db_2_0\/perl\/bin\/perl\nuse DBI;\nuse DBD::Oracle;\nmy $dbh = DBI-&gt;connect(\"dbi:Oracle:\",\"\/\",undef)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 or die \"$DBI::errstr\";\nmy $sth = $dbh-&gt;prepare(\"select sysdate from dual\") or die \"$DBI::errstr\";\n$sth-&gt;execute() or die \"couldn't execute statementn\";\nwhile (my $row = $sth-&gt;fetchrow_array())\n{\n\u00a0\u00a0 print \"Database $ENV{ORACLE_SID}-&gt; sysdate: $rown\";\n}<\/pre>\n<p>The result:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmtestora:\/home\/oracle\/ [DB11].\/test.pl\nDatabase DB11-&gt; sysdate: 22-DEC-10<\/pre>\n<p>As you can see, a &#8220;normal&#8221; database connection without pasword doesn&#8217;t require the special constants (like &#8220;:ora_session_modes&#8221;).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well, I have read many posts about this, but was unable to find a suitable solution up to now \u2026 Google was not my friend <img decoding=\"async\" src=\"plugins\/editors\/jce\/tiny_mce\/plugins\/emotions\/img\/smiley-cry.gif\" alt=\"Cry\" title=\"Cry\" border=\"0\" \/><\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[23,45,46,17,47],"type_dbi":[],"class_list":["post-2107","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-dba","tag-documentation","tag-linux-unix","tag-oracle-11g","tag-perl"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d? - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?\" \/>\n<meta property=\"og:description\" content=\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-12T14:57:00+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Witt\" \/>\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:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?\",\"datePublished\":\"2011-01-12T14:57:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/\"},\"wordCount\":319,\"commentCount\":0,\"keywords\":[\"DBA\",\"Documentation\",\"Linux\\\/UNIX\",\"Oracle 11g\",\"Perl\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/\",\"name\":\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2011-01-12T14:57:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"description\":\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\\\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-witt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d? - dbi Blog","description":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.","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:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/","og_locale":"en_US","og_type":"article","og_title":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?","og_description":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/","og_site_name":"dbi Blog","article_published_time":"2011-01-12T14:57:00+00:00","author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?","datePublished":"2011-01-12T14:57:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/"},"wordCount":319,"commentCount":0,"keywords":["DBA","Documentation","Linux\/UNIX","Oracle 11g","Perl"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/","name":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2011-01-12T14:57:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"description":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to connect to an Oracle database using the perl DBI module and DBD::Oracle \u201cas sysdba\u201d?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2107"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2107\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2107"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}