DB13 - UpdateStats Failing

[Former Member]

Hi there,

I have had the updatestats job falling over now for quite a long time on our devleopment system

after a kernel upgrade.

Anyone shed any light on it?

Any suggestions much appreciated

BR0801I BRCONNECT 7.20 (28)

BR0805I Start of BRCONNECT processing: celiryfs.sta 2013-06-04 08.00.12

BR0484I BRCONNECT log file: /oracle/DV1/sapcheck/celiryfs.sta

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

'ENABLE THREADS'

BR0806I End of BRCONNECT processing: celiryfs.sta 2013-06-04 08.00.12

BR0280I BRCONNECT time stamp: 2013-06-04 08.00.12

BR0804I BRCONNECT terminated with errors

[Former Member · Accepted solution]

Check SAP Note Note 1449619 if Your Oracle version is 11g

[Former Member]

Hi Andy,

Check your SAPXPG_DBDEST_<DATABASEServer> RFC connection is working properly. This is under TCP/IP Connection. If you are using Windows check ATAMAN or similar software whether entries are correct. As others have mention executing sapdba_role in database server is important. Other than that you should also schedule other housekeeping jobs running under DB13 make sure those are running fine.

All the best,

Zaki

[Reagan]

Hello

You must be having a problem with the Oracle instant client software.

If yes, update the Oracle instant client and use the latest BR-Tools

Good Luck

RB

[Former Member]

Hi Andy,

Did you run .saproot.sh SID from root user?  If not, please run it.

Secondly, try to login in as orasid and navigate to /sapmnt/SID/exe/ folder and run@sqlplus /nolog @sapdba_role.sql

This should fix your issue.

Thanks and Regards,

Vimal

[Former Member]

Hi Andy,

Please check Note 113747 - Owners and authorizations for BR*Tools

Did you run saproot.sh after kernel upgrade?

It is supposed to take care of the permissions.

Best Regards,

Anita

[former_member206552]

Hi Any,

can you please post the full

/oracle/DV1/sapcheck/celiryfs.sta

might just be authorizations at db level

Best Regards

Marius

[Former Member]

Hi Marius,

Its exactly the same content that I have already posted

i.e.

BR0801I BRCONNECT 7.20 (28)
BR0805I Start of BRCONNECT processing: celiryfs.sta 2013-06-04 08.00.12
BR0484I BRCONNECT log file: /oracle/DV1/sapcheck/celiryfs.sta
BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:
'ENABLE THREADS'

BR0806I End of BRCONNECT processing: celiryfs.sta 2013-06-04 08.00.12
BR0280I BRCONNECT time stamp: 2013-06-04 08.00.12
BR0804I BRCONNECT terminated with errors

[former_member206552]

Muhammed's note explains the error

sidadm> brconnect -u / -c -f stats -t all

BR0801I BRCONNECT 7.20 (1)

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

'ENABLE THREADS'

BR0806I End of BRCONNECT processing: cedbfuze.sta 2010-04-21 18.11.02

BR0280I BRCONNECT time stamp: 2010-04-21 18.11.02

BR0804I BRCONNECT terminated with errors

BR0280I BRCONNECT time stamp: 2010-04-21 18.15.12

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

'ENABLE THREADS'

Problem 1
---------
This problem is caused by a missing soft link (symbolic link) in $ORACLE_HOME/lib.
This soft link is required for SAP-internal make-technical reasons.

Problem 2
---------
Oracle client problem - This is solved in higher versions of Instant Client.
This problem may also occur on other platforms (for example, Linux).

Solution

Problem 1
---------
Create the missing soft link manually using the user ora<sid>:
> cd $ORACLE_HOME/lib
> ln -s libnnz11.so libnnz10.so
Note:
The soft link is no longer required for the version of BR*Tools 7.20 that is delivered with SAP Kernel 7.20_EXT. However, you can use this tool as of certain operating system versions only. (For more information about this, see Note 1638356.)

Problem 2
---------
Install Version 5 of Oracle Instant Client 10.2.0.4 (or higher) on the database server.
If you have installed Oracle Instant Client 11g and are still using the standard version of BR*Tools 7.20 (in other words, you are not using the 720_EXT tools), and if Oracle Instant Client 10g is not installed on the database server, you must also create the following soft link:
> cd /oracle/client
> ln -s 11x_64 10x_64