Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle 12.1 Business users use the sequence Times ORA-600 to cause the business not to proceed normally.

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Operating environment:

OS:HPUX 11.31

GI:12.1.0.2

DB:12.1.0.2

PSU: no PSU applied

Architecture: RAC+ADG

I received a phone call from a colleague at 23:00 on the evening of August 11, reporting back to a certain credit system to query the sequence Times ORA-600.

First of all, the sequence belongs to the business user, if the sequence state is normal, it should be a program problem, if the sequence state is not normal, it should be the problem of the database layer.

Second, the system has been online for two years, there has been no similar problem before, whether the application has changed recently (the most recent change to the database is the creation of new tablespaces and users, confirmation has nothing to do with this error report).

Execution in the program

Select seq_crd.nextval from dual

Database log error:

ORA-00600: internal error code, arguments: [kdnpart:partition], []

Included in trc

KdnAllocN

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report