title: How to Connect Airflow to oracle database
body: <p>I am trying to create a connection to an oracle db instance (oracle:thin) using Airflow.</p>
  
  <p>According to their <a href="https://webcache.googleusercontent.com/search?q=cache:MCETp_jTg5oJ:https://github.com/airbnb/airflow/wiki/AirBnb-Airflow---Tips-and-Tricks-for-Oracle-Shops+&amp;cd=2&amp;hl=en&amp;ct=clnk&amp;gl=us" rel="noreferrer">documentation</a> I entered my hostname followed by port number and SID:</p>
  
  <p>Host: example.com:1524/sid</p>
  
  <p>filled other fields as:</p>
  
  <p><strong>Conn Type</strong>: Oracle</p>
  
  <p><strong>Schema</strong>: username ( <a href="https://webcache.googleusercontent.com/search?q=cache:MCETp_jTg5oJ:https://github.com/airbnb/airflow/wiki/AirBnb-Airflow---Tips-and-Tricks-for-Oracle-Shops+&amp;cd=2&amp;hl=en&amp;ct=clnk&amp;gl=us" rel="noreferrer">documentation</a> says: use your username for schema )</p>
  
  <p><strong>Login</strong>: username</p>
  
  <p><strong>Password</strong>: * * *</p>
  
  <p><a href="https://i.stack.imgur.com/UUcbJ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/UUcbJ.png" alt="Create Connection Page -- Airflow"></a></p>
  
  <p>After connection is setup, it gives the save error code for every query that I tried to execute (<em>ORA-12514</em>).
  It seems like oracle doesn't let airflow to connect:</p>
  
  <p><em>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor</em></p>
  
  <p><a href="https://i.stack.imgur.com/zSVbD.png" rel="noreferrer"><img src="https://i.stack.imgur.com/zSVbD.png" alt="ORA-12514"></a></p>
  
  <p>Has someone experienced the same problem before. I mean connecting to a database shouldn't be a problem for a big platform like this. Or I am probably doing something wrong. Thanks</p>
  
  <p>Version: Airflow v1.7.0,  Oracle11g</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>I am using the same hostname which I use in Oracle SQLDeveloper client:
  <a href="https://i.stack.imgur.com/V0cy5.png" rel="noreferrer"><img src="https://i.stack.imgur.com/V0cy5.png" alt="Oracle client connection configuration"></a></p>