Make a backup for SAP 7.1's oracle database

[Former Member]

I'm using brtools to make a backup for SAP 7.1's oracle database. I follow the setting configuration manual but when I run the backup procedure, I got message that account already locked (FYI : I use username/password : system/manager)

SAP 7.1 的 OS Windows Server 2003 , Standard x64 Edition, Service Pack 2

At the time of installation of SAP 7.1, there is no place to setting oracle's account. I want to ask how can I solve this problem ?

Thanks.

[markus_doehr2]

Just to add:

Be aware of the fact, that a PI 7.1 is a combined ABAP + Java system, in case of a recovery it's not enough to have the database but you also need to have the filesystem backup of the Java instance done at the same time to restore your system completely. If you haven't done that you are not able to restore the Java part.

Markus

[Former Member]

Hello Sky

are you able to start brtools?you should be using either <sid?adm or ora<sid> to start BRTOOLS

what is the exact error that it gives you when you start BRTOOLS

Rohit

[Former Member]

If the user is locked you might need to unlock it in SQLplus:

SQL> select USERNAME, ACCOUNT_STATUS from dba_users where username = 'SYSTEM';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYSTEM                         LOCKED

SQL> alter user system account unlock;
User altered.

Passwords can be set using BR*Tools -> 8 - Additional functions, as already mentioned above.

Best regards, Michael

[Former Member]

The error message

###############################################################################

BR0051I BRBACKUP 7.10 (5)

BR0055I Start of database backup: beamonfi.and 2009-05-04 09.50.06

BR0484I BRBACKUP log file: C:\oracle\IS1\102\sapbackup\beamonfi.and

BR0280I BRBACKUP time stamp: 2009-05-04 09.50.06

BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-28000: the account is locked

BR0310E Connect to database instance IS1 failed

BR0280I BRBACKUP time stamp: 2009-05-04 09.50.06

BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-28000: the account is locked

BR0310E Connect to database instance IS1 failed

BR0056I End of database backup: beamonfi.and 2009-05-04 09.50.06

BR0280I BRBACKUP time stamp: 2009-05-04 09.50.06

BR0054I BRBACKUP terminated with errors

[Former Member]

do

SQL> alter user system account unlock;

SQL> alter user system identified by password;

where the 'password' is the password which you want to set and save it somewhere in documentation then

[Former Member]

refer to SAP Note 951167 - ORA-28000: the account is locked. You may want to have a look at SAP Note 400241