DB13 : BR0253E errno 13: Permission denied - For deleting Archived log files

[Former Member]

Dear All,

We have distributed environment and we have recently moved hardware. There were no changes technically, although we are facing below resepctive problem while performing redo log backups.

Redo log Backups are running, respective below error is occurring at the time of deletion of old redo logs.

Error -

BR0252E Function remove() failed for '/oracle/SID/oraarch/SIDarch1_586_859154667.dbf' at location BrFileDelete-1

BR0253E errno 13: Permission denied

As per SAP note 113747 - Owners and authorizations for BR*Tools

We checked and set respective permissions although the problem persists on DB node.

BR* files under Folder /sapmnt/SID/exe --

>>> ll br*

-rwsrwxr-x 1 orasid sapsys  9388559 Mar  5  2014 brarchive

-rwsrwxr-x 1 orasid sapsys  9506369 Mar  5  2014 brbackup

-rwsrwxr-x 1 orasid sapsys 11409480 Mar  5  2014 brconnect

-rwxr-xr-x 1 sidadm sapsys  9960982 Mar  5  2014 brrecover

-rwxr-xr-x 1 sidadm sapsys  6178431 Mar  5  2014 brrestore

-rwxr-xr-x 1 sidadm sapsys 11846656 Mar  5  2014 brspace

-rwxr-xr-x 1 sidadm sapsys  6777151 Mar  5  2014 brtools

We have standalone gateway on DB node of cluster/distributed environment and as i See we have files created with respective SIDadm user of gateway in saparch folder.

For example -

-rw-r--r-- 1 gwpadm sapsys   11814 Oct 10 13:51 aeoxxgmx.cds

-rw-r--r-- 1 gwpadm sapsys   13210 Oct 10 15:08 aeoxxkkz.cds

-rw-r--r-- 1 gwpadm sapsys   16597 Oct 11 08:05 aeoybcsn.cds

-rw-r--r-- 1 gwpadm sapsys   26452 Oct 12 08:06 aeoygano.cds

snipnet of /etc/group under DB host

as i suspect there might be permissions issues , so I have added gwpadm to both group dba and sapsys along with orasid, sidadm, and sjpadm which is a java addin installation.

dba:!:108:oracle,sidadm,sjpadm,lyceus,gwpadm,orasid

sapinst:!:1000:root,sapadm,sidadm,daaadm,sjpadm,sm1adm,orasid,da1adm,gwpadm

sapsys:!:1001:lyceus,orasid,gwpadm,sidadm,sjpadm

oper:!:1002:sidadm,sjpadm,orasid,gwpadm

lyceus:!:1004:lyceus,sapsys,dba

May I know where I can see , using which user redo log are getting deleted and I have tried deleting manually using all users ( sidadm, orasid, gwpadm, sjpadm) all users can delete redo log files successfully.

appreciate point to focus here.

Thanks,

Bond

[Former Member · Accepted solution]

Dear All,

Thanks for all your support.

Respective issue seems to be resolved.

Please note, it was using "GWPADM" user , although I have added gwpadm ,standalone gateway SIDadm, to groups dba and sapsys it wasnt able to delete archive log files.

Hence I have modified /sapmnt/(gateway SID)/exe/ br* by sap note 113747 - Owners and authorizations for BR*Tools

-rwsrwsr-x 1 orasrp sapsys  9388559 Oct 13 14:04 brarchive

-rwsrwsr-x 1 orasrp sapsys  9506369 Oct 13 14:04 brbackup

-rwsrwsr-x 1 orasrp sapsys 11409480 Oct 13 14:04 brconnect

-rwxr-xr-x 1 gwpadm sapsys  9960982 Oct 13 14:04 brrecover

-rwxr-xr-x 1 gwpadm sapsys  6178431 Oct 13 14:04 brrestore

-rwxr-xr-x 1 gwpadm sapsys 11846656 Oct 13 14:04 brspace

-rwxr-xr-x 1 gwpadm sapsys  6777151 Oct 13 14:04 brtools

after modifying the same and re-running respective issue was resolved.

A good learning for me to investigate respective issue.

