Sybase数据库安装及配置.doc

Case库sybase数据库安装安装环境系统：Red Hat Enterprise Linux AS release 4 (Nahant Update 5)主机名：dbIP地址：172.16.9.86内核：2.6.9-55.Elsmp内存：4G交换分区：4GCPU：Intel(R) Xeon(R) 2GHz （2颗，32bits）安装前准备1、新建安装用户sybaserootdb etc# useradd d /opt/sybase m sybaserootdb etc# id sybaseuid=505(sybase) gid=505(sybase) groups=505(sybase)2、修改内核参数在/etc/sysctl.conf文件中加入如下三行：kernel.shmmax=1000000000kernel.exec-shield=0kernel.exec-shield-randomize=0然后执行如下命令，使修改生效：rootdb etc# sysctl p检查修改是否生效：rootdb etc# sysctl kernel.shmmaxkernel.shmmax = 1000000000rootdb etc# sysctl kernel.exec-shield kernel.exec-shield = 0rootdb etc# sysctl kernel.exec-shield-randomizekernel.exec-shield-randomize = 0安装在图形界面下进行安装安装目录：/opt/sybase安装版本：Adaptive Server Enterprise 12.5.2 EBF 11949 linux以sybase用户登陆服务器图形界面，首先解压安装包sybase db inst$ tar xvfz ase1252_de_linux.tgz然后执行安装命令：sybase db inst$./setup根据提示进行设置，选择“Typical”安装。安装后， 修改sybase用户的.bash_profile文件。在该文件的末尾加入如下内容：. /opt/sybase/SYBASE.sh。修改完成后，注销用户，然后重新以sybase用户登陆系统。检查服务是否已经起来：sybasedb $ /opt/sybase/ASE-12_5/install/showserverF S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD0 S sybase 13725 13724 0 76 0 - 11689 - May08 ? 00:00:00 /opt/sybase/ASE-12_5/bin/monserver -SDB -Usa -P -l/opt/sybase/ASE-12_5/install/DB_MS.log -L/opt/sybase/ASE-12_5/DB_MS.cfg -m/opt/sybase/ASE-12_5 -MDB_MS0 S sybase 13597 13596 0 75 0 - 18861 - May08 ? 00:01:36 /opt/sybase/ASE-12_5/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-12_5/install/DB.log -c/opt/sybase/ASE-12_5/DB.cfg -M/opt/sybase/ASE-12_5 sDB登陆数据库sybasedb $ isql -Usa -P -SdbCT-LIBRARY error: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.通过google、baidu，以及重装数据库后，该问题一直没有得到解决，在陈川的帮助下解决，问题处在-S的db应该写成大写DB！sybasedb $ isql -Usa -SDB Password: Msg 2401, Level 11, State 2:Server DB:Character set conversion is not available between client character set utf8and server character set iso_1.No conversions will be done.1关闭数据库1 shutdown2 go启动数据库sybasedb $ /opt/sybase/ASE-12_5/install/startserver f RUN_DB数据库配置查看数据库现状1 2 sp_helpdb3 go name db_size owner dbid created status - - - - - - master 6.0 MB sa 1 May 08, 2008 mixed log and data model 2.0 MB sa 3 May 08, 2008 mixed log and data sybsystemdb 2.0 MB sa 31513 May 08, 2008 mixed log and data sybsystemprocs 120.0 MB sa 31514 May 08, 2008 trunc log on chkpt, mixed log and data tempdb 3.0 MB sa 2 May 08, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data (1 row affected)(return status = 0)创建设备1 disk init name = casedev01,physname=/oradata/sybase/sicase/casedev01,size=1024m 2 disk init name = casedev02,physname=/oradata/sybase/sicase/casedev02,size=1024m 3 disk init name=tempdev01,physname=/oradata/sybase/sicase/tempdev01,size=500m4 go创建数据库1 2 create database sicase on casedev01=1000m, casedev02=1000m3 goCREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on diskcasedev01.CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on diskcasedev02.扩展临时库1 alter database tempdb on tempdev01=500m2 goExtending database by 256000 pages (500.0 megabytes) on disk tempdev011 sp_helpdb tempdb2 go name db_size owner dbid created status - - - - - - tempdb 503.0 MB sa 2 May 08, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data (1 row affected) device_fragments size usage created free kbytes - - - - - master 3.0 MB data and log May 8 2008 2:42PM 1802 tempdev01 500.0 MB data and log May 8 2008 3:02PM 509986 (return status = 0)添加用户1 sp_addlogin con,sitechcase,sicase2 goPassword correctly set.Account unlocked.New login created.(return status = 0)1 use sicase2 go1 sp_adduser con2 goNew user added.(return status = 0)1 sp_role grant,sa_role ,con2 goAuthorization updated.(return status = 0)1 sp_role grant,sso_role,con2 goAuthorization updated.(return status = 0)更改数据库属主1 use sicase2 sp_changedbowner con sicase3 goMsg 102, Level 15, State 1:Server DB, Line 2:Incorrect syntax near sp_changedbowner.1 EXEC sp_changedbowner con2 goMsg 17362, Level 16, State 1:Server DB, Procedure sp_changedbowner, Line 97:The proposed new db owner already is a user in the database or owns thedatabase.(return status = 1)上面命令没有成功更改数据库属主，问题出在con应经是该数据库的用户了，所以应该首先在该库中删除con用户1 sp_dropuser con2 goUser has been dropped from current database.(return status = 0)1 sp_changedbowner con2 goDBCC execution completed. If DBCC printed error messages, contact a user withSystem Administrator (SA) role.Database owner changed.(return status = 0)1 sp_helpdb2 go name db_size owner dbid created status - - - - - - master 6.0 MB sa 1 May 08, 2008 mixed log and data model 2.0 MB sa 3 May 08, 2008 mixed log and data sicase 2000.0 MB con 4 May 08, 2008 select into/bulkcopy/pllsort, mixed log and data sybsystemdb 2.0 MB sa 31513 May 08, 2008 mixed log and data sybsystemprocs 120.0 MB sa 31514 May 08, 2008 trunc log on chkpt, mixed log and data tempdb 503.0 MB sa 2 May 08, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data (1 row affected)(return status = 0)解决不能telnet本机5000端口问题正常运行情况下，应用程序必须能访问5000端口。但是本机的5000端口只有本地才能访问。rootdb # lsof -i :5000COMMAND PID USER FD TYPE DEVICE SIZE NODE NAMEdataserve 21221 sybase 13u IPv4 18952868 TCP db:5000 (LISTEN)dataserve 21221 sybase 14u IPv4 18998135 TCP db:5000-db:45610 (ESTABLISHED)isql 29121 sybase 6u IPv4 18998134 TCP db:45610-db:5000 (ESTABLISHED)该命令显示5000端口已经打开，并且已有本地的访问连接，说明数据库的功能没有问题。sybasedb sybase$ netstat -anv | grep 500*tcp 0 0 127.0.0.1:5000 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5001 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5002 0.0.0.0:* LISTEN tcp 0 0