unable to connect to database.

[Former Member]

Trying to get dbmcli and get the following error,

dbmcli -d CSP -u control,xxxxxx db_online

ERR

-24994,ERR_RTE: Runtime environment error

1,Check knldiag! Kernel died before reaching ADMIN state (OS error code 11000)

And I have sdbverify every thing is consistant.

VERIFICATION SUMMARY:

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

INVALID PACKAGES: 0

VALID PACKAGES: 17

INCONSISTENT PACKAGES: 3

TOTAL FILES: 355

MISSED FILES: 0

MODIFIED FILES: 3

FILES WITH MODIFIED PERMISSIONS: 0

My knldiag file below

2010-10-04 17:54:34 1 20234 RTE TIME_MEASUREMENT=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_AK=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_ALLOCATOR=0

2010-10-04 17:54:34 1 20234 RTE TRACE_CATALOG=0

2010-10-04 17:54:34 1 20234 RTE TRACE_CLIENTKERNELCOM=0

2010-10-04 17:54:34 1 20234 RTE TRACE_COMMON=0

2010-10-04 17:54:34 1 20234 RTE TRACE_COMMUNICATION=0

2010-10-04 17:54:34 1 20234 RTE TRACE_CONVERTER=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DATACACHE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DATACHAIN=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DATAINDEX=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DATAPAM=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DATATREE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DBPROC=0

2010-10-04 17:54:34 1 20234 RTE TRACE_DEFAULT=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_DELETE=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_FBM=0

2010-10-04 17:54:34 1 20234 RTE TRACE_FILEDIR=0

2010-10-04 17:54:34 1 20234 RTE TRACE_FRAMECTRL=0

2010-10-04 17:54:34 1 20234 RTE TRACE_INDEX=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_INSERT=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_IOMAN=0

2010-10-04 17:54:34 1 20234 RTE TRACE_IPC=0

2010-10-04 17:54:34 1 20234 RTE TRACE_JOIN=0

2010-10-04 17:54:34 1 20234 RTE TRACE_KSQL=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LOCK=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_LOGACTION=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LOGHISTORY=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LOGPAGE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LOGTRANS=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LOGVOLUME=0

2010-10-04 17:54:34 1 20234 RTE TRACE_LONG=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_MEMORY=0

2010-10-04 17:54:34 1 20234 RTE TRACE_MESSAGES=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECTCONTAINER=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECT_ADD=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECT_ALTER=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECT_FREE=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECT_GET=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_OBJECT=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_CONTAINERDIR=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_CONTEXT=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_ERROR=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_FLUSHCACHE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_INTERFACE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_KEYRANGE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_KEY=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_LOCK=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_MEMORY=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_NEWOBJ=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_SESSION=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_STREAM=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_VAROBJECT=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OMS_VERSION=0

2010-10-04 17:54:34 1 20234 RTE TRACE_OPTIMIZE=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_ORDER_STANDARD=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_ORDER=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGER=0

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_BUP=0

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_EV=2

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_GC=20

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_LW=5

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_PG=3

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_SV=5

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_TI=2

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_US=10

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES_UT=5

2010-10-04 17:54:34 1 20234 RTE TRACE_PAGES=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_PRIMARY_TREE=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_QUERYREWRITE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_RUNTIME=0

2010-10-04 17:54:34 1 20234 RTE TRACE_SELECT=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_SHAREDSQL=0

2010-10-04 17:54:34 1 20234 RTE TRACE_SQLMANAGER=0

2010-10-04 17:54:34 1 20234 RTE TRACE_SRVTASKS=0

2010-10-04 17:54:34 1 20234 RTE TRACE_STOP_ERRORCODE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_SYNCHRONISATION=0

2010-10-04 17:54:34 1 20234 RTE TRACE_SYSVIEW=0

2010-10-04 17:54:34 1 20234 RTE TRACE_TABLE=0

2010-10-04 17:54:34 1 20234 RTE TRACE_TIME=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_UPDATE=NO

2010-10-04 17:54:34 1 20234 RTE TRACE_VOLUME=0

2010-10-04 17:54:34 1 20234 RTE TRANS_HISTORY_SIZE=0

