BRCONNECT error.

[Former Member]

Hello Gurus,

My problem is the following: we do not have data when executing transaction DB13 and when executing the commando brconnect, in order to check the connection, we obtain the following error:

brconnect -u / -c -f check

BR0801I BRCONNECT 6.40 (15)

BR0252E Function fopen() failed for '/oracle/NP1/920_64/dbs/initNP1.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading backup profile /oracle/NP1/920_64/dbs/initNP1.sap

BR0280I BRCONNECT time stamp: 2006-09-25 17.24.59

BR0301E SQL error -12545 at location db_connect-2

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

BR0310E Connect to database instance NP1 failed

BR0806I End of BRCONNECT processing: cdtorlup.log 2006-09-25 17.24.59

BR0280I BRCONNECT time stamp: 2006-09-25 17.24.59

BR0804I BRCONNECT terminated with errors

The file initNP1.sap exist but I don't have idea about "target host or object doesnot exist. How it could see if this defined correctly or what steps are necessary to define it?.

Thank you.

Regards.

Rafa R.R.

[Former Member]

Please assign points if any advice helped you solve your problem.

[Former Member]

Hi Cyrus,

Thank you for your help. Now brconnect work's fine but the problem with DB13 transaction continue.

I will continue investigating

Regards,

Rafa R.R.

[Former Member]

Hi Rafa,

From the log, it looks like you are running the brconnect with NPIadm user. Use the ora<SID> user and run brconnect or any other brtool.

Hope this helps

Cyrus

[Former Member]

Hi Mike,

Sorry, I have been confused when adding the data to post, was with several systems simultaneously. The problem this in NP1 and the file is initNP1.sap

SRM Server *****

npxpeb02:np1adm 21> brconnect -u / -c -f check

BR0801I BRCONNECT 6.40 (15)

BR0252E Function fopen() failed for '/oracle/NP1/920_64/dbs/initNP1.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading backup profile /oracle/NP1/920_64/dbs/initNP1.sap

BR0280I BRCONNECT time stamp: 2006-09-27 11.01.29

BR0301E SQL error -12545 at location db_connect-2

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

BR0310E Connect to database instance NP1 failed

BR0806I End of BRCONNECT processing: cdtozzjt.log 2006-09-27 11.01.29

BR0280I BRCONNECT time stamp: 2006-09-27 11.01.29

BR0804I BRCONNECT terminated with errors

npxpeb02:np1adm 22>

DB Server ***

-rw-rr 1 oranp1 dba 7008 Jan 10 2006 initNP1.sap

I have compared the content of this file with others servers in which the BRCONNECT works but I do not see differences.

Thanks and sorry again.

Regards,

Rafa R.R.

[Former Member]

Hi,

Yes, the owner is ora<SID>:

-rw-rr 1 orans1 dba 7008 Feb 6 2006 initNS1.sap

Regards,

Rafa R.R.

[Former Member]

Hi Rafa,

DB13/Brconnect is looking for initNP1.sap but not initNS1.sap that listed by you. Check whether it's a proper parameter file and rename it (if needed).

Have you recently changed the SID ? (seems like you have NS1 for system ID, but BRCONNECT/DB13 is set for NP1 system)

Regards,

Mike

Message was edited by: Mike Puzankov

[Former Member]

Hi,

Is ora<SID> the owner of the initNPI.sap file and are the permissions on the file correct?

[Former Member]

Looks like it cannot read your backup profile at 'oracle/NP1/920_64/dbs/initNP1.sap' . Check if the file is available and it'a accessible to your <SID>adm and ora<SID> users. (The file is placed on the SAP server where your DB instance is running)

Regards,

Mike