gistfile1.txt

2022-06-23 12:36:28,251 ERROR  ||  Failed testing connection for {connector.class=io.debezium.connector.oracle.OracleConnector, database.user=c##dbzuser, database.dbname=ORCLCDB, database.connection.adapter=logminer, database.pdb.name=ORCLPDB1, tasks.max=1, database.history.kafka.topic=schema-changes.inventory, database.history.kafka.bootstrap.servers=kafka:9092, database.server.name=server1, database.port=1521, database.hostname=localhost, database.password=********, name=inventory-connector} with user '[database.user,null,[],[],true]'   [io.debezium.connector.oracle.OracleConnector]
java.lang.RuntimeException: Failed to resolve Oracle database version
	at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:166)
	at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:76)
	at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:71)
	at io.debezium.connector.oracle.OracleConnector.validateConnection(OracleConnector.java:74)
	at io.debezium.connector.common.RelationalBaseSourceConnector.validate(RelationalBaseSourceConnector.java:54)
	at org.apache.kafka.connect.runtime.AbstractHerder.validateConnectorConfig(AbstractHerder.java:459)
	at org.apache.kafka.connect.runtime.AbstractHerder.lambda$validateConnectorConfig$2(AbstractHerder.java:362)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=gC+n0l6ERmiSNPb0f2P97A==)
	at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:870)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:675)
	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
	at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$0(JdbcConnection.java:191)
	at io.debezium.jdbc.JdbcConnection$ConnectionFactoryDecorator.connect(JdbcConnection.java:128)
	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:882)
	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:877)
	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:630)
	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:504)
	at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:136)
	... 11 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection (CONNECTION_ID=gC+n0l6ERmiSNPb0f2P97A==)
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:594)
	at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:565)
	at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:937)
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:346)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1967)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:640)
	... 24 more
Caused by: java.io.IOException: Connection refused, socket connect lapse 0 ms. 127.0.0.1 1521  0 (1/1) true
	at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:421)
	at oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:303)
	at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:265)
	at oracle.net.nt.ConnOption.connect(ConnOption.java:229)
	at oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:814)
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:555)
	... 29 more
Caused by: java.net.ConnectException: Connection refused
	at java.base/sun.nio.ch.Net.connect0(Native Method)
	at java.base/sun.nio.ch.Net.connect(Net.java:483)
	at java.base/sun.nio.ch.Net.connect(Net.java:472)
	at java.base/sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:692)
	at java.base/java.nio.channels.SocketChannel.open(SocketChannel.java:194)
	at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:184)
	at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:158)
	at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:380)
	... 34 more