ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], []

本文介绍了一个ORA-00600内部错误的解决方案,该问题由ORA_NLS10环境变量设置不当引起。通过创建正确的9idata目录并确保ORA_NLS10指向该目录,可以避免此错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

今天一套测试环境用户使用过程中报ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], []
查看告警日志,很多ORA-00600.trace文件也没有可用信息。google发现问题在于ORA_NLS10环境变量

Summary


Errors in file /database/log/diag/rdbms/test/TEST/trace/TEST_ora_31964.trc  (incident=64585):
ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [], [], [], [], []

more details in the trace file...

select T.nls_territory from
fnd_territories_vl T, v$nls_valid_values V
where T.nls_territory = V.value
and V.parameter = 'TERRITORY';

ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [], [], [], [], []
 Cause: The error is raised when the environment variable ORA_NLS10 is set incorrectly or pointing to a wrong location.  Executing the query as APPS results to ora-00600select T.nls_territory from
fnd_territories_vl T, v$nls_valid_values V
where T.nls_territory = V.value
and V.parameter = 'TERRITORY';
 ORA_NLS10 should be set to $ORACLE_HOME/nls/data/9idata

Workaround:
For E-Business Suite 12 on 11gR2, see step 7 of Document 1058763.1

Create nls/data/9idata directory

On the database server node, as the owner of the Oracle RDBMS file system and database instance,  run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.1. cd $ORACLE_HOME/nls/data/
2. mv 9idata 9idata_old
3. perl $ORACLE_HOME/nls/data/old/cr9idata.pl
4. check new 9idata was created!

After creating the directory, make sure that the ORA_NLS10 environment variable is set
to the full path of the 9idata directory whenever you enable the 11g Oracle home.

5. Restart database and check the query again!

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值