{"id":15400,"date":"2020-03-23T07:13:16","date_gmt":"2020-03-23T07:13:16","guid":{"rendered":"https:\/\/dbtut.com\/?p=15400"},"modified":"2020-03-23T11:50:55","modified_gmt":"2020-03-23T11:50:55","slug":"ora-16664-unable-to-receive-the-result-from-a-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/","title":{"rendered":"ORA-16664: unable to receive the result from a database"},"content":{"rendered":"<p>When querying the status of the configuration from broker, errors like below were seen.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Warning: ORA-16664: unable to receive the result from a database<\/em><\/span><\/p>\n<pre class=\"lang:default decode:true\">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  physical - Primary database\n    physclFS - Far sync instance \n      Warning: ORA-16664: unable to receive the result from a database\n\n      primary  - Logical standby database \n        Error: ORA-16664: unable to receive the result from a database\n\n      snapshot - Physical standby database \n        Error: ORA-16664: unable to receive the result from a database\n\n      logical  - Logical standby database \n        Error: ORA-16664: unable to receive the result from a database\n\n      logical2 - Physical standby database \n        Error: ORA-16664: unable to receive the result from a database\n\n\n  Members Not Receiving Redo:\n  prmyFS   - Far sync instance \n    Warning: ORA-16664: unable to receive the result from a database\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nERROR   (status updated 38 seconds ago)<\/pre>\n<p>Standby databases also receive connection errors as below.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Fatal NI connect error 12526, connecting to:<\/em><\/span><\/p>\n<pre class=\"lang:default decode:true\">Fatal NI connect error 12526, connecting to:\n (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.42.62)(PORT=1521)(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760)))(SDU=65535)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=physical_DGB)(INSTANCE_NAME=physical)(CID=(PROGRAM=oracle)(HOST=physclFS.tivibulab.local)(USER=oracle))))\n\n  VERSION INFORMATION:\n        TNS for Linux: Version 12.1.0.2.0 - Production\n        TCP\/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production\n  Time: 18-APR-2017 08:51:11\n  Tracing not turned on.\n  Tns error struct:\n    ns main err code: 12564\n    \nTNS-12564: TNS:connection refused\n    ns secondary err code: 0\n    nt main err code: 0\n    nt secondary err code: 0\n    nt OS err code: 0\n<\/pre>\n<h3>SOLUTION<\/h3>\n<p>We can fix the problem by following the steps below.<\/p>\n<h4>Step1:<\/h4>\n<p>Since the TNS problem appears, it is first checked whether the TNSNAMES.ora and Listener.ora files are working. Test access to Standby from Physical database with sqlplus. As you can see below, only one database connection is seen.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@physical ~]$ sqlplus sys\/Passw0rd4@logical2 as sysdba\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 18 08:33:19 2017\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\n\nSession altered.\n\n[Physical - 18-04-2017 08:33:19] SQL&gt; show parameter name\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ncell_offloadgroup_name               string\ndb_file_name_convert                 string      primary, logical2\ndb_name                              string      LOGICAL2\ndb_unique_name                       string      logical2\nglobal_names                         boolean     FALSE\ninstance_name                        string      logical2\nlock_name_space                      string\nlog_file_name_convert                string      primary, logical2\npdb_file_name_convert                string\nprocessor_group_name                 string\nservice_names                        string      logical2<\/pre>\n<h4>Step2:<\/h4>\n<p>Try tnsping. As you can see below, only one database connection is seen.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@physclFS ~]$ tnsping logical2 5\n\nTNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 18-APR-2017 08:35:19\n\nCopyright (c) 1997, 2014, Oracle.  All rights reserved.\n\nUsed parameter files:\n\/u01\/app\/oracle\/product\/12.1.0\/db_1\/network\/admin\/sqlnet.ora\n\n\nUsed TNSNAMES adapter to resolve the alias\nAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.42.42)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))) (SDU = 65535) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = logical2)))\nOK (20 msec)\nOK (0 msec)\nOK (0 msec)\nOK (0 msec)\nOK (0 msec)<\/pre>\n<h4>Step3:<\/h4>\n<p>Check Listener on all DBs in configurations. We have seen that there is something odd only in the Primary database &#8220;Physical&#8221;.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@physical ~]$ lsnrctl\n\nLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-APR-2017 08:36:31\n\nCopyright (c) 1991, 2014, Oracle.  All rights reserved.\n\nWelcome to LSNRCTL, type \"help\" for information.\n\nLSNRCTL&gt; status\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=physical.tivibulab.local)(PORT=1521)(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production\nStart Date                03-MAR-2017 08:31:16\nUptime                    45 days 23 hr. 5 min. 17 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/oracle\/product\/12.1.0\/db_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/physical\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=physical.tivibulab.local)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=physical.tivibulab.local)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/admin\/physical\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\nServices Summary...\nService \"physical\" has 2 instance(s).\n  Instance \"physical\", status UNKNOWN, has 1 handler(s) for this service...\n  Instance \"physical\", status RESTRICTED, has 1 handler(s) for this service...\nService \"physicalXDB\" has 1 instance(s).\n  Instance \"physical\", status RESTRICTED, has 1 handler(s) for this service...\nService \"physical_DGB\" has 1 instance(s).\n  Instance \"physical\", status RESTRICTED, has 1 handler(s) for this service...\nService \"physical_DGMGRL\" has 1 instance(s).\n  Instance \"physical\", status UNKNOWN, has 1 handler(s) for this service...\nThe command completed successfully\n<\/pre>\n<h4>Step4:<\/h4>\n<p>In this case, I suspect that the Primary database was opened in RESTRICT mode. We do the necessary checks.<\/p>\n<pre class=\"lang:default decode:true \">[Physical - 18-04-2017 08:49:54] SQL&gt; select logins from v$instance;\n\nLOGINS\n----------\nRESTRICTED<\/pre>\n<h4>Step5:<\/h4>\n<p>Disable RESTRICT mode.<\/p>\n<pre class=\"lang:default decode:true \">[Physical - 18-04-2017 08:43:34] SQL&gt; ALTER SYSTEM DISABLE RESTRICTED SESSION;\n\nSystem altered.\n<\/pre>\n<h4>Step6:<\/h4>\n<p>Check listener again.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@physical ~]$ lsnrctl\n\nLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-APR-2017 08:45:44\n\nCopyright (c) 1991, 2014, Oracle.  All rights reserved.\n\nWelcome to LSNRCTL, type \"help\" for information.\n\nLSNRCTL&gt; status\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=physical.tivibulab.local)(PORT=1521)(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production\nStart Date                03-MAR-2017 08:31:16\nUptime                    45 days 23 hr. 14 min. 30 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/oracle\/product\/12.1.0\/db_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/physical\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=physical.tivibulab.local)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=physical.tivibulab.local)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/admin\/physical\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\nServices Summary...\nService \"physical\" has 2 instance(s).\n  Instance \"physical\", status UNKNOWN, has 1 handler(s) for this service...\n  Instance \"physical\", status READY, has 1 handler(s) for this service...\nService \"physicalXDB\" has 1 instance(s).\n  Instance \"physical\", status READY, has 1 handler(s) for this service...\nService \"physical_DGB\" has 1 instance(s).\n  Instance \"physical\", status READY, has 1 handler(s) for this service...\nService \"physical_DGMGRL\" has 1 instance(s).\n  Instance \"physical\", status UNKNOWN, has 1 handler(s) for this service...\nThe command completed successfully<\/pre>\n<h4>Step7:<\/h4>\n<p>Check the configuration status.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  physical - Primary database\n    physclFS - Far sync instance \n      primary  - Logical standby database \n      snapshot - Physical standby database \n      logical  - Logical standby database \n      logical2 - Physical standby database \n\n  Members Not Receiving Redo:\n  prmyFS   - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 36 seconds ago)<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15400\" class=\"pvc_stats all  \" data-element-id=\"15400\" 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>When querying the status of the configuration from broker, errors like below were seen. Warning: ORA-16664: unable to receive the result from a database DGMGRL&gt; show configuration Configuration &#8211; DRSolution Protection Mode: MaxPerformance Members: physical &#8211; Primary database physclFS &#8211; Far sync instance Warning: ORA-16664: unable to receive the result from a database primary &#8211; &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15400\" class=\"pvc_stats all  \" data-element-id=\"15400\" 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":484,"featured_media":15402,"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":[9335,9333,9336,9334,9340,9338,9339,9337],"class_list":["post-15400","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-connecting-to","tag-disable-restrict-mode","tag-fatal-ni-connect-error","tag-fatal-ni-connect-error-12526","tag-ora-16664","tag-ora-16664-unable-to-receive-the-result-from-a-database","tag-unable-to-receive-the-result-from-a-database","tag-warning-ora-16664-unable-to-receive-the-result-from-a-database"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":5825,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ORA-16664: unable to receive the result from a database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Warning: ORA-16664: unable to receive the result from a database\" \/>\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\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-16664: unable to receive the result from a database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Warning: ORA-16664: unable to receive the result from a database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-23T07:13:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-23T11:50:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"277\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\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\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"ORA-16664: unable to receive the result from a database\",\"datePublished\":\"2020-03-23T07:13:16+00:00\",\"dateModified\":\"2020-03-23T11:50:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\"},\"wordCount\":168,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png\",\"keywords\":[\"connecting to:\",\"Disable RESTRICT mode.\",\"Fatal NI connect error\",\"Fatal NI connect error 12526\",\"ORA-16664\",\"ORA-16664: unable to receive the result from a database\",\"unable to receive the result from a database\",\"Warning: ORA-16664: unable to receive the result from a database\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\",\"name\":\"ORA-16664: unable to receive the result from a database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png\",\"datePublished\":\"2020-03-23T07:13:16+00:00\",\"dateModified\":\"2020-03-23T11:50:55+00:00\",\"description\":\"Warning: ORA-16664: unable to receive the result from a database\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png\",\"width\":550,\"height\":277},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-16664: unable to receive the result from a database\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-16664: unable to receive the result from a database - Database Tutorials","description":"Warning: ORA-16664: unable to receive the result from a database","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\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/","og_locale":"en_US","og_type":"article","og_title":"ORA-16664: unable to receive the result from a database - Database Tutorials","og_description":"Warning: ORA-16664: unable to receive the result from a database","og_url":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/","og_site_name":"Database Tutorials","article_published_time":"2020-03-23T07:13:16+00:00","article_modified_time":"2020-03-23T11:50:55+00:00","og_image":[{"width":550,"height":277,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"ORA-16664: unable to receive the result from a database","datePublished":"2020-03-23T07:13:16+00:00","dateModified":"2020-03-23T11:50:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/"},"wordCount":168,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png","keywords":["connecting to:","Disable RESTRICT mode.","Fatal NI connect error","Fatal NI connect error 12526","ORA-16664","ORA-16664: unable to receive the result from a database","unable to receive the result from a database","Warning: ORA-16664: unable to receive the result from a database"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/","url":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/","name":"ORA-16664: unable to receive the result from a database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png","datePublished":"2020-03-23T07:13:16+00:00","dateModified":"2020-03-23T11:50:55+00:00","description":"Warning: ORA-16664: unable to receive the result from a database","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-20.png","width":550,"height":277},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/23\/ora-16664-unable-to-receive-the-result-from-a-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ORA-16664: unable to receive the result from a database"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15400","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=15400"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15400\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15402"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}