Skip to Content

ORA-01031: insufficient privileges

Hi to all experts,

Whenever I run redo log backup in DB13, i will get the error message as below:

BR0002I BRARCHIVE 6.40 (15)

BR0006I Start of offline redo log processing: adyhdcwk.svd 2008-07-04 14.44.06

BR0280I BRARCHIVE time stamp: 2008-07-04 14.44.06

BR0301E SQL error -1031 at location BrInitOraCreate-2

ORA-01031: insufficient privileges

BR0303E Determination of RDBMS version failed

BR0007I End of offline redo log processing: adyhdcwk.svd 2008-07-04 14.44.06

BR0280I BRARCHIVE time stamp: 2008-07-04 14.44.06

BR0005I BRARCHIVE terminated with errors

Does anyone can help me?

Thanks a lot.

BR,

Nancy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 12:01 PM

    Hi Nancy,

    SAPDBA_ROLE.SQL is an oracle script.

    To start is, you have to logon to the system ad ora<SID> user, change directory where the sql script is located,

    then execute:

    sqlplus /nolog @sapdba_role <SAPSCHEMA_ID> UNIX

    where <SAPSCHEMA_ID> is probably the SID of your system. It depend on the Oracle schema owner of SAP objects.

    Stefano

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 07:13 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 04, 2008 at 08:03 AM

    Hello. Can you say your Oracle version, patch level , OS, Brtools version, and from wich tool you create backup ? One time i'm has collided to same problem...

    Data protector backup failed.... .

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 09:16 AM

    Hi,

    try to (re)execute the sql script SAPDBA_ROLE.SQL.

    You can find it on kernel directory ed if you read the content of file you can find how to launch it.

    Bye

    Stefano

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Stefasno,

      I get the error message when I was trying to execute that file:

      ./sapdba_role.sql: line 1: syntax error near unexpected token `('

      ./sapdba_role.sql: line 1: `-- @(#) $Id: //bas/640_REL/src/ccm/rsbr/sapdba_role.sql#5 $ SAP'

      Thanks a lot.

      BR,

      Nancy

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.