cancel
Showing results for 
Search instead for 
Did you mean: 

brconnect error

former_member199632
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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 !

former_member199632
Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member199632
Participant
0 Kudos

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

thiago_cavalheiro
Active Participant
0 Kudos

Hello zerandib,

You should check the permissions on /oracle/PI1/sapcheck since this is pointing to an OS issue. If you need help, please post the output of "ls-ltr /oracle/PI1/sapcheck" and "ls -ltr /oracle/PI1 | grep check".

Regards,

Thiago

former_member199632
Participant
0 Kudos

Hi Thiago,

    1. 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

    1. 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

former_member199632
Participant
0 Kudos

Any ideas.

Is the give permission alright?

thankx

thiago_cavalheiro
Active Participant
0 Kudos

Hi zerandib,

Kindly go through note [113747|https://service.sap.com/sap/support/notes/113747], since this is most likely a missing privilege on the OS level.

Best regards,

Thiago

Answers (2)

Answers (2)

jorge_velasquez
Contributor
0 Kudos

Hi,

How did you solve it?

I installed instant client 10.2.04 V5 and checked note 113747

Regards.

Former Member
0 Kudos

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