SAP instance down

[Former Member]

Hello SDNers,

When i try to start one of CRM instance, I am getting the below error:

[Thr 3036] Mon Dec 29 09:49:56 2008

[Thr 3036] profile G:\usr\sap\CR1\SYS\profile\CR1_SCS01_a2ms00015

[Thr 3036] hostname a2ms00015

[Thr 3036] *** ERROR => ShmDelete: Invalid shared memory Key=34. [shmnt.c 719]

[Thr 3036] *** ERROR => ShmCleanup: ShmDelete failed for Key:34. [shmnt.c 793]

[Thr 3036] initialize_global: enqueue server without replication

[Thr 3036] Enqueue: EnqMemStartupAction Utc=1230524396

[Thr 3036] *** ERROR => [CreateOsShm] CreateFileMapping(37,65 KB) failed with Err=5

ERROR_ACCESS_DENIED: Access is denied. [shmnt.c 2174]

[Thr 3036] *** ERROR => ShmCreate: Create (37,67072,1) failed [shmnt.c 506]

I searched for the same error in the forum, someone was saying it can be because it is taking the instance profile instead of the START profile. So how do i change the profile here?

I am using CRM 5.0 on Oracle 10g + Windows 2003.

Please advice on how to proceed.

Thanks in advance!

Abhilash

[JPReyes]

In the old kernels theres a executable called cleanipc... if your kernel is 640 or less you can call cleanipc XX where XX is the instance number and it should clean the shared memory. Once done start the system again.

Hope that helps

Regards

Juan

[sunny_pahuja2]

Hi Abhilash,

I faced similar issue in past on one of my server but when i rebooted host, it solved the problem. Please try to reboot the host and then start the instance. And let me know the result.

Regards

Sunny

[Former Member]

Hi Abhilash,

Greetings!

I had this same error when I was trying to start or execute the installation phase Start SAP Instance. I found the error in my case to be the Anti-Virus software that was installed in the Server.

Please try to deactivate the Anti-Virus software if you have any on the server and try to start the SAP instance after starting the DB.

Kindly get back in case you need further assistance.

Thank you

Regards,

Vineeth

[Former Member]

Hi,

Go through the below link which tells "How to Install SAP MMC on Windows Workstation"

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0f6978e-f73c-2a10-269f-93e8f0a1...

--Kishore

[Former Member]

Hello Kishore,

I have gone through the document.

But I uninstalled all the instance in the mmc, then restarted the system and again installed the new instance in the MMC (i gave the START profiles only) . But when i started the instance through the MMC, again the same error. The enqueue server is not coming up .

The developer trace gives me the below error:

-

---

trc file: "dev_enqsrv", trc level: 1, release: "700"

-

---

sysno 11

sid SLM

systemid 562 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 179

intno 20050900

make: multithreaded, Unicode, 64 bit, optimized

pid 2076

[Thr 2036] Mon Dec 29 14:49:02 2008

[Thr 2036] profile G:\usr\sap\SLM\SYS\profile\SLM_SCS11_a2ms00015

[Thr 2036] hostname a2ms00015

[Thr 2036] *** ERROR => ShmDelete: Invalid shared memory Key=34. [shmnt.c 719]

[Thr 2036] *** ERROR => ShmCleanup: ShmDelete failed for Key:34. [shmnt.c 793]

[Thr 2036] initialize_global: enqueue server without replication

[Thr 2036] Enqueue: EnqMemStartupAction Utc=1230542342

[Thr 2036] *** ERROR => [CreateOsShm] CreateFileMapping(37,65 KB) failed with Err=5

ERROR_ACCESS_DENIED: Access is denied. [shmnt.c 2174]

[Thr 2036] *** ERROR => ShmCreate: Create (37,67072,1) failed [shmnt.c 506]

*****************************************************

The same error, which i was getting earlier also

Regards,

Abhilash

[Former Member]

Hi,

Please let me know the following details:

1. How may instances installed on the same box. I have notices two.

2. Have you logon using user <SID>adm and started the Instance? If not login with <SID>adm.

3. Check environmnent variables for <SID>adm.

--Kishore

[Former Member]

Hi,

Please check the below note.

"Note 82751 - Problems with SAP Services & SAP Service Manager"

• ERROR CODE 5: (access is denied)

The named pipe that was opened by starting the R/3 System service SAP<SAPSID>_<instance_number> cannot be accessed. Log on with the correct user or check the user used to start the service.

