Unable to see DB13 and ST04 logs in the system.

[Former Member]

Hi All,

We are unable to see the DB13 logs in our SAP system. The same is happening while trying to look into the ST04 logs for Database Message Logs. In both the cases we find the same kind of log:

[in DB13 log]************************************************************************

BR252E Function fopen() failed for '/sapdba/sapcheck/cdvxzfrv.aly' at location file_printout-1

BR253E errno 2: No such file or directory

External program terminated with exit code 5

[in ST04 log]*************************************************************************

BR252E Function fopen() failed for '/sapdba/saptrace/background/alert_PIN.log' at location file_printout-1

BR253E errno 2: No such file or directory

External program terminated with exit code 5

SAP is running on Varitas cluster on two different nodes. One node is having SAP services and the another one Oracle services on it. Since the last week when we shifted the Oracle services from one node to another for monthly maintenace work, we are facing this problem.

Our system details are:

SAP 46C (kernel 46D_EXT) 32 bit

SuSe Linux 2.6.5-7 64 bit

Oracle 9.2.0.6.0

Can someone please help me on it.

Anil

[markus_doehr2]

Have you configured your system (init<SID>.dba) so that it writes the files to "/sapdba...:"?

--

Markus

[former_member204746]

also check init[SID].ora (or spfile)

[former_member204746]

login as [sid]adm and type this command:

env

provide results here.

[Former Member]

Hi Anil,

Are you able to see the files from operating system level?

Please check if the filesystems are properly mounted on the node to which oracle services have been moved .

Padmaja

[Former Member]

Thanks Padmaja/Eric for your reply !!!

File systems are properly mounted and I can see these said files at OS level. Following are the env variable:

USER=dinadm

LOGNAME=dinadm

HOME=/home/dinadm

PATH=/oracle/DIN/920_64/bin:.:/home/dinadm:/usr/sap/DIN/SYS/exe/run:/opt/kde3/bin:/opt/gnome/bin:/usr/games:/home/dinadm/bin:/usr/bin/X11:/usr/bin:/bin:/usr/sbin:/sbin:/usr/lib/java/jre/bin

MAIL=/var/mail/dinadm

SHELL=/bin/tcsh

SSH_CLIENT=10.234.14.33 1364 22

SSH_CONNECTION=10.234.14.33 1364 10.234.13.50 22

SSH_TTY=/dev/pts/0

TERM=xterm

HOSTTYPE=x86_64-linux

VENDOR=suse

OSTYPE=linux

MACHTYPE=x86_64

SHLVL=1

PWD=/usr/sap/trans/data

GROUP=sapsys

HOST=insapr3din01

HOSTNAME=insapr3din01.pdc.in.ap.holcim.net

MANPATH=/usr/share/man:/usr/X11R6/man:/usr/local/man:/opt/gnome/share/man

MINICOM=-c on

INFODIR=/usr/local/info:/usr/share/info:/usr/info

INFOPATH=/usr/local:/opt/gnome:/usr

LESS=-M -I

LESSOPEN=lessopen.sh %s

LESSCLOSE=lessclose.sh %s %s

LESSKEY=/etc/lesskey.bin

PAGER=/usr/bin/less

MORE=-sl

GZIP=-9

CSHEDIT=emacs

COLORTERM=1

NNTPSERVER=news

XFILESEARCHPATH=/usr/lib/X11/%L/%T/%N%C:/usr/lib/X11/%l/%T/%N%C:/usr/lib/X11/%T/%N%C:/usr/lib/X11/%L/%T/%N:/usr/lib/X11/%l/%T/%N:/usr/lib/X11/%T/%N:/var/X11R6/%T/%N%C:/var/X11R6/%T/%N

INPUTRC=/etc/inputrc

LANG=en_US.UTF-8

QTDIR=/usr/lib/qt3

no_proxy=localhost

WINDOWMANAGER=/usr/X11R6/bin/kde

JAVA_BINDIR=/usr/lib/java/jre/bin

JAVA_ROOT=/usr/lib/java

JAVA_HOME=/usr/lib/java/jre

JRE_HOME=/usr/lib/java/jre

CVS_RSH=ssh

G_BROKEN_FILENAMES=1

GNOME_PATH=/opt/gnome:/usr

GNOMEDIR=/opt/gnome

ACLOCAL_PATH=/opt/gnome/share/aclocal

PKG_CONFIG_PATH=/opt/gnome/lib/pkgconfig

GTK_PATH=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0

MODULE_VERSION=3.1.6

MODULE_VERSION_STACK=3.1.6

MODULESHOME=/usr/share/modules

MODULEPATH=/usr/share/modules/versions:/usr/share/modules/modulefiles

LOADEDMODULES=

CSHRCREAD=true

LS_OPTIONS=-N --color=tty -T 0

SAPSYSTEMNAME=DIN

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

LD_LIBRARY_PATH=/usr/sap/DIN/SYS/exe/run:/oracle/client/92x_32/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=DIN

dbs_ora_schema=SAPR3

ORACLE_PSRV=DIN

ORACLE_SID=DIN

ORACLE_HOME=/oracle/DIN/920_64

ORACLE_BASE=/oracle

ORA_NLS=/oracle/DIN/920_64/ocommon/NLS_723/admin/data

ORA_NLS32=/oracle/DIN/920_64/ocommon/NLS_733/admin/data

ORA_NLS33=/oracle/client/92x_32/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/sapdata/oracle/DIN

waiting for your reply,

Anil