guojing219 发表于 2009-07-03 10:42

sybase 增加新的设备在新的裸设备,高手请进,帮我看下错误原因啊?

sybase在sco unix5.0.6下安装成功后,在数据库下面需要增加新的设备在新的裸设备上面。小妹请高手们多多请指点!
我这样建立的啊?怎么报错啊?
我将裸设备划分在第一个区,空间4G应该是够的啊?vdevno=4,4也没有占用啊?到底是什么原因啊?
rsyb_hssb的权限和组我都更改了!列在下面。
我的操作:
1> disk init
2> name='hssb01',
3> physname='/dev/rsyb_hssb',
4> vdevno=4,size=256000
5> go
Msg 5115, Level 16, State 1:
Line 1:
I/O error during disk initialization.PHYSNAME '/dev/rsyb_hssb' may be
incorrect or 255999 (VSTART + SIZE) may exceed the size of the device.Please
consult the SQL Server error log for more details.
1>


+-------------------+------------+--------+---+-------------+------------+
| Name            | Type       | New FS | # | First Block | Last Block |
+-------------------+------------+--------+---+-------------+------------+
| syb_hssb          | NON FS   |no    | 0 |            0|   4120199|
|                   | NOT USED   |no    | 1 |            -|         -|
|                   | NOT USED   |no    | 2 |            -|         -|
|                   | NOT USED   |no    | 3 |            -|         -|
|                   | NOT USED   |no    | 4 |            -|         -|
|                   | NOT USED   |no    | 5 |            -|         -|
|                   | NOT USED   |no    | 6 |            -|         -|
| hd1a            | WHOLE DISK |no    | 7 |            0|   143334463|
+-------------------+------------+--------+---+-------------+------------+
143330400 1K blocks for divisions, 4064 1K blocks reserved for the system
n       Name or rename a division.
c   Create a new file system on this division.
d   Delete a file system on this division.
t       Select or change filesystem type on new filesystems.
p    Prevent a new file system from being created on this division.
s      Start a division on a different block.
e      End a division on a different block.
r    Restore the original division table.
# l -l rsyb*
crwxrwxrwx   1 sybase   sybase   1,104 Jul7 09:57 rsyb_hssb

错误日志如下:
00:09/07/07 10:22:11.10 kernelInitializing virtual device 4, '/dev/rsyb_hssb'
00:09/07/07 10:22:11.10 kernelVirtual device 4 started using asynchronous i/o.
00:09/07/07 10:22:11.10 kernelsddone: write error on virtual disk 4 block 0:
00:09/07/07 10:22:11.10 kernelsddone: No such device or address
00:09/07/07 10:22:11.10 kernelDeactivating virtual device 4, '/dev/rsyb_hssb'

65482473

[ 本帖最后由 guojing219 于 2009-7-7 10:30 编辑 ]

chuxu 发表于 2009-07-03 11:19

要看报的是什么错误

WFCJZ 发表于 2009-07-03 11:20

能否把报错贴出来?

guojing219 发表于 2009-07-03 11:33

有没有关于在裸设备上建立设备的例子?或者文档呢?数据库装在第一个硬盘,

[ 本帖最后由 guojing219 于 2009-7-7 10:20 编辑 ]

guojing219 发表于 2009-07-03 14:50

如上

[ 本帖最后由 guojing219 于 2009-7-7 10:21 编辑 ]

camham 发表于 2009-07-03 17:37

size=10240试试,如果不成功再加参数vstart=4096试试

WFCJZ 发表于 2009-07-03 19:55

以下是SYBASE官方网站的,你可以看看,具体情况具体分析!看看有用没!

Disk Errors
This section contains error messages pertaining to disk activation and system administrator disk commands.




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

Error 5115
Severity
16


Message text
I/O error during disk initialization.PHYSNAME '%.*s' may be incorrect or %ld (VSTART + SIZE) may exceed the size of the device.Please consult the SQL Server error log for more details.


This error may be caused by a hardware problem.

Explanation
This error occurs when a disk init command fails. It can occur for the following reasons:

Incorrect physical device name

Incorrect size

Virtual device number not unique

Permission problem

UNIX kernel not configured for asynchronous I/O.


Action
Check the Adaptive Server error log for information that might help determine the cause of the error.

If necessary, check the items mentioned in the sections below.

Make any needed changes and then run the command again.




Incorrect Device Name
Make sure you have the correct physical device name. Refer to the Adaptive Server installation and configuration guide or the System Administration Guide for instructions.



Incorrect Size
The size parameter of the disk init command must be specified in units of 2K blocks in version 12.0.x and earlier ; or Kilobytes (k or K), Megabytes(m or M), or Gigabytes (g or G) in 12.5 and later.

Sizing 2K units

There are 512 2K blocks in 1MB. Use the formula:

#_of_Megabytes * #_of_data_pages_per_Megabyte = #_of_2K_blocks


For example, to initialize a 10MB Sybase device, specify 5120 for the size:

10MB * 512 = 5120


To determine the number of 2K blocks to use for a raw partition on a UNIX system, convert the size of the partition, in sectors, to 2K blocks. The size of a sector varies on different UNIX systems. For example, it is 512 bytes on Sun, so use sectors/4 for the size parameter. It is 1024 bytes on HP, so use sectors/2. Also, see the information below about virtual device numbers. You must restart Adaptive Server or use a different virtual device number when you reissue the disk init command.

Refer to the Adaptive Server installation and configuration guide for more information about Sybase and your operating system's partitions.

Not all operating systems have partitions as described above.



Virtual Device Number
The vdevno parameter of the disk init command must be unique. Also, if a disk init command fails, Adaptive Server saves the vdevno used, even though the disk init command failed. To make the vdevno available again, restart Adaptive Server. Use sp_helpdevice to determine which virtual device numbers have been used.

The available number of virtual devices is equal to the number of configured devices minus one. For example, if the number of devices configuration parameter is set to 10, then there are 9 available devices, 1 through 9.



Permission Problem
If Adaptive Server was started by the “sybase” account, it must have permission to write to the raw partition or to create a file in the directory specified by disk init. Raw partitions used by Sybase should always be owned by the “sybase” account. Correct the permissions problem and execute the command again, using a different vdevno. Refer to “Virtual Device Number” for more information.



UNIX Kernel
If the UNIX kernel (on SunOS 4.x/Sun Solaris 1.x systems only) is not configured for asynchronous I/O, the 5115 error occurs only if your master device is on a UNIX file, and you are trying to do a disk init on a raw partition. Have your UNIX administrator rebuild the kernel to allow for asynchronous I/O. Refer to Error 823 for more information.

Versions in which this error is raised
All versions

guojing219 发表于 2009-07-07 10:20

原帖由 camham 于 2009-7-3 17:37 发表 http://bbs3.chinaunix.net/images/common/back.gif
size=10240试试,如果不成功再加参数vstart=4096试试
试过了,还是不行。报的是同样的错误!

hobbylu 发表于 2009-07-07 14:26

你的目标是建一个512M的库,是吧。
给你几条思路
1、确定这个设备上是否有其他的数据库使用这块设备
2、将该设备重建,大小不超过2GB

guojing219 发表于 2009-07-07 16:33

回复 #9 hobbylu 的帖子

我把裸设备全部删除了,重新建立的,现在还没有建立任何数据库,因为系统是我刚装起来的
页: [1] 2
查看完整版本: sybase 增加新的设备在新的裸设备,高手请进,帮我看下错误原因啊?