Permission Denied error in DB check job

[Former Member]

We have schduled DB check job in SM37 everyday to collect the statistics of DB.

But in recent days, the job is finished with errors. PFB the job log.

BR0801I BRCONNECT 7.00 (32)

BR0252W Function remove() failed for '/oracle/TBW/102_64/dbs/sapTBW.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for '/oracle/TBW/102_64/dbs/sapTBW.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0805I Start of BRCONNECT processing: cecjuhmx.chk 2010-01-19 03.00.27

BR0252E Function fopen() failed for '/oracledata/sapcheck/cecjuhmx.chk' at location main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracledata/sapcheck/cecjuhmx.chk failedPlease let me know if any possible solutions for the same.

Thanks in advance.

Regards,

Mohankumar.G

[Former Member · Accepted solution]

Hi,

BR0252W Function remove() failed for '/oracle/TBW/102_64/dbs/sapTBW.ora' at location BrInitOraCreate-1
BR0253W errno 13: Permission denied

BR0252W Function remove() failed for '/oracle/TBW/102_64/dbs/sapTBW.ora' at location BrInitOraCopy-7
BR0253W errno 13: Permission denied


BR0252E Function fopen() failed for '/oracledata/sapcheck/cecjuhmx.chk' at location main-11
BR0253E errno 13: Permission denied

All the above lines indicating permission issue...

Compare your filesystem permission as below:

#ll -ld /oracle/TBW/102_64/dbs
drwxr-xr-x   2 oratbw     dba
and
#ll -ld '/oracledata/sapcheck
drwxr-xr-x   2 oratbw     dba

next thing...

Check your BRTOOLs permissions (brtools, brspace, brarchive, brbackup, brrestore)

for that refer sap note [113747 - Permissions for DBA tools BRTools and SAPDBA|https://service.sap.com/sap/support/notes/113747]

It will solve your problem.

Regards.

Rajesh Narkhede

[Former Member]

Hi ,

I think you should simply give write permission to the group owner (DBA) of the file(sapTBW.ora) ,and read&write permission on the file (cecjuhmx.chk) so that SIDADM user can modify these files.

<sid>adm user is part of the group DBA.

Also check the permissions on the directory sapcheck.

'/oracle/TBW/102_64/dbs/sapTBW.ora'

oracle/TBW/102_64/dbs/sapTBW.ora'

'/oracledata/sapcheck/cecjuhmx.chk'

Regards

Amit

[former_member524429]

Hi,

Please refer the following SAP Notes to get more information.

[Note 583861 - UNIX: Errors due to Oracle executable|https://service.sap.com/sap/support/notes/583861]

[Note 1173159 - BR*Tools errors occur when accessing database directory|https://service.sap.com/sap/support/notes/1173159]

[Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA|https://service.sap.com/sap/support/notes/113747]

[Note 651351 - BR tools on UNIX: Error due to executable permissions|https://service.sap.com/sap/support/notes/651351]

Regards,

Bhavik G. Shroff

[Former Member]

Hi,

Run the correct one sapdba_role and sapconn sql and recheck.

Regards, Rahul.

[Former Member]

How to check the SAPDB_ROLE is latest/correct one.?

i have applied the SAPDB_ROLE and checked the output.. everything is fine...

What is SAPconn SQL? how to check that.. please enlighten.