电脑技术学习

安装Sybase后新建server时遇到的错误现象

dn001
错误案例:,/B>AIX环境下安装Sybase,新建server时遇到以下错误:

exec(): 0509-036 Cannot load program /usr/sybase/ASE-12_5/bin/dataserver because of the following errors:

0509-130 Symbol resolution failed for /usr/ccs/lib/libc.a[aio_64.o] because:

0509-136 Symbol kaio_rdwr64 (number 0) is not exported from

dependent module /unix.

0509-136 Symbol listio64 (number 1) is not exported from

dependent module /unix.

0509-136 Symbol acancel64 (number 2) is not exported from

dependent module /unix.

0509-136 Symbol iosuspend64 (number 3) is not exported from

dependent module /unix.

0509-136 Symbol aio_nwait (number 4) is not exported from

dependent module /unix.

0509-136 Symbol aio_nwait64 (number 5) is not exported from

dependent module /unix.

0509-136 Symbol aio_nwait_timeout (number 6) is not exported from

dependent module /unix.

0509-136 Symbol aio_nwait_timeout64 (number 7) is not exported from

dependent module /unix.

0509-028 Symbol used in ? type does not match exported type.

0509-192 Examine .loader section symbols with the

'dump -Tv' command.

检查后发现AIX的异步IO没打开。修改参数后,重启机器。

chdev -l aio0 -P -a autoconfig='available'

新建server 即可正常安装。

$ srvbuildres -r srvbuild.TIPS.rs

Directory is not a suitable Sybase directory.

Port number '5000' is being reserved or currently in use by a running server.

Building Adaptive Server 'TIPS':

Writing entry into directory services...

Directory services entry complete.

Building master device...

Master device complete.

Writing RUN_TIPS file...

RUN_TIPS file complete.

Starting server...

Server started.

Building sysprocs device and sybsystemprocs database...

sybprocs device and sybsystemprocs database created.

Running installmaster script to install system stored procedures...

installmaster: 10% complete.

installmaster: 20% complete.

installmaster: 30% complete.

installmaster: 40% complete.

installmaster: 50% complete.

installmaster: 60% complete.

installmaster: 70% complete.

installmaster: 80% complete.

installmaster: 90% complete.

installmaster: 100% complete.

installmaster script complete.

Creating two-phase commit database...

Two phase commit database complete.

Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,

Macintosh and HP Roman-8)...

Character sets installed.

Setting server name in Adaptive Server...

Server name added.

Server 'TIPS' was successfully created.

备注:

srvbuild.TIPS.rs 文件内容

srvbuild.release_directory: /export/home/sybase/ASE-12_5

srvbuild.product: sqlsrv

srvbuild.server_name: TIPS

srvbuild.new_config: yes

srvbuild.do_add_server: yes

srvbuild.do_upgrade: no

srvbuild.network_protocol_list: tcp

srvbuild.network_hostname_list: rp3440

srvbuild.network_port_list: 5000

srvbuild.server_page_size: 4k

srvbuild.master_device_physical_name: /export/home/sybase/data/master.dat

srvbuild.master_device_size: 200

srvbuild.master_database_size: 50

srvbuild.errorlog: /export/home/sybase/ASE-12_5/install/TIPS.log

srvbuild.sybsystemprocs_device_physical_name: /export/home/sybase/data/sysprocs.dat

srvbuild.sybsystemprocs_device_size: 120

srvbuild.sybsystemprocs_database_size: 120

srvbuild.sybsystemdb_device_physical_name: USE_DEFAULT

srvbuild.sybsystemdb_device_size: 5

srvbuild.sybsystemdb_database_size: 5

srvbuild.default_backup_server: TIPS_BS