Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
91 views

UCMDB Support Tip: Problems installing Configuration Manager 10.01 on an Oracle 11gR2 database

Hello All,

 

We have come across an issue with installing Configuration Manager 10.01 on an Oracle 11gR2 database. During startup of a Configuration Manager 10.01 server connected to an Oracle 11gR2 (11.2.0.2.0) Database , the following error could be seen in the error.log:

 

Can't execute statement [create index IX1_CDM_LIST_ATTR_1322511440 on CDM_LIST_ATTR_PRI_1907570472(PATH, ATTR_VALUE, ATTR_NAME, CMDB_ID)], due to exception: java.sql.SQLException: [mercury][Oracle JDBC Driver][Oracle]ORA-01450: maximum key length (6398) exceeded

 

An 8K block was used for the index.

 

The root cause for this issue is that the maximum value of the index corresponding to the 8K block used is 3218, and not  6398 as it could be seen in the logs. This is caused by an Oracle bug that is detailed in the following link: http://www.oracle-ckpt.com/index-failed-to-create-with-ora-01450/

 

The solution is to upgrade the Oracle 11gR2 (11.2.0.2.0) Database to version 11.2.0.3.

 

regards,

Irina

 
“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

Click the KUDOS star on the left to say 'Thanks'
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.