OID 11g Bulkload of Large Amount (Several Millions) of Entries Fails Initially with ORA-12592, Later with ORA-39776 and ORA-00600: internal error code, arguments: [klaprs_<##>], Finally with ORA-03135 and ORA-03114
(Doc ID 2091301.1)
Last updated on SEPTEMBER 03, 2024
Applies to:
Oracle Internet Directory - Version 11.1.1 and laterInformation in this document applies to any platform.
Symptoms
Oracle Internet Directory (OID) 11g, e.g., 11.1.1.7.0.
OID bulk load of millions of entries using Document 579529.1 fails:
*Error in loading data for "attr_store001"
For more details, refer bulkload.log*
As indicated above, there were errors during the load of data. This will leave the OID directory content in inconsistent state.
Hence, it is highly recommended that you use the bulkload -recover option to restore the OID directory content to the pre-bulkload state.
If you choose not to use the recover option of bulkload now, then you must restore the OID Database from a backup taken prior to this bulkload invocation so that the Directory content is restored to the pre-bulkload state.
Similar bulkload worked several times in previous environments configured the same way.
Initially there were no errors in the bulkload logs or files (other than a typical "Attribute pwdchangedtime is single valued", but can be skipped/ignored and do not cause problems and worked in previous successful bulkloads.)
Later on bulkload fails for a few different entries, for example, in bsl_attr_store<number>.log bulkload logs:
ORA-12592: TNS:bad packet
SQL*Loader-926: OCI error while uldlfca: last loaded row is bigger than the column array size for table DS_ATTRSTORE
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
After identifying and removing the few problem entries from the ldif file and retrying, bulkload now returns a different error, for example:
bsl_attr_store001.log: ORA-00600: internal error code, arguments: [klaprs_11], [60], [115], [45030627], [], [], [], [], [], [], [], []
bsl_attr_store006.log: ORA-00600: internal error code, arguments: [klaprs_11], [60], [36], [14538110], [], [], [], [], [], [], [], []
bsl_orclsecondaryuid.log: ORA-00600: internal error code, arguments: [klaprs_12], [110], [60], [15979905], [], [], [], [], [], [], [], []
As the bulkload.log also shows the following message:
Searching the root oraclecontext shows the default attributes, as after the initial install, as follows:
Changes
Tried modifying root oraclecontext base attribute values to match ldif file to be bulkloaded, which resolved the ORA-600 but results in new error ORA-03114 and unusable data and OID server.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |