SAP Note 21086 - NT: Database backup terminates with ORA-01031

Symptom:

Database backup with BRBACKUP terminates with the following error messages: SQLDBA> ORA-01031: insufficient privileges
SQLDBA> DBA-00302: not connected to a database
SQLDBA> SQL*DBA complete.
BR279E Return code from 'sqldba71': 0
BR302E SQLDBA call failed.
BR323E Archive log list failed.

Cause and prerequisites

Authorization problem in Oracle database.

Solution
Option 1 --------Deactivate the authorization check in Oracle with an additional entry in the registry: Call registry editor REGEDT32 and then
HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE
Edit -> Add value...
Data Type: REG_SZ
Value Name: DBA__AUTHORIZATION
String: BYPASSThen you do no longer have to enter a password for "connect internal".

Option 2 --------Call BRBACKUP with user "interanl" instead of with the default ORACLE user "system": brbackup -u internal/
Option 3 --------Activate the full authorization check under Oracle:
- enter a new parameter in the Oracle profile init.ora: REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE - Restart the database
- In SQLDBA71, assign the authorization SYSOPER (SYSDBA) as user "internal"
to user "system": GRANT SYSOPER TO SYSTEM;Then BRBACKUP can be called as a default: brbackup -u system/Caution: The 3rd option is only supported by SAPDBA as of SAP Release 2.2E.