2010-10-04 17:54:34 1 20234 RTE TRANSRGNS=8

2010-10-04 17:54:34 1 20234 RTE TRANS_THRESHOLD_VALUE=60

2010-10-04 17:54:34 1 20234 RTE _UNICODE=YES

2010-10-04 17:54:34 1 20234 RTE UPDATESTAT_PARALLEL_SERVERS=0

2010-10-04 17:54:34 1 20234 RTE UPDATESTAT_SAMPLE_ALGO=1

2010-10-04 17:54:34 1 20234 RTE UPDSTATWANTED=1

2010-10-04 17:54:34 1 20234 RTE USED_MAX_LOG_QUEUE_COUNT=16

2010-10-04 17:54:34 1 20234 RTE USESELECTFETCH=YES

2010-10-04 17:54:34 1 20234 RTE USEUNICODECOLUMNCOMPRESSION=NO

2010-10-04 17:54:34 1 20234 RTE USEVARIABLEINPUT=NO

2010-10-04 17:54:34 1 20234 RTE USE_COROUTINES=YES

2010-10-04 17:54:34 1 20234 RTE USEIOPROCS_ONLY=NO

2010-10-04 17:54:34 1 20234 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO

2010-10-04 17:54:34 1 20234 RTE USE_OPEN_DIRECT=NO

2010-10-04 17:54:34 1 20234 RTE USE_SYSTEM_PAGE_CACHE=YES

2010-10-04 17:54:34 1 20234 RTE UTILITYPROTFILE=dbm.utl

2010-10-04 17:54:34 1 20234 RTE UTILITY_PROTSIZE=100

2010-10-04 17:54:34 1 20234 RTE VOLUMENO_BIT_COUNT=8

2010-10-04 17:54:34 1 20234 RTE WORKDATASIZE=8192

2010-10-04 17:54:34 1 20234 RTE WORKSTACKSIZE=8192

2010-10-04 17:54:34 1 20234 RTE XP_CONVERTER_REGIONS=0

2010-10-04 17:54:34 1 20234 RTE XP_DATA_CACHE_RGNS=0

2010-10-04 17:54:34 1 20234 RTE XP_MAXPAGER=0

2010-10-04 17:54:34 1 20235 RTE Dump of all kernel parameters done

2010-10-04 17:54:34 1 WNG 11489 PARAM Open system console '/dev/console' reports (13) Permission denied

2010-10-04 17:54:34 1 WNG 11489 PARAM Modify parameter OPMSG1 or enable write access to prevent this message

2010-10-04 17:54:34 1 12841 DIAGHIST Backup of diagnostic files is in progress

2010-10-04 17:54:34 1 12842 DIAGHIST Backup of diagnostic files has finished

2010-10-04 17:54:34 1 12770 INFO SERVERNODE: 'sapcsp04'

2010-10-04 17:54:34 1 12932 INFO maximum cpu time: unlimited

2010-10-04 17:54:34 1 12891 INFO maximum core size: unlimited

2010-10-04 17:54:34 1 12892 INFO maximum number of open files: 256

2010-10-04 17:54:34 1 12934 INFO maximum file size: unlimited

2010-10-04 17:54:34 1 12895 INFO maximum number of threads: -1

2010-10-04 17:54:34 1 12935 INFO maximum stack size: 8 MB

2010-10-04 17:54:34 1 12893 INFO maximum virtual memory size: unlimited

2010-10-04 17:54:34 1 12894 INFO maximum heap size: unlimited

2010-10-04 17:54:34 1 12898 ENVIRON Environment dump start

2010-10-04 17:54:34 1 12898 ENVIRON DBROOT=/sapdb/CSP/db

2010-10-04 17:54:34 1 12898 ENVIRON HOME=/export/home/sdb

2010-10-04 17:54:34 1 12898 ENVIRON HZ=

2010-10-04 17:54:34 1 12898 ENVIRON LANG=C

2010-10-04 17:54:34 1 12898 ENVIRON LD_LIBRARY_PATH=/sapdb/CSP/db/lib/lib64:/sapdb/CSP/db/sap

2010-10-04 17:54:34 1 12898 ENVIRON LOGNAME=sdb

2010-10-04 17:54:34 1 12898 ENVIRON MAIL=/var/mail/sdb

