Error ORA-01031: insufficient privileges when backup via DB13

[Former Member]

Hi expert,

Currently, I have system on SuSE 10 SP2 with ECC6 and Oracle 10.2 installed.

Database backup works fine when using BRTOOLS from command line.

Error like this :

-

---

BR0278E Command output of 'SHELL=/bin/sh /oracle/I20/920_32/bin/rman

nocatalog':

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>

RMAN> connect target /;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01031: insufficient privileges

RMAN> *end-of-file*

-

---

happened when I try to schedule backup through DB13.

I try to solved this with SAP Note 776505 but still doesn't work.

Any suggestion ?

ardhian

[Former Member]

Check the Raman Uusr password as well as gratns of this user by sys user at oracle lavel.

Thanks

presu

[Former Member]

Hi ,

Check permits the users (oracle and system) from console, you must have full permits is 777, so if you don´t change this with the chmod command.

regards.

Gustavo Gonzalez

SofOS C.A

[former_member603052]

Hi,

Check this [http://help.sap.com/saphelp_nw04/helpdata/en/5a/4a704ba2308a4db5a4d36e39e7d05a/content.htm]

i think this could help

Regards,

Kalyan

[Former Member]

Hi,

Please execute sapdba_role.sql script.

Regards,

Sachin Rane.

[former_member220071]

Hi ,

Before RMAN Bachup do the following

you have to enable ARCHIVELOG Mode, you will prevent REDO logs to be overwritten.

>SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

Check that if you have your catalog and target databases on the same box otherwise box will crashes.

Create two databases. One for RMAN catalog(Test) and one target(PROD).

Also let me know have you change your operating system password ?

Abhijeet

[Former Member]

Hi,

Can you please tell me what are the permissions(owner, group) set on all BR* files in /usr/sap/<SID>/SYS/exe/run. Check this out. This is the most common reason for this error.

Thanks,

Faisal.

[former_member227600]

Hi,

Execute the following command at sql prompt.

grant dba,resource,connect,sapdba to OPS$<SID>ADM  OPS$ORA<SID>

grant dba,resource,connect,sapdba to O OPS$ORA<SID>

grant dba,resource,connect,sapdba to  SAPSR3 or SAP<SID>(YOUR SCHEMA NAME)

Also check owner of SAPUSER table

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

If it returns value OPS$<SID>ADM than its ok, otherwise you have to drop this & recreate with command

CREATE TABLE "OPS$QASADM".SAPUSER
       (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
        INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>',
'<password>');

For more info go through the snote 400241

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=400241]

Thanks & Regards

Karan

[former_member603052]

Hi Ardhian,

Have you performed any DB/SAP upgrade recently????

If yes,i think you need to execute sapdba_role.sql script which you can find in /usr/sap/sis/sys/exe/run or else you can dowload the latest script from service market place.

Regards,

Kalyan

[Former Member]

Hi,

It looks like you have a permission issue. Please check out the following link.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=113747]

Hope this helps.

Manoj Chintawar

[former_member220071]

Hi ,

>happened when I try to schedule backup through DB13

Can you give DB13 log.

Abhijeet

[former_member603052]

Hi,

Check the username exists or not.

Check the user has sufficient privilages to sapbackup directory.

Regards,

Kalyan