brtools statistic error as <sid>adm in Oracle 11g

[Former Member]

When running brtools statistics as <sid>adm I get this error. When I run it as ora<sid> I do not get this error.

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

I have oracle client setups in

/oracle/client/10x_64

/oracle/client/11x_64

I have 2 Oracle databases on the Linux(Redhat) server - one version 10.2.0.4 & the other version 11.2.0.2.

Any advice on what I should be looking at to fix this error?

[jairo_pedroza · Accepted solution]

Hello Bill,

I faced exactly with the same problem during Oracle Upgrade to 11g

Solution:

You should keep both instant client version ( Instant client 10g and 11g )

Update your Oracle instant client 10.2.0.4 V5

Create symbolic link

ln -s /oracle/client/11x_64 /oracle/client/10x_64

I hope it help you!

Regards,

Jairo Pedroza

[Former Member · Accepted solution]

Thanks!

[jairo_pedroza]

Hello Bill,

If it was helpful, please send us feedback if solved problem.

Regards,

Jairo

[Former Member]

Problem was solved...

Solution:

You should keep both instant client version ( Instant client 10g and 11g )

Update your Oracle instant client 10.2.0.4 V5

Create symbolic link

ln -s /oracle/client/11x_64 /oracle/client/10x_64

[Former Member]

Hi Bill

This solving way could not solve my problem.

I have still the same problem.

Also when creat symbolic link the result was;

ln: creating symbolic link `/oracle/client/10x_64/11x_64': File exists

Any idea?

Regards,

Emrah

[former_member182034]

hi Bill,

please check following note.

Note 1449619 - BR*Tools cannot be started on Oracle 11g

Problem 2
---------
The BRCONNECT statistic function cannot be started on Oracle 11g and under the user <sid>adm on Unix platforms. Directly after you call BRCONNECT, a termination occurs with one of the following SQL error messages, for example:

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
solution:
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

Regards

Edited by: majamil on Feb 22, 2012 10:39 PM

[Former Member]

pwd

/oracle/client

ls -l

lrwxrwxrwx 1 orapr1 dba 5 Feb 22 10:52 10x64 -> 11x64

drwxrwxr-x 3 pr1adm sapsys 4096 Feb 22 10:04 10x_64

drwxrwxr-x 3 orapr1 dba 4096 Feb 18 22:36 11x_64

I still get the same error.

This did not help.

[Former Member]

Typo in the link I created.

DId it again..

ln -s 11x_64 10x_64

ln: creating symbolic link `10x_64/11x_64' to `11x_64': File exists

I believe this is the link that already exists:

cd /oracle/client/10x_64

11x_64 -> /oracle/client/11x_64

[former_member182034]

hi Bill,

check following link

[BR0301E SQL error -2133|http://forums.sdn.sap.com/thread.jspa?threadID=1836506]

Regards,

[Former Member]

This link did not help.

[former_member188883]

Hi Bill,

Ideally brtools should be run with user ora<sid>. It has all the necessary rights to execute br* commands on Unix platform for Oracle database.

Regards,

Deepak Kori

[Former Member]

In DB13 brtools is run as <sid>adm

[former_member188883]

Hi Bill,

I recommend using the most recent 7.20 brtools version AND run saproot.sh SID after changing them to make sure the file permissions are correct.

Regards,

Deepak Kori

[Former Member]

I am using 720(15) and the permissions are correct...

-rwsrwxr-x 1 orapr1 sapsys 5600163 Feb 21 09:44 brarchive

-rwsrwxr-x 1 orapr1 sapsys 5723514 Feb 21 09:44 brbackup

-rwsrwxr-x 1 orapr1 sapsys 7394871 Feb 21 09:44 brconnect

-rwxr-xr-x 1 pr1adm sapsys 6146726 Feb 21 09:44 brrecover

-rwxr-xr-x 1 pr1adm sapsys 2286175 Feb 21 09:44 brrestore

-rwxr-xr-x 1 pr1adm sapsys 7820617 Feb 21 09:44 brspace

-rwxr-xr-x 1 pr1adm sapsys 3145351 Feb 21 09:44 brtools