Skip to Content
avatar image
Former Member

BR Connect Error for the job

Hi,

I am scheduling the job for ORADICSTATS and am getting error as below,

Step 001 started

External command: BRCONNECT

Related parameter: -u / -c -f stats -t oradict_stats

Ext. prog.: BR0801I BRCONNECT 7.40 (6)

Ext. prog.: BR0252E Function fopen() failed for '/oracle/client/11x_64/instantclient/dbs/init<SID>.sap' a

Ext. prog.: BR0253E errno 2: No such file or directory

Ext. prog.: BR0159E Error reading BR*Tools profile /oracle/client/11x_64/instantclient/dbs/init<SID>.sap

Ext. prog.: BR0280I BRCONNECT time stamp: 2014-09-15 11:20:46

Ext. prog.: BR0301E SQL error -12545 at location db_connect-2, SQL statement:

Ext. prog.: 'CONNECT /'

Ext. prog.: ORA-12545: Connect failed because target host or object does not exist

Ext. prog.: BR0310E Connect to database instance <SID> failed

Ext. prog.:

Ext. prog.: BR0806I End of BRCONNECT processing: ceotfkta.log 2014-09-15 11:20:46

Ext. prog.: BR0280I BRCONNECT time stamp: 2014-09-15 11:20:46

When checked the init<SID>.sap file is available under /oracle/<SID>/112_64/dbs.

Kindly help me to resolve this issue.

Thanks in advance.

Regards,

Anand

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2014 at 09:06 AM

    Hi,

    Issue is solved after maintaining the database server name in the Job step definition.

    Thank you.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2014 at 12:19 PM

    Is this is a distributed setup ?

    Could you supply the environment variables of the ora<SID> user on the host where the job was executed ?

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Anand,

      Can you try to run this directly at OS level of the database host and check if it works there with sidadm user

      brconnect -u / -c -f stats -t oradict_stats.

      If yes, then there might be some mismatch and environment variables are not correctly getting mapped at SAP level.

      In SM49/69 , you can test this. Create a sap command with utility "env" and run at remote db host using SAPXPG RFC, and check if any mismatch with the same command fired at os level.

      Thanks

      Amit

  • avatar image
    Former Member
    Sep 17, 2014 at 12:32 PM

    Hi Anand,

    Ext. prog.: BR0252E Function fopen() failed for '/oracle/client/11x_64/instantclient/dbs/init<SID>.sap' a

    As you you know, this path is incorrect. It should pick the file from /oracle/<SID>/112_64/dbs

    If you are running the job from DB13, then its using the envrionment variables of user sidadm to trigger the job

    Can you check the value of ORACLE_HOME environment variable and PATH variable and provide it here for user sidadm and orasid

    Thanks

    Amit

    Add comment
    10|10000 characters needed characters exceeded