使用flink cdc读取oracle19c日志报错:ORA-01031:权限不足

[LeatherMan-Mr-Li]

已按照教程开启日志和授权，抽取日志报错
`StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();

    Properties debezium = new Properties();
    debezium.setProperty("database.pdb.name", "PDBNAME");   //show pdbs;
    debezium.setProperty("database.dbname", "DBNAME");   //show pdbs;
    debezium.setProperty("snapshot.mode.configuration.based.snapshot.schema", String.valueOf(true));
    debezium.setProperty("snapshot.locking.mode","none");
    debezium.setProperty("database.tablename.case.insensitive", String.valueOf(false));
    debezium.setProperty("log.mining.strategy", "online_catalog");
    debezium.setProperty("snapshot.mode", "schema_only");
    SourceFunction<String> oracleSource = OracleSource.<String>builder()
            .url(url)
            .port(1521)
            .database(database)       // monitor XE database
            .schemaList(schemaList)   // monitor inventory schema
            .tableList(tableList)     // monitor products table
            .username(username)
            .password(password)
            .deserializer(new JsonDebeziumDeserializationSchema()) // converts SourceRecord to JSON String
            .debeziumProperties(debezium)
            .build();
    // use parallelism 1 for sink to keep message ordering
    env.addSource(oracleSource)
            .addSink(new CustomSink());
    env.execute();`

报错如下

`Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: 权限不足

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
at io.debezium.connector.oracle.OracleConnection.resetSessionToCdb(OracleConnection.java:102)
... 8 more

Caused by: Error : 1031, Position : 0, Sql = alter session set container=cdb$root, OriginalSql = alter session set container=cdb$root, Error Msg = ORA-01031: 权限不足

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 21 more`