bug in 10.2.0.5 support

[pioro]

Hi Marcin,

I recently added an Oracle 10.2.0.5 DB to OraSASH using adddb and got following error message:

BEGIN sash_pkg.configure_db('WOWO.wowo.int_10_91_2_30'); END;
*
ERROR at line 1:
ORA-20100: SASH configure_db error ORA-00904: "CUMULATIVE": invalid identifier
ORA-06512: at "SASH.SASH_PKG", line 21
ORA-06512: at line 1

Procedure sash_pkg.get_metrics(l_dblink); in sash_pkg.configure failed, because following select failed:

begin
EXECUTE IMMEDIATE 'insert into sash_osstat_name select distinct ' || L_DBID || ',OSSTAT_ID, STAT_NAME, COMMENTS, CUMULATIVE from sys.v_$osstat@'||V_DBLINK;
exception
WHEN DUP_VAL_ON_INDEX THEN
sash_repo.log_message('GET_METRICS', 'Already configured ?','W');
end;

Solution:
Columns COMMENTS and CUMULATIVE are not defined in Oracle 10 I temporarily changed the query to select nulls instead and everything was fine.

Regards

Ernst