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,顺利跑完。
- ORA_NCHAR_LITERAL_REPLACE quot pre-process ORA statementora_nchar_literal_replace quot pre-process ora ora_nchar_literal_replace bindingexception quot exception statement hospitalsetmapper quot mybatis-plus statement quot at_os_opt_sy ora database pre-process statement statements statement executing password before ora