on 12-19-2011 9:34 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
######################################################
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.