title: cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
body: <p>I am trying to do a sanity testing of newly installed <code>Oracle client 12.2 in RHEL 7 linux</code> from a Python program, but it fails with the above error, not sure what I am missing on there. Please help with this case :</p>
  
  <pre><code>cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service 
  requested in connect descriptor
  </code></pre>
  
  <p><em>my <code>tnsnames.ora</code> file under <code>/home</code> directory</em></p>
  
  <blockquote>
  <pre><code>  FRDLD2D1 =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(Host = frdld2d1.de.db.com)(Port = 1825))
      )
      (CONNECT_DATA =
        (SID = FRDLD2D1)
        )
     )
  </code></pre>
  </blockquote>
  
  <p><em>and my python program goes below</em></p>
  
  <blockquote>
  <pre><code>#!/usr/bin/python
  import cx_Oracle
  #connection = cx_Oracle.connect('PNTH_LOGGINGB_OWNER/password')
  connection = cx_Oracle.connect('PNTH_LOGGINGB_OWNER/password@10.245.63.34:1825/orcl')
  cursor = connection.cursor()
  querystring = "select * from BDR_JOB_MASTER_LOG where ROWNUM &lt;= 1;"
  cursor.execute(querystring)
  </code></pre>
  </blockquote>
  
  <p><code>frdld2d1.de.db.com</code> <em>- IP address :</em> <code>10.245.63.34</code></p>
  
  <p>Appreciate if any points the glitch on here.</p>
  
  <p><code>tnsping</code> utility is not there to test since it is an instaclient version </p>
  
  <p><code>oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm</code>.</p>
  
  <p>But with <code>SQLPlus</code>, I am able to connect the database without any issues.</p>