AIX下安装SyBase11.92

一、数据库软件安装

1、安装要求

平台硬件软件最小内存支持的协议

IBM RS/6000 AIX 4.1.4 256MB TCP,SPX

2、为SYBASE创建用户、文件系统和环境设置

创建用户和用户组

必须为syabse在系统中创建用户组sybase和用户sybase，用户sybase的基本组为sybase。

# gounpadd sybase

# useradd –g sybase sybase

创建文件系统

建议为sybase的系统文件创建一个单独的文件系统，最好加载一块新硬盘，不然就在/下mkdir一个新目录（空间要求足够大），一般为/sybase，建议大小为1000M以上。

将文件系统mount上，修改目录/sybase的用户属主为sybase用户，组属主为sybase组。

# cd /

# mkdir sybase

# chown sybase:sybase /sybase

3、设置安装环境

环境变量设置，可以设置在用户sybase的.profile或系统/etc/profile中。

.profile部分参考设置

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$home/bin:/usr/bin/X11:/sbin

export PATH

SYBASE = /sybase (sybase的安装目录)

export DISPLAY = 80.20.16.28:0.0

DISQUERY = F50

export DISQUERY

export LD_LIBRARY _PATH = $SYBASE/lib

export PATH = $PATH: $SYBASE/install:$SYBASE/bin

NLSDATH (略)

export NLSDATH

LANG = en_US

4、软件包处理

软件包来源一般有两种，光盘或tar压缩包

例：

光盘： # mount /dev/cdrom /mnt/cdrom

压缩包：# tar xvf syb1192_AIX.tar

5、安装sybase相关软件

Adaptive Server Enterprise或SQL Server是server端产品，其他的都是client端产品，一般只需要安装ASE就可以了。

安装Adaptive Server Enterprise

1)．以用户sybase登录。

2)．在用户sybase的HOME目录下，执行相应产品光盘的安装命令。

先取得对应产品的CAS，一般写在光盘的标签上，或者在该产品的install/cas文件中。如 Adaptive Server Enterprise 11.9.2的CAS在文件install/cas中。

运行以下安装命令：

$ /cdrom/ase119/sybload -D

SYBLOAD - Product Distribution Program

Current directory is "/sybase".

Is this the correct directory for installation?

If so, please enter 'y' or 'Y': y

Is this a Local or Remote installation, as defined in your Installation Guide?

Please enter L for Local or R for Remote.

> L

Please enter the full name of the disk file of the global archive:

> /cdrom/ase1192/sybimage (/sybase/ase1192/sybimage)

You specified /cdrom/aix/sybimage for the media device. Is this correct?

please enter 'y' or 'Y' to continue: y

Please enter your Customer Authorization String, letters only:

> JLBKBK BKGKCM BYBKBF GZBYBK BKBKQP QDRX (注册码)

Sybase Products available for installation:

Product No. 1: Adaptive Server Enterprise, RS6000, 11.9.2

Product No. 2: Monitor Server for 11.9.2 ASE, RS6000, 11.9.2

Product No. 3: Monitor Server for 11.0.x SQL Server, RS6000, 11.9.2

Product No. 4: Monitor Client Library, RS6000, 11.9.2

Product No. 5: Historical Server, RS6000, 11.9.2

Product No. 6: Language Module Brazilian Portuguese, RS6000, 11.9

Product No. 7: Language Module Chinese, RS6000, 11.9

Product No. 8: Language Module French, RS6000, 11.9

Product No. 9: Language Module German, RS6000, 11.9

Product No. 10: Language Module Japanese, RS6000, 11.9

Product No. 11: Language Module Korean, RS6000, 11.9

Product No. 12: Language Module Spanish, RS6000, 11.9

Please enter the Product Numbers that you wish to install, one per line.

Terminate your entries with a blank line.

> 1

> 2

> 7

The following products were chosen for installation:

Choice No. 1: Adaptive Server Enterprise, RS6000, 11.9.2

Choice No. 2: Monitor Server for 11.9.2 ASE, RS6000, 11.9.2

