title: How to use cx_Oracle within AWS SageMaker (Jupyter Notebook)
body: <p>I've followed the official <a href="https://oracle.github.io/odpi/doc/installation.html#linux" rel="nofollow noreferrer">installation guide</a> but haven't had any luck so far. I wonder if <code>cx_Oracle</code> <em>can</em> work on AWS SageMaker's virtual environment. The steps I've used so far are:</p>
  
  <ol>
  <li>Create a <code>/opt/oracle</code> directory and unzip the basic instantclient in it.</li>
  <li><code>sudo yum install libaio</code></li>
  <li><code>sudo sh -c "echo /opt/oracle/instantclient_18_3 &gt; /etc/ld.so.conf.d/oracle-instantclient.conf"</code> and
  <code>sudo ldconfig</code></li>
  <li>And finally exported the <code>LD_LIBRARY_PATH</code> with: <code>export LD_LIBRARY_PATH=/opt/oracle/instantclient_18_3:$LD_LIBRARY_PATH</code></li>
  </ol>
  
  <p>When trying to run a connection inside the notebook with <code>connection = cx_Oracle.connect(usr + '/' + pwd + '@' + url)</code>, I receive the <code>DPI-1047</code> error code that says that <code>libclntsh.so</code> cannot be open, however that library <em>is</em> in the <code>/opt/oracle</code> folder. As another option, when running the same connection through the terminal Python console, I get the <code>ORA-01804</code> error code, which says that the timezone files were not properly read, which is something I'm trying to fix also but suspect is related to <code>cx_Oracle</code> not finding its library folder. (Now, explain to me: why does it have to be so difficult for a billionaire company to create a decent library import and installation?)</p>
  
  <p>Is there a step I'm missing? Is there a detail about AWS SageMaker that I should account for? Also, is there another option for extracting data from an oracle server through Python and AWS?</p>