on 02-22-2012 5:13 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bill,
If it was helpful, please send us feedback if solved problem.
Regards,
Jairo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.