If you are unable to create a new account, please email support@bspsoftware.com

 

Content Database Migration - Oracle Enterprise to Standard [WORKAROUND]

Started by locus, 06 Jun 2016 06:11:27 AM

Previous topic - Next topic

locus

Hi Folks,

Due to various upgrades and streamlining of our IT infrastructure, the database server currently running CM for 8.4.1.0 is on Oracle 11 Enterprise Edition (EE),
and is moving to a new server running Standard Edition (SE) 12c.

We are getting errors during import relating to ORA-000439 which is an enabled feature in 11g EE.
In our case the 439 relates specifically to Bitmap indexing and Materialised View Rewrite.

Attached is a cap of part of the error.

What literature I have found states that this is 100% down to using SE and the function is only available on EE.

The move from SE to EE is in the thousands of Euro, and although we will get sign off, we need to ensure there is no way we can run CM on 12c SE.

Please anyone who has expertise on this come back to me asap.

Much appreciated,
Locus

MFGF

Quote from: locus on 06 Jun 2016 06:11:27 AM
Hi Folks,

Due to various upgrades and streamlining of our IT infrastructure, the database server currently running CM for 8.4.1.0 is on Oracle 11 Enterprise Edition (EE),
and is moving to a new server running Standard Edition (SE) 12c.

We are getting errors during import relating to ORA-000439 which is an enabled feature in 11g EE.
In our case the 439 relates specifically to Bitmap indexing and Materialised View Rewrite.

Attached is a cap of part of the error.

What literature I have found states that this is 100% down to using SE and the function is only available on EE.

The move from SE to EE is in the thousands of Euro, and although we will get sign off, we need to ensure there is no way we can run CM on 12c SE.

Please anyone who has expertise on this come back to me asap.

Much appreciated,
Locus

Hi,

I'm looking at the Supported Environments page for 8.4.1:

http://www-01.ibm.com/support/docview.wss?uid=swg27017522

Looks like Oracle 11g EE and Oracle 11g SE are both supported as content store databases. Oracle 12 - any version - doesn't appear to be, though. It's probably too modern for an antiquated version of Cognos like yours?

MF.
Meep!

locus

Thanks MF,

We tried SE 11g with the same result.

What I did discover is that the bitmapping seems to apply to OLAP schemas only.
We were fortunate enough to have all our DMR on another system, and after cleaning CM of all the OLAP content, the errors went away.

I don't know what would be the solution in a case where this clean was not possible.
Personally I believe any large Enterprise should run EE as a rule, as with all other OS and applications.

Cheers,
Locus