解決solaris10上因為共用記憶體不足導致不能初始化sybase15.0.3服務的問題

---------------------------------------------------------------------------

---- 本文為andkylee個人原創，請在尊重作者勞動成果的前提下進行轉載；

---- 轉載務必註明原始出處
:
http://blog.csdn.net/andkylee

---


2010-01-12 08:59

---- 關鍵字： ASE solaris 10 shared memory projadd 共用記憶體 couldn't create
kernel region

----------------------------------------------------------------------------

此篇為對以前的問題的整理。

 

 

在solaris
10
64-bit上安裝Sybase15.0.3 ESD#1，程式安裝好了後用資源檔
resource-files來建立服務
。但是老是報不能建立共用記憶體
的錯誤。
環境為： 

　　　　　　　　　Sun
OS 5.10
Generic_127111-11 sun4v sparc SUNW,SPARC-Enterprise-T5120
　　　　　　　　　16G記憶體，64核CPU

共用記憶體已經配置為如下，故沒有調整。
root@SERVER # more /etc/system | grep shm
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmax=4294967295
*               exclude: sys/shmsys
set shmsys:shminfo_shmmax=10294967295
set shmsys:shminfo_shmmin=1
* set shmsys:shminfo_shmmni=100
* set shmsys:shminfo_shmseg=10
*       set shmsys:shminfo_shmmax = 268435456
*       set shmsys:shminfo_shmseg = 1024
*       set shmsys:shminfo_shmmni = 1024
        set shmsys:shminfo_shmmni = 4096

其中重啟過一次伺服器
。

