Solution : https://service.sap.com/sap/support/notes/134592 (SAP Service marketplace login required)
Summary :
When using BRBACKUP, BRARCHIVE, BRCONNECT, and BRSPACE tools for database activities, errors such as ORA-01031 and ORA-00942 may occur due to lack of proper authorizations linked with the SAPDBNon-SAPDMDBA role. During SAP/Oracle upgrades, it's required to create the SAPDBA role as per upgrade instructions. If operating on a lower SAP release, database privileges may need adjustments. This can be resolved by running the advised SQL script to establish the SAPDBA role correctly using the provided commands, which cater to various SAP schema IDs ensuring proper logging and error handling in multi-component environments.
Key words :
sqlplus /nolog @sapdba_role sr3sqlplus /nolog @sapdba_role sr3dbcaution 3----------, sqlplus /nolog @sapdba_role r3the log file sapdba_role, database log header failedbr0280i time stamp 2009-11-10 10, sqlplus /nolog @sapdba_role sr3and, sqlplus /nolog @sapdba_role sapsr3caution 2----------, sqlplus /nolog @sapdba_role <sapschema_id>, database files failedbr0056i end, pure sap j2ee database, user sap<sid>db, insufficient privilegesbr0301w sql error -942
Related Notes :
| 1139623 | Using transaction RZ20 to monitor remote Oracle databases |
| 834917 | Oracle Database 10g: New database role SAPCONN |
| 717677 | BRCONNECT call of SAPInst fails with ORA-01017 |
| 700548 | FAQ: Oracle authorizations |
| 662644 | Composite SAP Note: ORA-00942 |
| 662219 | Add. info. on upgrading to SAP Web AS 6.40 ORACLE |
| 651452 | DB13: No action log found for this action |
| 437648 | DB13: External program terminated with exit code 1/2 |
| 403704 | BRCONNECT - Enhanced function for Oracle DBA |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 361641 | Creating OPS$ users on UNIX |
| 143288 | SAPDBA: Super collective note |
| 104215 | DB13-DB24: CPIC communication error |
| 12741 | Current versions of BR*Tools and SAPDBA |