brarchive does not return from primary_db

[andreas_laufer]

Hello,

I have problems to configure the brarchive for a standby db.

If I start brarchive it does not return while checking archive log list on primary db.

The connect to the primary db is ok. I can connect with user system/password@<primary_db>.

Example:

s26048sb:oragpj 62% brarchive -u system/password -sd -m

BR0002I BRARCHIVE 7.00 (32)

BR0006I Start of offline redo log processing: adxhpmjp.svd 2008-02-20 07.43.29

BR0484I BRARCHIVE log file: /oracle/GPJ/saparch/adxhpmjp.svd

BR0477I Oracle pfile /oracle/GPJ/102_64/dbs/initGPJ.ora created from spfile /oracle/GPJ/102_64/dbs/spfileGPJ.ora

Have everyone a good idea?

Thanks

Andreas

[Former Member]

HI,

check

http://help.sap.com/saphelp_nwmobile71/helpdata/en/37/50d1d05c901345a42cab116a14bb54/content.htm

http://help.sap.com/saphelp_nwmobile71/helpdata/en/8b/9199db17575945953676b91d4fc9a4/content.htm

regards,

kaushal

[andreas_laufer]

Hello Kaushal,

the standby-db isrunning normal and a recover standby database is also ok.

Just brarchive makes problems. We habe implemented also Note 131610 for remote connect to the primary-db but brarchive does not return. If I call brarchive without option -u this appears:

brarchive -sd -m

BR0002I BRARCHIVE 7.00 (32)

BR0006I Start of offline redo log processing: adxhpofd.svd 2008-02-20 08.04.05

BR0484I BRARCHIVE log file: /oracle/GPJ/saparch/adxhpofd.svd

BR0280I BRARCHIVE time stamp: 2008-02-20 08.04.05

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

'CONNECT system/*******@GPJ'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance GPJ/PRIMARY failed

BR0280I BRARCHIVE time stamp: 2008-02-20 08.04.06

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

'CONNECT system/*******@GPJ'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance GPJ/PRIMARY failed

BR0278W Command output of '/oracle/GPJ/102_64/bin/sqlplus /nolog < /oracle/GPJ/saparch/.adxhpofd.spi':

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 20 08:04:06 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> ERROR:

ORA-01017: invalid username/password; logon denied

SQL>

SQL> ORA-01012: not logged on

SQL>

BR0280I BRARCHIVE time stamp: 2008-02-20 08.04.08

BR0279W Return code from '/oracle/GPJ/102_64/bin/sqlplus /nolog < /oracle/GPJ/saparch/.adxhpofd.spi': 0

BR0302W SQLPLUS call for database instance GPJ/PRIMARY failed

BR0323W 'Archive log list' for database instance GPJ/PRIMARY failed

regards

Andreas

[Former Member]

Hi,

did you assign SYSOPER and SYSDBA to user system?

i think this is due to missing authorization only , you already apply note 131610, please check it again if something is missing.

regards,

kaushal

[andreas_laufer]

Hello Kaushal,

we implemented the note 131610 before some days. I checked it again.

Nothing changed. Brarchive does not return. Last message is:

BR0477I Oracle pfile /oracle/GPJ/102_64/dbs/initGPJ.ora created from spfile /oracle/GPJ/102_64/dbs/spfileGPJ.ora

regards

Andreas