8 Replies Latest reply: Feb 7, 2012 6:27 PM by Thiago Cavalheiro RSS

brconnect error

Zerandib @
Currently Being Moderated

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

  • Re: brconnect error
    Prateek Yadav
    Currently Being Moderated

    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 !

    • Re: brconnect error
      Zerandib @
      Currently Being Moderated

      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

      • Re: brconnect error
        Prateek Yadav
        Currently Being Moderated

        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

        • Re: brconnect error
          Zerandib @
          Currently Being Moderated

          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

  • Re: brconnect error
    Venkata Pagolu
    Currently Being Moderated

    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

  • Re: brconnect error
    jorge velasquez
    Currently Being Moderated

    Hi,

     

    How did you solve it?

     

    I installed instant client 10.2.04 V5 and checked note 113747

     

    Regards.

Actions