RE: Trouble starting databases on Solaris 2.8

Tue, 14 May 2002 00:15:47 -0700

Hi,
you have to reconfigure your kernel. Unfortunately the number of semaphores (SEMMNI) configured in your system is not sufficient. Thanks to the very informative UNIX error messages, this results in the system error message 'No space left on device'.
The number of semaphore you need mainly influenced by  'number of concurrent running clients' + 'number of UKT' + 'number of device threads'.
 
Here is an excerpt of ony of our test system '/etc/system' file:
*---------------------------------------------------------------------------
* Semaphores parameters set for SAP & DB's:
set semsys:seminfo_semmap=9218
set semsys:seminfo_semmni=9216
set semsys:seminfo_semmns=18432
set semsys:seminfo_semmnu=8192
set semsys:seminfo_semume=160
set semsys:seminfo_semmsl=75
set semsys:seminfo_semopm=50
 
You will have to modify '/etc/system' according to your needs and reboot.
CU
jrg
 -----Original Message-----
From: Carl Olivier [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 10. Mai 2002 12:53
To: [EMAIL PROTECTED]
Subject: Trouble starting databases on Solaris 2.8
Importance: High
Greetings.
 
I have recently installed SAP-DB 7.3.00.21 on SOlaris 2.8.  This seesm to have gone fine, except that whenever I try and run the create_demo_db.sh script, the following output and error is returned: (and yes I am running the script as sapdb and not root!)
 
create database PLATFORM...
set parameters for PLATFORM...
start PLATFORM...
start PLATFORM failed: ERR
-24994,ERR_RTE: runtime environment error
1,Kernel died before reaching COLD state
 
In the [indep_data path]/wrk/PLATFORM/knldiag log file the following output is found:
 
--------------------------------------------------------------------------------
Date       Time       TID Typ MsgID Label    Message-Text
--------------------------------------------------------------------------------
2002-05-10 12:46:08     1     12839 DIAGHIST Backup of diagnostic files is in progress
2002-05-10 12:46:08     1     12840 DIAGHIST Backup of diagnostic files has ended successfully
2002-05-10 12:46:08     1     12769 INFO     Starting SERVERDB:                  'PLATFORM'
2002-05-10 12:46:08     1     12770 INFO              SERVERNODE:                'PBLiveSparc'
2002-05-10 12:46:08     1     12773 INFO              X-te:                      02-05-10
2002-05-10 12:46:08     1     12771 INFO              Process ID:                5944
2002-05-10 12:46:08     1     12772 INFO              Owner:                     'sapdb'
2002-05-10 12:46:08     1     12781 INFO              Version:                   '32BIT Kernel'
2002-05-10 12:46:08     1     12781 INFO              Version:                   'X32|SUN   7.3.0    Build 021-000-084-927'
2002-05-10 12:46:08     1     12780 INFO              DBROOT:                    '/usr/sapdb/indep_data/wrk/PLATFORM'
2002-05-10 12:46:08     1     12883 DBSTATE  Core dump suppressed
2002-05-10 12:46:08     1     12698 IPC      Common RTE specific IPC key: 0x44000000
2002-05-10 12:46:08     1     11532 init_shm SHMCHUNK size 0x7F800000
2002-05-10 12:46:08     1     12692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw,cs;30000*us;compress
2002-05-10 12:46:08     1     12693 TCLUSTER number of 'BUP':   0
2002-05-10 12:46:08     1     12693 TCLUSTER number of ' DW':   8
2002-05-10 12:46:08     1     12693 TCLUSTER number of ' US':  50
2002-05-10 12:46:08     1     12693 TCLUSTER number of ' SV':  15
2002-05-10 12:46:08     1     12693 TCLUSTER number of ' EV':   0
2002-05-10 12:46:08     1     12693 TCLUSTER number of ' GC':   0
2002-05-10 12:46:08     1     11533 init_shm creating shared section size     335872
2002-05-10 12:46:08     1     11534 init_shm alignment gaps    total size       3928
2002-05-10 12:46:08     1     11536 init_shm attached shared section at   0xe0000000
2002-05-10 12:46:08     1     11537 init_shm shared section ends at       0xe0052000
2002-05-10 12:46:08     1     11542 init_shm KERNEL uses internal tasking
2002-05-10 12:46:08     1     12811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2002-05-10 12:46:08     1     12813 EVENTING No Eventbuffer created (0 entries 100 tasks)
2002-05-10 12:46:08     1 ERR 11277 IPC      create_sem: semget error, No space left on device
 
Now I have found other people with the same problem on the mailing list archives, but alsas, either I am too stupid to figure it out, or no-one else has solved this problem?!  Is the problem with the system wide semaphores?  Is the problem with the C libraries?
 
Can anyone at SAP tell me whether this release should work with Solaris 2.8?
 
I would really appreciate some assistance as I am going mad!

Thanks in advance,
 
Carl Olivier
Zero One
 

Reply via email to