Oracle设置"export ORA_NCHAR_LITERAL_REPLACE=true"导致dbca报错ORA-24450: Cannot pre-process OCI statement
Oracle设置"export ORA_NCHAR_LITERAL_REPLACE=true"导致dbca报错ORA-24450: Cannot pre-process OCI statement
问题如题。
11.2.0.4.0。
关于环境变量ORA_NCHAR_LITERAL_REPLACE的作用，可参考另外一篇博文：Oracle nvarchar2存储特殊字符乱码问题
以前dbca很多次，现在遇到了过程中会报错ORA-24450的问题，不敢随意忽略怕造成不可预知的后果。
遇到第一没头绪就先百度，没有跟dbca相关的结果。
第二mos查找，一样没结果。
oerr查看描述：
[oracle@db01 ~]$ oerr ora 24450 24450, 00000, "Cannot pre-process OCI statement" // *Cause: An error occured during statement pre-processing. // E.g., SQL statement has invalid usage of N' or Q' literals. // *Action: Correct the SQL statement. //
其中，E.g., SQL statement has invalid usage of N' or Q' literals.的描述让我想起这个参数，尝试先取消掉ORA_NCHAR_LITERAL_REPLACE配置后，重新dbca，顺利跑完。
防爬虫：https://www.cnblogs.com/PiscesCanon/p/17269753.html
补充：
在19.19版本中，在ORA_NCHAR_LITERAL_REPLACE=TRUE情况下，dbca使用Custom Database，则报错如下：
根据'PLS-00103: Encountered the symbol “USERENV” when expecting one of the following * & = – + ; ' During Database Upgrade to 12.1 (文档 ID 2224806.1)就是因为该参数的问题。
若是使用模板，在ORA_NCHAR_LITERAL_REPLACE=TRUE情况下，比如OEM13.5的19.11模板，则会导致应用RU.x(x>3)失败出问题，
（即datapatch -verbose，而dbca过程也会调用datapatch -verbose）
11:27:39 SYS@oemdb(387)> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDL -------------------- --------------- --------- ------------------------- ---------- ------------------------------------------------------------ ----- BOOTSTRAP DATAPATCH 19 RDBMS_19.11.0.0.0DBRU_LINUX.X64_210412 2021-04-23 17:36:01 RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update - 190410122720 2023-05-08 11:01:37 jvmpsu.sql SERVER 19.11.0.0.210420OJVMRU 0 RAN jvmpsu.sql 2023-05-08 11:01:37 APPLY SERVER 19.11.0.0.210420OJVMRU 0 OJVM RU post-install 2023-05-08 11:09:26 RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.3.0.0.0 to 19.11.0.0.0: Release_Update - 210413004009 2023-05-08 11:19:00 jvmpsu.sql SERVER 19.11.0.0.210420OJVMRU 0 RAN jvmpsu.sql 2023-05-08 11:19:00 APPLY SERVER 19.11.0.0.210420OJVMRU 0 OJVM RU post-install 2023-05-08 11:24:38 RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.11.0.0.0: Release_Update - 210413004009 8 rows selected. Elapsed: 00:00:00.01 11:27:44 SYS@oemdb(387)> select to_char(action_time,'yyyy-mm-dd hh24:mi:ss') action_time,patch_id,patch_type,status,description from dba_registry_sqlpatch order by action_time; ACTION_TIME PATCH_ID PATCH_TYPE STATUS DESCRIPTION -------------------- ---------- ---------- ------------------------- ---------------------------------------------------------------------------------------------------- 2021-04-23 17:36:27 29517242 RU SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 2023-05-08 11:18:28 32399816 INTERIM WITH ERRORS (PREV PATCH) OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816) 2023-05-08 11:18:28 32545013 RU WITH ERRORS (RETRYABLE) Database Release Update : 19.11.0.0.210420 (32545013) 2023-05-08 11:25:04 32399816 INTERIM SUCCESS OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816) 2023-05-08 11:25:04 32545013 RU SUCCESS Database Release Update : 19.11.0.0.210420 (32545013) Elapsed: 00:00:00.00
从datapatch -verbose看，
[oracle@oem13c 35050341]$ datapatch -verbose SQL Patching tool version 19.19.0.0.0 Production on Mon May 8 11:51:31 2023 Copyright (c) 2012, 2023, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_22430_2023_05_08_11_51_31/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Note: Datapatch will only apply or rollback SQL fixes for PDBs that are in an open state, no patches will be applied to closed PDBs. Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation (Doc ID 1585822.1) Bootstrapping registry and package to current versions...done Determining current state...done Current state of interim SQL patches: Interim patch 32399816 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)): Binary registry: Not installed PDB CDB$ROOT: Applied successfully on 2023-05-08 11:25:04 PDB EMPDBREPOS: Applied successfully on 2023-05-08 11:18:58 PDB PDB$SEED: Applied successfully on 2023-05-08 11:18:43 Interim patch 35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)): Binary registry: Installed PDB CDB$ROOT: Not installed PDB EMPDBREPOS: Not installed PDB PDB$SEED: Not installed Current state of release update SQL patches: Binary registry: 19.19.0.0.0 Release_Update 230322020406: Installed PDB CDB$ROOT: Applied 19.11.0.0.0 Release_Update 210413004009 successfully on 2023-05-08 11:25:04 PDB EMPDBREPOS: Applied 19.11.0.0.0 Release_Update 210413004009 successfully on 2023-05-08 11:18:58 PDB PDB$SEED: Applied 19.11.0.0.0 Release_Update 210413004009 successfully on 2023-05-08 11:18:43 Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED EMPDBREPOS The following interim patches will be rolled back: 32399816 (OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)) Patch 35042068 (Database Release Update : 19.19.0.0.230418 (35042068)): Apply from 19.11.0.0.0 Release_Update 210413004009 to 19.19.0.0.0 Release_Update 230322020406 The following interim patches will be applied: 35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)) Installing patches... Patch installation complete. Total patches installed: 9 Validating logfiles...done Patch 32399816 rollback (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32399816/24099425/32399816_rollback_OEMDB_CDBROOT_2023May08_11_52_22.log (no errors) Patch 35042068 apply (pdb CDB$ROOT): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_CDBROOT_2023May08_11_53_31.log (errors) -> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6848: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7290: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7597: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7763: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7785: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7795: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7806: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7817: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7828: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7839: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7850: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7861: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7872: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7883: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7894: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7905: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7916: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7927: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7938: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7949: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7960: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7971: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7982: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7993: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8004: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8015: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8026: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8037: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8048: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8059: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8070: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8081: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 154569: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154580: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154591: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154602: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154613: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154624: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154635: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154646: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154657: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154668: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb CDB$ROOT): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_CDBROOT_2023May08_11_53_30.log (no errors) Patch 32399816 rollback (pdb PDB$SEED): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32399816/24099425/32399816_rollback_OEMDB_PDBSEED_2023May08_11_59_34.log (no errors) Patch 35042068 apply (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_PDBSEED_2023May08_12_00_02.log (errors) -> Error at line 6276: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6545: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6986: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7265: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7430: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7450: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7459: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7469: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7479: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7489: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7499: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7509: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7519: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7529: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7539: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7549: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7559: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7569: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7579: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7589: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7599: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7609: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7619: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7629: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7639: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7649: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7659: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7669: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7679: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7689: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7699: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7709: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7719: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 144564: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144574: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144584: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144594: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144604: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144614: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144624: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144634: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144644: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144654: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb PDB$SEED): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_PDBSEED_2023May08_12_00_02.log (no errors) Patch 32399816 rollback (pdb EMPDBREPOS): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32399816/24099425/32399816_rollback_OEMDB_EMPDBREPOS_2023May08_11_59_34.log (no errors) Patch 35042068 apply (pdb EMPDBREPOS): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_EMPDBREPOS_2023May08_12_00_01.log (errors) -> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6848: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7290: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7597: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7763: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7785: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7795: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7806: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7817: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7828: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7839: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7850: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7861: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7872: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7883: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7894: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7905: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7916: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7927: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7938: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7949: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7960: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7971: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7982: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7993: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8004: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8015: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8026: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8037: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8048: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8059: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8070: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 8081: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 154562: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154573: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154584: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154595: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154606: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154617: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154628: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154639: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154650: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 154661: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb EMPDBREPOS): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_EMPDBREPOS_2023May08_12_00_01.log (no errors) Adding patches to retry installation queue...done Retry installation queue: For the following PDBs: CDB$ROOT PDB$SEED EMPDBREPOS No interim patches need to be rolled back Patch 35042068 (Database Release Update : 19.19.0.0.230418 (35042068)): Apply from 19.11.0.0.0 Release_Update 210413004009 to 19.19.0.0.0 Release_Update 230322020406 The following interim patches will be applied: 35050341 (OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)) Installing patches... Patch installation complete. Total patches installed: 6 Validating logfiles...done Patch 35042068 apply (pdb CDB$ROOT): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_CDBROOT_2023May08_12_04_42.log (errors) -> Error at line 6318: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6332: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6342: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6352: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6362: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6372: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6382: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6392: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6402: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6412: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6422: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6432: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6442: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6452: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6462: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6482: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6502: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6512: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6522: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6532: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6542: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6562: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6572: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6587: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7028: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7042: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7052: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7062: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7072: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7082: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7092: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7102: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7112: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7122: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7132: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7142: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7152: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7162: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7172: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7182: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7192: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7202: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7212: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7222: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7232: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7242: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7252: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7262: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7272: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7282: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7292: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7307: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7501: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7511: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7521: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7531: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7541: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7551: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7561: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7571: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7581: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7591: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7601: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7611: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7621: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7631: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7641: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7651: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7661: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7671: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7681: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7691: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7701: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7711: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7721: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7731: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7741: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7751: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7761: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 144669: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144679: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144689: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144699: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144709: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144719: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144729: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144739: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144749: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144759: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb CDB$ROOT): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_CDBROOT_2023May08_12_04_42.log (no errors) Patch 35042068 apply (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_PDBSEED_2023May08_12_09_35.log (errors) -> Error at line 6318: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6332: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6342: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6352: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6362: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6372: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6382: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6392: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6402: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6412: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6422: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6432: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6442: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6452: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6462: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6482: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6502: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6512: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6522: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6532: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6542: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6562: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6572: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6587: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7028: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7042: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7052: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7062: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7072: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7082: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7092: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7102: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7112: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7122: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7132: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7142: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7152: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7162: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7172: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7182: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7192: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7202: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7212: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7222: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7232: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7242: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7252: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7262: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7272: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7282: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7292: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7307: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7501: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7511: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7521: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7531: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7541: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7551: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7561: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7571: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7581: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7591: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7601: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7611: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7621: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7631: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7641: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7651: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7661: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7671: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7681: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7691: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7701: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7711: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7721: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7731: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7741: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7751: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7761: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 144662: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144672: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144682: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144692: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144702: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144712: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144722: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144732: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144742: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144752: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb PDB$SEED): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_PDBSEED_2023May08_12_09_35.log (no errors) Patch 35042068 apply (pdb EMPDBREPOS): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35042068/25183678/35042068_apply_OEMDB_EMPDBREPOS_2023May08_12_09_36.log (errors) -> Error at line 6318: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6332: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6342: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6352: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6362: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6372: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6382: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6392: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6402: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6412: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6422: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6432: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6442: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6452: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6462: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6482: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6502: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6512: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6522: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6532: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6542: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6562: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6572: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 6587: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7028: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7042: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7052: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7062: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7072: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7082: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7092: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7102: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7112: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7122: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7132: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7142: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7152: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7162: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7172: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7182: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7192: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7202: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7212: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7222: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7232: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7242: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7252: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7262: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7272: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7282: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7292: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7307: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7472: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7492: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7501: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7511: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7521: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7531: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7541: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7551: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7561: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7571: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7581: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7591: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7601: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7611: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7621: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7631: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7641: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7651: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7661: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7671: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7681: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7691: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7701: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7711: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7721: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7731: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7741: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7751: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7761: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 144662: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144672: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144682: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144692: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144702: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144712: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144722: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144732: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144742: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms -> Error at line 144752: script rdbms/admin/catcheckviews.sql - ORA-01775: looping chain of synonyms Patch 35050341 apply (pdb EMPDBREPOS): WITH ERRORS (PREV PATCH) logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35050341/25148755/35050341_apply_OEMDB_EMPDBREPOS_2023May08_12_09_35.log (no errors) Automatic recompilation incomplete; run utlrp.sql to revalidate. PDBs: CDB$ROOT EMPDBREPOS PDB$SEED Please refer to MOS Note 1609718.1 and/or the invocation log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_22430_2023_05_08_11_51_31/sqlpatch_invocation.log for information on how to resolve the above errors. SQL Patching tool complete on Mon May 8 12:13:59 2023
因为会导致DBA_EDITION_INHERITED_OBJECTS只有同义词却没有表，
12:31:46 SYS@oemdb(255)> select owner ,object_name,object_type,status from dba_objects where object_name like '%DBA_EDITION_INHERITED_OBJECTS%' ; OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ----------------------------------- ----------------------- ------- PUBLIC DBA_EDITION_INHERITED_OBJECTS SYNONYM VALID
所以上边的datapatch内容才会大量报错
-> Error at line 6552: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 6848: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7290: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 104, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7597: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms -> Error at line 7763: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-06550: line 100, column 17: - PLS-00103: Encountered the symbol "_" when expecting one of the following: - * & = - + ; < / > at in is mod remainder not rem - <an exponent (**)> <> or != or ~= >= <= <> and or like like2 - like4 likec between || multiset member submultiset -> Error at line 7785: script rdbms/admin/backport_files/bug_17777718_apply.sql - ORA-01775: looping chain of synonyms
从PLS-00103看像语法错误，导致无法创建表DBA_EDITION_INHERITED_OBJECTS。