但是用資源檔建立服務時，srvbuildres -I /app/sybase/interfaces -r
/app/sybase/srvbuild-adaptiveserver.res
一直下面的報錯。
=========================================================================
-bash-3.00$ more srvbuild0111.017
Mon Jan 11 22:55:57 2010: srvbuild/15.0.3 ESD #1/P/Sun_svr4/SunOS
5.8/EBF 16556/OPT/Mon Ma
r  9 02:14:53 PDT 2009
Mon Jan 11 22:55:57 2010: Getting attribute values from sybinit resource
file `/app/sybase
/srvbuild.adaptive_server.rs'.
Mon Jan 11 22:55:57 2010:
Mon Jan 11 22:55:57 2010:
Mon Jan 11 22:55:57 2010:
Mon Jan 11 22:55:57 2010:
type = 1
application_type = MIXED
server_page_size = 4k
master_device_physical_name = /app/sybdata/master.dat
master_device_size = 200
master_database_size = 160
sybsystemprocs_device_physical_name = /app/sybdata/rsystemprocs.dat
sybsystemprocs_device_size = 200
sybsystemprocs_database_size = 200
errorlog = /app/sybase/ASE-15_0/install/SYBASE.log
configfile = /app/sybase/ASE-15_0/SYB_XXXX_TEST.cfg
sybsystemdb_device_physical_name = /app/sybdata/rsystemdb.dat
sybsystemdb_device_size = 20
sybsystemdb_database_size = 20
tempdb_device_physical_name = /app/sybdata/tempdbdev.dat
tempdb_device_size = 100
tempdb_database_size = 100
shmem = /app/sybase/ASE-15_0
default_backup_server = SYB_XXXX_TEST_BS
ifiledir = /app/sybase
addl_cmdline_parameters =
do_configure_pci = no
sybpcidb_device_physical_name =
PUT_THE_PATH_OF_YOUR_SYBPCIDB_DATA_DEVICE_HERE
sybpcidb_device_size = 48
sybpcidb_database_size = 48
server_name = SYB_XXXX_TEST
force_buildmaster = no
do_optimize_config = no
Mon Jan 11 22:55:57 2010: (Shell command)
/app/sybase/ASE-15_0/bin/dataserver -d/app/sybda
ta/master.dat -b200M -z4k -sSYB_XXXX_TEST
-e/app/sybase/ASE-15_0/install/SYBASE.log -T1623
> /tmp/sbAAAjCaGrf 2>&1
dataserver: master device size for this server: 200.0 Mb
dataserver: master database size for this server: 26.0 Mb
dataserver: model database size for this server: 6.0 Mb
00:00000:00000:2010/01/11 22:55:57.87 kernel  SySAM: Using licenses
from: /app/sybase/SYSA
M-2_0/licenses
00:00000:00000:2010/01/11 22:55:57.96 kernel  SySAM: Checked out license
for 1 ASE_CORE (2
009.1231/permanent/19B3 47BC 0B7E 8DC3).
00:00000:00000:2010/01/11 22:55:57.96 kernel  This product is licensed
to: ASE Developer E
dition - For Development and Test use only
00:00000:00000:2010/01/11 22:55:57.96 kernel  Checked out license
ASE_CORE
00:00000:00000:2010/01/11 22:55:57.96 kernel  Adaptive Server Enterprise
(Developer Editio
n)
00:00000:00000:2010/01/11 22:55:57.97 kernel  Initializing device
/app/sybdata/master.dat
from offset 0 with zeros.
00:00000:00000:2010/01/11 22:56:00.46 kernel  Finished initialization.
00:00000:00000:2010/01/11 22:56:00.47 kernel  Using config area from
primary master device
.
00:00000:00000:2010/01/11 22:56:00.47 server  Configuration Error:
Configuration file, '/a
pp/sybase/SYB_XXXX_TEST.cfg', does not exist.
00:00000:00000:2010/01/11 22:56:00.66 kernel  Warning: A configuration
file was not specif
ied and the default file '/app/sybase/SYB_XXXX_TEST.cfg' does not exist.
ASE creates the d
efault file with the default configuration.
00:00000:00000:2010/01/11 22:56:00.68 kernel  Warning: Using default
file '/app/sybase/SYB
_XXXX_TEST.cfg' since a configuration file was not specified. Specify a
configuration file
name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/01/11 22:56:00.69 kernel  os_create_region: can't
allocate 70795264 by
tes
00:00000:00000:2010/01/11 22:56:00.69 kernel  kbcreate: couldn't create
kernel region.
00:00000:00000:2010/01/11 22:56:00.69 kernel  kistartup: could not
create shared memory
Mon Jan 11 22:56:00 2010: Buildmaster return code: 0.
sybdata/master.dat -e/app/sybase/ASE-15_0/install/SYBASE.log
-c/app/sybase/ASE-15_0/SYB_XXXX_TEST.cfg -M/app/sybase/ASE-15_0
-i/app/sybase -sSYB_XXXX_TEST -T1623 > /dev/null 2>&1
-bash-3.00$
=========================================================================

是共用記憶體的問題嗎？我不是已經按照安裝文檔上的說明修改了solaris的共用記憶體了嗎？

 

後來，經過諮詢solaris工程師，原來是solaris10和以前的solaris9在共用記憶體上有些不同。solaris10修改了共用記憶體方式，針對使用者層級可以設定使用者所能共用的記憶體段。

 

為sybase使用者在項目資料庫中添加一條記錄，命令如下：
projadd -U sybase -p 1233 -c "sybase parameters" user.sybase
projmod -sK "project.max-shm-memory=(priv,6G,deny)" user.sybase
projmod -sK "project.max-sem-ids=(priv,100,deny)" user.sybase
projmod -sK "process.max-sem-nsems =(priv,256,deny)" user.sybaseprojadd -U sybase -p 1233 -c "sybase parameters" user.sybase<br />projmod -sK "project.max-shm-memory=(priv,6G,deny)" user.sybase<br />projmod -sK "project.max-sem-ids=(priv,100,deny)" user.sybase<br />projmod -sK "process.max-sem-nsems =(priv,256,deny)" user.sybase

 

修改完之後，再次執行srvbuildres命令建立sybase主服務，成功！