Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DirectQuery of Oracle DB Stuck Detecting Table Schema

Hi everyone - below is an overview of my issue I'm hoping someone can help me with. If there's anything additional I can provide to help troubleshoot, please let me know.   ISSUE: When I try to con...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi All,

     

    For those interested, I had different Oracle clients installed on my machine so that was the starting point. We performed the steps below to resolve:

    1. Uninstall all clients from machine
    2. Install Oracle Database Client 19c from this Oracle site (scroll down to the database client) 
      1. Base Path: C:\app\oracle\product
      2. Software Location: C:\app\oracle\product\19.3\client_2
    3. Add tnsnames.ora file to C:\app\oracle\product\19.3\client_2\network\admin
    4. Make sure environment variables are correct
      1. ORACLE_HOME = C:\app\oracle\product\19.3\client_2
      2. TNS_ADMIN = C:\app\oracle\product\19.3\client_2\network\admin
      3. Delete old paths from the 'Path' variable from the old clients
        1. Should be a C:\app\oracle\product\19.3\client_2\bin path here
    5. Install ODAC 19c from this Oracle site 
      1. We had to install this via Windows PowerShell
      2. We created a 19.1 folder so we had the resulting path C:\app\oracle\product\19.1
        1. We may have also created the odac_client folder in the 19.1 folder
      3. Below is the command syntax we used. The first C:\ location was where the ODAC download was.

     

    I definitely wouldn't have been able to do this without help from one of our Oracle database admins, so recommend enlisting the help of IT if someone else runs into this issue.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi All,

 

For those interested, I had different Oracle clients installed on my machine so that was the starting point. We performed the steps below to resolve:

  1. Uninstall all clients from machine
  2. Install Oracle Database Client 19c from this Oracle site (scroll down to the database client) 
    1. Base Path: C:\app\oracle\product
    2. Software Location: C:\app\oracle\product\19.3\client_2
  3. Add tnsnames.ora file to C:\app\oracle\product\19.3\client_2\network\admin
  4. Make sure environment variables are correct
    1. ORACLE_HOME = C:\app\oracle\product\19.3\client_2
    2. TNS_ADMIN = C:\app\oracle\product\19.3\client_2\network\admin
    3. Delete old paths from the 'Path' variable from the old clients
      1. Should be a C:\app\oracle\product\19.3\client_2\bin path here
  5. Install ODAC 19c from this Oracle site 
    1. We had to install this via Windows PowerShell
    2. We created a 19.1 folder so we had the resulting path C:\app\oracle\product\19.1
      1. We may have also created the odac_client folder in the 19.1 folder
    3. Below is the command syntax we used. The first C:\ location was where the ODAC download was.

 

I definitely wouldn't have been able to do this without help from one of our Oracle database admins, so recommend enlisting the help of IT if someone else runs into this issue.