Oracle Users blocked after backup offline CRM

[Former Member]

Hi all,

everytime the backup offline finished the oracle users are blocked and the system is unable to start up again, so we have to unblock them manually, does anybody have a clue why this is happening?

Many thanks in advance

[Former Member]

Hello Markus,

This is the error i got:

ERROR => ORA-1403 when accessing table SAPUSER

And then i have to unlock all this users:

ALTER USER OPS$CRPADM ACCOUNT UNLOCK;

ALTER USER OPS$SR3ADM ACCOUNT UNLOCK;

ALTER USER OPS$SAPSERVICESAP_SID ACCOUNT UNLOCK;

ALTER USER OUTLN ACCOUNT UNLOCK;

ALTER USER OPS$ORACRQ ACCOUNT UNLOCK;

ALTER USER OPS$ORACRP ACCOUNT UNLOCK;

ALTER USER OPS$SAPSERVICECRQ ACCOUNT UNLOCK;

ALTER USER OPS$CRQADM ACCOUNT UNLOCK;

ALTER USER OPS$SAP_SIDADM ACCOUNT UNLOCK;

ALTER USER OPS$SAPSERVICECRP ACCOUNT UNLOCK;

ALTER USER SYS ACCOUNT UNLOCK;

ALTER USER SYSTEM ACCOUNT UNLOCK;

ALTER USER SAPSR3DB ACCOUNT UNLOCK;

ALTER USER DIP ACCOUNT UNLOCK;

ALTER USER TSMSYS ACCOUNT UNLOCK;

ALTER USER DBSNMP ACCOUNT UNLOCK;

ALTER USER SAPSR3 ACCOUNT UNLOCK;

Many thanks

[markus_doehr2]

> everytime the backup offline finished the oracle users are blocked and the system is unable to start up again, so we have to unblock them manually, does anybody have a clue why this is happening?

which users? the Oracle database users?

Markus