ora2pg连接失败，但sqlplus正常

Question

我正在使用https://oracle-base.com/articles/19c/minimum-viable-oracle-database-19c-installation-on-ol8#download-software的设置:

sqlplus / as sysdba <<EOF
alter session set container=ORCLPDB1;
create user testuser1 identified by testuser1 quota unlimited on users;
grant connect, resource to testuser1;
exit;
EOF

使用以下命令成功登录DB:

sqlplus testuser1/testuser1@//localhost:1521/ORCLPDB1

但是这样设置一个ora2pg.conf文件:

ORACLE_DSN      dbi:Oracle:host=localhost;service_name=ORCLCDB;port=1521
ORACLE_USER     testuser1
ORACLE_PWD      testuser1

…我无法登录。我试过了

1. 改变DSN，它正确地说它根本找不到数据库;好
2. 修改service_name，显示不存在这样的服务;好
3. 尝试service_name=ORCLCDB(因为它出现在tnsnames.ora)和service_name=ORCLCDB1在ORACLE_DSN。ORCLCDB等待一点，然后失败;
ORCLCDB1快速失败

FATAL: 12514 ... ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

ora2pg.confdist版本的副本与DNS,用户和PWD改变。

任何想法?

Answer 1

您的可插入数据库的服务名称是ORCLPDB1，所以使用它代替CDB服务名称(ORCLCDB):

ORACLE_DSN      dbi:Oracle:host=localhost;service_name=ORCLPDB1;port=1521
ORACLE_USER     testuser1
ORACLE_PWD      testuser1