DB13 Check database not working

[Former Member]

Hi All,

Check DB and update stats from DB13 does not work. It comes back with the following error

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

Checked from OS level and found that brconnect -u / -c -f check works only from exe directory. If i execute the

command from any other directory it comes back with an error saying command not found

Upon further investigation found that this is an issue with env variable PATH

The current value of PATH in env variable of sidadm is

PATH=/oracle/SID/102_64/bin:/opt/IBMJava2-amd64-142/bin:.:/export/home/sidadm:/usr/sap/SID/DVEBMGS01/exe:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin

I want to change the value from usr/sap/SID/DVEBMGS01/exe to /usr/sap/SID/SYS/exe/run

I checked all the csh and .sh profiles for sidadm user but i did not find any PATH variable,

I can see DIR_LIBRARY and LD_LIBRARY_PATH but i cant see PATH variable

Checked the shell and it is /bin/csh

checked .bash_profile and all i can see is this

1. .bash_profile

1. Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

1. User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

unset USERNAME

Has any one faced this issue earlier??

Meanwhile i have found a temporary fix for timebeing i.e i copied all the br* executables from /sapmnt/SID/exe to

/usr/sap/SID/DVEBMGS01/exe and after doing that DB13 - DBcheck and Update optimizer works fine.

Regards,

Ershad Ahmed

[Former Member]

Hi All,

The issue has been resolved.

I had to change the path in .sapenv_hostname.csh

Original Value

setenv DIR_LIBRARY /usr/sap/SID/SYS/exe/run

foreach d ( /usr/sap/SID/DVEBMGS01/exe $HOME . )

Changed Value

foreach d ( /usr/sap/SID/SYS/exe/run $HOME . )

Thanks

Regards,

Ershad Ahmed

[Former Member]

Hi Sunil and Eric

Thanks for the reply

I checked all the profiles but no luck. I cant find the parameter.

As i mentioned in my earlier post i have found a temporary fix by copying the br executables from /sapmnt/SID/exe to

/usr/sap/SID/DVEBMGS01/exe and ran saproot.sh and that resolved the issue.

If i can change my PATH variable to point to /usr/sap/SID/SYS/exe/run that would be a permanent fix

Regards,

Ershad Ahmed

[Former Member]

Hi Dibya ,

Thanks for the reply but i dont have anything called as DEFEXE in .sapenv_hostname.csh

I checked it across all the systems and i dont have that variable.

more .sapenv_hostname.csh | grep "_DEF_EXE" does not fetch anything

Regards,

Ershad Ahmed

[Former Member]

Check appropriate files from below, depends on your shell

.sapenv.csh

.sapenv.sh

.sapenv_<hostname>.csh

.sapenv_<hostname>.sh

[former_member204746]

check permission of file brconnect if directory /usr/sap/SID/DVEBMGS01/exe

login as root, then:

cd /usr/sap/SID/DVEBMGS01/exe

saproot.sh SID

good luck.

[Former Member]

Yes the default shell for <sid>adm will be csh.

In the home directory of <sid>adm there should be a file called .sapenv_<hostname>.csh

Inside that there should be a variable called "_DEF_EXE" you will have to re-define that & it is in-turn used for $PATH

- Regards, Dibya