19c 导入导出问题处理ORA-00600 [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number]

** 数据库版本：
19.7 使用容器数据库。
平台：
Asianux linux 7.3**

一、数据泵问题

导出测试语句：

expdp bkpdbadmin/test@bk directory=BACK2 dumpfile=expdp_user_20210226.dmp logfile=expdp_user_20210226.log schemas=test cluster=N CONTENT=METADATA_ONLY
复制

数据泵导出导入会报如下错误：

ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT__INT", line 2144
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2081
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1
复制

alert日志里会有如下的600错误，从报错来看像是19c导出使用到服务别名，DBMS_DATAPUMP传入变量导致:

Errors in file /oracle/app/oracle/diag/rdbms/cdbcs/cdbcs2/trace/cdbcs2_ora_59780.trc  (incident=452420) (PDBNAME=BKPDB):
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [**ORA-01036: illegal variable name/number**
], [], [], [], [], [], [], [], [], []
BKPDB(5):Incident details in: /oracle/app/oracle/diag/rdbms/cdbcs/cdbcs2/incident/incdir_452420/cdbcs2_ora_59780_i452420.trc
2021-03-01T11:25:32.664654+08:00
BAOKANPDB(5):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/cdbcs/cdbcs2/trace/cdbcs2_ora_59780.trc  (incident=452421) (PDBNAME=BAOKANPDB):
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []
BAOKANPDB(5):Incident details in: /oracle/app/oracle/diag/rdbms/cdbcs/cdbcs2/incident/incdir_452421/cdbcs2_ora_59780_i452421.trc
2021-03-01T11:25:33.027127+08:00
Dumping diagnostic data in directory=[cdmp_20210301112533], requested by (instance=2, osid=59780), summary=[incident=452420].
2021-03-01T11:25:35.836972+08:00
BAOKANPDB(5):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2021-03-01T11:25:36.219868+08:00
Dumping diagnostic data in directory=[cdmp_20210301112536], requested by (instance=2, osid=59780), summary=[incident=452421].
2021-03-01T11:48:33.951075+08:00

复制

通过查询MOS未发现有相关的文章，在数据库上进行测试，1节点可以正常导出，2节点导出出现报错现象。无意中发现两个节点PSU号不一致，1节点19.7，2节点19.3。怀疑是2节点补丁应用有问题，重新rollback PSU，再重新打上补丁问题解决。

二、补丁问题

打补丁的过程中遇到如下问题:
执行rollback命令，会出现perl的问题。

#/oracle/app/oracle/product/19c/db/OPatch/opatchauto rollback /opt/30899722/30869156 -oh /oracle/app/oracle/product/19c/db

OPatchauto session is initiated at Mon Mar  1 16:28:31 2021

System initialization log file is /oracle/app/oracle/product/19c/db/cfgtoollogs/opatchautodb/systemconfig2021-03-01_04-28-35PM.log.

Can't locate Cwd.pm:   /root/perl5/lib/perl5/Cwd.pm: (null) at /oracle/app/oracle/product/19c/db/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.
BEGIN failed--compilation aborted at /oracle/app/oracle/product/19c/db/OPatch/auto/database/bin/RemoteHostExecutor.pl line 2.

OPATCHAUTO-72050: 未能创建系统实例。
OPATCHAUTO-72050: 检索系统信息时失败。
OPATCHAUTO-72050: 请查看日志文件, 以了解更多详细信息。

OPatchauto session completed at Mon Mar  1 16:28:37 2021
Time taken to complete the session 0 minute, 6 seconds

Topology creation failed.
复制

报错解决办法，执行下面的语句即可：
export PERL5LIB=/oracle/app/oracle/product/19c/db/perl/lib/5.28.1/x86_64-linux-thread-multi/