on 06-19-2011 11:33 AM
I have just updated my MDM production database from 10.2.0.2 to 10.2.0.4.Everything went right but after running the catupgrd.sql script , I got the output as
OLAP Analytic Workspace OPTION OFF 10.2.0.2.0 00:00:00
OLAP Catalog OPTION OFF 10.2.0.2.0 00:00:00
Oracle OLAP API OPTION OFF 10.2.0.2.0 00:00:00
Rest have the version 10.2.0.4.
When I fired the command:
SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
OLAP Analytic Workspace
10.2.0.2.0 OPTION OFF
Oracle OLAP API
10.2.0.2.0 OPTION OFF
OLAP Catalog
10.2.0.2.0 OPTION OFF
Can anybody tell me its effect?
Thanks,
Riya Sarkar
Hi Riya
You can ignore it. For more information read below blog.
http://kkempf.wordpress.com/category/oracle/page/3/
Regards,
Nirav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>> OLAP Analytic Workspace
>> 10.2.0.2.0 OPTION OFF
>> Oracle OLAP API
>> 10.2.0.2.0 OPTION OFF
>> OLAP Catalog
>> 10.2.0.2.0 OPTION OFF
Hi Riya,
It means that these components are not supported by your database edition. After the upgrade they will remain at the original version and not been patched. As far as I know that they are not necessary for the MDM product.
Consequently, you should't face with a side effect, if you do not specially use these components.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.