{"id":1460,"date":"2021-11-24T09:53:14","date_gmt":"2021-11-24T12:53:14","guid":{"rendered":"https:\/\/rodrigosilvaesilva.com.br\/?p=1460"},"modified":"2021-11-24T09:53:14","modified_gmt":"2021-11-24T12:53:14","slug":"tns-12549-tns-12560-tns-00519-oracle-rac-scan-resolve-single-ip","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2021\/11\/24\/tns-12549-tns-12560-tns-00519-oracle-rac-scan-resolve-single-ip\/","title":{"rendered":"TNS-12549: TNS-12560: TNS-00519: Oracle RAC SCAN &#8211; Resolve Single IP"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Causa<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\n[grid@exa03vm02 ~]$ lsnrctl start\n\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 23-NOV-2021 11:29:38\n\nCopyright (c) 1991, 2016, Oracle.  All rights reserved.\n\nStarting \/u01\/app\/12.2.0.1\/grid\/bin\/tnslsnr: please wait...\n\nTNSLSNR for Linux: Version 12.2.0.1.0 - Production\nSystem parameter file is \/u01\/app\/12.2.0.1\/grid\/network\/admin\/listener.ora\nLog messages written to \/u01\/app\/grid\/diag\/tnslsnr\/exa03vm02\/listener\/alert\/log.xml\nError listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nTNS-12549: TNS:operating system resource quota exceeded\n TNS-12560: TNS:protocol adapter error\n  TNS-00519: Operating system resource quota exceeded\n   Linux Error: 28: No space left on device\n\nListener failed to start. See the error message(s) above...\n\n<\/pre><\/div>\n\n\n\n<p><strong>An\u00e1lise<\/strong><\/p>\n\n\n\n<p>identificado que os Inodes da parti\u00e7\u00e3o \/ estavam em 100%.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\n[grid@exa03vm02 ~]$ df -i\nFilesystem              Inodes    IUsed     IFree IUse% Mounted on\n\/dev\/mapper\/VGExaDb-LVDbSys1\n                       1572864  1572864         0  100% \/\ntmpfs                  6381267     2453   6378814    1% \/dev\/shm\n\/dev\/xvda1               32768      332     32436    2% \/boot\n\/dev\/mapper\/VGExaDb-LVDbOra1\n                       1310720    33841   1276879    3% \/u01\n\/dev\/xvdb              3276800    44231   3232569    2% \/u01\/app\/12.2.0.1\/grid\n\/dev\/xvdg              6553600   729839   5823761   12% \/u02\n\/dev\/asm\/acfsvol01-298\n                     346030080 34417046 311613034   10% \/acfs01\n10.1.3.50:\/apps\/apps-repo\/sccard\/tiss\/\n                     104570880    15389 104555491    1% \/utl\/sguprd\/tiss<\/pre><\/div>\n\n\n\n<p><strong>Identificando quantidade de arquivo nos diret\u00f3rio<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \" >\n\n[oracle@exa03vm02 cprops]$ for i in \/var\/opt\/oracle\/log\/grid\/cprops*; do echo $i; find $i |wc -l; done\n\/var\/opt\/oracle\/log\/grid\/cleandblogs\n291\n\/var\/opt\/oracle\/log\/grid\/cprops\n1261462\n\/var\/opt\/oracle\/log\/grid\/creg\n6<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>A\u00e7\u00e3o<\/strong> <\/p>\n\n\n\n<p>Apagar todos os arquivos de log <\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:default decode:true \" >[oracle@exa03vm02 cprops]$ cd \/var\/opt\/oracle\/log\/grid\/cprops\n\n[oracle@exa03vm02 cprops]$ find . -name 'cprops_2021-*log' | xargs rm -v<\/pre><\/div>\n\n\n\n<p><strong>Verificando status do SCAN<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:sh decode:true \" >\ncd \/u01\/app\/12.2.0.1\/grid\/bin\/\n[grid@exa0201vm02 bin]$ srvctl status scan\nSCAN VIP scan1 is enabled\nSCAN VIP scan1 is running on node exa0201vm02\nSCAN VIP scan2 is enabled\nSCAN VIP scan2 is not running\nSCAN VIP scan3 is enabled\nSCAN VIP scan3 is not running<\/pre><\/div>\n\n\n\n<p><strong>Reiniciando o scan<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:sh decode:true \" >[oracle@exa03vm02 cprops]$ srvctl restart scan<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Causa An\u00e1lise identificado que os Inodes da parti\u00e7\u00e3o \/ estavam em 100%. Identificando quantidade de arquivo nos diret\u00f3rio A\u00e7\u00e3o Apagar todos os arquivos de log Verificando status do SCAN Reiniciando o scan<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[413],"tags":[417,416,360],"class_list":["post-1460","post","type-post","status-publish","format-aside","hentry","category-rac","tag-tns-00519","tag-tns-12549","tag-tns-12560","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1460"}],"version-history":[{"count":2,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1460\/revisions"}],"predecessor-version":[{"id":1462,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1460\/revisions\/1462"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}