on 09-16-2015 11:17 AM
Hello
I have just installed Solution manager 7.1 in oracle linux 7 with oracleDB 12.1. But know I cant login to solman. The sap system starts without any error:
lsnrctl start
startsap
But Saplogon cant connect to server. As I understand, saplogon connects to 3200 port. I check in server, no program listen to this port, while in other sap systems this port is listened by this process: dw.sap<SID>_DVE.
How can I find the source the problem?
Thank you
Hi Aram,
Just check whether your able to see the dw_ & ms_ process on os level.
also run the dpmon pf=<instance profile> to check the work process and are running correctly.
IF there is no work process running then do check the logs under /usr/sap/SID/DV*/work for dev_w0 and dev_ms log file for more on the error.
Also based on your instance number the port for ms will change and do check the 32<Instance number port> for listening.
And do verify your sap gui entries are correct to connect using SPAGUI.
And do maintain the sapms<SID> entries in your C:\Windows\system32\drivers\service directory
Let us know if you need any further help.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello ramkrishna
Thank you for fast reply.
Just check whether your able to see the dw_ & ms_ process on os level.
There are two ms processes
ms.sapSM2_SCS02 pf=/usr/sap/SM2/SYS/profile/SM2_SCS02_test5
ms.sapSM2_ASCS01 pf=/usr/sap/SM2/SYS/profile/SM2_ASCS01_test5
and no one dw process.
IF there is no work process running then do check the logs under /usr/sap/SID/DV*/work for dev_w0 and dev_ms log file for more on the error.
There is no dev_ms file. The dev_w0 is attached to this reply. There are errors in dev_w0.
Also based on your instance number the port for ms will change and do check the 32<Instance number port> for listening.
This two ports are listened
tcp 0 0 0.0.0.0:3201 0.0.0.0:* LISTEN 10087/en.sapSM2_ASC
tcp 0 0 0.0.0.0:3202 0.0.0.0:* LISTEN 8573/en.sapSM2_SCS0
But I cant connect to that ports too.
When I compare with working system this line is missed
tcp 0 0 0.0.0.0:3200 0.0.0.0:* LISTEN 23623/dw.sapSME_DVE
The sapgui entries and services entries are correct
Best regards
Aram
Hi Aram:
As per the developer traces you provided you have *** ERROR => shmget(10040,486000000,992) (28: No space left on device)
Can you please check recommendadtion as per below:
Error e=28 no space left on device | SCN
http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=375030464
Hi ARam,
From the dev_w0, its clear there the shared pool 40 is having no space.
M SHM_PAGING_ADM | (addr: 7fd2068e0000, size: 3277856) |
I *** ERROR => shmget(10040,486000000,2016) (28: No space left on device) [shmux.c 1532]
I *** ERROR => shmget(10040,486000000,992) (28: No space left on device) [shmux.c 1532]
I *** ERROR => Shm Pool Create Error. PoolKey=40, Key=48. [shmux.c 2105]
M *** ERROR => ThCreateNoBuffer: ShmCreate failed, rc: 1 [thxxnum.c 700]
M *** ERROR => ThShMCreate: ThCreateNoBuffer failed [thxxhead.c 2927]
M *** ERROR => ThIPCInit: ThShMCreate [thxxhead.c 2216]
M ***LOG R19=> ThInit, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c 1608]
M in_ThErrHandle: 1
M *** ERROR => ThInit: ThIPCInit (step 1, th_errno 17, action 3, level 1) [thxxhead.c 11560]
I would recommend you to run the sappfpar check for the instance profile and increased the shared pool 10 & 40.
Also do verify your kernel parameters for kernel.shmmax & kernel.shmall.
# SAP settings
kernel.sem=1250 256000 100 1024
vm.max_map_count=2000000 (see SAP Note 900929 for more information)
2002167 - Red Hat Enterprise Linux 7.x: Installation and Upgrade
2069760 - Oracle Linux 7.x SAP Installation and Upgrade
Do let us know the outcome.
Regards,
Ram
Please attach output of ipcs -l command and ipcs -u
------ Messages Limits --------
max queues system wide = 23517
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 6021614
max total shared memory (kbytes) = 4817288
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
------ Messages Status --------
allocated queues = 0
used headers = 0
used space = 0 bytes
------ Shared Memory Status --------
segments allocated 22
pages allocated 918086
pages resident 895822
pages swapped 0
Swap performance: 0 attempts 0 successes
------ Semaphore Status --------
used arrays = 8
allocated semaphores = 224
ps -ef |grep dw
there is no process
ps -ef |grep ora
orasm3 3345 1 0 18:48 ? 00:00:00 /oracle/SM3/121/bin/tnslsnr LISTENER -inherit
oracle 5835 1 0 18:50 ? 00:00:00 ora_pmon_SM3
oracle 5837 1 0 18:50 ? 00:00:00 ora_psp0_SM3
oracle 5839 1 0 18:50 ? 00:00:01 ora_vktm_SM3
oracle 5843 1 0 18:50 ? 00:00:00 ora_gen0_SM3
oracle 5845 1 0 18:50 ? 00:00:00 ora_mman_SM3
oracle 5849 1 0 18:50 ? 00:00:00 ora_diag_SM3
oracle 5851 1 0 18:50 ? 00:00:00 ora_dbrm_SM3
oracle 5853 1 0 18:50 ? 00:00:00 ora_vkrm_SM3
oracle 5855 1 0 18:50 ? 00:00:00 ora_dia0_SM3
oracle 5857 1 0 18:50 ? 00:00:00 ora_dbw0_SM3
oracle 5859 1 0 18:50 ? 00:00:00 ora_lgwr_SM3
oracle 5861 1 0 18:50 ? 00:00:00 ora_ckpt_SM3
oracle 5863 1 0 18:50 ? 00:00:00 ora_lg00_SM3
oracle 5865 1 0 18:50 ? 00:00:00 ora_smon_SM3
oracle 5867 1 0 18:50 ? 00:00:00 ora_lg01_SM3
oracle 5869 1 0 18:50 ? 00:00:00 ora_reco_SM3
oracle 5871 1 0 18:50 ? 00:00:00 ora_lreg_SM3
oracle 5873 1 0 18:50 ? 00:00:00 ora_pxmn_SM3
oracle 5875 1 0 18:50 ? 00:00:00 ora_mmon_SM3
oracle 5877 1 0 18:50 ? 00:00:00 ora_mmnl_SM3
oracle 5890 1 0 18:50 ? 00:00:00 ora_p000_SM3
oracle 5892 1 0 18:50 ? 00:00:00 ora_p001_SM3
oracle 5894 1 0 18:50 ? 00:00:00 ora_p002_SM3
oracle 5896 1 0 18:50 ? 00:00:00 ora_tmon_SM3
oracle 5898 1 0 18:50 ? 00:00:00 ora_arc0_SM3
oracle 5900 1 0 18:50 ? 00:00:00 ora_arc1_SM3
oracle 5902 1 0 18:50 ? 00:00:00 ora_arc2_SM3
oracle 5904 1 0 18:50 ? 00:00:00 ora_arc3_SM3
oracle 5906 1 0 18:50 ? 00:00:00 ora_tt00_SM3
oracle 5908 1 0 18:50 ? 00:00:00 ora_smco_SM3
oracle 5910 1 0 18:50 ? 00:00:00 ora_w000_SM3
oracle 5912 1 0 18:50 ? 00:00:00 ora_w001_SM3
oracle 5916 1 0 18:50 ? 00:00:00 ora_aqpc_SM3
oracle 5918 1 0 18:50 ? 00:00:00 ora_cjq0_SM3
oracle 5931 1 0 18:50 ? 00:00:00 ora_p003_SM3
oracle 5934 1 0 18:50 ? 00:00:00 ora_p004_SM3
oracle 5936 1 0 18:50 ? 00:00:00 ora_p005_SM3
oracle 5938 1 0 18:50 ? 00:00:00 ora_p006_SM3
oracle 5940 1 0 18:50 ? 00:00:00 ora_p007_SM3
oracle 7224 1 0 18:50 ? 00:00:00 ora_qm02_SM3
oracle 7249 1 0 18:50 ? 00:00:00 ora_q002_SM3
oracle 7254 1 0 18:50 ? 00:00:00 ora_q003_SM3
root 12685 3171 0 18:53 pts/0 00:00:00 grep --color=auto ora
Additional share trans.log & dev_w0 log files too.
there is no trans.log file dev_w0 ahave already shared, in the third message.
In general you need to pay attention to kernel.shmmni and kernel.smhall parameters.
Where I can find the minimal or recommended values for this parameters
Now the parameters are
kernel.sem = 250 32000 100 128
kernel.shmmax = 6166132737
kernel.shmmni = 4096
kernel.shmall = 1204322
I would recommend you to run the sappfpar check for the instance profile
The execution of sappfpar check returns this result
***ERROR: Size of shared memory pool 40 too small
================================================================
SOLUTIONS: (1) Locate shared memory segments outside of pool 40
with parameters like: ipc/shm_psize_<key> =0
SOLUTION: Increase size of shared memory pool 40
with parameter: ipc/shm_psize_40 =486000000
and increased the shared pool 10 & 40.
How can I change this( ipc/shm_psize_40) parameters where are they located?
This lines I find in /var/log/messages
Sep 19 12:52:33 test2 SAPSM3_02[27866]: Unable to open trace file sapstartsrv.log. (Error 11 Resource temporarily unavailable) [ntservsserver.cpp 3467]
Sep 19 12:52:48 test2 SAPSM3_01[29426]: Unable to open trace file sapstartsrv.log. (Error 11 Resource temporarily unavailable) [ntservsserver.cpp 3467]
Sep 19 12:53:03 test2 SAPSM3_00[31003]: Unable to open trace file sapstartsrv.log. (Error 11 Resource temporarily unavailable) [ntservsserver.cpp 3467]
And
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi:
As indicated above you cretainly have issue with your Shared memory.
1. What kernel level are you using? Did you try updating your kernel patch?Review Note 941735
- SAP memory management system for 64-bit Linux systems
2. ipc/shm_psize_40 can be set in your instance profile parameter to a value suggested by report sappfpar. But before changing any of these values that please review above note and you may reach out to your OS Admin for help.
Hi,
| 1532] |
Do you check & confirm for the sufficient space on the system as well.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you share result for the command
ps -ef |grep dw
ps -ef |grep ora
Additional share trans.log & dev_w0 log files too.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.