{"id":6094,"date":"2019-03-01T09:01:14","date_gmt":"2019-03-01T09:01:14","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6094"},"modified":"2020-11-11T18:13:17","modified_gmt":"2020-11-11T18:13:17","slug":"ora-28040-no-matching-authentication-protocol","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/ora-28040-no-matching-authentication-protocol\/","title":{"rendered":"ORA-28040: No matching authentication protocol"},"content":{"rendered":"<p>You can get &#8221; <strong>ORA-28040: No matching authentication protocol<\/strong> &#8221; error because of Oracle Client incompatibility when you upgrade Oracle database from 11g to 12c or Oracle 18c, 19c,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6095 aligncenter\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931.png\" alt=\"\" width=\"467\" height=\"205\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931.png 467w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931-300x132.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">ORA-28040: No matching authentication protocol 19c<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>If you get\u00a0 <strong>ORA-28040 error<\/strong> When you connect to Oracle 19c database then change your sqlnet.ora file like below. Add these two lines to the sqlnet.ora<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>SQLNET.ALLOWED_LOGON_VERSION_SERVER=8<\/strong><\/span><br \/>\n<span style=\"color: #ff0000;\"><strong>SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<pre>[oracle@MehmetSalih ~]$ ps -ef | grep smon\r\noracle 25167 17807 0 11:56 pts\/0 00:00:00 grep --color=auto smon\r\noracle 28385 1 0 10:31 ? 00:00:00 ora_smon_DEVECI19C\r\n[oracle@MehmetSalih ~]$\r\n[oracle@MehmetSalih ~]$\r\n<span style=\"color: #ff0000;\"><strong>[oracle@MehmetSalih ~]$ cd $ORACLE_HOME\r\n[oracle@MehmetSalih install]$ cd network\/admin\/<\/strong><\/span>\r\n[oracle@MehmetSalih admin]$\r\n\r\n\r\n<strong><span style=\"color: #ff0000;\">[oracle@MehmetSalih admin]$ cat sqlnet.ora\r\n<\/span><\/strong># sqlnet.ora Network Configuration File: \/oradata\/install\/network\/admin\/sqlnet.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)\r\n\r\n\r\n<span style=\"color: #ff0000;\"><strong>SQLNET.ALLOWED_LOGON_VERSION_SERVER=8<\/strong>\r\n<strong>SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8\r\n\r\n\r\n<\/strong><\/span><\/pre>\n\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000;\">SQLNET.ORA<\/span><\/h3>\n<p>If you change sqlnet.ora file which is under the $ORACLE_HOME\/network\/admin then reload your listener like below. And try to connect again.<\/p>\n<pre>[oracle@MehmetSalih admin]$ lsnrctl reload\r\n\r\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-MAR-2019 11:57:26\r\n\r\nCopyright (c) 1991, 2018, Oracle. All rights reserved.\r\n\r\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\nThe command completed successfully\r\n[oracle@MehmetSalih admin]$\r\n[oracle@MehmetSalih admin]$\r\n[oracle@MehmetSalih admin]$ lsnrctl status\r\n\r\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-MAR-2019 11:57:30\r\n\r\nCopyright (c) 1991, 2018, Oracle. All rights reserved.\r\n\r\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias LISTENER\r\nVersion TNSLSNR for Linux: Version 19.0.0.0.0 - Production\r\nStart Date 01-MAR-2019 11:46:57\r\nUptime 0 days 0 hr. 10 min. 32 sec\r\nTrace Level off\r\nSecurity ON: Local OS Authentication\r\nSNMP OFF\r\nListener Log File \/u01\/app\/oracle\/diag\/tnslsnr\/MehmetSalih\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MehmetSalih.DeveciDomain)(PORT=1521)))\r\n(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MehmetSalih.DeveciDomain)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/admin\/DEVECI19C\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\r\nServices Summary...\r\nService \"DEVECI19C.DeveciDomain\" has 1 instance(s).\r\nInstance \"DEVECI19C\", status READY, has 1 handler(s) for this service...\r\nService \"DEVECI19CXDB.DeveciDomain\" has 1 instance(s).\r\nInstance \"DEVECI19C\", status READY, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n[oracle@MehmetSalih admin]$\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000;\">Do you want to learn Oracle Database Performance Tuning detailed, then read the following articles.<\/span><\/h3>\n<blockquote class=\"wp-embedded-content\" data-secret=\"nFXm3WN04X\"><p><a href=\"https:\/\/ittutorial.org\/performance-tuning-and-sql-tuning-tutorial-in-the-oracle-database\/\">Performance Tuning and SQL Tuning Tutorial in the Oracle Database<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Performance Tuning and SQL Tuning Tutorial in the Oracle Database&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/performance-tuning-and-sql-tuning-tutorial-in-the-oracle-database\/embed\/#?secret=uSF3WBD87B#?secret=nFXm3WN04X\" data-secret=\"nFXm3WN04X\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\"><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then Click and read the following articles.<\/span><\/a><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can get &#8221; ORA-28040: No matching authentication protocol &#8221; error because of Oracle Client incompatibility when you upgrade Oracle database from 11g to 12c or Oracle 18c, 19c,<\/p>\n","protected":false},"author":1,"featured_media":6095,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2111],"tags":[13720,13126,2083,13727,13722,2082,2086,9174,13302,9173,9177,10394,13125,13127,10392,13303,9176,9179,9178,10395,9180,13124,13719,13717,2081,9175,10393,13724,13123,13723,2087,2090,13725,13726,13718,13721,10391,10396,10398,10397],"class_list":["post-6094","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-ora-errors","tag-13720","tag-exception-in-thread-main-java-sql-sqlexception-ora-28040-no-matching-authentication-protocol","tag-no-matching-authentication-protocol","tag-no-matching-authentication-protocol-oracle","tag-no-matching-authentication-protocol-oracle-18c","tag-ora-28040","tag-ora-28040-error-solution","tag-ora-28040-no-matching-authentication-protocol-11g-client","tag-ora-28040-no-matching-authentication-protocol-12c","tag-ora-28040-no-matching-authentication-protocol-18c","tag-ora-28040-no-matching-authentication-protocol-19c","tag-ora-28040-no-matching-authentication-protocol-aws-rds","tag-ora-28040-no-matching-authentication-protocol-c","tag-ora-28040-no-matching-authentication-protocol-in-jdeveloper","tag-ora-28040-no-matching-authentication-protocol-informatica","tag-ora-28040-no-matching-authentication-protocol-oracle-12c","tag-ora-28040-no-matching-authentication-protocol-oracle-12c-java","tag-ora-28040-no-matching-authentication-protocol-oracle-18c","tag-ora-28040-no-matching-authentication-protocol-oracle-19c","tag-ora-28040-no-matching-authentication-protocol-pentaho","tag-ora-28040-no-matching-authentication-protocol-pl-sql-developer","tag-ora-28040-no-matching-authentication-protocol-when-running-with-oracle-database-12c","tag-ora-28040-oracle-18c","tag-ora-28040-oracle-19c","tag-ora-28040-no-matching-authentication-protocol","tag-ora-28040-no-matching-authentication-protocol-in-12cr2","tag-ora-28040-no-matching-authentication-protocol-websphere","tag-ora28040","tag-oracle-19c-ora-28040-no-matching-authentication-protocol","tag-oracle-19c-sqlnet-allowed_logon_version_server","tag-oracle-errors","tag-oracle-sqlnet-ora","tag-sqlnet-allowed_logon_version_client-oracle-19c","tag-sqlnet-allowed_logon_version_server","tag-sqlnet-allowed_logon_version_server-19c","tag-sqlnet-allowed_logon_version_server-oracle-19c","tag-status-failure-test-failed-ora-28040-no-matching-authentication-protocol","tag-status-failure-failed-ora-28040-no-matching-authentication-protocol-in-sql-developer","tag-tableau-oracle-database-error-28040-ora-28040-no-matching-authentication-protocol","tag-the-error-encountered-is-ora-28040-no-matching-authentication-protocol"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6094"}],"version-history":[{"count":11,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6094\/revisions"}],"predecessor-version":[{"id":32190,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6094\/revisions\/32190"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/6095"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}