Saketh Kurnool created FLINK-35503:
--------------------------------------
Summary: OracleE2eITCase fails with error ORA-12528 on Mac M2
Key: FLINK-35503
URL: https://issues.apache.org/jira/browse/FLINK-35503
Project: Flink
Issue Type: Bug
Components: Flink CDC
Affects Versions: cdc-3.1.0
Environment:
* Mac M2 (Apple Silicon)
* using docker desktop with Rosetta enabled for amd64 emulation
Reporter: Saketh Kurnool
Attachments: com.ververica.cdc.connectors.tests.OracleE2eITCase.txt,
oracle-docker-setup-logs.txt
Hello Flink CDC community,
I am attempting to run `OracleE2eITCase` (in the cdc source connector e2e
tests), and I am running into the following runtime exception:
{code:java}
java.sql.SQLException:
Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
at
oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at
com.ververica.cdc.connectors.tests.OracleE2eITCase.getOracleJdbcConnection(OracleE2eITCase.java:197)
at
com.ververica.cdc.connectors.tests.OracleE2eITCase.testOracleCDC(OracleE2eITCase.java:149)
at java.base/java.lang.reflect.Method.invoke(Method.java:567)
at
org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45)
at
org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:29)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the
following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
... 11 more{code}
I have attached the test results to this issue.
`OracleE2eITCase` runs the `goodboy008/oracle-19.3.0-ee:non-cdb` docker image.
I am able to reproduce the same issue when I run this docker image locally - my
observation is that dockerized Oracle DB instance is not being set up properly,
as I notice another ORA in the setup logs (`ORA-03113: end-of-file on
communication channel`). I have also attached the logs from the docker image
setup to this issue. To reproduce the ORA-12528 issue locally, I:
* ran: `docker run goodboy008/oracle-19.3.0-ee:non-cdb`
* ssh'ed into the db pod
* ran: `sqlplus sys/top_secret@//localhost:1521/ORCLCDB as sysdba`
Any insight/workaround on getting this e2e test and the docker image running on
my machine would be much appreciated. I'm also happy to provide any other
information regarding my setup in the comments. Thank you!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
