Summary
Error
When trying to setup an SM 9.33 system with the new oracle setting we are running into issues.
In the sm.ini we have the below settings:
sqlupper:1
allowunsupporteddbversion:1
However the logs still show the below messages:
RTE E An unsupported version of Oracle cannot be used even when starting Service Manager with the parameter allowunsupporteddbversion:1 in conjunction with sqlupper:1
Cause
When checking the logs the below was showing:
9524( 9557) 02/28/2014 14:51:29 RTE I Connected to Oracle Version 11.2.0.3.0
9524( 9557) 02/28/2014 14:51:29 RTE I Oracle Client version: 11.2.0.1.0
The oracle client is cause of the message since this oracle client is not allowed anymore from 9.30 P5 onwards because of issues that this client does not read CLOB correctly.
Fix
Upgrade oracle client to the same level as server 11.2.0.3.0 and problem is fixed