错误案例:,/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