BRconnect Error

[Former Member]

Hi,

I am getting BRconnect error with this external pgm Background job...

log....................

Job started

Step 001 started

External command: BRCONNECT

Related parameter: -c -u / -f stats -t all -f collect -p 16

Ext. prog.: BR0801I BRCONNECT 7.00 (41)

Ext. prog.: BR0252E Function fopen() failed for '/oracle/client/10x_64/instantclient/dbs/initSID.sap' a

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

Ext. prog.: BR0159E Error reading BR*Tools profile /oracle/client/10x_64/instantclient/dbs/initSID.sap

Ext. prog.: BR0280I BRCONNECT time stamp: 2011-02-16 05.53.48

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: cefgafxk.log 2011-02-16 05.53.48

Ext. prog.: BR0280I BRCONNECT time stamp: 2011-02-16 05.53.48

Ext. prog.: BR0804I BRCONNECT terminated with errors

Ext. prog.: External program terminated with exit code 3

Ext. prog.: SAPXPG started on bslcrmprdci_BCP_02, Process ID 880732, Process Number 39

External program was cancelled

Job cancelled

I have no dbs directory in tis path...

/oracle/client/10x_64/instantclient/dbs/initSID.sap

Please help in priority...

Regards,

SIva

Edited by: skreddy555 on Feb 17, 2011 1:57 PM

[Former Member]

check the soft links in /oracle/client/10x_64 directory

[Former Member]

First check the current variable value with env command, Post that you have to correct the variable (ORACLE_HOME) with setenv or export commands.

Regards,

Nick Loy

[Former Member]

Hi,

My ORA_HOME is /oracle/SID/102_64 means coorect...

my question is BRconnect is looking for .sap file in another directory not in ORA_HOME path...

wre it is reading this parameter???

please help

Rgds,

Siva

[ashish_vikas]

Hello,

Can you try to run brtools manually from unix level and check if it starts ? Also start Brconnect Job from CI in SAP. Does it works ?

For what users Brconnect works from OS level .. sidadm/orasid/service.. check and get some clueu.

thanks

ashish

[Former Member]

For a workaround just create a directory dbs and copy your initSID.sap from original to this directory and check.

Reply this mail with more details from where you are running BRCONNECT and what is the env that you are using to connect?

Error seems with job configuraion with wrong Oracle home path.

Regards,

Nick Loy

[Former Member]

Hi,

Juss guide wre to set the ORA_HOME path...

or

tis is reading any of the file..

can i set env path using SETENV/EXPORT??

Regds,

Siva

[Former Member]

Check environment variables.

I suspect ORACLE_HOME is wrong.