安装Sybase ASE 15.5在浅顶软呢帽13

# useradd -d /opt/sybase -c "Sybase ASE account" -g users -m -- sybase

To view current value:
# cat /proc/sys/kernel/shmmax

To set it to a new value for this running session (takes effect immediately):
# echo 268435456 > /proc/sys/kernel/shmmax

To set it to a new value permanently (so it survives reboots), edit /etc/sysctl.conf:
....
kernel.shmmax = 268435456
....

compat-libstdc++-33-3.2.3-68
libaio
libaio-devel

glibc-2.12-2.i686
libXext-1.1-2.fc13.i686
libXtst-1.0.99.2-3.fc12.i686

[sybase]$ ./setup.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
strings: '/lib/libc.so.6': No such file
[sybase]$

Graphical installers are not supported by the VM. The console mode will
be used instead...

# xhost si:localuser:sybase

export LD_POINTER_GUARD=0
export SYBASE=/opt/sybase
. ./SYBASE.sh

[sybase]$ showserver
F S UID        PID  PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
0 S sybase    7573  7572 34  80   0 - 91438 poll_s 18:14 ?        00:00:03 /opt/sybase/ASE-15_0/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-15_0/install/ULTRA.log -c/opt/sybase/ASE-15_0/ULTRA.cfg -M/opt/sybase/ASE-15_0 -sULTRA
[sybase]$

[sybase@ultra ASE-15_0]$ isql -Usa  -P -SULTRA
1> select @@version
2> go
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Adaptive Server Enterprise/15.5/EBF 17340 SMP/P/x86_64/Enterprise Linux/ase155/2391/64-bit/FBO/Mon Nov  9 18:44:45 2009                                                                                                                                                                                                                                                                                                                                                                                                        

(1 row affected)
1> quit
[sybase]$

[sybase]$ isql -Usa -P -Sserver_name
1> sp_password null, NEWPASSWORD
2> go
1> quit
[sybase]$

[sybase]$ isql -Usa -PXXXXXX -SULTRA
1> disk init name='test', physname='/var/lib/sybase/test.dat', size='64m'
2> go
00:00:00000:00023:2010/07/02 12:59:56.44 kernel  Initializing virtual device 5, '/var/lib/sybase/test.dat' with dsync 'off'.
00:00:00000:00023:2010/07/02 12:59:56.44 kernel  Virtual device 5 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00023:2010/07/02 12:59:56.44 kernel  Initializing device /var/lib/sybase/test.dat from offset 0 with zeros.
00:00:00000:00023:2010/07/02 12:59:59.27 kernel  Finished initialization.
1> disk init name='testlog', physname='/var/lib/sybase/test-bs.dat', size='64m'
2> go
00:00:00000:00023:2010/07/02 13:01:04.34 kernel  Initializing virtual device 6, '/var/lib/sybase/test-bs.dat' with dsync 'off'.
00:00:00000:00023:2010/07/02 13:01:04.34 kernel  Virtual device 6 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00023:2010/07/02 13:01:04.34 kernel  Initializing device /var/lib/sybase/test-bs.dat from offset 0 with zeros.
00:00:00000:00023:2010/07/02 13:01:07.08 kernel  Finished initialization.
1> create database test on test='64m' log on test-bs='64m'
2> go
CREATE DATABASE: allocating 16384 logical pages (64.0 megabytes) on disk 'test' (16384 logical pages requested).
CREATE DATABASE: allocating 16384 logical pages (64.0 megabytes) on disk 'test-bs' (16384 logical pages requested).
Database 'test' is now online.
1> quit
[sysbase]$

[sybase]$ isql -Usa -PXXXXX -SULTRA
1> use  sybsystemprocs
2> go
1> sp_configure "xp_cmdshell context", 0
2> go
 Parameter Name
	 Default                                  Memory Used
	 Config Value
	 Run Value
	 Unit
	 Type
 --------------------------------------------------------------------------------------------------------------------------
 --------------------------------------------------------------------------------------------------------------------------
 xp_cmdshell context
	           1                                        0
	            0
	            0
	 switch
	 dynamic                                  

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is dynamic.
Changing the value of 'xp_cmdshell context' does not increase the amount of memory Adaptive Server uses.
(return status = 0)
1>
1> xp_cmdshell date
2> go
 xp_cmdshell
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sat Jul  3 23:04:07 EDT 2010

(1 row affected)
(return status = 0)
1> quit
[sybase]$

#!/bin/bash
#
# sybase      This shell script takes care of starting and stopping Sybase ASE
#
# chkconfig: - 86 16
#
# config: /etc/sysbase/sybase.conf
#
### BEGIN INIT INFO
# Provides: dataserver
# Required-Start:
# Required-Stop:
# Should-Start:
# Short-Description: start and stop Sybase ASE database
# Description:
### END INIT INFO

# Source function library
if [[ -r /etc/rc.d/init.d/functions ]]; then
   . /etc/rc.d/init.d/functions
else
   exit 1
fi

# Source sybase configuration
if [[ -r /etc/sybase/sybase.conf ]]; then
   . /etc/sybase/sybase.conf
else
   exit 1
fi

# Source sybase variables
if [[ -r ${SYBASE_HOME}/SYBASE.sh ]]; then
   . ${SYBASE_HOME}/SYBASE.sh
else
   exit 1
fi

# Find the name of the script
BASENAME=$(basename $0)

# For SELinux we need to use 'runuser' not 'su'
if [[ -x /sbin/runuser ]]; then
    SU=/sbin/runuser
else
    SU=/bin/su
fi

RETVAL=0

start() {
    SYBASE_START=$"Starting ${BASENAME} service: "
    echo -n "$SYBASE_START"
    $SU -l sybase -c "startserver -f ${SYBASE}/${SYBASE_ASE}/install/RUN_${SYBASE_SERVER}" > /dev/null
    # ret=$?
    if [[ $? -eq 0 ]]; then
        success "$SYBASE_START"
    else
        failure "$SYBASE_START"
        RETVAL=1
    fi
    echo
}

stop() {
    echo -n $"Stopping ${BASENAME} service: "
    $SU -l sybase -c "isql -S ${SYBASE_SERVER} -U sa < ${SYBASE}/stop.in" > /dev/null
    # ret=$?
    if [[ $? -eq 0 ]]; then
        echo_success
    else
        echo_failure
        RETVAL=1
    fi
    echo
}

case $1 in
    start)
        start
        ;;
    stop)
        stop
        ;;
    status)
        CNT=$($SU -l sybase -c "showserver" | /usr/bin/wc -l | /usr/bin/cut -f1)
        RETVAL=$?
        if [[ $CNT -eq 1 ]]; then
            echo "$BASENAME is stopped ..."
        else
            echo "$BASENAME is running ..."
        fi
        ;;
    restart)
        stop
        start
        ;;
    *)
        echo $"Usage: $0 {start|stop|status|restart}"
        RETVAL=3

esac

exit $RETVAL

# cat /etc/sybase/sybase.conf
SYBASE_HOME="/opt/sybase"
SYBASE_SERVER="ULTRA"
#

PASSWORD
shutdown
go
shutdown SYB_BACKUP
go
quit

# service sybase start
Starting sybase service:                                   [  OK  ]
# service sybase status
sybase is running ...
# service sybase stop
Stopping sybase service:                                   [  OK  ]
# service sybase status
sybase is stopped ...