Skip to Content
avatar image
Former Member

schema ORACLE

Hello,

we are about to migrate to ORACLE V12.

what will be the impact on BO4.1 if we change the name of the schema on ORACLE ?? what are the things to change in SAP BO (CONNECTION, UNIVERS .....) if the schema name changes ?

thanks in advance.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 22, 2017 at 11:39 AM

    If your Oracle host CMS DB for the BOE - then changing schema will brake CMS DB connection and make environment not run. You will have to update CMS DB connection to fix that.
    If your Oracle hosts reporting DB's to which BOE connects - changing schemas will brake all those connections, so you have to fix all your connections, universes, direct connections in CR reports etc..

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22, 2017 at 01:57 PM

    Just to add with Denis,

    In general most of the tables will be always referenced using synonyms. Make sure you take care of them. Also check Oracle 12C's compatibility with BI 4.1 too.

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded