After Upgrade Oracle 10g to 11gBrtools 7.2 Stats gives SQL -2133 "Enable Threads"

[former_member590565]

After upgrading Oracle 10g to 11g, and BRTOOLS 7.0 to 7.2,

BRCONNECT -p init.sap E -f stats -t gives SQL error -2133 "Enable Threads"

All Sapnote pages were referred to but I am still having the error.

SAPNOTE pages referenced: 0113747,0012741,1428529,1430669,819929

So:

1. LD_LIBRARY_PATH=usr/sap/SYS/exe/run:/oracle/sid/112_64/lib:

/oracle/client/11x_64/instantclient:/oracle/client/10x_64/instantclient

2. Permissions are correct for sidadm,orasid br* (113747)

3. cd /oracle/client ln -s 11x_64 10x_64

4. cd $ORACLE_HOME/lib ln -s libnnz11.so libnnz10.so

5. ln -s $ORACLE_HOME/lib /oracle/client/11x_64/lib I also tried linking 10x_64/lib

Nothing is working.

Any ideas?

Thank you so much!

[fidel_vales]

Hello,

I'm going to start from the beginning as there are so many "things" going on.

You have upgraded from 10g to 11g.

Please upgrade your BR*Tools also. You are using version 7.20 patch 3 (or even 7.00), use 7.40 please.

Note => dboraslib is used by the SAP Kernel. Not by BR* tools. BR*tools is "part of the kernel" but at the same time "is not part of the kernel" as it can be updated to higher/different versions of it.
Your kernel (dboraslib) is using the oracle client from the ORACLE_HOME, not the instantclient. This points to a wrong configuration of your environment variables (SHLIB_PATH, LD_LIBRARY_PATH or LIBPATH depending on your OS)

BRCONNECT has hardcoded the instantclient path. your version do not uses the 11g but the 10g.

So, please, upgrade teh BRtools, review your client installation including environment variables, it does not matter if you have the "correct" instant client if you do not use it because the environment variables are not correct

[former_member590565]

Hi Fidel,

Thank you for looking at this. Realllllllllllllllllllly need your help!

1. Unfortunately, BRTOOLS 7.4 is not accessible. Using Rimini Street who does not have upgrade software. Further, BRTOOLS 7.2 works fine on our QAS system. Although, it does state,"Harmful Statistics" on occasion, the brtools stats command runs without error.

2.

echo $LD_LIBRARY_PATH=/usr/sap/PRD/sys/exe/run:/oracle/PRD/112_64/lib:/oracle/client/instantclient_11_2

LD_LIBRARY_PATH is set correctly.  Sun SPARC

3. You stated, "BRCONNECT has client hardcoded..." How do I undo this?

4. I definitely know it's related to the client. However, what is wrong?

Thanks.

[fidel_vales]

I do not know why 7.40 is not accessible. it should be available.

LD_LIBRARY_PATH is not set correctly. Take out the $ORACLE_HOME, so it uses the INSTANTCLIENT, instead of the "normal" client, please.

Before the "version and path" of the client was harcoded, now only the version is hardcoded. it cannot be changed. But you are not poining to the instant client.

also, you have to be sure that there is no other oracle client on the kernel directory (I have seen people copying all around and then the wrong one is used)

[former_member590565]

I changed the path of the LD_LIBRARY variable as you indicated and also reinstalled the 11.2 client (INSTANTCLIENT) in a directory called /oracle/client..

Now, the backups give an error message but still run..and also the STATS still gives the same error message -2133..

I attached a file with the print out of the results.

HELP!!!!!!!!!!!!!!!!!!!!!!!!!

Thank you.

ohnogoodstill.txt.zip

[fidel_vales]

hello,

the LD_LIBRARY_PATH still is "correct" because you did a mess installing the client.

it points to /oracle/client but your instant client should not be there. why have you not followed the note 819829.

On the attchment the error is related to SAPSECURLIB not to the initial issue

BR1301W Error message from likeywlib: 527 likey_init: Couldn't load SAPSECULIB ("/usr/sap/PRD/SYS/exe/run/libsapsecu.so") using function SsfSupInitEx (), rc = 5 (not all functions).
BR1301W Error message from likeywlib: 542 likey_init: At least one more attempt to load the SAPSECULIB will follow.
BR1301W Error message from likeywlib:
===...could not load SSF library libsapsecu.so
BR1301W Error message from likeywlib: 543 likey_init: Couldn't load SAPSECULIB ("libsapsecu.so") using function SsfSupInitEx (), rc = 10 (no library).
BR1301W Error message from likeywlib: 541 likey_init: Couldn't load SAPSECULIB. Giving up.
BR1302W Initialization of license key library likeywlib failed, return code 1
BR1304W Checking SAP license failed at location BrLicCheck-108
BR0602W No valid SAP license found - please contact SAP

for that reason it works.

your current issue probably is because the cripto lib is not on the DIR_LIBRARY path

[former_member590565]

/oracle/client/11x_64/instantclient_11_2/genezi -v ld.so.1: genezi: fatal: libclntsh.so.11.1: open failed: No such file or directoy Killed Look at this error..?

[JamesZ]

Hi Sarah,

Gaurav's suggestion should have worked.

Can you check which client version is being used? "genezi -v"?

Also can you attach the brconnect log?

Best regards,
James

[former_member590565]

Header 1

2133error.txt.zip

[former_member590565]

Client version is 11.2.0.4

client version.txt.zip

[former_member590565]

Any one out there??

No one has provided a solution as of yet..

Any ideas??

Thank you.

[Reagan]

Have you updated the BR*Tools?

The instant client used by SAP should be the one present in the client directory which is /oracle/client/11x_64. You should run the genezi -v from there.

The command you have run is most likely using the one (genezi) from the ORACLE_HOME/bin directory.

cd /oracle/client/11x_64/instantclient

The instantclient here should be a symbolic link to the correct instant client directory and if you have the upgraded the database to 11.2.0.4 it should be instantclient_11204

Execute the genezi -v from here to get the correct client version.

./genezi -v

Also check if the parameters are set as recommended.

The environment variable pointing to the Oracle Instant Client should be set for the <SID>adm user.

Run the statistics collection as ora<SID>

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

[former_member590565]

Hi,

Yes. BRTOOLS 7.2

--

I have attached Reagan.doc with the commands you suggested. => SAME error.

--

nogoodnews.txt.zip

[former_member590565]

correction..attached file is called nogoodnews.txt.

[former_member590565]

environmental variables (env.out) is attached also.

--

If you are saying there is an error in my link, please identify what link you would like to try?

[Reagan]

The trace file shows the brconnect patch level is 3 which I believe is not the latest.

The attached txt file shows the command "genezi -v" was executed from /oracle/client/11x_64

I believe the file genezi should be at /oracle/client/11x_64/instantclient location wherein the instantclient should be a symbolic link to the directory instantclient_11204

su - devadm

ls -la /oracle/client

ls -la /oracle/client/11x_64

ls -la /oracle/client/11x_64/instant*

/oracle/client/11x_64/instantclient/genezi -v

Run the above commands and provide the output.

[former_member590565]

ff

[former_member590565]

DEV:devadm 1% ls -la /oracle/client total 64 drwxr-x---  5 devadm  dba        8192 Jun 22 16:40 . drwxrwxr-x  23 oradev  dba        8192 Jun  1 13:58 .. lrwxrwxrwx  1 root    root          6 Jun 22 16:40 10x_64 -> 11x_64 drwxrwxr-x  3 oradev  dba        8192 Jun 22 15:38 10x_64_bak drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 11x_64 drwxr-xr-x  5 devadm  dba          96 May 12 15:34 92x_64 DEV:devadm 3% ls -la /oracle/client/11x_64 total 130768 drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 . drwxr-x---  5 devadm  dba        8192 Jun 22 16:40 .. -rw-r--r--  1 root    root        668 Jun 22 14:31 env.out -rw-r--r--  1 oradev  dba      66584354 May 27  2015 instantclient-basic-solap -rw-r--r--  1 oradev  dba      328113 May 27  2015 instantclient-odbc-solarip drwxr-xr-x  2 oradev  dba        8192 Jun 22 16:45 instantclient_11_2 DEV:devadm 4% ls -la /oracle/client/11x_64/instant* -rw-r--r--  1 oradev  dba      66584354 May 27  2015 /oracle/client/11x_64/inp -rw-r--r--  1 oradev  dba      328113 May 27  2015 /oracle/client/11x_64/insp /oracle/client/11x_64/instantclient_11_2: total 512544 drwxr-xr-x  2 oradev  dba        8192 Jun 22 16:45 . drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 .. -rw-rw-r--  1 oradev  dba          414 Aug 21  2013 BASIC_README -r-xr-xr-x  1 oradev  dba        91881 Aug 21  2013 ODBCRelnotesJA.htm -r-xr-xr-x  1 oradev  dba        44091 Aug 21  2013 ODBCRelnotesUS.htm -r-xr-xr-x  1 oradev  dba        19217 Aug 21  2013 ODBC_IC_Readme_Unix.html -rwxrwxr-x  1 oradev  dba        23792 Aug 21  2013 adrci -rwsrwxr-x  1 oradev  sapsys  6423320 May  6 11:04 brarchive -rwsrwxr-x  1 oradev  sapsys  6658440 May  6 11:04 brbackup -rwsrwxr-x  1 oradev  sapsys  8855472 May  6 11:04 brconnect -rwxr-xr-x  1 devadm  sapsys  7170888 May  6 11:04 brrecover -rwxr-xr-x  1 devadm  sapsys  2707576 May  6 11:04 brrestore -rwxr-xr-x  1 devadm  sapsys  9534560 May  6 11:04 brspace -rwxr-xr-x  1 devadm  sapsys  3283432 May  6 11:04 brtools -rwxrwxr-x  1 oradev  dba        41464 Aug 21  2013 genezi lrwxrwxrwx  1 oradev  dba          22 May 12 09:15 lib -> /oracle/DEV/112_64b lrwxrwxrwx  1 oradev  dba          17 Jun 22 14:55 libclntsh.so -> libclntsh1 -rwxr-xr-x  1 oradev  dba      23827400 Feb 23  2006 libclntsh.so.10.1 -rwxrwxr-x  1 oradev  dba      50268448 Aug 21  2013 libclntsh.so.11.1 lrwxrwxrwx  1 root    root          17 Jun 22 16:43 liblclntsh.so.10.1 -> lib1 -rwxr-xr-x  1 oradev  dba      6899544 Feb 23  2006 libnnz10.so -r-xr-xr-x  1 oradev  dba      8653320 Aug 21  2013 libnnz11.so -rwxr-xr-x  1 oradev  dba      1416856 Feb 23  2006 libocci.so.10.1 -rwxrwxr-x  1 oradev  dba      1545008 Aug 21  2013 libocci.so.11.1 -rwxrwxr-x  1 oradev  dba      118735824 Aug 21  2013 libociei.so -rwxr-xr-x  1 oradev  dba      123560 Feb 23  2006 libocijdbc10.so -r-xr-xr-x  1 oradev  dba      121800 Aug 21  2013 libocijdbc11.so -rwxrwxr-x  1 oradev  dba      756232 Aug 21  2013 libsqora.so.11.1 -r-xr-xr-x  1 oradev  dba        3732 Aug 21  2013 odbc_update_ini.sh -r--r--r--  1 oradev  dba      2091135 Aug 21  2013 ojdbc5.jar -r--r--r--  1 oradev  dba      2739616 Aug 21  2013 ojdbc6.jar -rwxrwxr-x  1 oradev  dba      177680 Aug 21  2013 uidrvci -rw-rw-r--  1 oradev  dba        66779 Aug 21  2013 xstreams.jar DEV:devadm 10% /oracle/client/11x_64/instantclient_11_2/genezi -v ld.so.1: genezi: fatal: libclntsh.so.11.1: open failed: No such file or directoy Killed

[former_member590565]

DEV:devadm 1% ls -la /oracle/client total 64 drwxr-x---  5 devadm  dba        8192 Jun 22 16:40 . drwxrwxr-x  23 oradev  dba        8192 Jun  1 13:58 .. lrwxrwxrwx  1 root    root          6 Jun 22 16:40 10x_64 -> 11x_64 drwxrwxr-x  3 oradev  dba        8192 Jun 22 15:38 10x_64_bak drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 11x_64 drwxr-xr-x  5 devadm  dba          96 May 12 15:34 92x_64 DEV:devadm 3% ls -la /oracle/client/11x_64 total 130768 drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 . drwxr-x---  5 devadm  dba        8192 Jun 22 16:40 .. -rw-r--r--  1 root    root        668 Jun 22 14:31 env.out -rw-r--r--  1 oradev  dba      66584354 May 27  2015 instantclient-basic-solap -rw-r--r--  1 oradev  dba      328113 May 27  2015 instantclient-odbc-solarip drwxr-xr-x  2 oradev  dba        8192 Jun 22 16:45 instantclient_11_2 DEV:devadm 4% ls -la /oracle/client/11x_64/instant* -rw-r--r--  1 oradev  dba      66584354 May 27  2015 /oracle/client/11x_64/inp -rw-r--r--  1 oradev  dba      328113 May 27  2015 /oracle/client/11x_64/insp /oracle/client/11x_64/instantclient_11_2: total 512544 drwxr-xr-x  2 oradev  dba        8192 Jun 22 16:45 . drwxr-xr-x  3 oradev  dba        8192 Jun 22 15:31 .. -rw-rw-r--  1 oradev  dba          414 Aug 21  2013 BASIC_README -r-xr-xr-x  1 oradev  dba        91881 Aug 21  2013 ODBCRelnotesJA.htm -r-xr-xr-x  1 oradev  dba        44091 Aug 21  2013 ODBCRelnotesUS.htm -r-xr-xr-x  1 oradev  dba        19217 Aug 21  2013 ODBC_IC_Readme_Unix.html -rwxrwxr-x  1 oradev  dba        23792 Aug 21  2013 adrci -rwsrwxr-x  1 oradev  sapsys  6423320 May  6 11:04 brarchive -rwsrwxr-x  1 oradev  sapsys  6658440 May  6 11:04 brbackup -rwsrwxr-x  1 oradev  sapsys  8855472 May  6 11:04 brconnect -rwxr-xr-x  1 devadm  sapsys  7170888 May  6 11:04 brrecover -rwxr-xr-x  1 devadm  sapsys  2707576 May  6 11:04 brrestore -rwxr-xr-x  1 devadm  sapsys  9534560 May  6 11:04 brspace -rwxr-xr-x  1 devadm  sapsys  3283432 May  6 11:04 brtools -rwxrwxr-x  1 oradev  dba        41464 Aug 21  2013 genezi lrwxrwxrwx  1 oradev  dba          22 May 12 09:15 lib -> /oracle/DEV/112_64b lrwxrwxrwx  1 oradev  dba          17 Jun 22 14:55 libclntsh.so -> libclntsh1 -rwxr-xr-x  1 oradev  dba      23827400 Feb 23  2006 libclntsh.so.10.1 -rwxrwxr-x  1 oradev  dba      50268448 Aug 21  2013 libclntsh.so.11.1 lrwxrwxrwx  1 root    root          17 Jun 22 16:43 liblclntsh.so.10.1 -> lib1 -rwxr-xr-x  1 oradev  dba      6899544 Feb 23  2006 libnnz10.so -r-xr-xr-x  1 oradev  dba      8653320 Aug 21  2013 libnnz11.so -rwxr-xr-x  1 oradev  dba      1416856 Feb 23  2006 libocci.so.10.1 -rwxrwxr-x  1 oradev  dba      1545008 Aug 21  2013 libocci.so.11.1 -rwxrwxr-x  1 oradev  dba      118735824 Aug 21  2013 libociei.so -rwxr-xr-x  1 oradev  dba      123560 Feb 23  2006 libocijdbc10.so -r-xr-xr-x  1 oradev  dba      121800 Aug 21  2013 libocijdbc11.so -rwxrwxr-x  1 oradev  dba      756232 Aug 21  2013 libsqora.so.11.1 -r-xr-xr-x  1 oradev  dba        3732 Aug 21  2013 odbc_update_ini.sh -r--r--r--  1 oradev  dba      2091135 Aug 21  2013 ojdbc5.jar -r--r--r--  1 oradev  dba      2739616 Aug 21  2013 ojdbc6.jar -rwxrwxr-x  1 oradev  dba      177680 Aug 21  2013 uidrvci -rw-rw-r--  1 oradev  dba        66779 Aug 21  2013 xstreams.jar DEV:devadm 10% /oracle/client/11x_64/instantclient_11_2/genezi -v ld.so.1: genezi: fatal: libclntsh.so.11.1: open failed: No such file or directoy Killed

[Reagan]

Your system is not correctly configured to use the Oracle Instant Client for SAP.

The environment variable is set to use /oracle/client/11x_64/instantclient and /oracle/client/10x_64/instantclient.

1 – There is no need to set both even though the 10x_64 is symbolic link to 11x_64

2 – it is looking for /oracle/client/11x_64/instantclient which is not existing under /oracle/client/11x_64. You can confirm that by running ls –la /oracle/client/11x_64/instantclient

3 – Follow the instructions to set up Oracle Instant Client as suggested in the note 1431794 - Oracle 11.2.0: Instant Client


4 – Download the Oracle client software from SAP and extract it using the SAPCAR tool.

Follow the steps shown below to extract and setup the client software.

[orahost:root:/:] su - devadm

orahost:devadm 1> cd /oracle/stage/CLIENT

orahost:devadm 2> ./SAPCAR -xvf OCL11264.SAR

SAPCAR: processing archive OCL11264.SAR (version 2.01)

x dbclient.lst

x instantclient_11204

x instantclient_11204/adrci

x instantclient_11204/classes12.jar

x instantclient_11204/genezi

x instantclient_11204/libclntsh.a

x instantclient_11204/libclntsh.so

x instantclient_11204/libnnz11.so

x instantclient_11204/libociei.so

x instantclient_11204/ojdbc14.jar

x instantclient_11204/ojdbc5.jar

x instantclient_11204/ojdbc6.jar

x instantclient_11204/wrc

x instantclient_11204/libnnz10.so

x instantclient_11204/SAPIC_README

SAPCAR: 15 file(s) extracted

orahost:devadm 3> logout

[orahost:root:/:] cd /oracle/stage/CLIENT

[orahost:root:/oracle/stage/CLIENT:] cp -rhp instantclient_11204 /oracle/client/11x_64

[orahost:root:/oracle/stage/CLIENT:] cd /oracle/client/11x_64

[orahost:root:/oracle/client/11x_64:] ls -la

total 16

drwxrwxr-x    4 devadm sapsys          256 Apr 30 12:07 .

drwxr-xr-x    4 root system          256 Feb  8 2013 ..

lrwxrwxrwx    1 devadm sapsys           19 Apr  2 08:14 instantclient -> instantclient_11203

drwxrwxr-x    2 devadm sapsys         4096 Feb  8 2013 instantclient_11203

drwxr-xr-x    2 devadm sapsys         4096 Jul  4 2014 instantclient_11204

[orahost:root:/oracle/client/11x_64:] su - devadm

orahost:devadm 1> cd /oracle/client/11x_64

orahost:devadm 2> rm instantclient

orahost:devadm 3> ln -s instantclient_11204 instantclient

orahost:devadm 4> ls -la

total 16

drwxrwxr-x    4 devadm sapsys          256 Apr 30 12:07 .

drwxr-xr-x    4 root system          256 Feb  8 2013 ..

lrwxrwxrwx    1 devadm sapsys           19 Apr 30 12:07 instantclient -> instantclient_11204

drwxrwxr-x    2 devadm sapsys         4096 Feb  8 2013 instantclient_11203

drwxr-xr-x    2 devadm sapsys         4096 Jul  4 2014 instantclient_11204

[former_member590565]

I will look at this on my test system.

--

However, on my PRD system, the genezi -v command works but I still get the -2132 when issue the stats command. Let's focus on this system since at least the client looks well here.

--

ash-3.2$ pwd /oracle/client bash-3.2$ cd instantclient_11_2 bash-3.2$ genezi -v Client Shared Library 64-bit - 11.2.0.4.0 System name:    SunOS Release:        5.10 Version:        Generic_150400-30 Machine:        sun4v Operating in ORACLE_HOME environment. Small timezone file = /oracle/PRD/112_64/oracore/zoneinfo/timezone_14.dat Large timezone file = /oracle/PRD/112_64/oracore/zoneinfo/timezlrg_14.dat bash-3.2$ --- LD_LIBRARY_PATH=PRD:prdadm 1% echo $LD_LIBRARY_PATH /etc/emc/rsa/cst/lib:/usr/sap/PRD/SYS/exe/run:/oracle/client/11x_64/instantclient Why is this happening? thanks.

[Former Member]

Hello,

Can you please cross check a few things again please.

1. brconnect -V (just want to be 100% sure you are using the latest)

2. cdexe ; ldd dboraslib.so (check the paths of the shared libraries being used. Do the paths and the libraries correspond to the path where you placed your latest oracle client ?)

3. What SBP level are you on after your upgrade ?

4. What is the patch level of your dboraslib ?

5. Even though you have run genezi, this tells you the version not the patch level. 11.2.0.4 also has patch levels. The SAPIC_README file will tell you something like 11.2.0.4 V?

KR,

Amerjit

[former_member590565]

1. brconnect -V (just want to be 100% sure you are using the latest) For PRD, I had to resort back to Brtools 7.0 because  7.2(3), caused the backups to fail. So: PRD:oraprd 27% brconnect -V BR0801I BRCONNECT 7.00 (44) Patch  Date    Info   1  2005-05-31  New check condition CRITICAL_TABLESPACE in BRCONNECT (note 849)   3  2005-07-26  Support for wildcards in BRCONNECT parameters (note 865365)   4  2005-07-26  Changes in collecting statistics for partitions (note 865366)   7  2005-10-26  Extended support for non-ABAP databases in BRCONNECT (note 892)   8  2005-10-26  Enhancements in statistics collection in BRCONNECT (note 89229) 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) 14  2006-05-23  Wrong exit code of BRARCHIVE and BRCONNECT (note 950787) 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 105) 26  2007-05-31  New BR*Tools command options (note 1060696) 27  2007-07-05  Further enhancements in collection of statistics (note 892296) 32  2008-02-05  Corrections for BR*Tools 7.00 patch 31 (note 1138968) 35  2008-07-29  SQL error ORA-01012 in BRCONNECT in offline backup (note 12359) 36  2008-07-29  Small functional enhancements in BR*Tools (2) (note 1235952) release note              849483 kernel release            700 patch date                2009-10-28 patch level                44 make platform              sun_64 make mode                  OCI_102 make date                  Oct 31 2009 PRD:oraprd 28% 2. cdexe ; ldd dboraslib.so (check the paths of the shared libraries being used. Do the paths and the libraries correspond to the path where you placed your latest oracle client ?) PRD:oraprd 28% cd exe exe: No such file or directory PRD:oraprd 29% cdexe PRD:oraprd 30% ldd dboraslib.so         libdl.so.1 =>    /lib/64/libdl.so.1         libnsl.so.1 =>  /lib/64/libnsl.so.1         libsocket.so.1 =>        /lib/64/libsocket.so.1         libclntsh.so.10.1 =>    /oracle/PRD/112_64/lib/libclntsh.so.10.1         libnnz10.so =>  /oracle/PRD/112_64/lib/libnnz10.so         libc.so.1 =>    /lib/64/libc.so.1         libmp.so.2 =>    /lib/64/libmp.so.2         libmd.so.1 =>    /lib/64/libmd.so.1         libscf.so.1 =>  /lib/64/libscf.so.1         libkstat.so.1 =>        /lib/64/libkstat.so.1         libresolv.so.2 =>        /lib/64/libresolv.so.2         libgen.so.1 =>  /lib/64/libgen.so.1         libsched.so.1 =>        /usr/lib/64/libsched.so.1         librt.so.1 =>    /lib/64/librt.so.1         libaio.so.1 =>  /lib/64/libaio.so.1         libpool.so.1 =>  /usr/lib/64/libpool.so.1         libadm.so.1 =>  /lib/64/libadm.so.1         libefi.so.1 =>  /lib/64/libefi.so.1         libm.so.2 =>    /lib/64/libm.so.2         libdoor.so.1 =>  /lib/64/libdoor.so.1         libuutil.so.1 =>        /lib/64/libuutil.so.1         libnvpair.so.1 =>        /lib/64/libnvpair.so.1         libexacct.so.1 =>        /usr/lib/64/libexacct.so.1         libxml2.so.2 =>  /usr/lib/64/libxml2.so.2         libuuid.so.1 =>  /lib/64/libuuid.so.1         libpthread.so.1 =>      /lib/64/libpthread.so.1         libz.so.1 =>    /usr/lib/64/libz.so.1         /platform/sun4v/lib/sparcv9/libc_psr.so.1         /platform/sun4v/lib/sparcv9/libmd_psr.so.1         /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2 PRD:oraprd 31% 3. What SBP level are you on after your upgrade ? QL*Plus: Release 11.2.0.4.0 Production on Fri Jun 24 15:14:35 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved. 4. Where is this readme file?

[Reagan]

I believe you have updated the BR*Tools to the latest version.

What happens when you collect the statistics from the OS level?

su - orasid

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

[former_member590565]

Same error if you issue Brconnect from the OS. Please see attached file.

--

Os version (see attached)

fromos.txt.zip

[former_member182657]

Hi Sarah,

After upgrading Oracle 10g to 11g, and BRTOOLS 7.0 to 7.2,

BRCONNECT -p init.sap E -f stats -t gives SQL error -2133 "Enable Threads"

Suggest you to follow SAP Note   1449619 - BR*Tools cannot be started on Oracle 11g

resolution for the issue.

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

Hope this will help you.

Regards,

Gaurav 

[former_member590565]

Hi Gaurav,

I already did that. See my #3 listed. No good. Doesn't work.

Any ideas?

Thanks.