cancel
Showing results for 
Search instead for 
Did you mean: 

Update stats Error

Former Member
0 Kudos

Hi ,

I am getting below Error in update optimizer statistics in DB13. However i am able to run stats update with help of Brtools.

this error comes after oracle upgrade from 10.0.2.4 to 11.2.0.2.0. if anyone faced this error , please share resolution.

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

Execute logical command BRCONNECT On host

Parameters: -u / -jid STATS20111219225543 -c -f stats -t ALL

BR0801I BRCONNECT 7.00 (51)

BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:

'ENABLE THREADS'

BR0806I End of BRCONNECT processing: cehmarhv.sta2011-12-19 22.55.43

BR0280I BRCONNECT time stamp: 2011-12-19 22.55.43

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Br

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

As mentioned by above techie

BR0801I BRCONNECT 7.00 (51)

Update your BR* tools with 720 and then follow the note mentioned above.

It's a well known error and easily can sorted out if you follow the standards (SAP Notes).

Regards,

Nick Loy

Answers (4)

Answers (4)

Former Member
0 Kudos

Required Changes done are as below :-

1. Brtools update as version 7.20

2. Softlink creation as per sap note 1449619

Platform HP-UX IA64:

> cd /usr/lib/hpux64

> ln -s /oracle/client/10x_64/instantclient/libclntsh.so.10.1 .

Former Member
0 Kudos

Hi

That was the solution:

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

Required Changes done are as below :-

1. Brtools update as version 7.20

2. Softlink creation as per sap note 1449619

Platform HP-UX IA64:

> cd /usr/lib/hpux64

> ln -s /oracle/client/10x_64/instantclient/libclntsh.so.10.1 .

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

Former Member
0 Kudos

> BR0801I BRCONNECT 7.00 (51)

> BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:

> 'ENABLE THREADS'

First let's update the BR*Tools to 7.20 and then try the mentioned note.

And what is the OS ?

Thanks

Former Member
0 Kudos

> BR0801I BRCONNECT 7.00 (51)

> BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:

> 'ENABLE THREADS'

First let's update the BR*Tools to 7.20 and then try the mentioned note.

And what is the OS ?

Thanks

Former Member
0 Kudos

Hi,

Check the note "1449619 - BR*Tools cannot be started on Oracle 11g" and search for "Problem 2" string.

You'll find the answer right there

Best regards,

Orkun Gedik

Former Member
0 Kudos

Thank Orkun ,

i tried mentioned solution (Problem Type 2) but still its not resolving my issue and getting same error.

with ORASID brconnect working fine , but with SIDADM its still giving same error .

Br

Gyan

former_member188883
Active Contributor
0 Kudos

Hi Gyaan,

Did you apply latest SAP bundles patches for Oracle 11.2.0.2 . Many of these issues are rectified in these patches.

Let me know the results please.

Regards,

Deepak Kori

Former Member
0 Kudos

> with ORASID brconnect working fine , but with SIDADM its still giving same error .

So, this time you tried - 'sidadm> brconnect -u / -c -f stats -t all' or 'DB 13' ?

Thanks

Former Member
0 Kudos

Hi ,

I was tried in both way , from DB13 as well as sidadm> brconnect -u / -c -f stats -t all' . but same error

ok , let me update Brtools also .

Br

Gyan