SXPG_COMMAND_EXECUTE failed for BRTOOLS

[Former Member]

Hi experts,

I have my SAP ECC in a distributed system (CI and DB nodes are different) on Oracle 11G/ Solaris.

When I try to execute any action in db13, appear the following error:

SXPG_COMMAND_EXECUTE failed for BRTOOLS - Reason: program_start_error: For More Information, See SYS

I follow the SAP Note:  1974030 - How to configure DB13 to work with a standalone Oracle database in Unix/Linux

but I continue with the error

The RFC SAPXPG_DBDEST_HOSTDB works fine but I check in the trace of the proccess is:

LOCATION    SAP-Gateway on host adonis.blumaq.local / sapgw00

ERROR       timeout during allocate

TIME        Tue Sep  9 12:47:24 2014

RELEASE     721

COMPONENT   SAP-Gateway

VERSION     2

RC          242

MODULE      gwr3cpic.c

LINE        2164

DETAIL      no connect of TP sapxpg from host adonisdb after 20 sec

COUNTER     6595

Any idea?

Thanks in advance,

Regards,

[Reagan]

Could you supply the environment variables of sidadm user from both the nodes ?

Regards

RB

[Former Member]

DB server:

DIR_LIBRARY=/usr/sap/BLP/SYS/exe/run

HZ=

LC_MONETARY=en_US.ISO8859-15

dbs_ora_tnsname=BLP

dbms_type=ORA

SHELL=/usr/bin/bash

TERM=xterm

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPEXE=/usr/sap/BLP/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/BLP/SYS/global/security/rsecssfs/data

LC_NUMERIC=en_US.ISO8859-15

THREAD=NOPS

LD_LIBRARY_PATH=/usr/sap/BLP/SYS/exe/run:/usr/sap/BLP/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

ORACLE_SID=BLP

ORACLE_BASE=/oracle

dbs_ora_schema=SAPBLP

TNS_ADMIN=/usr/sap/BLP/SYS/profile/oracle

MAIL=/var/mail/blpadm

PATH=/usr/j2se/jre/bin:/oracle/BLP/112_64/bin:/usr/bin::/usr/sap/BLP/SYS/exe/uc/sun_64:/usr/sap/BLP/SYS/exe/run:/export/home/blpadm:.:/usr/ccs/bin:/usr/ucb

rsdb_ssfs_connect=0

LC_MESSAGES=C

LC_COLLATE=en_US.ISO8859-15

PWD=/export/home/blpadm

JAVA_HOME=/usr/j2se/jre

SAPDATA_HOME=/oracle/BLP

DB_SID=BLP

RSEC_SSFS_KEYPATH=/usr/sap/BLP/SYS/global/security/rsecssfs/key

SAPSYSTEMNAME=BLP

TZ=Europe/Madrid

PS1=

blpadm>

SHLVL=1

HOME=/export/home/blpadm

LOGNAME=blpadm

LC_CTYPE=en_US.ISO8859-15

ORACLE_HOME=/oracle/BLP/112_64

LC_TIME=en_US.ISO8859-15

_=/usr/bin/env

CI server:

DIR_LIBRARY=/usr/sap/BLP/SYS/exe/run

HZ=

LC_MONETARY=en_US.ISO8859-15

dbs_ora_tnsname=BLP

dbms_type=ORA

SHELL=/usr/bin/bash

TERM=xterm

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPEXE=/usr/sap/BLP/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/BLP/SYS/global/security/rsecssfs/data

LC_NUMERIC=en_US.ISO8859-15

THREAD=NOPS

LD_LIBRARY_PATH=/usr/sap/BLP/SYS/exe/run:/usr/sap/BLP/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

ORACLE_SID=BLP

ORACLE_BASE=/oracle

dbs_ora_schema=SAPBLP

TNS_ADMIN=/usr/sap/BLP/SYS/profile/oracle

MAIL=/var/mail/blpadm

PATH=/usr/j2se/jre/bin:/usr/bin::/usr/sap/BLP/SYS/exe/uc/sun_64:/usr/sap/BLP/SYS/exe/run:/export/home/blpadm:.:/usr/ccs/bin:/usr/ucb

rsdb_ssfs_connect=0

LC_MESSAGES=C

LC_COLLATE=en_US.ISO8859-15

PWD=/export/home/blpadm

JAVA_HOME=/usr/j2se/jre

SAPDATA_HOME=/oracle/BLP

DB_SID=BLP

RSEC_SSFS_KEYPATH=/usr/sap/BLP/SYS/global/security/rsecssfs/key

SAPSYSTEMNAME=BLP

TZ=Europe/Madrid

PS1=

blpadm>

SHLVL=1

HOME=/export/home/blpadm

LOGNAME=blpadm

LC_CTYPE=en_US.ISO8859-15

LC_TIME=en_US.ISO8859-15

_=/usr/bin/env

[Reagan]

Do you have a file called .bashrc in the home directory of the blpadm user on both the nodes ? if yes then copy the one from CI node to DB node. (make sure to backup the original one before you replace).

If this is not available and not working then supply all the environment files present in the home directory.

Regards

RB

[Former Member]

No, I have not any .bashrc in any nodes...

[Reagan]

In that case could you list the files like I have asked above ?

[Former Member]

These one?

[Reagan]

Check whether the .profile file is same on both the nodes and if not replace it (after backing up a copy) and see if that helps. I don't have a Solaris system handy to test it

[Former Member]

yes, it is the same in both nodes

[Reagan]

There are others who had the same issue in the past as well. If possible try to change the shell to CSH and see if that helps. The SAP notes 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13 and 1025707 - DBA Cockpit planning calendar and remote Oracle databases speaks about.

The last option I would try is to set (Copying) the environment variables for users on both nodes and restart the system and see if that helps.

[Former Member]

How can change it?

[divyanshu_srivastava3]

I have given the command above..

You need to execute them using root.

** I am not an Solaris OS expert - please recheck the syntax using man command on you OS