2010-10-04 17:54:34 1 12898 ENVIRON PATH=/sapdb/CSP/db/bin:/sapdb/programs/bin:/usr/bin::/usr/sfw/bin:/usr/ccs/bin

2010-10-04 17:54:34 1 12898 ENVIRON PS1=sapcsp04 #

2010-10-04 17:54:34 1 12898 ENVIRON SERVERDB=CSP

2010-10-04 17:54:34 1 12898 ENVIRON SHELL=/bin/sh

2010-10-04 17:54:34 1 12898 ENVIRON TERM=dtterm

2010-10-04 17:54:34 1 12898 ENVIRON TZ=Indian/Mauritius

2010-10-04 17:54:34 1 12898 ENVIRON Environment dump completed

2010-10-04 17:54:34 1 12883 DBSTATE Core dump suppressed

2010-10-04 17:54:34 1 20219 RTE Memory allocation not limited

2010-10-04 17:54:34 1 20220 RTE System page cache usage enabled

2010-10-04 17:54:34 1 12927 TASKING Using coroutines for tasks

2010-10-04 17:54:34 1 12927 TASKING Using ucontext_t for coroutine context

2010-10-04 17:54:34 1 12692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;4us;equalize

2010-10-04 17:54:34 1 12693 TCLUSTER number of 'BUP': 0

2010-10-04 17:54:34 1 12693 TCLUSTER number of ' DW': 64

2010-10-04 17:54:34 1 12693 TCLUSTER number of ' US': 60

2010-10-04 17:54:34 1 12693 TCLUSTER number of ' SV': 28

2010-10-04 17:54:34 1 12693 TCLUSTER number of ' EV': 2

2010-10-04 17:54:34 1 12693 TCLUSTER number of ' GC': 10

2010-10-04 17:54:34 1 12692 TCLUSTER Total Number of UKT 22

2010-10-04 17:54:34 1 12692 TCLUSTER Number of UKT with User Tasks 16

2010-10-04 17:54:34 1 12698 IPC Common RTE specific IPC key: 0x44000000

2010-10-04 17:54:34 1 11536 init_shm attached shared section at 0xFFFFFFFF7CC00000

2010-10-04 17:54:34 1 11537 init_shm shared section ends at 0xFFFFFFFF7D11A000

2010-10-04 17:54:36 1 11520 PIPE_IO Input check for pipe with fstat supported

2010-10-04 17:54:36 1 11522 PIPE_IO Input check for pipe with poll supported

2010-10-04 17:54:36 1 WNG 11000 INITIAL Configured 390 files. Failed to open optional 330 self io files.

2010-10-04 17:54:36 1 WNG 11000 INITIAL Limit reached at file 241! Check user and system limits...

2010-10-04 17:54:36 1 WNG 11000 INITIAL Database tries to start now, but can run into resource problem later...

2010-10-04 17:54:37 1 12767 CLOCK started

2010-10-04 17:54:37 3 12821 TASKING Thread 3 starting

2010-10-04 17:54:37 1 12769 INFO Starting SERVERDB: '+++++++++++++++++++++++++++++++++++++++++++++++++'

2010-10-04 17:54:37 1 12769 INFO Starting SERVERDB: '+++++++++++++++++++ Kernel Forked +++++++++++++++'

2010-10-04 17:54:37 4 12821 TASKING Thread 4 starting

2010-10-04 17:54:37 1 12769 INFO Starting SERVERDB: 'CSP'

2010-10-04 17:54:37 1 12771 INFO Process ID: 22798

2010-10-04 17:54:37 1 12769 INFO Starting SERVERDB: '+++++++++++++++++++++++++++++++++++++++++++++++++'

2010-10-04 17:54:37 1 12811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2010-10-04 17:54:37 1 12812 EVENTING Eventbuffer 2 events 100 tasks

2010-10-04 17:54:37 5 12821 TASKING Thread 5 starting

2010-10-04 18:15:57 1 ERR 8 RTEMem No more system pages for 8192 bytes available,BYTE_SIZE=8192,DESCRIPTION=mmap,ERRORTEXT=EAGAIN ? too much memory

lo

