error after upgrade to 11.2.0.3

[Former Member]

Hello all,

I just upgrade my oracle DB from 11.2.0.1 to 11.2.0.3... the upgrade went totaly fine and SAP was brought up and validated....everything works fine except brconnet...

I was able to run brconnect before the upgrade without any issue, but after the uprade we are having below issue...

i have already checked Note 1449619 - BR*Tools cannot be started on Oracle 11g  but that dont seem to help....i am trying to run this as ORA<SID> user...orasid or sidadm both dont work....sapcheck permission are 775.... and also the link under $ORACLE_HOME/lib  exist as the doc points out....any help would be appreciated...

dev535:orab2d 16> id

uid=10293(orab2d) gid=101(dba) groups=104(oper),107(sapinst)

dev535:orab2d 17>

dev535:orab2d 17> brconnect -u / -c -f stats -t system_stats

BR0801I BRCONNECT 7.20 (22)

BR0805I Start of BRCONNECT processing: ceixrjkp.sta 2012-07-05 23.08.31

BR0484I BRCONNECT log file: /oracle/b2d/sapcheck/ceixrjkp.sta

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

'ENABLE THREADS'

BR0806I End of BRCONNECT processing: ceixrjkp.sta 2012-07-05 23.08.31

BR0280I BRCONNECT time stamp: 2012-07-05 23.08.31

BR0804I BRCONNECT terminated with errors

dev535:orab2d 18>

dev535:orab2d 18> ls -ltr /usr/sap/

total 50

-rwxr-x---   1 root       sapsys         185 May 26  2010 sapservices.1

-rwxr-x---   1 root       sapsys         360 Jul 15  2010 sapservices.2

drwxr-xr-x   2 root       root            96 Aug 12  2010 lost+found

-rwxr-x---   1 root       sapsys         535 Oct 26  2010 sapservices.3

-rwxr-x---   1 root       sapsys         536 Nov  8  2010 sapservices.4

drwxrwxrwx  17 b1dadm     sapinst      12288 Mar 19  2011 put

drwxrwxr-x   6 root       sapsys          96 Mar 19  2011 ccms

-rwxr-xr-x   1 root       sapsys         711 Mar 19  2011 sapservices

-rw-r--r--   1 b1dadm     sapsys        2012 Jun  2  2011 tmp\DOWNTIMEMAINTENANCERESULTS.XLS

-rw-r--r--   1 b1dadm     sapsys        2012 Jun  2  2011 tmp\DOWNTIME.XLS

drwxr-xr-x   4 b2dadm     sapsys          96 Jun 14 19:06 B2D

drwxrwxr-x   4 root       sapsys        2048 Jul  5 21:48 tmp

[Former Member]

First Please upgrade your instant client to 11.2.0 version . Note -: 819829

Check the output of brtools -V , if the output of  make mode  is OCI_102 then please follow the notes -:  1449619 an create the necessary soft link.

Also, All the environment variables should be set as per the note -: 602843  especially the LD_LIBRARY_PATH should point to the appropriate instantclient directory

[Former Member]

Just wanted to put the solution that i found out there for the community...

found out brconnect was owned by a different user....after chaning owner ship back it worked....

[Former Member]

forgot to mention our Oracle Client is V5 10.2.0.4