Startup of Sapinstance failed after database restore

[former_member185031]

HI,

We are facing this error after restoration of database. R3trans -d returncode is 0 and database is running properly, but while starting sap we are getting this error.

proddemo:ledadm 2> startsap r3 DVEBMGS01

Checking LED Database
------------------------------
 ABAP Database is running

Starting SAP-Collector Daemon
------------------------------
/usr/sap/LED/SYS/exe/run/startsap: line 1019: /usr/sap//SYS/exe/run/saposcol: No such file or directory
 Start of saposcol failed

Starting SAP Instance DVEBMGS01
------------------------------
 Startup-Log is written to /home/ledadm/startsap_DVEBMGS01.log
 Instance Service on host proddemo started
 Startup of Instance failed
 See /home/ledadm/startsap_DVEBMGS01.log for details

proddemo:ledadm 3> more /home/ledadm/startsap_DVEBMGS01.log
Trace of system startup/check of SAP System LED on Fri Oct  9 11:35:08 IST 2009


Called command: /usr/sap/LED/SYS/exe/run/startsap DVEBMGS01

Starting SAP Instance DVEBMGS01
------------------------------
 Instance Service on host proddemo started

SAP-R/3-Startup Program Rel 700 V1.8 (2003/04/24)
-------------------------------------------------

Starting at 2009/10/09 11:35:09
Startup Profile: "/usr/sap/LED/SYS/profile/START_DVEBMGS01_proddemo"

Setup Environment Variables
---------------------------
(4906) SETENV LD_LIBRARY_PATH=/usr/sap/LED/DVEBMGS01/exe:/usr/sap/LED/DVEBMGS01/
exe:/opt/CA/SharedComponents/lib:/usr/sap/LED/SYS/exe/run:/oracle/client/10x_64/
instantclient
(4906) SETENV SHLIB_PATH=/usr/sap/LED/DVEBMGS01/exe:
(4906) SETENV LIBPATH=/usr/sap/LED/DVEBMGS01/exe:

Update local Kernel Files
-------------------------
(4909) Local: /usr/sap/LED/SYS/exe/run/sapcpe name=LED
(4906) system(/usr/sap/LED/SYS/exe/run/sapcpe name=LED) returns 1
(4906) Return-Code 1 in Local-Kernel-Update. See sapcpe.log.

Execute Pre-Startup Commands
----------------------------
(4911) Local: /usr/sap/LED/SYS/exe/run/sapcpe pf=/usr/sap/LED/SYS/profile/LED_DVEBMGS01_proddemo
(4906) system(/usr/sap/LED/SYS/exe/run/sapcpe pf=/usr/sap/LED/SYS/profile/LED_DVEBMGS01_proddemo) returns 2
(4913) Local: /usr/sap/LED/DVEBMGS01/exe/sapmscsa pf=/usr/sap/LED/SYS/profile/LED_DVEBMGS01_proddemo -n
/usr/sap/LED/DVEBMGS01/exe/sapmscsa=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

Could you please suggest what needs to be check as SAPSYSEMNAME is properly set and available on profile

Regards,

Subhash

[hannes_kuehnemund · Accepted solution]

Dear Subhash,

please provide the output of the following commandrun as <sid>adm

env | grep -i sap

If you do not find SAPSYSTEM there, you have to enter it in your .cshrc of <sid>adm, e.g. by adding set env SAPSYSTEMNAME <SID>

Thanks,

Hannes

[former_member185031 · Accepted solution]

Hello Hanes,

The variable seems to be ok

proddemo:ledadm 12> env | grep -i sap
PATH=/oracle/LED/102_64/bin:/opt/IBMJava2-amd64-142/bin:.:/home/ledadm:/usr/sap/LED/SYS/exe/run:/usr/kerberos
/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
PWD=/usr/sap/LED/SYS/profile
GROUP=sapsys
LD_LIBRARY_PATH=/opt/CA/SharedComponents/lib:/usr/sap/LED/SYS/exe/run:/oracle/client/10x_64/instantclient
SAPSYSTEMNAME=LED
DIR_LIBRARY=/usr/sap/LED/SYS/exe/run
dbs_ora_schema=SAPSR3
TNS_ADMIN=/usr/sap/LED/SYS/profile/oracle
SAPDATA_HOME=/oracle/LED
CASAP_HOME=/opt/CA/BABsapagt/
SECUDIR=/usr/sap/LED/DVEBMGS01/sec
proddemo:ledadm 13>

Anything else i can check.

Regards,

Subhash

[Former Member · Accepted solution]

Did you check the trace files within your /usr/sap/LED/DVEBMGS01/work directory - especially the stderr files?

[Former Member · Accepted solution]

SAPSYSTEMNAME neither in Profile nor in Commandline

Afaik SAPSYSTEMNAME should also be defined in an SAP profile, for example in default profile.

[former_member185031 · Accepted solution]

Hi All,

I have no error except this on any trace files.

proddemo:ledadm 18> more stderr1
(6780) New Child Process created.
(6780) Starting local Command:
 Command:  dw.sapLED_DVEBMGS01
           pf=/usr/sap/LED/SYS/profile/LED_DVEBMGS01_proddemo
dw.sapLED_DVEBMGS01=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

Fri Oct  9 13:13:43 2009
*** ERROR => DpSetWorkDir: chdir /usr/sap//DVEBMGS01/work [dpuxtool.c   175]
*** ERROR => DpArgsHandle: DpSetWorkDir [dpuxdisp.c   236]
*** ERROR => main: DpArgsHandle [dpxxdisp.c   1078]
proddemo:ledadm 20> more stderr0
(6779) New Child Process created.
(6779) Starting local Command:
 Command:  ms.sapLED_DVEBMGS01
           pf=/usr/sap/LED/SYS/profile/LED_DVEBMGS01_proddemo
ms.sapLED_DVEBMGS01=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

[Thr 182896116640] Fri Oct  9 13:13:43 2009
[Thr 182896116640] *** ERROR => MsSetWorkDir: chdir /usr/sap//DVEBMGS01/work [msuxserv_mt. 307]
[Thr 182896116640] *** ERROR => MsSPrvInit: MsSetWorkDir [msuxserv_mt. 156]
[Thr 182896116640] *** ERROR => mainU: MsSPrvInit [msxxserv_mt. 1645]
proddemo:ledadm 21>

SAPSYSTEMNAME is defined in Default profile and My kernel is same 201 of my production server.

Regards,

Subhash

[Former Member · Accepted solution]

Have a look at your paths mentioned in your posting - the SID is always missing. Check your environment and profiles regarding this.

*** ERROR => DpSetWorkDir: chdir /usr/sap//DVEBMGS01/work [dpuxtool.c   175]
[Thr 182896116640] *** ERROR => MsSetWorkDir: chdir /usr/sap//DVEBMGS01/work [msuxserv_mt. 307]
proddemo:ledadm 21>

[Former Member]

Hi ,

Please try to upgrade your kernel.Make the kernel level same as your PRD & hope after tht it will wrk fine.

Thanks..

Mohit