Logstash连接Oracle数据库报错：oracle.jdbc.OracleDriver未加载

Hey, let's work through this Logstash-Oracle connection issue you're hitting. That oracle.jdbc.OracleDriver not loaded error is a common gotcha when the JDBC driver isn't set up correctly, so let's break down the fixes step by step:

1. Fix the Driver Path Format (Critical!) #

Windows uses backslashes (\) for file paths, but in Logstash's JRuby-based config, single backslashes are treated as escape characters. Your current path D:\data\... isn't being read correctly. You have two safe options:

• Use forward slashes instead: "D:/data/ojdbcX.jar" (replace X with your driver version like 6/7/8)
• Use double backslashes: "D:\\data\\ojdbcX.jar"

2. Use the Correct Oracle JDBC Driver #

Make sure you've downloaded the driver jar that matches your Oracle database version:

• Oracle 11g → ojdbc6.jar
• Oracle 12c/18c/19c → ojdbc8.jar
  Mismatched versions (like using ojdbc6 with Oracle 19c) will cause loading failures even if the path is right.

3. Explicitly Define the Driver Class #

Add this line to your JDBC input block to remove any ambiguity about which driver to load:

jdbc_driver_class => "oracle.jdbc.OracleDriver"

4. Verify File Existence & Permissions #

• Double-check that the jar file exists exactly at the path you specified (no typos in the filename or directory).
• Ensure the Logstash process has read access to the jar. If you run into permission issues, move the jar to Logstash's vendor/jars directory and use a relative path:

  jdbc_driver_library => "./vendor/jars/ojdbc8.jar"
  

Example Corrected Configuration #

Here's how your input block should look after applying these fixes:

input {
  jdbc {
    jdbc_driver_library => "D:/data/ojdbc8.jar"
    jdbc_driver_class => "oracle.jdbc.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@//your-oracle-host:1521/your-db-sid"
    jdbc_user => "your-db-username"
    jdbc_password => "your-db-password"
    statement => "SELECT * FROM your-target-table"
  }
}

The root issue here is that Logstash's JDBC plugin can't locate or load the Oracle driver jar due to path formatting mistakes, incorrect driver version, or missing explicit driver class setup. These steps should resolve the LogStash::ConfigurationError you're seeing.

内容的提问来源于stack exchange，提问作者Karthikeyan