brarchive works, even though SYSTEM user is locked ?

[Former Member]

Hello,

Oracle Release : 10.2

We're planing on performing backup of archive redolog on disk twice a day using ,

the following options :

1) brarchive -p initSMA.sap -s

2) brarchive -p initSMA.sap.dir2 -scd

The problem is , when i launch the brarchive command , I got many Oracle errors messages, apparently the password of SYSTEM user needs to be specified.

But I don't know where ? Now, the system user seems to be locked ...

Should I considere that the errors messages , are only warnings ?

The strage thing is that when I check the archive_copy_dir directory, it seems that the archive redo log have been correctly archivded.

ORA-28000: the account is locked

BR0310W Connect to database instance SMA failed

BR0201I Compressing /oracle/SMA/oraarch/SMAarch1_269_634146551.dbf

BR0203I to /users2/gmt00/save/ptmp/archive/SMAarch1_269_634146551.dbf.Z ...

#ARCHIVE.. /oracle/SMA/oraarch/SMAarch1_269_634146551.dbf

#SAVED.... /users2/gmt00/save/ptmp/archive/SMAarch1_269_634146551.dbf.Z #1/19 1.5652:1 31981961

BR0280I BRARCHIVE time stamp: 2007-09-27 12.49.08

BR0014I 19 of 19 offline redo log files processed - 793.609 MB of 793.609 MB done

BR0204I Percentage done: 100.00%, estimated end time: 12:49

BR0001I **************************************************

BR0280I BRARCHIVE time stamp: 2007-09-27 12.49.08

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

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

ORA-28000: the account is locked

BR0310W Connect to database instance SMA failed

BR0280I BRARCHIVE time stamp: 2007-09-27 12.49.08

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

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

ORA-28000: the account is locked

BR0310W Connect to database instance SMA failed

BR0039I Last offline redo log file /oracle/SMA/oraarch/SMAarch1_270_634146551.dbf will not be backed due to connect error to database instance SMA

BR0016I 19 offline redo log files processed, total size 793.609 MB

BR0202I Saving space_log

BR0203I to /users2/gmt00/save/ptmp/archive/SMA ...

BR0202I Saving /oracle/SMA/saparch/adwgapru.sve

BR0203I to /users2/gmt00/save/ptmp/archive/SMA ...

BR0202I Saving /oracle/SMA/saparch/archSMA.log

BR0203I to /users2/gmt00/save/ptmp/archive/SMA ...

BR0280I BRARCHIVE time stamp: 2007-09-27 12.49.08

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

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

ORA-28000: the account is locked

BR0310W Connect to database instance SMA failed

BR0115I Compression rate for all files 1.6512:1

BR0007I End of offline redo log processing: adwgapru.sve 2007-09-27 12.49.08

BR0280I BRARCHIVE time stamp: 2007-09-27 12.49.08

BR0004I BRARCHIVE completed successfully with warnings

Thank you for your help.

[Former Member · Accepted solution]

Hi Indus,

To avoid the error ORA-28000 Pls do the following:

If FAILED_LOGIN_ATTEMPTS is not set to UNLIMITED, you can adjust it as follows:

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

This is also possible for Oracle 10. 1 and earlier and Oracle 10.2 and later.

If a user is already locked, you can unlock it as follows:

ALTER USER <username> ACCOUNT UNLOCK;

Hope this is useful

Regards

Umesh

[Former Member · Accepted solution]

Hi,

thank you,.

I've found useful informations in note 562863

"A useful alternative to the SYSTEM user when using the BR*TOOLS is to use the OPS$ mechanism by specifying "-u/". This mechanism is also used by DB13 actions by default. "