-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
executable file
·22 lines (22 loc) · 15.6 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<!doctype html><html lang=en dir=auto><head><meta name=generator content="Hugo 0.135.0"><meta charset=utf-8><meta http-equiv=X-UA-Compatible content="IE=edge"><meta name=viewport content="width=device-width,initial-scale=1,shrink-to-fit=no"><meta name=robots content="index, follow"><title>amardeepsidhu.com</title>
<meta name=description content><meta name=author content="Amardeep Sidhu"><link rel=canonical href=https://amardeep-sidhu.github.io/mywebsite/><link crossorigin=anonymous href=/mywebsite/assets/css/stylesheet.fc220c15db4aef0318bbf30adc45d33d4d7c88deff3238b23eb255afdc472ca6.css integrity="sha256-/CIMFdtK7wMYu/MK3EXTPU18iN7/MjiyPrJVr9xHLKY=" rel="preload stylesheet" as=style><link rel=icon href=https://amardeep-sidhu.github.io/mywebsite/favicon.ico><link rel=icon type=image/png sizes=16x16 href=https://amardeep-sidhu.github.io/mywebsite/favicon-16x16.png><link rel=icon type=image/png sizes=32x32 href=https://amardeep-sidhu.github.io/mywebsite/favicon-32x32.png><link rel=apple-touch-icon href=https://amardeep-sidhu.github.io/mywebsite/apple-touch-icon.png><link rel=mask-icon href=https://amardeep-sidhu.github.io/mywebsite/safari-pinned-tab.svg><meta name=theme-color content="#2e2e33"><meta name=msapplication-TileColor content="#2e2e33"><link rel=alternate type=application/rss+xml href=https://amardeep-sidhu.github.io/mywebsite/index.xml><link rel=alternate hreflang=en href=https://amardeep-sidhu.github.io/mywebsite/><noscript><style>#theme-toggle,.top-link{display:none}</style><style>@media(prefers-color-scheme:dark){:root{--theme:rgb(29, 30, 32);--entry:rgb(46, 46, 51);--primary:rgb(218, 218, 219);--secondary:rgb(155, 156, 157);--tertiary:rgb(65, 66, 68);--content:rgb(196, 196, 197);--code-block-bg:rgb(46, 46, 51);--code-bg:rgb(55, 56, 62);--border:rgb(51, 51, 51)}.list{background:var(--theme)}.list:not(.dark)::-webkit-scrollbar-track{background:0 0}.list:not(.dark)::-webkit-scrollbar-thumb{border-color:var(--theme)}}</style></noscript><meta property="og:title" content="amardeepsidhu.com"><meta property="og:description" content><meta property="og:type" content="website"><meta property="og:url" content="https://amardeep-sidhu.github.io/mywebsite/"><meta name=twitter:card content="summary"><meta name=twitter:title content="amardeepsidhu.com"><meta name=twitter:description content><script type=application/ld+json>{"@context":"https://schema.org","@type":"Organization","name":"amardeepsidhu.com","url":"https://amardeep-sidhu.github.io/mywebsite/","description":"","thumbnailUrl":"https://amardeep-sidhu.github.io/mywebsite/favicon.ico","sameAs":["https://x.com/","https://stackoverflow.com","https://github.com/"]}</script></head><body class=list id=top><script>localStorage.getItem("pref-theme")==="dark"?document.body.classList.add("dark"):localStorage.getItem("pref-theme")==="light"?document.body.classList.remove("dark"):window.matchMedia("(prefers-color-scheme: dark)").matches&&document.body.classList.add("dark")</script><header class=header><nav class=nav><div class=logo><a href=https://amardeep-sidhu.github.io/mywebsite/ accesskey=h title="amardeepsidhu.com (Alt + H)">amardeepsidhu.com</a><div class=logo-switches><button id=theme-toggle accesskey=t title="(Alt + T)"><svg id="moon" width="24" height="18" viewBox="0 0 24 24" fill="none" stroke="currentcolor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M21 12.79A9 9 0 1111.21 3 7 7 0 0021 12.79z"/></svg><svg id="sun" width="24" height="18" viewBox="0 0 24 24" fill="none" stroke="currentcolor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="12" r="5"/><line x1="12" y1="1" x2="12" y2="3"/><line x1="12" y1="21" x2="12" y2="23"/><line x1="4.22" y1="4.22" x2="5.64" y2="5.64"/><line x1="18.36" y1="18.36" x2="19.78" y2="19.78"/><line x1="1" y1="12" x2="3" y2="12"/><line x1="21" y1="12" x2="23" y2="12"/><line x1="4.22" y1="19.78" x2="5.64" y2="18.36"/><line x1="18.36" y1="5.64" x2="19.78" y2="4.22"/></svg></button></div></div><ul id=menu><li><a href=https://amardeep-sidhu.github.io/mywebsite/blog1/ title=blog1><span>blog1</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/blog2/ title=blog2><span>blog2</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/blog3/ title=blog3><span>blog3</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/categories/ title=categories><span>categories</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/tags/ title=tags><span>tags</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/search/ title="search (Alt + /)" accesskey=/><span>search</span></a></li><li><a href=https://amardeep-sidhu.github.io/mywebsite/archives/ title=archive><span>archive</span></a></li></ul></nav></header><main class=main><article class="first-entry home-info"><header class=entry-header><h1>Hi there 👋</h1></header><div class=entry-content>Welcome to my blog</div><footer class=entry-footer><div class=social-icons><a href=https://x.com/ target=_blank rel="noopener noreferrer me" title=X><svg viewBox="0 0 24 24" fill="currentcolor"><path d="M18.244 2.25h3.308l-7.227 8.26 8.502 11.24H16.17l-5.214-6.817L4.99 21.75H1.68l7.73-8.835L1.254 2.25H8.08l4.713 6.231zm-1.161 17.52h1.833L7.084 4.126H5.117z"/></svg>
</a><a href=https://stackoverflow.com target=_blank rel="noopener noreferrer me" title=Stackoverflow><svg viewBox="0 0 24 24" fill="none" stroke="currentcolor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M2.913 16.041v6.848h17.599v-6.848M7.16 18.696h8.925M7.65 13.937l8.675 1.8M9.214 9.124l8.058 3.758M12.086 4.65l6.849 5.66M15.774 1.111l5.313 7.162"/></svg>
</a><a href=https://github.com/ target=_blank rel="noopener noreferrer me" title=Github><svg viewBox="0 0 24 24" fill="none" stroke="currentcolor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M9 19c-5 1.5-5-2.5-7-3m14 6v-3.87a3.37 3.37.0 00-.94-2.61c3.14-.35 6.44-1.54 6.44-7A5.44 5.44.0 0020 4.77 5.07 5.07.0 0019.91 1S18.73.65 16 2.48a13.38 13.38.0 00-7 0C6.27.65 5.09 1 5.09 1A5.07 5.07.0 005 4.77 5.44 5.44.0 003.5 8.55c0 5.42 3.3 6.61 6.44 7A3.37 3.37.0 009 18.13V22"/></svg></a></div></footer></article><article class=post-entry><header class=entry-header><h2 class=entry-hint-parent>Database performance degradation due to multipath issues ashishb</h2></header><div class=entry-content><p>To put it in bit of an Indian context, database is not your daughter-in-law that you can blame it for every performance issue that occurs in the environment. But it does happen. Most of the time it is the database that is blamed for all such issues. Many times, the issues are in some other layer like OS, network or storage.
Faced this issue recently at one of the customer sites where performance in one of the databases went down suddenly. It was a 2 node RAC on 12.1.0.2 running on Linux 7 using some kind of Hitachi SSD storage array. There were no changes as per DBA, application, OS and storage teams. But something must have changed somewhere. Otherwise why would performance degrade just like that. I & my colleague checked some details and found that something happened in the morning a day before. Starting from that point in time, the execution time for all the commonly run queries shot up. Generally speaking, when all the queries are doing bad and you are sure that nothing has been changed on the database side, the reasons could be outside the database. But being a DBA, it is not easy to prove that. We took AWRs from good and bad times and the wait events section looked like this:
...</p></div><footer class=entry-footer><span title='2021-03-22 07:24:19 +0000 UTC'>March 22, 2021 at 7:24 AM</span> · 2 min · 402 words · Amardeep Sidhu</footer><a class=entry-link aria-label="post link to Database performance degradation due to multipath issues ashishb" href=https://amardeep-sidhu.github.io/mywebsite/blog/database-performance-degradation-due-to-multipath-issues/></a></article><article class=post-entry><header class=entry-header><h2 class=entry-hint-parent>ZDLRA patching ashishb</h2></header><div class=entry-content><p>To be honest, Fernando Simon has already documented all the steps needed in ZDLRA patching . So this post is more like a reference post for me and it points to the links on his blog. One thing he could change though are the post titles. He also agrees ;)
https://twitter.com/amardeep_sidhu/status/1370304085245661192
ZDLRA patching is broadly divided into two parts. First part is where you patch the RA library and Grid & DB homes. Second part includes compute node & storage cell image patch and patches for IB/RoCE switches. Second part is exactly similar to Exadata except that it is bit restricted in terms of image versions that you can use. Only the versions that are certified for ZDLRA can be used. Also the RA library version and the Exadata image version should be compatible with each other. So if you are planning to patch only one part; RA library or the image, make sure that both the components stay compatible. The MOS note that has all these details is 1927416.1. This note should be the first place to go when you are planning to patch a ZDLRA. The steps for upgrade/patch, image patching are given in MOS note 2028931.1. There is another note 2639262.1 that discusses some of the known issues that you may face while doing the patching. It is important to review all three notes before you plan to patch.
...</p></div><footer class=entry-footer><span title='2021-03-12 17:00:52 +0000 UTC'>March 12, 2021 at 5:00 PM</span> · 2 min · 396 words · Amardeep Sidhu</footer><a class=entry-link aria-label="post link to ZDLRA patching ashishb" href=https://amardeep-sidhu.github.io/mywebsite/blog/zdlra-patching/></a></article><article class=post-entry><header class=entry-header><h2 class=entry-hint-parent>[FATAL] [INS-44000] Passwordless SSH connectivity is not setup ashishb</h2></header><div class=entry-content><p>Faced this while running installer for setting up a 2 node RAC setup (version 19.8) on an Oracle SuperCluster. The error reported in the log is:
[FATAL] [INS-44000] Passwordless SSH connectivity is not setup from the local node node1 to the following nodes: [node2] [INS-06006] Passwordless SSH connectivity not set up between the following node(s): [node2] From the error it appears that the ssh is not setup between two nodes but actually that is not the case. Here the error message is bit misleading. It turned out to be an issue with scp with openssh version 8.x. Running the setup with -debug option gives the clue:
...</p></div><footer class=entry-footer><span title='2021-03-10 12:47:34 +0000 UTC'>March 10, 2021 at 12:47 PM</span> · 1 min · 212 words · Amardeep Sidhu</footer><a class=entry-link aria-label="post link to [FATAL] [INS-44000] Passwordless SSH connectivity is not setup ashishb" href=https://amardeep-sidhu.github.io/mywebsite/blog/fatal-ins-44000-passwordless-ssh-connectivity-is-not-setup/></a></article><article class=post-entry><header class=entry-header><h2 class=entry-hint-parent>[FATAL] [INS-44000] Passwordless SSH connectivity is not setup - nodejs</h2></header><div class=entry-content><p>Faced this while running installer for setting up a 2 node RAC setup (version 19.8) on an Oracle SuperCluster. The error reported in the log is:
[FATAL] [INS-44000] Passwordless SSH connectivity is not setup from the local node node1 to the following nodes:
[node2]
[INS-06006] Passwordless SSH connectivity not set up between the following node(s): [node2] From the error it appears that the ssh is not setup between two nodes but actually that is not the case. Here the error message is bi t misleading. It turned out to be an issue with scp with openssh version 8.x. Running the setup with -debug option gives the clue:
...</p></div><footer class=entry-footer><span title='2021-03-10 00:00:00 +0000 UTC'>March 10, 2021 at 12:00 AM</span> · 1 min · 205 words · Amardeep Sidhu</footer><a class=entry-link aria-label="post link to [FATAL] [INS-44000] Passwordless SSH connectivity is not setup - nodejs" href=https://amardeep-sidhu.github.io/mywebsite/blog3/2021-03-10-fatal-ins-44000-passwordless-ssh-connectivity-is-not-setup-nodejs/></a></article><article class=post-entry><header class=entry-header><h2 class=entry-hint-parent>Garbled display while running FMW installer on Linux ashishb</h2></header><div class=entry-content><p>A colleague faced this while running FMW installer on a Linux machine. The display appeared like this
This thread gave a clue that it could have something to do with fonts. So I checked what all fonts related stuff was installed.
[bash][root@someserver ~]# rpm -aq |grep -i font stix-fonts-1.1.0-5.el7.noarch xorg-x11-font-utils-7.5-20.el7.x86_64 xorg-x11-fonts-cyrillic-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-1-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-9-100dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-9-75dpi-7.5-9.el7.noarch libXfont-1.5.2-1.el7.x86_64 xorg-x11-fonts-ISO8859-14-100dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-1-100dpi-7.5-9.el7.noarch xorg-x11-fonts-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-2-100dpi-7.5-9.el7.noarch libfontenc-1.1.3-3.el7.x86_64 xorg-x11-fonts-ethiopic-7.5-9.el7.noarch xorg-x11-fonts-100dpi-7.5-9.el7.noarch xorg-x11-fonts-misc-7.5-9.el7.noarch fontpackages-filesystem-1.44-8.el7.noarch fontconfig-2.10.95-11.el7.x86_64 xorg-x11-fonts-ISO8859-2-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-14-75dpi-7.5-9.el7.noarch xorg-x11-fonts-Type1-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-15-75dpi-7.5-9.el7.noarch [root@someserver ~]#[/bash]
...</p></div><footer class=entry-footer><span title='2017-11-18 10:56:02 +0000 UTC'>November 18, 2017 at 10:56 AM</span> · 1 min · 97 words · Amardeep Sidhu</footer><a class=entry-link aria-label="post link to Garbled display while running FMW installer on Linux ashishb" href=https://amardeep-sidhu.github.io/mywebsite/blog/garbled-display-while-running-fmw-installer-on-linux/></a></article></main><footer class=footer><span>© 2024 <a href=https://amardeep-sidhu.github.io/mywebsite/>amardeepsidhu.com</a></span> ·
<span>Powered by
<a href=https://gohugo.io/ rel="noopener noreferrer" target=_blank>Hugo</a> &
<a href=https://github.com/adityatelange/hugo-PaperMod/ rel=noopener target=_blank>PaperMod</a></span></footer><a href=#top aria-label="go to top" title="Go to Top (Alt + G)" class=top-link id=top-link accesskey=g><svg viewBox="0 0 12 6" fill="currentcolor"><path d="M12 6H0l6-6z"/></svg>
</a><script>let menu=document.getElementById("menu");menu&&(menu.scrollLeft=localStorage.getItem("menu-scroll-position"),menu.onscroll=function(){localStorage.setItem("menu-scroll-position",menu.scrollLeft)}),document.querySelectorAll('a[href^="#"]').forEach(e=>{e.addEventListener("click",function(e){e.preventDefault();var t=this.getAttribute("href").substr(1);window.matchMedia("(prefers-reduced-motion: reduce)").matches?document.querySelector(`[id='${decodeURIComponent(t)}']`).scrollIntoView():document.querySelector(`[id='${decodeURIComponent(t)}']`).scrollIntoView({behavior:"smooth"}),t==="top"?history.replaceState(null,null," "):history.pushState(null,null,`#${t}`)})})</script><script>var mybutton=document.getElementById("top-link");window.onscroll=function(){document.body.scrollTop>800||document.documentElement.scrollTop>800?(mybutton.style.visibility="visible",mybutton.style.opacity="1"):(mybutton.style.visibility="hidden",mybutton.style.opacity="0")}</script><script>document.getElementById("theme-toggle").addEventListener("click",()=>{document.body.className.includes("dark")?(document.body.classList.remove("dark"),localStorage.setItem("pref-theme","light")):(document.body.classList.add("dark"),localStorage.setItem("pref-theme","dark"))})</script></body></html>