Choice No. 3: Language Module Chinese, RS6000, 11.9

If this list is correct as shown,

please enter 'y' or 'Y' to continue, 'q' or 'Q' to quit,

or any other character to make another set of choices: y

x ./bin/backupserver, 1038645 bytes, 1015 tape blocks

x ./bin/bcp, 826875 bytes, 808 tape blocks

The following products have been distributed from tape:

Adaptive Server Enterprise, RS6000, 11.9.2

Monitor Server for 11.9.2 ASE, RS6000, 11.9.2

Language Module Chinese, RS6000, 11.9

This concludes the tape distribution portion of the Sybase Installation.

Please consult your Installation Guide for further installation instructions.

至此，Adaptive Server Enterprise, RS6000, 11.9.2已安装成功。

安装Open Clients/Server 11.1

$ /cdrom/opencli/sybload -D

SYBLOAD - Product Distribution Program

Current directory is "/sybase".

Is this the correct directory for installation?

If so, please enter 'y' or 'Y': y

Is this a Local or Remote installation, as defined in your Installation Guide?

Please enter L for Local or R for Remote.

> L

Please enter the full name of the disk file of the global archive:

> /cdrom/opencli/sybimage

You specified /cdrom/opencli/sybimage for the media device. Is this correct?

please enter 'y' or 'Y' to continue: y

Please enter your Customer Authorization String, letters only:

> BKBYBK BOUOBY BYBYBY BOBYBY IOWJPN DCZS

Sybase Products available for installation:

Product No. 1: Open Client/C, RS6000, 11.1

Please enter the Product Numbers that you wish to install, one per line.

Terminate your entries with a blank line.

> 1

The following products were chosen for installation:

Choice No. 1: Open Client/C, RS6000, 11.1

If this list is correct as shown, please enter 'y' or 'Y' to continue,

'q' or 'Q' to quit,

or any other character to make another set of choices: y

x ./bin/bcp, 716653 bytes, 700 tape blocks

x ./bin/bcp_dce, 732487 bytes, 716 tape blocks

x ./bin/defncopy, 656517 bytes, 642 tape blocks

安装ESQL-C

$ /cdrom/esql/sybload -D

SYBLOAD - Product Distribution Program

Current directory is "/sybase".

Is this the correct directory for installation?

If so, please enter 'y' or 'Y': y

Is this a Local or Remote installation, as defined in your Installation Guide?

Please enter L for Local or R for Remote.

> L

Please enter the full name of the disk file of the global archive:

> /cdrom/esql/sybimage

You specified /cdrom/esql/sybimage for the media device. Is this correct?

please enter 'y' or 'Y' to continue: y

Please enter your Customer Authorization String, letters only:

> BKBYSO DIBYBY BYBODD BYBYBY BKHSKR MEUD

Sybase Products available for installation:

Product No. 1: Embedded SQL/C, RS6000, 11.1

Please enter the Product Numbers that you wish to install, one per line.

Terminate your entries with a blank line.

> 1

The following products were chosen for installation:

Choice No. 1: Embedded SQL/C, RS6000, 11.1

If this list is correct as shown, please enter 'y' or 'Y' to continue,

'q' or 'Q' to quit,

or any other character to make another set of choices: y

Positioning Media For Loading - Please Wait.

x ./bin/bcp, 750177 bytes, 733 tape blocks

x ./bin/bcp_dce, 690248 bytes, 675 tape blocks

x ./bin/cpre, 917577 bytes, 897 tape blocks

x ./bin/cpre_dce, 934562 bytes, 913 tape blocks

x ./bin/defncopy, 665826 bytes, 651 tape blocks

安装XA LIBRARY FOR CICS

$ /cdrom/xa11.1/sybload -D

SYBLOAD - Product Distribution Program

Current directory is "/sybase".

Is this the correct directory for installation?

If so, please enter 'y' or 'Y': y

Is this a Local or Remote installation, as defined in your Installation Guide?

Please enter L for Local or R for Remote.

> L

