Database backup failure ORA-01031: insufficient privileges BR0303E

[Former Member]

Hi,

database 10.2 on windows . i checked System user and its as below. can someone please help .

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP

-

---

-

---

-

---

SYS TRUE TRUE

SAPDAT TRUE TRUE

SAPWSTDB TRUE TRUE

SYSTEM TRUE TRUE

BR0051I BRBACKUP 7.00 (41)

BR0055I Start of database backup: bebynmur.anf 2009-11-20 20.30.41

BR0484I BRBACKUP log file: F:\oracle\SID\sapbackup\bebynmur.anf

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.41

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

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bebynmur.anf 2009-11-20 20.30.41

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.41

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.41

BR0291I BRARCHIVE will be started with options '-U -d util_file -c force -p initSID.sap -cds'

BR0280I BRBACKUP time stamp: 2009-11-20 20.30.43

BR0292I Execution of BRARCHIVE finished with return code 3

[Former Member]

Hi,

Just check all the things mentioned in 400241.

And also one hint: check the file permissions of oracle_home and all datafiles (in your manner compare with your second system, where backup is happening perfect).

Joe: user is comparing the checks with other system in his landscape

Regards

Nick Loy

[Former Member]

Hi,

check your Oracle service user......permissions...........

Mark

[former_member204746]

SAP note 400241.

[Former Member]

Hi,

I checked wih privilege issue but i could not find any issue here .

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

-

---

OPS$\SIDADM

OPS$<server>\SIDADM

SQL> SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS

2 WHERE SYNONYM_NAME = 'SAPUSER';

OWNER TABLE_OWNER

-

---

-

---

TABLE_NAME

-

---

OPS$<server>\SAPSERVICE,SID> OPS$<server>SIDADM

SAPUSER

OPS$\SAPSERVICEWST OPS$\SIDADM

SAPUSER

SQL>

[Former Member]

Thoroughly read the note provided by Eric.

Obviously there is an issue here:

The table SAPUSER must occur in the system only once 

[Former Member]

Accepted . But point is here other system also having the same things and backup are running there .

so i dont want to touch them .

Any other idea please

Thanks

[Former Member]

Is it an MCOD system, that is more than one SAP systems in one Oracle database?

If so, it will be sufficient to run brbackup/barchive in one of those systems.

[Former Member]

Hi,

Database and SAP both running on same server.

Thanks

Dharmendra.

[Former Member]

This doesn't answer my question:

Is it an MCOD system, that is more than one SAP systems in one Oracle database?

[Former Member]

Or in other words:

You wrote that there is another system and backup is running there.

Two possible scenarios:

1) Both SAP systems are in the same Oracle database. In this case there will be no need to backup both SAP systems separately.

2) The two SAP systems are in two different Oracle databases. In this case the SAPUSER table from one system must not be in the other system.

regards

[Former Member]

Hi,

Execute the below query & try to take the backup.

GRANT connect,resource,sapdba,sapconn TO ora<SID>;
commit;

Hope this will solve the file.

Thanks,

Sachin