This content has been marked as final. Show 6 replies
The problem here is that you're also upgrading from an XE version, which doesn't appear to support 10g XE.
Upgrading Oracle Express Edition XE to 11g (11.2) using DBUA
You have not mentioned the full version of your XE database. If it is 10.2.0.1, you cannot directly upgrade it to 11.2 using >DBUA. You have to first upgrade it atleast to 10.2.0.2 before going to 11.2.In which case, I would look into other options, such as Oracle's Data Pump.
Please refer to Metalink Notes 980693.1 and 837570.1 for more details.
Since you've purchased license, I would assume you also have Support contract. If you've followed the relevant Upgrade guide and something does not work per procedure, then call Support / open SR via MOS.
As 10g XE is very small (max 4GB, I think) you might consider importing the relevant data in a new, clean 11.2 database instead of "direct" upgrade. Consult Primavera documentation of course, for details and if such a "move" is supported.
1008016 wrote:To upgrade to 11gR2, you need to be at 10.2.0.2 - hence the error
Windows 7 64 bit, please find the below error message when I am trying to upgrade through Database Upgrade Assistant
"Could not get database version from the "oracle server" component.The "CEP" file "D:\app\usr\product\11.2.0\dbhome_1\rdbms\admin\rdbmsup.sql" does not provide the version directive
11gR2 DBUA States "The CEP File does not provide the version directive" [ID 980693.1]
As noted by orafad, the easiest approach would be to perform a full export from 10gR2, install 11gR2 into a new ORACLE_HOME, create an empty 11gR2 database, then perform a full import into 11gR2. As also noted, you will have to follow any special directions related to Primavera.
You will need Win 7 Professional or higher (Home versions are not supported for Oracle installs)