on 02-04-2012 5:30 AM
hi all,
'/usr/sap/TRN/SYS/exe/uc/linuxx86_64/brconnect -u / -c -o summary -f stats -o SAPSR3 -t all -p 2' exits with error code 5.
while installing SAP , im getting this error. Installation is unable to precede from here
What would be the issue?
brsonnect.log is as follows;;;;;
- - - - - - - - - - - - - - - - - - -
BR0801I BRCONNECT 7.10 (3)
BR0805I Start of BRCONNECT processing: cehukshe.sta 2012-02-02 10.56.10
BR0484I BRCONNECT log file: /oracle/TRN/sapcheck/cehukshe.sta
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.10
BR0813I Schema owners found in database TRN: SAPSR3*, SAPSR3DB%
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.11
BR0814I Number of tables in schema of owner SAPSR3: 19494
BR0836I Number of info cube tables found for owner SAPSR3: 82
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.12
BR0815I Number of indexes in schema of owner SAPSR3: 24961
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.13
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 100
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.13
BR0807I Name of database instance: TRN
BR0808I BRCONNECT action ID: cehukshe
BR0809I BRCONNECT function ID: sta
BR0810I BRCONNECT function: stats
BR0811I Owner of database schema for processing: SAPSR3
BR0812I Database objects for processing: ALL
BR0851I Number of tables with missing statistics: 0
BR0852I Number of tables to delete statistics: 0
BR0854I Number of tables to collect statistics without checking: 0
BR0855I Number of indexes with missing statistics: 0
BR0856I Number of indexes to delete statistics: 0
BR0857I Number of indexes to collect statistics: 0
BR0853I Number of tables to check (and collect if needed) statistics: 19494
BR0846I Number of threads that will be started in parallel to the main thread: 2
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.13
BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 19494/3
BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 460/0
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.13
BR0301E SQL error -2132 at location thr_db_connect-3, SQL statement:
'ENABLE THREADS'
SQL-02132: Unable to allocate runtime context sdfla asdjklfajs jfja ajsdf
BR0310E Connect to database instance TRN failed
BR0806I End of BRCONNECT processing: cehukshe.sta 2012-02-02 10.56.13
BR0280I BRCONNECT time stamp: 2012-02-02 10.56.13
BR0804I BRCONNECT terminated with errors
Is it error with brtools?
when i execute this seperatly from ora<sid>
'/usr/sap/TRN/SYS/exe/uc/linuxx86_64/brconnect -u / -c -o summary -f stats -o SAPSR3 -t all
(that is without "-p 2")
is says... BRCONNECT Completed successfully.
But in the installation is it possible to remove "-p 2" ?
Even after executing that separately and retrying... still give that error
kindly help.
regards,
Zerandib
Greetings,
BR0301E SQL error -2132 at location thrdb_connect-3, SQL statement:_
'ENABLE THREADS'
SQL-02132: Unable to allocate runtime context sdfla asdjklfajs jfja ajsdf
BR0310E Connect to database instance TRN failed
You need to 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
More Info : SAPnote: 1449619
Enjoy !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi prateek_y,
From which user should i try out this;
> cd /oracle/client
> ln -s 11x_64 10x_64
Is it root? ora<sid>? or <sid>adm
While doing with ora<sid> , it issues a permission denied message
and then i have done this with <sid>adm
The link created, but seems no success yet
any suggestions
regards,
zerandib
Did you check the SAPnote given in the first post... by the way user needs to be oraSID.. and group needs to be dba
However read the below SAPnote to get more information on how to create the soft links.. in UNIX and Linux .. Even we have the same envrioment and we have the lsoft link..
SAPnote 819829: Oracle Instant Client Installation and Configuration on Unix
Hi prateek,
I was able to create the soft link using ora<sid>. Its got created
(mean while, we have upgrade our brtools version 7.10 to 7.20)
(Not to 7.20_EXT)
But still hangs in the same position with following error
'/usr/sap/PI1/SYS/exe/uc/linuxx86_64/brconnect -u system/manager -c -f stats -t system_stats' exits with error code 3
brconnect.log is as follows
- - - - - - -
BR0801I BRCONNECT 7.20 (22)
BR0805I Start of BRCONNECT processing: cehvftdi.sta 2012-02-06 17.37.22
BR0252E Function fopen() failed for '/oracle/PI1/sapcheck/cehvftdi.sta' at location main-6
BR0253E errno 13: Permission denied
BR0121E Processing of log file /oracle/PI1/sapcheck/cehvftdi.sta failed
BR0806I End of BRCONNECT processing: cehvftdi.sta 2012-02-06 17.37.22
BR0280I BRCONNECT time stamp: 2012-02-06 17.37.22
BR0804I BRCONNECT terminated with errors
I have done steps as Note 134592 - Importing the SAPDBA role (sapdba_role.sql)
pls guide..., what further actions needs to be done?
Is this error relavent to brtools or issue with permissions in files,folders
regards,
zerandib
Edited by: zerandib on Feb 6, 2012 7:54 AM
Hi Thiago,
ls -ltr /oracle/PI1/sapcheck*
total 36
-rw-rr 1 orapi1 dba 410 Feb 6 01:13 cehvcjvx.sta
-rw-rr 1 orapi1 dba 410 Feb 6 01:14 cehvcjwa.sta
-rw-rr 1 orapi1 dba 410 Feb 6 01:49 cehvcmzj.sta
-rw-rr 1 orapi1 dba 410 Feb 6 01:50 cehvcnbg.sta
-rw-rr 1 orapi1 dba 410 Feb 6 13:06 cehvevcb.sta
-rw-rr 1 orapi1 dba 410 Feb 6 13:30 cehvexeo.sta
-rw-rr 1 orapi1 dba 410 Feb 6 14:08 cehvfapj.sta
-rw-rr 1 orapi1 dba 94 Feb 6 14:22 connPI1.log
-rw-rr 1 orapi1 dba 1817 Feb 6 14:22 cehvfbqv.sta
ls -ltr /oracle/PI1 | grep check*
drwxr-xr-x 2 orapi1 dba 4096 Feb 6 15:51 sapcheck
Is the above permissions are alright all , do i need to do any modifications
regards,
zeranddib
Hi,
How did you solve it?
I installed instant client 10.2.04 V5 and checked note 113747
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go through below note. Hope this helps you.
SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA
Regards,
Venkata S Pagolu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.