Run the brtools from Central Instance Failed

[Former Member]

hi All,

currently i'm just finished my installation for CI and DB in the different server, but i'm having an error when i'm trying to run brtools in the CI Server using <SID>adm user, but if i running in DB Server it works fine, is there any step i must do to prevent the error run in Central Instance? thanks.

Best Regards

Hariyono

[Former Member]

Hi,

There is maybe some parameter or profile related issue may be because of this you are not able to run the BRTOOLS but i also had the same issue with my server and i got the solution here.. You also try this will definitely work for you..

If not, please update here, we would glad to help you.

[Former Member]

hi All,

the question is answered now :

- brtools only can run in database instance not in application instance

- to able run the job in db13 we need to adjust the job below

a. set the DEFAULT.PFL -> SAPDBHOST = DATABASE HOSTNAME

b. Install the gateway instance or Dialog Instance at database instance

c. try to create the job in DB13 so that is can automatically generate the RFC to database Instance sapxpg_XXX_dbhostname and make sure you fill the gateway hostname and gateway service for the RFC after that do a test connection.

d. create a backup job again (this time is will successfull)

[Former Member]

Hi,

Am I reading your message correctley, are you saying the CI and DB are on different servers ?

If so, how are you bridging the communication e.g. mapping the drive ?

Mark

Edited by: Mark Norman on Oct 23, 2009 1:37 PM

[Former Member]

hi Mark,

yes the CI and DB are on the different Server, currently i'm not mapping any drive from any server.

[sunny_pahuja2]

Hi,

Check below thread :

Thanks

Sunny

[Former Member]

hi Sunny,

i check the link you give to me, is said that brtools must always run on the database instance, i'm not sure about this since currently not only brtools run fail on instance server but my all my DB13 job also fail from sap server, check the error below is the log from checkdb (DB13)

Job started

Step 001 started (program RSDBAJOB, variant &0000000000002, user ID SAP*)

Execute logical command BRCONNECT On host

Parameters: -u / -jid CHECK20091023170943 -c -f check

BR0801I BRCONNECT 7.00 (16)

BR0252E Function fopen() failed for 'C:\oracle\P01\102\database\initP01.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile C:\oracle\P01\102\database\initP01.sap

BR0280I BRCONNECT time stamp: 2009-10-23 17.09.52

BR0301E SQL error -12560 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance P01 failed

BR0806I End of BRCONNECT processing: cebtdnrk.log2009-10-23 17.09.52

BR0280I BRCONNECT time stamp: 2009-10-23 17.09.52

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

[Former Member]

Hi

It is correct that brtools would only run on database server. So your question that brtools not running from CI server is not valid.

As for DB13 jobs to run, DB13 takes database server's location from destination SAPXPG_DBDEST_<DBHOST>

Look in SM59 and verify that database server details are maintained out there.

Also, do you have additional instance on database server? If no, then you will need to install a separate gateway instance on that server to enable RFC communication.

After that, refer to note below for additional work. Your all problems will be solved (Hopefully )

Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

Regards,

Javed

[Former Member]

hi Javed,

do you know where i can download the Gateway Instance for my database Instance? thanks.

[Former Member]

It is present in Installation Master CD

Goto Standalone Engine --> Gateway --> Gateway Installation

Regards

Javed

[Former Member]

hi Javed,

i try install the dialog instance in my database instance as a gateway for my oracle database, now the connection for SAPXPG_DBDEST_ was working in sm59, but when i try to run the db13 (database check) the error still persist, check the error below, is there something i miss out?

Job started

Step 001 started (program RSDBAJOB, variant &0000000000000, user ID DDIC)

Execute logical command BRCONNECT On host

Parameters: -u / -jid CHECK20091027133556 -c -f check

BR0801I BRCONNECT 7.00 (18)

BR0252W Function remove() failed for 'C:\oracle\P01\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'C:\oracle\P01\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0252E Function fopen() failed for 'E:\oracle\P01\sapcheck\cebtwlym.chk' at location main-9

BR0253E errno 2: No such file or directory

BR0121E Processing of log file E:\oracle\P01\sapcheck\cebtwlym.chk failed

BR0806I End of BRCONNECT processing: cebtwlym.chk2009-10-27 13.36.11

BR0280I BRCONNECT time stamp: 2009-10-27 13.36.11

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

[Former Member]

Hi

I doubt that you have maintained SAPXPG_DBDEST_ parameters correctly. You should choose "Start on explicit host" then maintain target host as your DB server hostname and Gateway host as your DB host and gateway service as sapgw<nn> where nn is the instance of gateway that you have just installed on your DB host server.

