SYBASE 11.0.0 For SCO Unix 安装手册

SYBASE 11.0.0 For SCO Unix 安装手册 　SYBASE SYSTEM 11.0.0 for SCO UNIX 5.0.5 　　安 装 说 明 　　1.首先必须确定网卡已正确地配置在系统上。 　　2.以root登录，用scoadmin命令创建Sybase用户，组属为Sybase 　　确定上述二部骤无误之后，我们可以转入一阶段地安装工作。 　　3.login:root 　　# divvy 　　系统 子分区（试举例） 　　NameTypeNew Fs#Fist BlockLast Block 　　bootEAFSno0019999 　　swapNON FSno120000109999 　　rootHTFSno211000709999 　　/uHTFSno37100001309999 　　raw1NON FSno4－－ 　　raw2NON FSno5－－ 　　recoverNON FSno621104542110463 　　hd0WHOLE DISKno702111471 　　raw1和raw2是Sybase的数据库设备实际存放的物理设备名称。raw1用来存放数据库，raw2用来存放事务日志。 　　在这里我们正确地分配raw1和raw2的大小： 　　假设我们定义raw1=600M, raw2=200m。 　　nName or renawe a divishon 　　cCredit a new file system on this divison 　　tSelect or change filesystem type on new filesystem 　　pPrevent a new file system from being crented on the division 　　sStart a division on a different block 　　eEnd a division on a different block 　　rRestore the original division table 　　Enter you choice or q to Quit_____ n ↙ 　　Whick division (o through 7)： 4 ↙ 　　What do your want to call it?：raw1 ↙ 　　定义起始块，按需要设定起始块： 　　Enter you choice or q Quit： S ↙ 　　Whick division ? ：4 ↙ 　　Start number block：1310000 ↙ 　　（建议：boot 的大小为20MB，u文件系统的大小为500MB） 同上，如此类推定义raw2后，屏幕应提示 　　NameTypeNew Fs#Fist BlockLast Block 　　bootEAFSno0019999 　　swapNON FSno120000109999 　　rootHTESno211000709999 　　/uEAFSno37100001309999 　　raw1NON FSno413100001910000 　　raw2NON FSno519100012110001 　　recoverNON FSno621104542110463 　　hd0aWHOLE DISKno702111471 　　Enter you choice or q to Quit q ↙ 　　系统提示： 　　iInstall the division set_up shown 　　rRetarn to the previous menu 　　eexit without installing a division table 　　Enter your choice or q to Quit i ↙ 　　然后，准备物理设备raw1, raw2，在root下将raw1, rraw1, raw2, rraw2的属性及组名更改为sybase，并且权限为666 　　# cd dev ↙ 　　# chown sybase raw* rraw* ↙ 　　# chgrp sybase raw* rraw* ↙ 　　# chmod 666 raw* rraw* ↙ 　　然后退出以Sybase用户登录系统 　　$ mkdir install ↙ 　　$ cd install ↙ 　　$ tar xv6 sco_kernel.scr ↙ 　　把光盘插入CD_ROM将它安装进文件系统，以root登录。 　　# mount /dev/cd0 /mnt ↙ 　　再次以Sybase用户登录： 　　$ cd /mnt 　　$ sybload －D ↙ 　　current directory is "/mnt"设置安装的路径 　　Is this the correct directory for installation? 　　If so, Please enter 'y' or 'n' : n ↙ 　　Please specify the correct installation directory here 　　A null entry will terminate this installation: /u/sybase ↙ 　　Current directory is "/u/Sybase" Is this the correct directory for installation? 　　If so, Please enter 'Y' or 'Y' : y 　　设置安装的方式：Is this a local or Remote in 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 : > /mnt/sybimage ↙ 　　Yor specified /mnt/sybimage for the media device, Is this correct? Please enter 'y' or 'Y' to continue: y 　　紧跟随着系统将会提示你输入Sybase产品的序列号（CAS）： 　　CAS：DVBYBY SOKOBY BYBYBD BYBKBK BZTWLO BJVL ↙ 　　正确输入序列号后，会提供一串可供安装的菜单项 　　选择1：Sybase 11.0之后回车 　　可把光盘上的Sybase安装至/u/Sybase之下。 　　至此，Sybase已安装至硬盘上面，我们可以进行设置方面地工作。 　　$ pwd ↙ $/mnt 　　$ cd.. ↙ 退出mnt目录。 　　首先, 要把在/mnt下的sybase拆卸掉,我们以root登录,执行# umount /dev/cd0 ↙ 即可 　　然后# cd /u/sybase/install ↙ “设置环境变量” 　　# SYBASE = /u/sybase; export SYBASE ↙ 　　增大SHMMAX的大小 　　# 重新链接内核 sh ./sco_kernel.scr sybase ↙ 　　# cd /etc/conf/cf.d ↙ 　　# vi stune 　　删掉MAXPMEM 0该行后，存盘退出 　　# vi mtune 　　修改NAIOHBUF该行，将50修改成500后，存盘退出 　　# cd /etc/conf/pack.d /itimer ↙ 　　# cp space.c.presyb space.c ↙ 　　# vi space.c 　　修改该行int alarm_accuracy设为等于-1； # cd /usr/lib 　　# cp aiomemlock. presyb aiomemlock ↙ 　　# vi aiomemlock （在该文件末增加一行sybase 28000000） 　　# cd /etc/conf/sdevice.d 　　# vi aio 　　将该文件重覆的两行删掉一行后，存盘退出 　　# vi suds 　　将suds该行的N，改为Y后存盘退出 　　# cd /etc/rc2.d 　　# vi S99* 　　在#字符下一行的行首加入一句： /etc/suds_ctrl -a 100 　　该100为Sybase的组号，做完此步之后 　　链接内核重新启动后，重新进入Sybase用户 　　$ cd install 　　$ sybinit 　　此时，请参考附页1，将参数设置正确，提示安装成功即可。 　　附页1 　　注：在下文中每屏信息由横线隔开，在<>中在值为输入值，MASTER设备为raw1. 　　Sybase的主目录为/u/sybase 　　SYBINIT 　　1. Release directory: /u/sybase 　　2. Edit / View Interfaces File 　　3. Configure a Server product 　　4. Configure an Open Client/Server product 　　5. Configure a Front End product 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: <3> 　　---------------------------------------------------------------------------- 　　CONFIGURE SERVER PRODUCTS 　　Product Date Installed Date Configured 　　1. SQL Server Jun 09 96 14:35 Jun 13 96 17:30 　　2. Backup Server Jun 09 96 14:35 Jun 13 96 17:32 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: <1> 　---------------------------------------------------------------------------- 　　NEW OR EXISTING SQL SERVER 　　1. Configure a new SQL Server 　　2. Configure an existing SQL Server 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: <1> 　　---------------------------------------------------------------------------- 　　ADD NEW SQL SERVER 　　1. SQL Server name:SYBASE 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the name of the new SQL Server (default is 'SYBASE'): 　　---------------------------------------------------------------------------- 　　ADD NEW SQL SERVER 　　1. SQL Server name:SYBASE 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Incomplete 　　2. MASTER DEVICE CONFIGURATION Incomplete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete 　　4. SET ERRORLOG LOCATION Incomplete 　　5. CONFIGURE DEFAULT BACKUP SERVER Incomplete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<1> 　　---------------------------------------------------------------------------- 　　SERVER INTERFACES FILE ENTRY SCREEN 　　Server name: SYBASE 　　1. Retry Count: 0 　　2. Retry Delay: 0 　　3. Add a new listener service 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<1> 　　Enter the retry count (default is '0'): <3> 　　---------------------------------------------------------------------------- 　　SERVER INTERFACES FILE ENTRY SCREEN 　　Server name: SYBASE 　　1. Retry Count: 3 　　2. Retry Delay: 0 　　3. Add a new listener service 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<2> 　　Enter the delay interval between retries (default is '0'): <3> 　　---------------------------------------------------------------------------- 　　SERVER INTERFACES FILE ENTRY SCREEN 　　Server name: SYBASE 　　1. Retry Count: 3 　　2. Retry Delay: 3 　　3. Add a new listener service 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<3> EDIT TCP SERVICE 　　1. Hostname/Address: credit.credit.COM 　　2. Port: 　　3. Name Alias: 　　4. Delete this service from the interfaces entry 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<2> 　　Enter the port number to use for this entry (default is ''):<7371> 　　---------------------------------------------------------------------------- 　　EDIT TCP SERVICE 　　1. Hostname/Address: credit.credit.COM 　　2. Port: 7371 　　3. Name Alias: 　　4. Delete this service from the interfaces entry 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　Is this information is correct? 　　---------------------------------------------------------------------------- 　　SERVER INTERFACES FILE ENTRY SCREEN 　　Server name: SYBASE 　　1. Retry Count: 3 　　2. Retry Delay: 3 　　3. Add a new listener service 　　Modify or delete a service 　　Listener services available: 　　Protocol Address Port Name Alias 　　4. tcp credit.credit.COM 7371 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　Write the changes to the interfaces file now? 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Incomplete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete 　　4. SET ERRORLOG LOCATION Incomplete 　　5. CONFIGURE DEFAULT BACKUP SERVER Incomplete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<2> 　　---------------------------------------------------------------------------- 　　MASTER DEVICE CONFIGURATION 　　1. Master Device: 　　2. Size (Meg): 29.299805 　　(建议：Master Device最好放在裸设备/dev/rraw1下) 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<1> 　　---------------------------------------------------------------------------- 　　MASTER DEVICE CONFIGURATION 　　1. Master Device: 　　2. Size (Meg): 29.299805 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<2> 　　Enter the size of the SQL sever's master device in megabutes：40 　　---------------------------------------------------------------------------------- 　MASTER DEVICE CONFIGURATION 　　1. Master Device: 　　2. Size (Meg): 40 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete 　　4. SET ERRORLOG LOCATION Incomplete 　　5. CONFIGURE DEFAULT BACKUP SERVER Incomplete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<3> 　　--------------------------------------------------------------------------- 　　SYBSYSTEMPROCS DATABASE CONFIGURATION 　　1. sybsystemprocs database size (Meg): 16 　　2. sybsystemprocs logical device name: sysprocsdev 　　3. create new device for the sybsystemprocs database: yes 　　4. physical name of new device: 　　5. size of the new device (Meg): 16 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<4> Enter the physical device name for the sybsystemprocs database: 　　（建议：sybsystemprocs database放在裸设备/dev/rraw2下） 　　--------------------------------------------------------------------------- 　　SYBSYSTEMPROCS DATABASE CONFIGURATION 　　1. sybsystemprocs database size (Meg): 16 　　2. sybsystemprocs logical device name: sysprocsdev 　　3. create new device for the sybsystemprocs database: yes 　　4. physical name of new device: /u/sybase/data/sysprocs.dat 　　5. size of the new device (Meg): 16 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Incomplete 　　5. CONFIGURE DEFAULT BACKUP SERVER Incomplete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<4> 　　--------------------------------------------------------------------------- SET ERRORLOG LOCATION 　　1. SQL Server errlrlog: /u/sybase/install/errorlog 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　--------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　　5. CONFIGURE DEFAULT BACKUP SERVER Incomplete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<5> 　　--------------------------------------------------------------------------- 　　SET THE SQL SERVER'S BACKUP SERVER 　　1. SQL Server Backuup Server name: SYB_BACKUP 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　　5. CONFIGURE DEFAULT BACKUP SERVER Complete 　　6. CONFIGURE LANGUAGES Incomplete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<6> 　　--------------------------------------------------------------------------- 　　CONFIGURE LANGUAGES 　　Current default language: us_english 　　Current default character set: ISO 8859-1 (Latin-1) - Westen European 　　8-bitcharacter set. 　　Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 　　character set (iso_1). 　　Select the language you want to install, remove, or designate as the default 　　language. 　　Language Installed? Remove Install Make default 　　1. us_english yes no no yes 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　5. CONFIGURE DEFAULT BACKUP SERVER Complete 　　6. CONFIGURE LANGUAGES Complete 　　7. CONFIGURE CHARACTER SETS Incomplete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<7> 　　--------------------------------------------------------------------------- 　　CONFIGURE CHARACTER SETS 　　Current default language: us_english 　　Current default character set: ISO 8859-1 (Latin-1) - Westen European 　　8-bitcharacter set. 　　Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 　　character set (iso_1). 　　Select the character set you want to install, remove, or designate as the 　　default character set. 　　Character set Installed? Remove Install Make default 　　1. ASCII, for use with unsp yesno no no 　　2. Code Page 437, (United S nono no no 　　3. Code Page 850 (Multiling nono no no 　　4. ISO 8859-1 (Latin-1) - W yesno no yes 　　5. Macintosh default charac nono no no 　　6. Hewlett-Packard propriet nono no no 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　---------------------------------------------------------------------------- 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　　5. CONFIGURE DEFAULT BACKUP SERVER Complete 　　6. CONFIGURE LANGUAGES Complete 　　7. CONFIGURE CHARACTER SETS Complete 　　8. CONFIGURE SORT ORDER Incomplete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<8> 　　--------------------------------------------------------------------------- 　　CONFIGURE SORT ORDER 　　Current default language: us_english 　　Current default character set: ISO 8859-1 (Latin-1) - Westen European 　　8-bitcharacter set. 　　Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 　　character set (iso_1). 　　Select a sort order. 　　SortOrder Chosen 　　1. Binary ordering, for the ISO 8859/1 or Latin-1 characterset set (is yes 　　2. General purpose dictionary ordering. no 　　3. Dictionary order, case insensitive, accent insensitive. no 　　4. Dictionary order, case insensitive. no 　　5. Dictionary order, case insensitive with preference. no 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　------------------------------------------------------------------------------ 　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　　5. CONFIGURE DEFAULT BACKUP SERVER Complete 　　6. CONFIGURE LANGUAGES Complete 　　7. CONFIGURE CHARACTER SETS Complete 　　8. CONFIGURE SORT ORDER Complete 　　9. ACTIVATE AUDITING Incomplete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return:<9> 　　--------------------------------------------------------------------------- 　　ACTIVATE AUDITING 　　1. Install auditing: no 　　2. sybsecurity database size (Meg): 5 　　3. sybsecurity logical device name: sybsecurity 　　4. creat new device for the sybsecurity database: no 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　------------------------------------------------------------------------------ 　　SQL SERVER CONFIGURATION 　　1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete 　　2. MASTER DEVICE CONFIGURATION Complete 　　3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete 　　4. SET ERRORLOG LOCATION Complete 　　5. CONFIGURE DEFAULT BACKUP SERVER Complete 　　6. CONFIGURE LANGUAGES Complete 　7. CONFIGURE CHARACTER SETS Complete 　　8. CONFIGURE SORT ORDER Complete 　　9. ACTIVATE AUDITING Complete 　　Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. 　　Enter the number of your choice and press return: 　　Execute the SQL Server Configuration now? 　　--------------------------------------------------------------------------- 　　<在这需要等5分钟,可出如下提示> 　　Running task to create the master device. 　　Building the master device 　　...................................Done 　　Task to create the msster device succeeded. 　　Running task jto boot the SQL Server. 　　Task to boot the SQL Server succeeded. 　　Running task to create the sybsystemprocs database. 　　sybsystemprocs database created. 　　Task to created the sybsystemprocs database succeeded. 　　Running task to install system stored procedures. 　　............................................................................ 　　..................................................... 　　Task to install system stored procedures succeeded. 　　Running task to