< 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
Sarkari 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.
ReplyDeletekobe byrant shoes
ReplyDeleteyeezy
jordan sneakers
bape clothing
stephen curry shoes
jordan shoes
supreme clothing
yeezy supply
air jordan
supreme