Failed to start SAPDB instance
I just installed MaxDB 7.6 in AIX 5.3. During the installation, I created the user "sdb", instance name "TST".
Under this sdb user, I ran this "./x_server start" to start the db server.
After that I used the command "./x_start TST "
Then I hit the follow error:
--- Starting GMT 2008-11-28 10:08:33 7.6.03 Build 009-123-163-622
2008-11-28 18:08:37 1 ERR 8 RTEMem No more system pages for 12288 bytes available,BYTE_SIZE=4096,DESCRIPTION=valloc,ERRORTEXT=ENOMEM ? out of memory
2008-11-28 18:08:37 1 ERR 11 RTEMem + Used 130277376 bytes from system heap with a limit of system imposed limitation bytes,ALLOC_COUNT=22,FREE_COUN
2008-11-28 18:08:37 1 ERR 11 RTEMem + T=0,ERROR_COUNT=275,BYTES_MAX_USED=13604741120
2008-11-28 18:08:37 1 ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted : 13282304 kB!
2008-11-28 18:08:37 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200
2008-11-28 18:08:37 0 ERR 12010 DBCRASH Kernel exited exit code 2
2008-11-28 18:08:37 ___ Stopping GMT 2008-11-28 10:08:37 7.6.03 Build 009-123-163-622
The interesting thing is that I am able to start the db instance from Database Manager.
Can anyone please help me to take a look at this issue? Is it the system memory problem? Or is it becasue the way I start db instance by unix command is wrong?
Thanks in advance!!
Lars Breddemann replied
would you mind to check the documentation from time to time ? [http://maxdb.sap.com/documentation]
DBMGUI is not the only way (as I already indicated).
You may use dbmcli as well:
dbmcli -n <dbhostname> -d <DBSID> -u control,<pw> db_online
or, if you already setup the XUSER data correctly you may simply use:
dbmcli -U c db_online
By the way: SAP offers trainings on MaxDB (ADM515) - so your boss may want to book some of those...