on 10-26-2010 6:14 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.