cancel
Showing results for 
Search instead for 
Did you mean: 

backup error

Former Member
0 Kudos

hi experts

while iam taking backup with brtools i got following error

BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdzgcgba.ant 2008-11-13 13.23.38

BR0484I BRBACKUP log file: /oracle/KPR/sapbackup/bdzgcgba.ant

BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bdzgcgba.ant 2008-11-13 13.23.38

BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38

BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 3

can anyone answer this error

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

As of Oracle 10g you have new roles database SAPCONN and SAPDBA. You can problem for this role...

As you can start SAP , the SAPCONN role are configured correctly, are you importing SAPDBA role to ?

try to check the "Note 134592 - Importing the SAPDBA role (sapdba_role.sql)"

to check your SAP database user in sqlplus execute :

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

Some times all authorization are GOOD, but you steel will see same error ,as me for example in one situation

in case of HP Data Protector :

Regards.

Former Member
0 Kudos

hi experts

i added these roles sapdba,sapconn to sapsr3,ops$sidam users again i got sam problem.

BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdzgcgba.ant 2008-11-13 13.23.38

BR0484I BRBACKUP log file: /oracle/KPR/sapbackup/bdzgcgba.ant

BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bdzgcgba.ant 20

i tried with sidadm user following error get

usr/sap/KPR/SYS/exe/run/brbackup: error while loading shared libraries: libclnt sh.so.10.1: cannot open shared object file: No such file or directory

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 127

regards

vasu

Edited by: vasu k on Nov 14, 2008 10:17 AM

Former Member
0 Kudos

Hi Vasu. Can you say SAP , DB releases and patches, also are you doing this backap on tape or other tool, please post full logs where you see errors, under orasid and sidadm users. Regards.

former_member204746
Active Contributor
0 Kudos

brtools 7.00 only work on Oracle 10g. Are you using oracle 9i? If so, use BRTOOLS 6.40.

0 Kudos

Hi Eric,

it is possible to use BRtools 7.00 with Oracle 9i.

In any case, BRTools require the oracle 10g instant client to be installed and properly configured and this does not seem to be the case here.

If the OP does not want to complicate itself by installing the instantclient and changing environment variables ... then it should follow you recommendation (use 6.40)

Former Member
0 Kudos

Hi All,

I have resolved this error by adding group "oper" to user ora<sid>

How to add:

=========

To check the available groups

cat  /etc/group

To add the "oper" group as supplementary group use below command

usermod -G 503 orasxy      ( 503 is group id)

we can findout group id in /etc/group

ex:oper::503

To check the available groups for user orasid use command. "id"

Regards

======

DeviSri

Answers (2)

Answers (2)

Former Member
0 Kudos

try

SQL> connect system as sysoper

Enter password:

ERROR:

ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

SQL> connect sys as sysdba

Enter password:

Connected.

SQL> grant sysoper to system;

Grant succeeded.

SQL> connect system as sysoper

Enter password:

Connected.

/thread/672949 [original link is broken]

former_member204746
Active Contributor
0 Kudos

try SAP note 400241.