Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 21, 2007 at 03:08 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2007 at 09:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2007 at 08:00 PM

    Hi,

    Refer SAP Note Number 400241

    Regards,

    Suraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.