Oracle internals, debugging and undocumented features
Two weeks ago I was trying to install OEM grid control version 11 .I did it many times already but this time my process failed in the middle of install.
After digging numerous number of install logs I have found message like one bellow:
HealthMonitor Jan 26, 2011 5:39:44 PM OMS Heartbeat Recorder: error: Could not get id: java.sql.SQLException: Oracle Error ORA-12650
Critical error err=3 detected in module OMS Heartbeat Recorder:
Quick search turn out that ORA-12650 No common encryption or data integrity algorithm is error related to Oracle Advanced Security Option.
Then I realized that have ASO enabled on datatabase which will be used as OEM respository.
My sqlnet.ora looks something like this:
/* ASO Encryption */
SQLNET.CRYPTO_SEED = “-blablablablablabla”
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER = (RC4_256)
SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_256)
/* ASO Checksumm */
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)
After taking this part from sqlnet.ora file my install finished successfully.
It sounds easy but it took me some time to dig all install logs and find the cause..