Thanks all.

[Former Member]

Dear All,

Even after changing the permissions for brarchive, respective redolog backup is failing for same reason while deleting old archive logs with permission denied.

-rwsrwxr-x 1 orasid dba     9388559 Mar  5  2014 brarchive

-rwsrwxr-x 1 orasid sapsys  9506369 Mar  5  2014 brbackup

-rwsrwxr-x 1 orasid sapsys 11409480 Mar  5  2014 brconnect

-rwxr-xr-x 1 sidadm sapsys  9960982 Mar  5  2014 brrecover

-rwxr-xr-x 1 sidadm sapsys  6178431 Mar  5  2014 brrestore

-rwxr-xr-x 1 sidadm sapsys 11846656 Mar  5  2014 brspace

-rwxr-xr-x 1 sidadm sapsys  6777151 Mar  5  2014 brtools

Saparch contains file created by "gateway" user

BR0280I BRARCHIVE time stamp: 2014-10-13 15.32.35

#ARCHIVE.. /oracle/SID/oraarch/SIDarch1_657_859154667.dbf

#SAVED.... VXF1413189003

BR0252E Function remove() failed for '/oracle/SID/oraarch/SIDarch1_657_859154667.dbf' at location BrFileDelete-1

BR0253E errno 13: Permission denied

permissions to Oraarch is set to 640

-rw-r----- 1 oraSID dba 139982336 Oct 13 15:12 SIDarch1_657_859154667.dbf

-rw-r----- 1 oraSID dba 140137472 Oct 13 15:32 SIDarch1_658_859154667.dbf

When archive backup is started as we check respective backup run under user "gwpadm" which is a gateway instance. "GWP" on db server.

hostname:gwpadm 81> ps -eaf | grep -i brarchive

gwpadm    1005  1004  0 14:04 ?        00:00:01 brarchive -jid LOG__20141013140446 -u / -c force -p initSIDarc1.sap -cds

gwpadm   18293  2254  0 15:08 pts/2    00:00:00 grep -i brarchive

Please note, I have added user "gwpadm" to /etc/group file to both DBA and SAPSYS groups.

if I login using "gwpadm" and try to delete oraarch file, i am able to delete the same sucessfully.

Any hint on same?

Why respective is not able to delete via SAP.

Regards,

Bond

[Sriram2009]

Hi Bond,

Could you refer the SAP Note

1836386 - DBA Planning Calendar jobs fail with the error "BR0253E errno 13: Permission denied"

Regards

SS

[former_member185239]

Hi James ,

Log on with sidadm on db instance and try to delete the archive file and before that take a backup of that particular archive file.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hello James,

Plz check the below similar thread. Hope this helps.

http://scn.sap.com/thread/1924946

regards,

pavan

[Former Member]

Dear

This is a permission issue you have to logged in with orasid and change permission to

with ora<sid>:dba and check again.

your permission are  rwsrwxr-x 1 orasid sapsys  9388559 Mar  5  2014 brarchive

it will work

Regards

[Former Member]

Hello James,

Does oraSID have permissions to delete(once backed-up) the files from oraarch folder?

If not, please go through the below link and alter the permissions.

Access Privileges for Database-Related Resources - Oracle Under UNIX - SAP Library

regards,

pavan

[former_member182657]

Hi Bond,

-

rwsrwxr-x 1 orasid sapsys  9388559 Mar  5  2014 brarchive
-rwsrwxr-x 1 orasid sapsys  9506369 Mar  5  2014 brbackup
-rwsrwxr-x 1 orasid sapsys 11409480 Mar  5  2014 brconnect
-rwxr-xr-x 1 sidadm sapsys  9960982 Mar  5  2014 brrecover
-rwxr-xr-x 1 sidadm sapsys  6178431 Mar  5  2014 brrestore
-rwxr-xr-x 1 sidadm sapsys 11846656 Mar  5  2014 brspace
-rwxr-xr-x 1 sidadm sapsys  6777151 Mar  5  2014 brtools

Could you please change permissions for br* with ora<sid>:dba and check again.

Regards,

Gaurav Rana