Oracle -- Intermittent [Connection is not valid.] message

I’m using Dremio v. 4.1.8. Much of the time, my Oracle connection works. However, I run across the following error,often once or twice a day, when trying to pull data via my Oracle connection

The source [myoraclesourcename ] is currently unavailable. Info: [Connection is not valid.]

If I resubmit my query, or use the UI to browse to another dataset used by that same connection, the error goes away, often for several hours/rest of the day.

I’m assuming this message might be occurring because for some reason, the connection closed, but don’t know for sure because of the ambiguity of the message.

Is there a fix or a workaround for this?

We use Oracle all the time without issues. Have your DBA check the Oracle listener log. We are on Dremio 4.2.1.

1 Like


What @mcotter suggested was good. In addition, you can also install Oracle client on the Dremio coordinator and try a tnsping and see how the return comes. Run the tnsping a few times in a loop and see if you get a time out


@balaji.ramaswamy Thank you for the suggestion.

@balaji.ramaswamy Our Oracle DBAs have asked us to turn on Oracle tracing, so they can further help troubleshoot this connection is not valid issue we’re still seeing.

Is this possible with Dremio? Here’s what we’ve attempted, but no oracle.log is getting generated. Any ideas?

    “-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=[mydremiopathhere]/conf/”

where the looks like this:

  • restarted Dremio



Looking at, it looks good but not sure why it is not generating a log file. Have we checked in Oracle’s listener. logfile if there is an entry for the Dremio coordinator IP when the error happens? Atleast we can see if this even reaching the Oracle server


@balaji.ramaswamy Yes. Our DBAs checked. They could not find errors in the listener logfile that corresponded to errors coming from our coordinator’s IP.

They DBAs also suggested we change the connection to use an ldap based connection string such as:


rather than hard coding a single RAC node. But the Dremio UI does not appear to support the format above. Is there any way to create such a connection from Dremio, or would that require an enhancement to the plugin?


Currently we do not have one like that,