Oracle database online/offline backups with brtool failing with error

[Former Member]

Dear All,

I'm scheduling oracle online/offline backup using brtools.

It's throwing error message "SQL error -1031 at location in BrSapTspGet-8, SQL Statement :

'PREPARE stmt_1 FROM' 'SELECT TABSPACE FROM "SAPSLM".TSORA UNION SELECT INDSPACE FROM "SAPSLM".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

I've performed stack12 upgrade on solman 7.1. After successful completion of upgrade, I'm taking database backup as post steps. This issue is coming.

Kindly see the screenshot for more info.

Note: Archive log backup with BRtools is working fine.

Thanks & Regards

Venkatesh P

[Reagan · Accepted solution]

This has been discussed before. Have you thought of executing the sapdba_role.sql script?

134592 - Import of SAPDBA role (sapdba_role.sql)

[Former Member · Accepted solution]

Dear Benjamin,

Issue is solved.

Thank you very much for your quick response.

Regards

Venkatatesh P

[former_member207186]

Hi,

Regarding this "ORA-01031:insufficient privileges" issue, you can re-execute  the sapconn_role.sql and sapdba_role.sql as per SAP Notes 134592 and 480266. Please also check SAP Note1028220 and ensure that BR*Tools permissions are set correctly as per SAP Note 113747 and update us on the status of the issue.

Regards,

Bíborka

[Former Member]

Dear Biborka,

Thank you very much for your giving quick reply.

Issue has been solved.

Thanks

Venkat

[Former Member]

Dear Biborka,

Thank you very much for your quick resolution.

Issue has been solved.

Thanks

Venkat