cancel
Showing results for 
Search instead for 
Did you mean: 

updates and check DB failed in DB13

Former Member
0 Kudos

Hi All,

in one of our quality system, updates and check DB failed that scheduled in DB13. the error log shows there is permission issue, but i checked the BRTOOLS permissions it has rights, i attached the error log here, plz suggest to solve the issue.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000816, user ID SAPADM)

Execute logical command BRCONNECT On host sapqasr

Parameters: -u / -jid CHECK20100724000000 -c -f check

BR0801I BRCONNECT 7.20 (6)

BR0252E Function stat() failed for '/oracle/QAS/112_64/bin/sqlplus' at location BrFileStatGet-1

BR0253E errno 13: Permission denied

BR0273E Determination of file status for /oracle/QAS/112_64/bin/sqlplus failed

BR0280I BRCONNECT time stamp: 2010-10-26 07.00.43

BR0301E SQL error -12546 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12546: TNS:permission denied

BR0310E Connect to database instance QAS failed

BR0806I End of BRCONNECT processing: ceekqzgd.log2010-10-26 07.00.43

BR0280I BRCONNECT time stamp: 2010-10-26 07.00.43

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Thanks,

Balaji

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member524429
Active Contributor
0 Kudos

Hi,

BR0301E SQL error -12546 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12546: TNS:permission denied
BR0310E Connect to database instance QAS failed

From the above errors, I am guessing that you may be trying to run CheckDB / Update statistics jobs from DB13 for REMOTE DB Instance located on Remote Host (i.e. QAS instance).

If my guess is right then, please refer [SAP Note 1256322 - Establishing a remote database connection in DBACOCKPIT|https://service.sap.com/sap/support/notes/1256322] and do the required settings as listed in that SAP Note 1256322 and then retry.

Also ensure that latest BR*tools is in use with the required permissions on local/remote hosts.

Permissions 4775 should be there for brarchive, brbackup, brconnect, brtools with owner ora<sid> and group sapsys.

&

Permissions 755 should be there for brrestore, brrecover, brspace with owner <sid>adm and group sapsys.

Use the following commands to change the permissions & owners/groups for the same.

chmod 4775 brarchive, brbackup, brconnect, brtools

chown ora<sid>:sapsys brarchive, brbackup, brconnect, brtools

chmod 755 brrestore, brrecover, brspace

chown <sid>adm:sapsys brrestore, brrecover, brspace

ORA-12546: TNS:permission denied

If QAS is the remote DB host, then copy+paste the TNS entry in file tnsnames.ora of monitoring system (located at /oracle/<SID>/<Rel>_64/network/admin location). Its guided in the above suggested SAP Note 1256322. then check the connectivity using tnsping <Instance ID>. It should be completed with success and response time.

Regards,

Bhavik G. Shroff

Former Member
0 Kudos

Dear Gurus...

Im facing the same problem in DB13 (Archive Logs backup) stating

BR0252E Function stat() failed for '/oracle/SID/102_64/sapbackup' at location BrFileStatGet-1

BR0253E errno 13: Permission denied

BR0273E Determination of file status for /oracle/SID/102_64/sapbackup failed

but this doesnt happen daily...sometimes the backup is successful and sometimes its not...

i have scheduled the archive logs backup at 10:00 pm... if backup at 10:00pm is unsuccessful...then i usually take the backup at 9:30 am the next day...

what seems to be the problem? if the problem is of permission...then how backup is sometimes successful?

former_member206552
Active Contributor
0 Kudos

Good Day, Zeeshan

When facing issues it is always better to log a new thread than post on an old one.

How are all your backups executed, is it running from the crontab ?

are all the backups running as the same user ?

as a test do a

chmod -R 777 /oracle/SID/102_64/sapbackup

and rerun the bakcup

Best Regards

Marius


former_member182034
Active Contributor
0 Kudos

hi Madhu,

BR0252E Function stat() failed for '/oracle/QAS/112_64/bin/sqlplus' at location BrFileStatGet-1
BR0253E errno 13: Permission denied

plz follow this.

1. Login with user SIDadm and this user must be member of

ora_DBA

oraSID_oper

oraSIDdba with full control in the directory.

2. You also need to add the perrmisions on drive:\oracle\SID\102\database folder for SAPserviceSID user.

after above changes you will not face this error...

regards,

majamil

Former Member
0 Kudos

This is comman issue for all UNIX servers, if you serach on SAP marketplace you will get solutions. Check below notes.

Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Note 651351 - BR tools on UNIX: Error due to executable permissions