Please enter the full name of the disk file of the global archive:

> /cdrom/xa11.1/sybimage

You specified /cdrom/xa11.1/sybimage for the media device. Is this correct?

please enter 'y' or 'Y' to continue: y

Please enter your Customer Authorization String, letters only:

> QFBKBY IOBXBK BYBYBO BKBKBY BYBOLO OBJZ

Sybase Products available for installation:

Product No. 1: XA Library for CICS and Encina, RS6000, 11.1.1

Please enter the Product Numbers that you wish to install, one per line.

Terminate your entries with a blank line.

> 1

The following products were chosen for installation:

Choice No. 1: XA Library for CICS and Encina, RS6000, 11.1.1

If this list is correct as shown, please enter 'y' or 'Y' to continue,

'q' or 'Q' to quit,

or any other character to make another set of choices: y

x ./devlib/libxa.a, 150644 bytes, 148 tape blocks

x ./install/SPR/cpr_xa, 2198 bytes, 3 tape blocks

x ./install/SPR/spr_xa, 800 bytes, 1 tape blocks

x ./install/setperm_xa, 1209 bytes, 2 tape blocks

x ./scripts/xasproc.sql, 7985 bytes, 8 tape blocks

x ./scripts/xaspropt.sql, 8639 bytes, 9 tape blocks

The following products have been distributed from tape:

XA Library for CICS and Encina, RS6000, 11.1.1

This concludes the tape distribution portion of the Sybase Installation.

Please consult your Installation Guide for further installation instructions.

6、安装补丁

以sybase用户登录

ASE补丁：

将ase1192/ebf/ ebf9455/目录下的所有包拷贝到/sybase/dbsys

$ mkdir dbsys

$ cd ase1192//ebf/ebf9455

$ cp –r ﹡ /sybase/dbsys

7、建服务

ASE安装完成后，查看sybase用户的.profile文件的SYBASE的路径是否正确，正确的话就可以建服务了，建服务最好直接使用向导。

以sybase用户登录

$ cd /sybase/bin

$ ./srvbuild

出现向导后开始配置服务器，具体配置略。

下来列部分配置：

sqlsrv.server_name:SYBASE (server名称)

sqlsrv.network_protocol_list:tcp

sqlsrv.network_hostname_list:192.168.0.253

sqlsrv.network_port_list:4100

sqlsrv.master_device_physical_name:/sybase/data_lv/rmster_lv

sqlsrv.master_device_size:90

sqlsrv.master_database_size:60

sqlsrv.sybsystemprocs_device_physical_name:/sybase/data_lv /rsybproc_lv

sqlsrv.sybsystemprocs_device_size:90

sqlsrv.sybsystemprocs_database_size:80

sqlsrv.default_backup_server:SYB_BACKUP(backup server名称)

bsrv.server_name SYB_BACKUP(backup server名称)

bsrv.network_protocol_list:tcp

bsrv.network_hostname_list:192.168.0.253

bsrv.network_prot_list:4200

bsrv.language:USE_DEFAULT

bsrv.character_set:iso_1

sqlsrv.server_name:SYBASE

sqlsrv.sa_login:sa

sqlsrv.sa_password:

sqlsrv.default_language:us_english

sqlsrv.default_characterset: iso_1

sqlsrv.sort_order:binary

建库成功后，启动sybase，确定sybase服务正常。

# ps –A

可以查看到进程dataserver 、backupserver

以sybase用户登陆

$ showserver

8、加载自动启动的脚本

脚本文件run内容：

# !/bin/kch

su - sybase

/sybase/install/startserver -f /sybase/install/RUN_SYBASE(服务名)

/sybase/install/startserver -f /sybase/install/RUN_SYB_BACKUP(备份服务名)

sleep 20

更改文件的权限，确保可以执行。加载到 /etc/inittab文件里

9、sybase部分执行命令(中止服务)

# su - sybase

$ isql -Usa -P -SSYBASE(服务名)

< shutdown SYBASE(服务名)

< shutdown SYB_BUCKUP(固定名称)

< go