Brbackup Fail: BR0301E, BR0303E

[Former Member]

Hello gurus.

I have the problem with backup SAP with Legato Networker. When i tried to execute the backup, the brbackup fails with the error messages:

BR0051I BRBACKUP 7.00 (28)

BR0055I Start of database backup: bdxhiyub.anf 2008-02-18 18.22.41

BR0484I BRBACKUP log file: E:\oracle\MID\sapbackup\bdxhiyub.anf

BR0280I BRBACKUP time stamp: 2008-02-18 18.22.41

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

'CONNECT midbackup/************ AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bdxhiyub.anf 2008-02-18 18.22.41

BR0280I BRBACKUP time stamp: 2008-02-18 18.22.41

BR0054I BRBACKUP terminated with errors

The user midbackup was to created for backup with Legato.

How can i solve the problem ???

[Former Member · Accepted solution]

Hi. Find the files sapconn_role.sql and sapdba_role.sql, open from editor and read. Then apply them.

Check the notes 834917, 1028220 , and 134592.

Thanks and regards.

Award is helpful.

[Former Member · Accepted solution]

Hello Sergo,

Thanks for the replay.

I check the sap note 834917, and the SAPSR3 they have the autorization for the Role SAPCONN.

I am using a user that was created to run the backups, The user has assigned the role:

GRANTEE GRANTED_ROLE DEF

-

---

-

---

-

---

MIDBACKUP SAPDBA YES

MIDBACKUP DBA YES

MIDBACKUP RESOURCE YES

MIDBACKUP CONNECT YES

I do not understand what are the roles that should be assigned this user?

[Former Member · Accepted solution]

Try giving sysoper (ORA_OPER or ORA_<sid<_OPER) privilege to the user.

Thanks

BMG

[Former Member · Accepted solution]

also take a look at note# 192374

[Former Member · Accepted solution]

Hello, Murali.

The authorization for ORA_DBA, ORA_MID_DBA and ORA_MID_OPER, is ok. And the authorization for sysoper and sysdba too.

I tried run the backing directly on the server and the brbackup run OK, with the user "midbackup", but when run since Legato the error is the same, not change.

[markus_doehr2]

In that case you need to create an OPS$-User, otherwise the user can´t authenticate against the database.

Markus