srvbuildres后提示这该死的错误--请经验人士帮忙--实在没辙了

wangliangkaiser

srvbuildres: Server 'SYBASE' was not created.
$ vi ase.rs
nit.release_directory: /sybase
sybinit.product: sqlsrv
sqlsrv.server_name: SYBASE
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: 192.168.1.168
sqlsrv.network_port_list: 8000
sqlsrv.master_device_physical_name: /sybase/data/master
sqlsrv.master_device_size: 200
sqlsrv.master_database_size: 150
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /sybase/data/systemprocs
sqlsrv.sybsystemprocs_device_size: 200
sqlsrv.sybsystemprocs_database_size: 140
sqlsrv.sybsystemdb_device_physical_name: /sybase/data/systemdb
sqlsrv.sybsystemdb_device_size: 200
sqlsrv.sybsystemdb_database_size:150
sqlsrv.default_backup_server: SYB_BACKUP

----执行srvbuildres -r /sybase/init/sample_resource_files/ase.rs--提示错误信息，没见过这样的错误
$ srvbuildres -r ./ase.rs
srvbuildres: Building Adaptive Server 'SYBASE':
srvbuildres: Building master device...
srvbuildres: Master device complete.
srvbuildres: Writing entry into directory services...
srvbuildres: Directory services entry complete.
srvbuildres: Writing RUN_SERVER file...
srvbuildres: RUN_SERVER file complete.
srvbuildres: Starting server...
srvbuildres: Server started.
srvbuildres: Building sysprocs device and sybsystemprocs database...
srvbuildres: Task failed
srvbuildres: Adaptive Server message: 'Message number: 692, Severity 20, State
1, Line 1
Message String: Uninitialized logical page '61184' was read while accessing
object '99' in database '4'. Please contact Sybase Technical Support.
'.  Adaptive Server message: 'Message number: 1813, Severity 16, State 1, Line
1
Message String: Cannot open new database 'sybsystemprocs'. CREATE DATABASE is
aborted.
'.
Error in query: 'create database sybsystemprocs on sysprocsdev = 140'.

srvbuildres: Server 'SYBASE' was not created.

------各位，我郁闷死了----

tomer

检查/sybase/data/的权限是否正确

还有就是共享内寸设置了吗

wangliangkaiser

/sybase/data/ 权限都是 sybase用户 sybase组 的
---stune---
# vi stune
NUMREGPT        256
NUMSCOPT        32
DRV_SEGKMEM_BYTES       0x147A000
RSTCHOWN        0
CONSOLE_SECURITY        0
SHMMNI  100
SHMSEG  15
SHMMAX  268435456
SHMALL  2048
NPROC   500
ARG_MAX 51200
SFNOLIM 400
SFSZLIM 0x7FFFFFFF
HFSZLIM 0x7FFFFFFF
SDATLIM 0x7FFFFFFF
HDATLIM 0x7FFFFFFF
SCORLIM 0x7FFFFFFF
HCORLIM 0x7FFFFFFF
SVMMLIM 0x7FFFFFFF
HVMMLIM 0x7FFFFFFF
SSTKLIM 0x7FFFFFFF
HSTKLIM 0x7FFFFFFF
MSGMAX  32768
"stune" 31 lines, 455 characters

共享内存256M 也就是SHMMAX  268435456

wangliangkaiser

/sybase/data 目录里的权限都是 777 了，我刚才试了哈，还是报同样错误
我没辙了。。。

wangliangkaiser

发现原因了，裸设备越界问题。。。。。

hobbylu

看倪是什么操作系统，有些操作系统设备的前面一段地址是不能被使用的，所以你需要避过这些地址

pngzhy

请问搂主wangliangkaiser ，你具体是怎么解决的，我遇到的问题和你所讲的完全一样，但我对这些完全不懂，希望不吝赐教。。。谢谢！

pngzhy

Server Message:  Number  5115, Severity  16
Line 1:
I/O error during disk initialization.  PHYSNAME '/home/sybase/data/hisindexdb.dat' may be incorrect or 153599 (VSTART + SIZE) may exceed the size of the device.  Please consult the SQL Server error log for more details.
Server Message:  Number  102, Severity  15

建库时，执行
disk init
name='hisindexdb',
physname='/home/sybase/data/hisindexdb.dat',
vdevno=8,
size=153600
go
报上面错，这个裸设备大小是300M
请高手指点。。

sean_server

size的单位是2k，你初始化空间超过了设备大小

pngzhy

原帖由 sean_server 于 2008-4-26 01:22 发表
size的单位是2k，你初始化空间超过了设备大小

确实是超过了设备大小，第一次弄这个，问题太多了都不知道

谢谢。。。！