title: How do I list tnsnames
body: <p>Is there any <strong>easy way</strong> to list out all the available tnsnames in my system via command line?</p>
  
  <p>Whenever I need to find out a tnsname, I just simply search for the <strong>tnsnames.ora</strong> file with <strong>tnsping</strong> command and open it in a text editor to scan through. Then subsequently run <strong>tnsping [tnsname]</strong> to check the connection health. I was thinking if there's any easy command like <strong>tnslist or tns -l</strong> to list out all the tnsnames but I couldn't find such.</p>