brarchive fails with "ORA-01031" when spfile is created

[Former Member]

Hi,

We recently created spfile for one of our databases. Since then we started receiving following error

-

---

Thu Jun 21 08:28:50 EDT 2007: Start of BRARCHIVE for database BWX

BR0002I BRARCHIVE 6.40 (39)

BR0262I Enter database user name[/password]:

BR0006I Start of offline redo log processing: advnnffv.svd 2007-06-21 08.28.51

BR0280I BRARCHIVE time stamp: 2007-06-21 08.28.51

BR0301E SQL error -1031 at location BrInitOraCreate-2

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: advnnffv.svd 2007-06-21 08.28.51

BR0280I BRARCHIVE time stamp: 2007-06-21 08.28.51

BR0005I BRARCHIVE terminated with errors

Thu Jun 21 08:28:51 EDT 2007: BRARCHIVE ended with errors!

-

---

When we remove spfile then everything works fine.

The similar setup works fine on other system.

Thanks

[Former Member]

Hi,

Refer SAP Note Number 400241

Regards,

Suraj

[Former Member]

Hi Chandrashekar,

Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.

Regards

Ganesh

[Former Member]

Import the SAPDBA role (Version 7.00) in accordance with Note 134592. Do this using the sapdba_role.sql script from the sapdba_role_ora10.SAR attachment to the note.

Also, check the owner of BR*tools. If needed run saproot.sh.