2010-10-04 18:15:57 1 ERR 8 RTEMem cked

2010-10-04 18:15:57 1 ERR 11 RTEMem + Used 20643823616 bytes from system heap with a limit of system imposed limitation bytes,ALLOC_COUNT=55,FREE_

CO

2010-10-04 18:15:57 1 ERR 11 RTEMem + UNT=0,ERROR_COUNT=608,BYTES_MAX_USED=22909820928

2010-10-04 18:15:57 1 ERR 12 RTEMem + 0X3AB85FAC000 is next address in reserved address space

2010-10-04 18:15:57 1 ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted : 22369280 kB!

+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++

2010-10-04 18:15:57 0 11987 dump_rte rtedump written to file 'rtedump'

2010-10-04 18:15:57 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200

2010-10-04 18:15:57 0 ERR 12010 DBCRASH Kernel exited exit code 2

2010-10-04 18:15:57 0 12890 DIAGHIST Backup of diagnostic files will be forced at next restart

2010-10-04 18:15:57 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)

-

---

current write position -

---

.

Regards,

Panu

[former_member184473]

Hello Panu,

Just to complement the previous information, review notes [487972|http://service.sap.com/sap/support/notes/487972] and [628131|http://service.sap.com/sap/support/notes/628131] to make sure the parameter values are correctly.

Regards,

Eduardo

[Former Member]

Hi Sunil/Eduardo,

First I have installed SAP Content Server on Solaris and Maxdb 7.6 on less memory space of 250GB the installation was get error with u201Csdb_instance_start was executed with status ERROR u201C.

My knldiag logs:

2010-09-30 17:11:38 1 WNG 11000 INITIAL Configured 390 files. Failed to open optional 330 self io files.

2010-09-30 17:11:38 1 WNG 11000 INITIAL Limit reached at file 242! Check user and system limits...

2010-09-30 17:11:38 1 WNG 11000 INITIAL Database tries to start now, but can run into resource problem later...

'+++++++++++++++++++++++++++++++++++++++++++++++++'

2010-09-30 17:11:39 1 12811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2010-09-30 17:11:39 1 12812 EVENTING Eventbuffer 2 events 100 tasks

2010-09-30 17:11:39 5 12821 TASKING Thread 5 starting

2010-09-30 17:24:47 1 ERR 8 RTEMem No more system pages for 8192 bytes available,BYTE_SIZE=8192,DESCRIPTION=mmap,ERRORTEXT=EAGAIN ?

too much memory lo

2010-09-30 17:24:47 1 ERR 8 RTEMem cked

2010-09-30 17:24:47 1 ERR 11 RTEMem + Used 16102367232 bytes from system heap with a limit of system imposed limitation bytes,ALL

OC_COUNT=42,FREE_CO

2010-09-30 17:24:47 1 ERR 11 RTEMem + UNT=0,ERROR_COUNT=588,BYTES_MAX_USED=22909820928

2010-09-30 17:24:47 1 ERR 12 RTEMem + 0X2BCD5302000 is next address in reserved address space

2010-09-30 17:24:47 1 ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted : 22369280 kB!

+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++

2010-09-30 17:24:47 0 11987 dump_rte rtedump written to file 'rtedump'

2010-09-30 17:24:47 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200

2010-09-30 17:24:47 0 ERR 12010 DBCRASH Kernel exited exit code 2

2010-09-30 17:24:47 0 12890 DIAGHIST Backup of diagnostic files will be forced at next restart

2010-09-30 17:24:47 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)

Then later I deleted all the file system and re-installed it on 450GB. The installation was successful but when I restart I am unable to UP the database through dbmcli.

Regards,

Panu

[Former Member]

Can you please provide the below logs? From Database manager go to Check --> Diagnosis files -->

1) Database Trace

2) Database errors

3) Database messages

[former_member229109]

Hello Panu,

-> Are you SAP customer?

-> Please let us know with which user did you login to the database servers.

What are the ulimits of this user?

What command did you run using dbmcli tool?

-> Post the output of the commands:

uname -a

ulimit -a

Review the SAP notes - 300464, 724713 & 628131 .

Thank you and best regards, Natalia Khlopina

[Former Member]

Maybe you have set cache size to consume more than virtual or physical