Friday, May 27, 2011
DBCHECKORA
After upgrading to Oracle 11.2.0.2, we may want to update the PROF COMPATIBLE
parameter in DB02 or ST04.
I got an error
ORA-00942: table or view does not exist.
The table references was sap_dbcheckora_sap.
According to SAP Note 1397834 - DBACOCKPIT: ORA-00942 when changing "Check Conditions", we can implement this note, or upgrade to 7.01 SPS06.
The system I was working in is on SPS05 at the moment.
How about SQL?
The following query worked too.
update sapecc.DBCHECKORA set CHKVAL='11.2.0' where PARAM='COMPATIBLE' and CHKVAL='10.2.0';
1 row updated.
commit;
After commit, ST04 shows the new parameter value.
