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

今天一套测试环境用户使用过程中报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!

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值