< ORA-00600: internal error code, arguments: [kkdlron-max-objid], [4254950911], [4254950914], [], [], [], [], [], [], [], [], [] < ORA-00600: internal error code, arguments: [kewrose_1], [600]
You will get the max object id by running below commands.
SQL> select max(obj#) from SYS.obj$;
MAX(OBJ#)
----------
4254909633
SQL> SELECT dataobj# FROM sys.obj$ where name='_NEXT_OBJECT';
SQL> select max(object_id),max(DATA_OBJECT_ID) from dba_objects ;
Oracle Support Document 20529650.8 (Bug 20529650 - ORA-600 [kkdlron-max-objid], [4254950911]) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=20529650.8
Also check SAP note : 2137109 - Data Object ID limit , if you see the issue on SAP related applications.
I see 2 options here
1. Logically rebuild the DB - Permanent fix
2. Apply the patch 20529650 - workaround/temporary fix
The option 2 applying the patch will brings us the new limit 4293950911 (4254950911+39000000). But keep in mind that this new limit can reach quickly in BW systems. Note that the patch will give team some time but the permanent solution is to rebuilding the database.
You can use below query to estimate how much time you might have , but note that this is just an estimate only.
Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
Candidates, who have successfully submitted the BSTC 2019 Online Form will be able to download Rajasthan BSTC Admit Card 2019 download.
ReplyDeleteSarkari Jobs 2019. Get Sarkari Job notification regarding central and state Sarkari Job of this week and its Latest Sarkari Jobs 2019 news across various sectors like Banking, Teaching Naukari, Defense, Universities and schools, Railway Sarkari Job 2019, Financial Institutions, Government Jobs 2018, SSC, UPSC, Agriculture and many more.
ReplyDeleteA befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
A bewildering web journal I visit this blog, it's unfathomably heavenly. Oddly, in this present blog's substance made purpose of actuality and reasonable. The substance of data is informative
ReplyDeleteA befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
ReplyDeleteشركة غسيل خزانات بمكة شركة غسيل خزانات بمكة
شركة غسيل خزانات بجدة شركة غسيل خزانات بجدة
شركة غسيل خزانات بالدمام شركة غسيل خزانات بالدمام
Great Article Artificial Intelligence Projects
ReplyDeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
kobe byrant shoes
ReplyDeleteyeezy
jordan sneakers
bape clothing
stephen curry shoes
jordan shoes
supreme clothing
yeezy supply
air jordan
supreme