Database Upgrade to 10.2.0.4
Using Windows 2003 64-bit, 10.2.0.3 Standard Edition.
I clone the database to a spare server, shut it down immediate, and stopped all Oracle services. I installed the 10.2.0.4 patchset into the original Oracle Home without a problem. I then ran the Database Upgrade Assistant and it ran through to completion. However, it did declare a series of errors when upgrading the 'Data Mining' component:
Error ignored: ORA-29831: operator binding not found ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_FILTER'
...and others like it. The report at the end of the process is saying the Oracle Server component is 'Successful *' -and the asterisk links to a list of the errors that I clicked 'ignore' to during the process. The one for 'data mining' says 'Skipped'.
I don't think I mind the errors about Data Mining, because as far as I know, we don't use that (are we even allowed to on an SE license?) When I look in V$OPTION, for example, we get:
OLAP Window Functions TRUE
Block Media Recovery FALSE
Fine-grained Auditing FALSE
Application Role FALSE
Enterprise User Security FALSE
Oracle Data Guard FALSE
Oracle Label Security FALSE
OLAP FALSE
Table compression FALSE
Join index FALSE
Trial Recovery FALSE
Data Mining FALSE
Online Redefinition FALSE
Streams Capture FALSE
File Mapping FALSE
So my question is: did the upgrade work properly or not?! Should I mind that the errors appeared when upgrading a component that doesn't even exist, as far as I know? Is there some way of knowing that all is as it should be?
I have logged onto the database after the upgrade and all looks fine, with queries working as expected and so on. But I just have a nagging doubt...