db13 Can't exec external program (No such file or directory)

[Former Member]

Hi,

I am working with SAP SCM 7.0 (BS AIX 5.3 on DB Oracle 11.2.0.2)

When I execute in DB13 Checkdb I get the following error:

Can't exec external program (No such file or directory)

External program terminated with exit code 1

because on AIX I can execute the brconnect -u / -c -f check.

regards,

[Former Member]

Can you execute 'brconnect -u / -c -f check' from command line as sidadm or orasid? Is this ok? If not paste output

Regards

Roman

[Former Member]

When I execute on OS level with sidadm then

lmtaix003:amtadm 15> brconnect -u / -c -f cleanup

brconnect: Command not found.

with orasid its ok!

[former_member189725]

Can you login as <sid>adm and paste the output of the command

#env

Probably the PATH environment is missing the value /usr/sap/<SID>/SYS/exe/run

Regards

Ratnajit

[Former Member]

I agree with Ratnajit,

add to PATH environment variable value /usr/sap/<SID>/SYS/exe/run for <sid>adm user

Regards

Roman

[Former Member]

Is you CI and D B are on same hosts ?

Or

CI is on NODE A and DB is on NODE B ? , I have faced the similar error when setup SAP system in distributed environment...

[Former Member]

Hi Rahul,

yes they are on the same host

[Former Member]

Hi,

Hope permissions are set this way as per mentioned sap note 113747

chown orasid:sapsys brarchive brbackup brconnect
chmod 4775 brarchive brbackup brconnect

chown sidadm:sapsys brtools brspace brrecover brrestore
chmod 755  brtools brspace brrecover brrestore

ls -ltr br* from /sapmnt/SID/exe

-rwsrwxr-x   1 oraeeq     sapsys     14856512 Apr  7 21:59 brarchive

-rwsrwxr-x   1 oraeeq     sapsys     15340352 Apr  7 21:59 brbackup

-rwsrwxr-x   1 oraeeq     sapsys     19597728 Apr  7 21:59 brconnect

-rwxr-xr-x   1 eeqadm     sapsys     16207736 Apr  7 21:59 brrecover

-rwxr-xr-x   1 eeqadm     sapsys     6804768 Apr  7 21:59 brrestore

-rwxr-xr-x   1 eeqadm     sapsys     21691352 Apr  7 21:59 brspace

-rwxr-xr-x   1 eeqadm     sapsys     9090728 Apr  7 21:59 brtools

and can you login to orasid and sidadm providing the password at OS level...

not switching as user from root...

[Former Member]

Hi,

it see as follow

-rwsrwxr-x	1 oraamt   sapsys	6581297 Feb 22 2011  brarchive*
-rwsrwxr-x	1 oraamt   sapsys	6753416 Feb 22 2011  brbackup*
-rwsrwxr-x	1 oraamt   sapsys	8664012 Feb 22 2011  brconnect*
-rwxr-xr-x	1 amtadm   sapsys	7337100 Feb 22 2011  brrecover*
-rwxr-xr-x	1 amtadm   sapsys	2751806 Feb 22 2011  brrestore*
-rwxr-xr-x	1 amtadm   sapsys	9186442 Feb 22 2011  brspace*
-rwxr-xr-x	1 amtadm   sapsys	3484571 Feb 22 2011  brtools*

yes I can logon to the server at OS level with orasid and sidadm.

[Former Member]

Is the path that contains brtools, added into the both "amtadm" and "oraamt" user, "path" environment variable?

[Former Member]

in which file can I edit PATH?

[Former Member]

Could you execute"env" command and paste the output here for both "amtadm" and "oraamt" user?

[Former Member]

lmtaix003:oraamt 17> env

USER=oraamt

LOGNAME=oraamt

LOGIN=oraamt

HOME=/oracle/AMT

PATH=/oracle/AMT/112_64/bin:/oracle/AMT:/usr/sap/AMT/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/AMT/bin:/usr/bin/X11:/sbin:.

MAIL=/var/spool/mail/oraamt

SHELL=/usr/bin/csh

TZ=CET-1CEST-2,M3.5.0/02:00:00,M10.5.0/03:00:00

SSH_CLIENT=172.16.13.158 56937 22

SSH_CONNECTION=172.16.13.158 56937 172.16.8.156 22

SSH_TTY=/dev/pts/0

TERM=vt100

AUTHSTATE=compat

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

ODMDIR=/etc/objrepos

SAPSYSTEMNAME=AMT

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

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AMT

dbs_ora_schema=SAPADM

ORACLE_SID=AMT

DB_SID=AMT

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/AMT/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AMT

MAILMSG=[YOU HAVE NEW MAIL]

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/AMT/SYS/exe/run:/oracle/AMT/112_64/lib

lmtaix003:oraamt 18>

lmtaix003:amtadm 1> env

USER=amtadm

LOGNAME=amtadm

LOGIN=amtadm

HOME=/sapmnt/AMT/amtadm

PATH=/oracle/AMT/112_64/bin:/usr/java14_64/bin:/sapdb/programs/bin:.:/sapmnt/AMT/amtadm:/usr/sap/AMT/DVEBMGS40/exe:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java131/jre/bin:/usr/java131/bin:/opt/freeware/bin

MAIL=/var/spool/mail/amtadm

SHELL=/usr/bin/csh

TZ=CET-1CEST-2,M3.5.0/02:00:00,M10.5.0/03:00:00

SSH_CLIENT=172.16.13.158 64023 22

SSH_CONNECTION=172.16.13.158 64023 172.16.8.156 22

SSH_TTY=/dev/pts/2

TERM=vt100

AUTHSTATE=compat

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

ODMDIR=/etc/objrepos

SAPSYSTEMNAME=AMT

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

JAVA_HOME=/usr/java14_64

IBM_JAVA_OPTIONS=-Xmx256M -Xj9

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AMT

dbs_ora_schema=SAPADM

ORACLE_SID=AMT

DB_SID=AMT

ORACLE_BASE=/oracle

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

ORACLE_HOME=/oracle/AMT/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AMT

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/AMT/SYS/exe/run:/sapdb/programs/lib/lib64:/oracle/client/10x_64/instantclient

[Former Member]

Could you confirm that the command has run, successfully or not;

SM69 -> Select BRTOOLS -> Press F8 -> Press F8

Are you able to see the command executed at the bottom window?

Best regards,

Orkun Gedik

[Former Member]

I get the following message:

Can't exec external program (No such file or directory)

External program terminated with exit code 1.

My question:

When I execute on OS level with sidadm then

lmtaix003:amtadm 15> brconnect -u / -c -f cleanup

brconnect: Command not found.

with orasid its ok!

[Former Member]

Add "/usr/sap/AMT/SYS/exe/run" into "amtadm" the PATH variable

Best regards,

Orkun Gedik

[Former Member]

Hi Shatti,

Check SAPXPG_DBDEST_<hostname> on SM59 is pointing the correct host. Additionally check the note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

I checked on SM59 SAPXPG_DBDEST_LMTAIX003 -> its OK

and the permissions are also OK.

[Former Member]

Could you execute saproot.sh at the os level

[Former Member]

I don't have saproot.sh on the server

[Former Member]

login by root user and execute the command below, to find saproot.sh

cd /

find . -name saproot.sh

Best regards,

Orkun Gedik

[Former Member]

can't find it.

There is no saproot.sh on the server.