Thursday, November 10, 2011

DB13 update stats will fail with error

In this scenario update stats was never successful and failed with error :

BR0301E SQL error -2132 at location thr_db_connect-3, SQL statement:
'ENABLE THREADS'


we checked the brtools permissions in /sapmnt/BIP/exe and they were wrong

SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA provides permissions for brtools, they are as follows :

brarchive, brbackup, and brconnect have permission 4775:
-rwsrwxr-x ora sapsys ...
These can be started by the ora or the adm OS user.

brrestore, brrecover, brspace, brtools, and sapdba have permission 755:
-rwxr-xr-x adm sapsys ...
These should only be started by the ora OS user.

No comments: