Brarchive Failed

[Former Member]

Dears ,

Recently We have installed PI 7.1 on AIX with Oracle 10g.

Now I am executing command brarchive with user orasid then its showing error:

BR0280I BRARCHIVE time stamp: 2009-10-29 10.17.07

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

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

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance PD1 failed

BR0007I End of offline redo log processing: aebugdad.sve 2009-10-29 10.17.07

BR0280I BRARCHIVE time stamp: 2009-10-29 10.17.07

BR0005I BRARCHIVE terminated with errors

Please suggest what to do,Do I have to maintain user settings in some file or what to do.

Regards,

Shivam

[Former Member]

Hi,

Check SAP note 400241 & below link. It may help you.

Thanks

Sushil

[Former Member]

Dears,

Thanks for the reply.

Issue was with OPS$ORASID password after changing it now that error has been resolved but now its showing:

BRARCHIVE 7.10 (3)

BR0006I Start of offline redo log processing: aebuhmml.sve 2009-10-29 16.54.27

BR0484I

BRARCHIVE log file: /oracle/PD1/saparch/aebuhmml.sve

BR0280I

BRARCHIVE time stamp: 2009-10-29 16.54.27

BR0301E SQL error -1031 at location BrInitOraCreate-2,

SQL statement:

'CONNECT OPS$ORAPD1/******** AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: aebuhmml.sve 2009-10-29 16.54.27

BR0280I BRARCHIVE time stamp: 2009-10-29 16.54.27

BR0005I BRARCHIVE terminated with errors

Please suggest.

I have also provided dba authorization to OPS$ORAPD1

Shivam

[Former Member]

Hi,

It's a privilege problem.

Go to sapmnt/SID/exe & run

sqlplus /nolog @sapdba_role.sql SID

BR,

Darshan

[volker_borowski2]

Hi,

your setup of the ops$ - user is wrong. It should not have

a password at all but should be "identified externally".

Then you can use

connect /

as user "orasid" to connect to the database without a password.

Never ever give "dba" to the OPS$ User !!!

It should just get SAPDBA_ROLE for security reasons.

You need script "oradbusr.sql" to create the user(s) correctly.

Volker

[anindya_bose]

Change the password of database user SYSTEM to "manager" ( default password) and make sure the user is not locked.

>select username, account_status from dba_users;

above statement will show you if your system user is locked.

try running BRARCHIVE once again

Edited by: Anindya Bose on Oct 29, 2009 10:39 AM