how to unlock DDIC at database level

[Former Member]

Hello,

Can any tell me how to unlock DDIC at database level(oracle).

We are in the process of upgrading BW 3.5 system to BI 7.0, during upgrade at one point of time it has thrown error n it says unlock DDIC of shadow instance...

pls help me out in this.

Praveen.

[former_member204746]

sqlplus "/ as sysdba"

update sapr3shd.usr02 set uflag='0';

or

update sap[SID]shd.usr02 set uflag='0';

then:

commit;

try again. you might need to restart shadow instance or flush buffers.