--Kishore

[Former Member]

Hi again,

Yeah, I tried to start the instance after logging in as sidadm only.

Also we have 2 instances currently running on this server. But both of them are facing the same issue.

Recently we installed one 4.7 instance to test an upgrade scenario and later uninstalled it. From that moment onwards the other 2 instances are not working

The enviornmental variable of one of the sidadm are as below:

C:\Documents and Settings\slmadm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\slmadm\Application Data

CLIENTNAME=A2MD03658

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=A2MS00015

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ora

dbs_ora_schema=SAPSR3

dbs_ora_tnsname=SLM

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\slmadm

JAVA_HOME=C:\j2sdk1.4.2_17-x64

LOGONSERVER=
A2MS00015

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=H:\oracle\SLM\102

ORACLE_SID=SLM

OS=Windows_NT

Path=H:\oracle\SLM\102\bin;G:\Robocopy\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW

S\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\BINN;C:\j2s

dk1.4.2_17-x64\bin;G:\usr\sap\SLM\SYS\exe\uc\NTAMD64;H:\oracle\SLM\102\bin;G:\Ro

bocopy\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files

(x86)\Microsoft SQL Server\80\Tools\BINN

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PERL5LIB=H:\oracle\SLM\102\perl\5.8.3\lib\MSWin32-X64-multi-thread;H:\oracle\SLM

\102\perl\5.8.3\lib;

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=EM64T Family 6 Model 15 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0f06

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

PROMPT=$P$G

SAPDATA_HOME=H:\oracle\SLM

SAPEXE=G:\usr\sap\SLM\SYS\exe\uc\NTAMD64

SAPLOCALHOST=a2ms00015

SAPSYSTEMNAME=SLM

SESSIONNAME=RDP-Tcp#1

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=G:\usr\sap\SLM\tmp\1

TMP=G:\usr\sap\SLM\tmp\1

TNS_ADMIN=G:\usr\sap\SLM\SYS\profile\oracle

USERDOMAIN=A2MS00015

USERNAME=slmadm

USERPROFILE=C:\Documents and Settings\slmadm

windir=C:\WINDOWS

Regards,

Abhilash

[Former Member]

Hi,

Note 82751 - Problems with SAP Services & SAP Service Manager

• ERROR CODE 5: (access is denied)

The named pipe that was opened by starting the R/3 System service SAP<SAPSID>_<instance_number> cannot be accessed. Log on with the correct user or check the user used to start the service.

Check the following:

1. check the service SAP<SID>_NR is started or not and also check which user is used to start the service. It should be SAPService<SID>

2. Check the user SAPService<SID> is not locked at the os level. If your installation is local installation then goto --> My computer --> Right click --> Manage --> on left hand side extract "Local Users and Groups" --> select Users --> on right hand pane you can see SAPService<SID> --> Right click --> Properties and check whether the user account is locked or not. Do the same for <SID>adm user.

If it is domain installation ask system adminstrator to check the users.

3. Check all profiles i.e instance, start and default profiles

4. Try to start SAP with user SAPService<SID>.

--Kishore

[Former Member]

hi, please check the share name of transport directory. ex: shmnt\. the issue is while starting instance its not able to locate instance profile. please check the sharename of the profiles path (ex: CI system). once you correct , please stop all SAP and stop DB. then Start DB and start SAP. Regards, Venkat

[Former Member]

Hi,

Please go through the below link which may be helpful in trouble shooting.

--Kishore

[Former Member]

Hello Kishore,

I think the issue is similar to the one you posted.

In the dev_enqsrv i can see,

profile G:\usr\sap\CR1\SYS\profile\CR1_SCS01_a2ms00015

It is pointing towards the instance profile and not the start profile.

But how do i change this back to the start profile?

Thanks,

Abhilash

[Former Member]

Hi,

First you check Start Profile at O/S level.

2nd you try to check Instance Profile at O/S level.

check the content there some thing might be changed at Start (or) Instance Profile.

[Former Member]

Hi,

I guess you have not provided correct credential while starting the server. Please cross check the same and start the server in the following sequence.

1. check whether your database i.e. Oracle started or not. If not start the database.

Command > Goto cmd> sqlplus "/as sysdba" --> startup

2. Start sap from MMC. (It will prompt user name and password provide correct credentials)

--Kishore