| Issues with component--11.2.0.2 upgrade [message #477548] |
Fri, 01 October 2010 12:55  |
nadvi
Messages: 46
Registered: May 2006
Location: Canada
|
Member |
|
|
Hi,
I am testing upgrade from 11.1.0.6 to 11.2.0.2 patchset on linux X86-64 version. And facing the following component related issue.
The following components cannot be upgraded as the corresponding upgrade scripts are missing:
OLAP Analytic Workspace ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/apsdbmig.sql )
OLAP Catalog ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/amddbmig.sql )
Spatial ( /u01/app/oracle/product/11.2.0/dbhome_3/md/admin/sdodbmig.sql )
Oracle OLAP API ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/xoqdbmig.sql )
If you want to upgrade these components, you must first install them, using the OUI, and then re-run the Upgrade Assistant.
Do you want to continue with upgrade?
Note: If you continue, the above components will not be considered as part of the upgrade process.*
Following is the status of the specified components from 11.1.0.6
COMP_ID COMP_NAME VERSION STATUS
AMD OLAP Catalog 11.1.0.6.0 VALID
SDO Spatial 11.1.0.6.0 VALID
APS OLAP Analytic Workspace 11.1.0.6.0 VALID
Should I install these components while installing 11.2.0.2 patchset prior upgrading? I was unable to find any component installation on OUI.
Also DBUA pre-upgrade asked to remove existing UltraSearch from 11.1.0.6 prior upgrading. Though I removed it, but not sure is that going to hamper the upgraded DB, as I'm not sure of the usage of this component as well.
Can anyone shed some light on it.
Thanks.
[Updated on: Fri, 01 October 2010 12:59] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Issues with component--11.2.0.2 upgrade [message #477550 is a reply to message #477549] |
Fri, 01 October 2010 13:10  |
nadvi
Messages: 46
Registered: May 2006
Location: Canada
|
Member |
|
|
Hi Michel,
Thanks for your reply.
As per metalink note: ID 1189783.1
Quote:
"Because the release 11.2.0.2 patch set is a full installation package, if you are installing Oracle Database on a system without an existing Oracle Database installation, then you can simply install the release 11.2.0.2 patch set. You are no longer required to install the base release, and then apply the patch set."
So I was trying installing 11.2.0.2 first and upgrade.
Also, As you said, I tried with 11.2.0.1 and upgrade but still faced the component issues.
Any idea?
Thanks
[Updated on: Fri, 01 October 2010 13:12] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
