Summary
Error
After upgrading to Service Manager (SM) 9.33 on server and trying to connect to DB verifying the DB connection fails.
Error as seen via command line:
E:\HP\Service Manager 9.30\Server\RUN>sm -sqlverifyconnection
Failed to connect to RDBMS server, terminating.
Error as seen in sm.log:
2988( 5852) 01/27/2014 08:40:34 RTE I Command line: sm -sqlverifyconnection
2988( 5852) 01/27/2014 08:40:34 RTE I Connection to dbtype 'oracle10' Oracle server 'DOWNTOWN' as user 'SM933' successful
2988( 5852) 01/27/2014 08:40:34 RTE I Connected to Oracle Version 10.2.0.1.0
2988( 5852) 01/27/2014 08:40:34 RTE I Oracle Client version: 11.2.0.1.0
2988( 5852) 01/27/2014 08:40:34 RTE E Detected an unsupported version of Oracle Server. To override this please enable the parameter [allowunsupporteddbversion] and restart Service Manager to continue.
2988( 5852) 01/27/2014 08:40:34 RTE E Service Manager will be terminated.
2988( 5852) 01/27/2014 08:40:34 RTE E Please check Service Manager compatibility matrix and upgrade your Oracle software.
2988( 5852) 01/27/2014 08:40:34 RTE E Oracle version incompatible between Server and Client, Never try to reconnect Oracle
Cause
The DB version is not mentioned in the compatibility matrix.
Fix
Quick temporary solution add the following parameter to the sm.ini file:
allowunsupporteddbversion:1
NOTE you will still see like the one below in the sm.log but it will not prevent SM from working.
4888( 2060) 01/27/2014 09:36:51 RTE E Detected an unsupported version of Oracle Server.
4888( 2060) 01/27/2014 09:36:51 RTE E Please check Service Manager compatibility matrix and upgrade your Oracle software.
Permanent solution:
Upgrade the oracle DB to a supported version.
NOTE the oracle client software needs to be upgraded to the same level as the DB.