R3trans -d fails

[Former Member]

Hi All,

After making system copy I cannot start SAP systesm .

When I try startsap , oracle processes are started using sidadm user ID .

I checked the oracle binary fiel permissions are correct .

Follwoing is the R3trans -d log .trans.log

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 28000 30027 0.141010

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'

4 ETW000 21 0.141031

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 28000 performing CON 15 0.141046

4 ETW000 [dblink ,00627] ***LOG BY0=> 7 0.141053

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'IA2'"

The startdb.log

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

Please help .

Thanks,

Suman

[Former Member · Accepted solution]

Hi,

Thanks for your answer.

How do I check if the user is locked ?

Thanks,

Suman

[JPReyes · Accepted solution]

You can unlock the user, using the SQL command ALTER USER <USER> ACCOUNT UNLOCK;

Regards

Juan

[Former Member]

Problem resolved by ALTER USER SAPR3 ACCOUNT UNLOCK; in sqlplus.

[Former Member]

hi

You can check the status of a user using the follwing SQL command

SQL> select USERNAME,ACCOUNT_STATUS from dba_users;

Jonu

[Former Member]

but how do I check if any user is locked ?

[JPReyes]

Check dev_w0 and dev_disp logs for more errors.

Did you change your OPS$ users after the copy?.... if not Read SAP Note 400241

Also check if the user SAPR3 or SAPSR3 (depending on your SAP Schema) is locked.

Regards

Juan