{"id":16672,"date":"2021-09-06T10:51:47","date_gmt":"2021-09-06T08:51:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/"},"modified":"2023-01-06T11:36:13","modified_gmt":"2023-01-06T10:36:13","slug":"after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/","title":{"rendered":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact"},"content":{"rendered":"

A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c.<\/p>\n

Problem
\n<\/strong>The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done are<\/p>\n

    \n
  1. Install new Oracle Home (u01\/app\/oracle\/product \/19.0.0\/dbhome_1)<\/li>\n
  2. Patch new Oracle Home with newest RU for 19c<\/li>\n
  3. stop database<\/li>\n
  4. modify oracle home in oracle restart to new patched oracle home<\/li>\n
  5. start database with the new oracle home<\/li>\n
  6. run datapatch againt the database<\/li>\n<\/ol>\n

    So everything was good, the patch was applied successfully. A day later, the DBA wanted to connect to the database as sysdba. However, this was no longer possible because the connection was immediately rejected with ORA-12547: TNS:lost contact.<\/p>\n

    [oracle@dbsrv01:\/home\/oracle]$[cdb19] sqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 02 17:45:21 2021\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\nERROR:\nORA-12547: TNS:lost contact\nEnter user-name:\nERROR:\nORA-12547: TNS:lost contact\nEnter user-name:\nERROR:\nORA-12547: TNS:lost contact\nSP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus<\/pre>\n
    Problem solving
    \n<\/strong>My first assumption was that something had gone wrong with the database patching, so I wanted to check the status of the new patch in the database first. First of all I needed to be able to connect to the database again, so I tried to stop the database with srvctl and start it manually with sqlplus.<\/p>\n
    This worked and I was able to log back into the database.<\/p>\n
    oracle@ora21:\/home\/oracle\/ [cdb19] srvctl stop database -db cdb19\noracle@ora21:\/home\/oracle\/ [cdb19] sqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 11:22:45 2021\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\nConnected to an idle instance.\nSQL> startup\nORACLE instance started.\nTotal System Global Area 1543500144 bytes\nFixed Size 8896880 bytes\nVariable Size 369098752 bytes\nDatabase Buffers 1157627904 bytes\nRedo Buffers 7876608 bytes\nDatabase mounted.\nDatabase opened.\nSQL><\/pre>\n
    dba_registry_sqlpatch view showed no abnormalities, and the patch was applied cleanly to the database.
    \nSo let’s do a restart of the database to check if we still have the same issue with the login<\/p>\n
    oracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl stop database -db cdb19\noracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl start database -db cdb19\noracle@ora21:\/u01\/app\/oracle\/ [cdb19] sqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 11:34:31 2021\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\nERROR:\nORA-12547: TNS:lost contact<\/pre>\n
    Nothing has changed, a login to the database after starting it with srvctl is still not possible.
    \nLet’s check the cluster settings of the database:<\/p>\n
    oracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl config database -db cdb19\nDatabase unique name: cdb19\nDatabase name: cdb19\nOracle home: \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/\nOracle user: oracle\nSpfile: \/u01\/app\/oracle\/admin\/cdb19\/pfile\/spfilecdb19.ora\nPassword file:\nDomain:\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nDisk Groups: DATA,RECO\nServices:\nOSDBA group: oinstall\nOSOPER group: oinstall\nDatabase instance: cdb19\n\n<\/pre>\n
    Solution
    \n<\/strong>As a very attentive DBA, you may have already discovered the problem. There is a small error in the configuration, but I did not recognize it at first glance. So i did a research on Oracle Support about that and after a few minutes i found the following note:
    \nDB started by sqlplus cannot be stopped by srvctl( ORA-12547 ), and vice versa (Doc ID 2612663.1)<\/em><\/strong><\/p>\n
    The problem is a copy \/ paste error. If you modify your oracle home with srvctl to attach your database to a new oracle home and you copy the path in your shell, then be careful, that you don’t have a “\/”<\/strong> in the end!<\/p>\n
    oracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl config database -db cdb19 | grep home\nOracle home: \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/<\/pre>\n
    This \/ at the end does not trigger an error when updating the home with srvctl, but it ensures that a sqlplus \/ as sysdba<\/em> is no longer possible from this point on.
    \nAfter adjusting the Oracle home parameter and restarting the database, the login works as expected.<\/p>\n
    oracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl modify database -db cdb19 -o \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\noracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl stop database -db cdb19\noracle@ora21:\/u01\/app\/oracle\/ [cdb19] srvctl start database -db cdb19\noracle@ora21:\/u01\/app\/oracle\/ [cdb19] sqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 11:57:03 2021\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\nSQL><\/pre>\n
    Conclusion
    \n<\/strong>This example shows once again that a small cause can have a big effect. Copy \/ Paste is basically a good thing, because it prevents typos, but it can unfortunately also lead to a significant additional effort.
    \n<\/strong><\/p>\n
     <\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[2248,1171],"type_dbi":[],"class_list":["post-16672","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-clusterware","tag-oracle-19c"],"acf":[],"yoast_head":"\nAfter startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact - dbi Blog<\/title>\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\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact\" \/>\n<meta property=\"og:description\" content=\"A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-06T08:51:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-06T10:36:13+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact\",\"datePublished\":\"2021-09-06T08:51:47+00:00\",\"dateModified\":\"2023-01-06T10:36:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/\"},\"wordCount\":480,\"commentCount\":2,\"keywords\":[\"Clusterware\",\"Oracle 19c\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/\",\"name\":\"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-09-06T08:51:47+00:00\",\"dateModified\":\"2023-01-06T10:36:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact\"}]},{\"@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\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact - dbi Blog","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\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/","og_locale":"en_US","og_type":"article","og_title":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact","og_description":"A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done […]","og_url":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/","og_site_name":"dbi Blog","article_published_time":"2021-09-06T08:51:47+00:00","article_modified_time":"2023-01-06T10:36:13+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact","datePublished":"2021-09-06T08:51:47+00:00","dateModified":"2023-01-06T10:36:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/"},"wordCount":480,"commentCount":2,"keywords":["Clusterware","Oracle 19c"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/","url":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/","name":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-09-06T08:51:47+00:00","dateModified":"2023-01-06T10:36:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/after-startup-database-with-srvctl-sqlplus-as-sysdba-results-in-ora-12547-tnslost-contact\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16672","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16672"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16672\/revisions"}],"predecessor-version":[{"id":21461,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16672\/revisions\/21461"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16672"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}