Skip to Content
author's profile photo Former Member
Former Member

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

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Feb 22, 2012 at 06:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 22, 2012 at 05:23 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      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

  • Posted on Feb 22, 2012 at 05:34 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 22, 2012 at 07:38 PM

    Hello Bill,

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

    Regards,

    Jairo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.