Confirm me if this is the case or not and do the changes as above. In case of error again do let me know the error and every filed value under Technical Settings for this RFC.

By the way, what is RFC full name? It should be SAPXPG_DBDEST_<DB Server Host name>

Regards

Javed

[Former Member]

hi Javed,

i check my current SM59 there was SAPXPG_DBDEST_ in there at the first time, even i deleted the RFC the it still created automatically again, beside that i configure the SAPXPG_DBDEST_ like the option below

- Start On Explicit Host

- program = C:\usr\sap\P01\SYS\exe\uc\NTI386\sapxpg.exe

- target host = oracle (database hostname)

- start type of external program = default gateway

- CPI-C Timeout = Default Gateway Value

- Gateway Host = oracle

- Gateway service = sapgw00

i also try to copy RFC SAPXPG_DBDEST_ to SAPXPG_DBDEST_ORACLE and the result still the same.

RFC Test Result

Connection Test SAPXPG_DBDEST_ORACLE

Connection Type TCP/IP Connection

Logon 30 msec

Transfer of 0 KB 30 msec

Transfer of 10 KB 31 msec

Transfer of 20 KB 32 msec

Transfer of 30 KB 32 msec

[JPReyes]

Do you want us to guess the error?.... what user are you logged as?

Regards

Juan

[Former Member]

hi Juan,

i'm using windows oracle and the user that i using to run the brtools is <SID>adm, here is the further error for brconnect command "brconnect -u / -c -f check"

Central Instance Server output :

BR0801I BRCONNECT 7.00 (16)

BR0252E Function fopen() failed for 'C:\oracle\P01\102\database\initP01.sap' at

location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile C:\oracle\P01\102\database\initP01.sap

BR0280I BRCONNECT time stamp: 2009-10-23 16.17.46

BR0301E SQL error -12560 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance P01 failed

BR0806I End of BRCONNECT processing: cebtdjbe.log 2009-10-23 16.17.46

BR0280I BRCONNECT time stamp: 2009-10-23 16.17.46

BR0804I BRCONNECT terminated with errors.

but when i'm trying in Database Instance is working.

[JPReyes]

ORA-12560: TNS:protocol adapter error

You most likely haven't set the ORACLE_SID enviromental variable. set ORACLE_SID = SID of your DB and that should fix the problem

Regards

Juan

[Former Member]

hi Juan,

i run the set command in CI, the parameter already in there :

C:\Documents and Settings\p01adm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\p01adm\Application Data

CLASSPATH=C:\sapjco-ntintel-2.1.8\sapjco.jar

CLIENTNAME=OBT-SG-HARIYONO

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=OBT-SG-SVCA1

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ora

dbs_ora_schema=SAPSR3

dbs_ora_tnsname=P01

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\p01adm

JAVA_HOME=C:\Program Files\Java\jre1.5.0_21

lib=C:\Program Files\SQLXML 4.0\bin\

LOGONSERVER=
OBT-SG-SVCA1

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=C:\oracle\P01\102

ORACLE_SID=P01

OS=Windows_NT

Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Mi

crosoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\B

inn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:

\sapjco-ntintel-2.1.8;C:\Program Files\Java\jre1.5.0_21\bin;D:\usr\sap\P01\SYS\e

xe\uc\NTI386

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=1706

ProgramFiles=C:\Program Files

PROMPT=$P$G

SAPDATA_HOME=C:\oracle\P01

SAPEXE=D:\usr\sap\P01\SYS\exe\uc\NTI386

SAPLOCALHOST=obt-sg-svca1

SAPSYSTEMNAME=P01

SESSIONNAME=RDP-Tcp#9

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP\1

TMP=C:\WINDOWS\TEMP\1

TNS_ADMIN=D:\usr\sap\P01\SYS\profile\oracle

USERDOMAIN=OBT-SG-SVCA1

USERNAME=p01adm

USERPROFILE=C:\Documents and Settings\p01adm

windir=C:\WINDOWS

[Former Member]

hi

Please go through the following SAP notes : 1) 441518 - ORA-12560 composite SAP Note

2) 384839 - ora-12540, tns-12560, tns-12500, tns-12546

Ravi

[Former Member]

hi Ravi,

i check your notes already, is not related to my error since the brtools was working in my database instance and not working in my central instance.

[JPReyes]

BR0252E Function fopen() failed for 'C:\oracle\P01\102\database\initP01.sap' at
location BrInitSapRead-1
BR0253E errno 2: No such file or directory

Does initP01.sap exist?

Regards

Juan

[Former Member]

hi Juan,

the initP01.sap is located at the DB instance but at CI this file doesn't exist.