Error while executing the table statistics using Brtools

[Former Member]

Dear Team,

We are getting ORA-01031: insufficient privileges error whenever we have tried to execute the update or table statistics using brtools on our SAP development server. I have checked the permissions of sapcheck directory and changed it to 775 still error remains the same. I have observed, it is failing to create the sta or chk files in sapcheck directory after executing update statistics using Brtools.

BR0291I BRCONNECT will be started with options '-p initDEV.sap -l E -f stats -t "USTUD" -p 1'

BR0280I BRTOOLS time stamp: 2010-07-20 12.02.33

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-07-20 12.02.34

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 6.40 (50)

BR0280I BRCONNECT time stamp: 2010-07-20 12.02.42

BR0301E SQL error -1031 at location BrLicCheck-12

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cedsegpe.log 2010-07-20 12.02.42

BR0280I BRCONNECT time stamp: 2010-07-20 12.02.42

BR0804I BRCONNECT terminated with errors

I have checked the owner for SAPUSER table and it is showing as OPS$DEVADM

Please, advise me on the same.

Thanks and Regards,

Kedar

[Former Member · Accepted solution]

Hi,

BR0301E SQL error -1031 at location BrLicCheck-12
ORA-01031: insufficient privileges

Please correct BRTools permissions as per below note. (read it carefully... Specially sticky bit)

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

If you still encounter errors, UPDATE YOUR BRTOOLS VERSION WITH LATEST ONE....

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Dear All,

Thanks for your responses.

Permissions are set as below for br* files.

sap-dev:devadm 23> ls -ltr br*

-rwxrwxr-x 1 oradev sapsys 3437688 Oct 31 2008 brarchive

-rwxrwxr-x 1 oradev sapsys 3547760 Oct 31 2008 brbackup

-rwxrwxr-x 1 oradev sapsys 4632408 Oct 31 2008 brconnect

-rwxrwxr-x 1 devadm sapsys 3850224 Oct 31 2008 brrecover

-rwxrwxr-x 1 devadm sapsys 1480656 Oct 31 2008 brrestore

-rwxrwxr-x 1 devadm sapsys 4837672 Oct 31 2008 brspace

-rwxrwxr-x 1 oradev sapsys 2175208 Oct 31 2008 brtools

I guess it is fine because with these set of permissions, it is working absolutely fine in my quality system.

QAS Permissions are as belows for your information

sap-qas:qa1adm 22> ls -ltr br*

-rwsrwxr-x 1 oraqa1 sapsys 3437688 Oct 31 2008 brarchive

-rwsrwxr-x 1 oraqa1 sapsys 3547760 Oct 31 2008 brbackup

-rwsrwxr-x 1 oraqa1 sapsys 4632408 Oct 31 2008 brconnect

-rwxrwxr-x 1 qa1adm sapsys 3850224 Oct 31 2008 brrecover

-rwxrwxr-x 1 qa1adm sapsys 1480656 Oct 31 2008 brrestore

-rwxrwxr-x 1 qa1adm sapsys 4837672 Oct 31 2008 brspace

-rwsrwxr-x 1 oraqa1 sapsys 2175208 Oct 31 2008 brtools

So do you feel still it has something to do with permissions?

Thanks and Regards,

Kedar

[Former Member · Accepted solution]

Hi Kedar,

Permissions are not same in DEV and QA..

Please notice it carefully (sticky bit...)

Below are correct permissions...

-rwsrwxr-x 1 oraqa1 sapsys 3437688 Oct 31 2008 brarchive

-rwsrwxr-x 1 oraqa1 sapsys 3547760 Oct 31 2008 brbackup

-rwsrwxr-x 1 oraqa1 sapsys 4632408 Oct 31 2008 brconnect

Not correct as per the sap note mentioned earlier..

rwxrwxr-x 1 oradev sapsys 3437688 Oct 31 2008 brarchive

-rwxrwxr-x 1 oradev sapsys 3547760 Oct 31 2008 brbackup

-rwxrwxr-x 1 oradev sapsys 4632408 Oct 31 2008 brconnect

-rwxrwxr-x 1 oradev sapsys 2175208 Oct 31 2008 brtools

So correct it as per the note...

Also both OPS$<SID>adm and OPS$ora<SID> with "connect, resource,sapdba" role must be exists in DBA_USERS table...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh,

Sorry for late reply. My problem is solved after correcting the permission for brconnect, brrestore and brarchieve files.

Thanks a lot for your help.

By the way, I would to know something about you on professional front if you wont mine.

Best Regards,

Kedar

[Former Member · Accepted solution]

you can drop me a mail...

See my business card for the same..

[JPReyes]

Read,

Note 700548 - FAQ: Oracle authorizations

Note 834917 - Oracle Database 10g: New database role SAPCONN

Regards

Juan

[ImtiazKaredia]

What are the permissions and owners of br* in /sapmnt/<SID>/exe

[Former Member]

currently in my system it is::

-rwxrwxr-x 1 oraec1 dba 2481056 Feb 21 2009 br*

but the it your oprating system would not have proper privillege then can't be able to execute the brtools. it fils in starting the brtools. though it filed at the time of calling the brconnect show it's lake of permission in database user..

thank & regard Anil Jaiswal

[Former Member]

Hi kedar

I think your OPS$ user not having the sufficient privilege for the backup action or the action you want to perform. plz go to your database prompt. if oracle then

logging sidadm user and

sqlplus "/as sysdba"

sql> grant connect ,resource, dba to ops$dev;

i think this may resolve your problem

[Former Member]

Dear Anil,

Even after changing the permissions, I am getting same error.

SQL> grant connect, resource, dba to OPS$DEVADM;

Grant succeeded.

###############################################################################

BR0801I BRCONNECT 6.40 (50)

BR0280I BRCONNECT time stamp: 2010-07-20 17.35.05

BR0301E SQL error -1031 at location BrLicCheck-12

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cedsfkcm.log 2010-07-20 17.35.05

BR0280I BRCONNECT time stamp: 2010-07-20 17.35.05

BR0804I BRCONNECT terminated with errors

###############################################################################

Please, advise on the same.

Or The only option is to create all the OPS$ users again for sidadm and orasid profiles.

Thanks and Regards,

Kedar