Question Re: schema ORACLE in Technology Q&A

schema ORACLE

Former Member — Fri, 22 Sep 2017 07:42:42 GMT

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,

Re: schema ORACLE

denis_konovalov — Fri, 22 Sep 2017 11:39:41 GMT

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..

Re: schema ORACLE

manikandan_elumalai — Fri, 22 Sep 2017 13:57:47 GMT

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

Re: schema ORACLE

Former Member — Fri, 22 Sep 2017 15:48:18 GMT

if i change only the name of the schema, what well be nedded to be changed in order to maintaine the correcte connectivity on BO ( CMC, BI, reports, Universes ....).

I think that we need to change juste the connexions parameters.

thank you for your assistance.

Re: schema ORACLE

denis_konovalov — Fri, 22 Sep 2017 15:52:03 GMT

changing shema name changes connectivity, so it all has to be updated.