BRBackup error

[former_member199694]

hi,

When starting BRBACKUP, below error is showing up. Is there any privilege is missing?

Thanks,

RajS

Error Log:

-

---

BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:

'PREPARE stmt_1 FROM'

'SELECT TABSPACE FROM "SAPSOL".TSORA UNION SELECT INDSPACE FROM

"SAPSOL".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

When executing the query as sysdba:

-

---

SQL> SELECT TABSPACE FROM "SAPSOL".TSORA UNION SELECT INDSPACE FROM

"SAPSOL".TSORA ORDER BY 1;

TABSPACE

-

---

PSAPSOL

PSAPSOL702

PSAPSOLUSR

[former_member199694]

issue fixed by recreating OPS$

[Former Member]

Try note 134592 for importing the right sapdba_role.sql and how to apply it

Thanks

Anish

[Former Member]

Hi,

Check whether the user has grant permission for the table, this is primarily due to permissions problem.

Once you have logged in as orasid in SQL prompt exeute SHOW USER

Now the grant permissions for that user.

If you are in Linux, hope the below note is useful:

Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Regards,

SBK

[Former Member]

This message was moderated.

[sunny_pahuja2]

Hi,

>

> Error Log:

> -

---

> BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:

> 'PREPARE stmt_1 FROM'

> 'SELECT TABSPACE FROM "SAPSOL".TSORA UNION SELECT INDSPACE FROM

> "SAPSOL".TSORA ORDER BY 1'

> ORA-01031: insufficient privileges

You are facing ora-01031 error. Check SAP note 400241.

Thanks

Sunny