[
https://issues.apache.org/jira/browse/FLINK-35503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhongqiang Gong updated FLINK-35503:
------------------------------------
Issue Type: Improvement (was: Bug)
> 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: Improvement
> 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
> Assignee: Zhongqiang Gong
> Priority: Blocker
> Labels: pull-request-available
> 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)
