Update statistics with ora<sid> not working with parallel degree option.

[Former Member]

Hi All,

We are facing strange problem. When we are executing update stats in our 11g oracle database with sun os 5.10 using below command with <sid>adm user we are able to execute the command without any problem

brconnect -c -u / -f stats -t all -f collect -p 4 - It is working with user <sid>adm

BUT

When we use same command with user ora<sid> it just get killed

With ora<sid>

brconnect -c -u / -f stats -t all -f collect -p 4

08.02.32

BR0881I Collecting statistics for table SAPERP./ASU/SSMCONTENTP with method/sample C ...

BR0280I BRCONNECT thread 2: time stamp: 2011-03-11 08.02.32

BR0884I Statistics collected for table: SAPERP./ASU/SCMATASKLST, rows old/new: 0/0

BR0280I BRCONNECT thread 2: time stamp: 2011-03-11 08.02.32

BR0881I Collecting statistics for table SAPERP./ASU/SSMFOLDR with method/sample C ...

BR0280I BRCONNECT thread 8: time stamp: 2011-03-11 08.02.32

BR0884I Statistics collected for table: SAPERP./ASU/SSMCONTENTP, rows old/new: 1/1

BR0280I BRCONNECT thread 8: time stamp: 2011-03-11 08.02.32

BR0881I Collecting statistics for table SAPERP./ASU/SSMFOLDRCND with method/sample C ...

Killed

We have database and application on different server and database administrator use ora<sid> for stats update

We have check the env and profiles. But of no use.

Please let us know what could have gone wrong.

Regards

[Former Member]

Hi,

Can you paste the permissions for all br* executables.

and could you paste the init<SID.sap file

Mark

[Former Member]

Hi,

Thanks for the reply.

Please find below brtools details.

-rwxr-xr-x 1 rd4adm sapsys 2481056 Feb 20 2009 brrestore

-rwxr-xr-x 1 rd4adm sapsys 3097024 Feb 22 2009 brtools

-rwsrwxr-x 1 orard4 sapsys 5754056 Feb 24 2009 brarchive

-rwsrwxr-x 1 orard4 sapsys 5915128 Feb 24 2009 brbackup

-rwsrwxr-x 1 orard4 sapsys 7779376 Feb 24 2009 brconnect

-rwxr-xr-x 1 rd4adm sapsys 6276704 Feb 24 2009 brrecover

-rwxr-xr-x 1 rd4adm sapsys 8099288 Feb 24 2009 brspace

I can not provide the .sap file due to security. But please let me know if you are looking for some specific parameters. I will provide you the same.

Thanks

Deepak

[former_member204746]

have you read my previous answer?

you are NOT using latest BRTOOLS:

kernel release 700
patch date 2009-01-28
patch level 40

that is over 2 years old.

You should update it first, then we will be able to try to help you.

[Former Member]

I agree with ERIC, upgrade BRTOOLS package first, install them and set permissions as owner oraSID and group SAPSys.

brarchive, brbackup, and brconnect have permission 4775:

-rwsrwxr-x ora<sid> sapsys ...

These can be started by the ora<sid> or the <sid>adm OS user.

brrestore, brrecover, brspace, brtools, and sapdba have permission 755:

-rwxr-xr-x <sid>adm sapsys ...

These should only be started by the ora<sid> OS user.

And then:

use command brtools > update stats> parallel threads --> enter number and enter the parallel thread and enter c to continue.

If there is any issue with the brtools it will show you the error right away and paste the error here.

Regards

SM

[Former Member]

Hi,

We have oracle 11g and as per sap note we must go for the highest brtools patch (i.e. 7.20). At present we have SAP Kernel 7.01. I tried to search brtools as below

Support Packages and Patches > SAP KERNEL 64-BIT UNICODE" > SAP KERNEL 7.01 64-BIT UNICODE

> Solaris on SPARC 64bit > ORACLE

But i could not able to find the brtools patch

BUT

When i checked as below

Support Packages and Patches > SAP KERNEL 64-BIT UNICODE > SAP KERNEL 7.20 64-BIT UNICODE >

Solaris on SPARC 64bit > ORACLE

File > DBATL720O10_13-20005274.SAR - File found.

I could able to find the file.

My questions are

Can i use the file DBATL720O10_13-20005274.SAR alone with kernel 7.01?

Is there latest BRTOOLS file available for Kernel 7.01?

Is BRTOOLS version is depend on SAP Kernel version ?

Please reply

[Former Member]

Yes you can use the latest BRTools with 7.01 and 7.1 Kernel.

Thanks,

Naveed

[Former Member]

Can i use the file DBATL720O10_13-20005274.SAR alone with kernel 7.01? ==> Yes . You have to use 720 with 11g

Is there latest BRTOOLS file available for Kernel 7.01? ==> No . There is no brtools released for 7.01,7.10 etc. use brtools 7.10,7.20 depending of your Oracle. Better use the latest version.

Is BRTOOLS version is depend on SAP Kernel version ? ==> No

Thanks

Prince Jose

[Former Member]

Refer OSS Note 1449619 - BR*Tools cannot be started on Oracle 11g - Problem 1

Best, -Sudheer

[former_member204746]

try with - p 3

also try to update BRTOOLS.

[Former Member]

Hi,

Thanks for reply. We have latest brtools. It is not working with -p 3 also.

The main concern is the difference between <sid>adm & ora<sid>

As i mentioned with <sid>adm we can run -p 8

but

with ora<sid> we can not run -p 3 OR -p4 or even -p 2

Regards

BR0651I BRTOOLS 7.00 (40) Patch Date Info 10 2006-01-05 BR*Tools fail due to SAP license problems (note 912969)

11 2006-01-11 Small functional enhancements in BR*Tools (note 914174)

13 2006-03-29 BR*Tools support for MDM databases (note 936665)

16 2006-08-11 BR*Tools start error: library libnnz10 not found (note 972136)

20 2006-11-24 Extended support for system copy in BR*Tools (note 1003028)

24 2007-03-01 BR*Tools support for Oracle 10g RAC (note 1033126)

25 2007-04-26 BR*Tools failing with ORA-01455 for database > 16 TB (note 1050329)

26 2007-05-31 New BR*Tools command options (note 1060696)

36 2008-07-29 Small functional enhancements in BR*Tools (2) (note 1235952) release note 849483

kernel release 700

patch date 2009-01-28

patch level 40

make platform sun_64

make mode OCI_102

make date Feb 21 2009

[former_member204746]

you are NOT using latest BRTOOLS:

kernel release 700

patch date 2009-01-28

patch level 40

that is over 2 years old.

[former_member182505]

Hi,

Have you updated your kernel and DBA tools ?

and ran the saproot.sh SID after all.

thanks

sadiq

[Former Member]

Hi

Thanks for the reply.

I can run stats using <sid>adm but the problem is with ora<sid>. If the problem is due to brtools then it should be same for <sid>adm also. Why only for ora<sid>?