我正在执行logstash JDBC配置文件,而执行该文件时收到以下错误
Error: Java::JavaSql::SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:xe
请找到我的logstash配置文件:
input {
jdbc {
jdbc_driver_library => "D:\1SearchEngine\data\ojdbc14.jar"
jdbc_driver_class => "Java::oracle.jdbc.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@localhost:1521:xe"
jdbc_user => "ub"
jdbc_password => "1234567"
statement => "select * from documents"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "documents"
}
}但我能够通过SQLDeveloper连接数据库没有任何问题。
https://stackoverflow.com/questions/50747301
复制相似问题