- Install a minimal version of CentOS 6 You will require 3 partitions
- To aid set up ensure that SELinux is disabled and iptables is off
- Set up kernel parameters in /etc/sysctl.conf;
kernel.exec-shield=0
kernel.randomize_va_space=0
kernel.shmmax=67108864 # Only if tis number is bigger than the default - Update kernel parameters;
sysctl -p /etc/sysctl.conf - Ensure that you have 3 partitions, or seperate disks
- export LD_POINTER_GUARD=0
- Install the following rpms;
yum install compat-libstdc++-296
For this you might want to install the rpmfusion repository
Do this by downloading the rpm and the epel rpm
Install using rpm -i rpmfusion epel
INSTALLING SYBASE
- Extract your Sybase tgz file
- Run the setup command
./setup -is:javaconsole -console
Where filename will record your options, note that this option can only be used in GUI mode.
Follow the on screen instructions, which includes agreeing to the T&Cs, deciding where you want to install Sybase, create the directory, typical/full or custom.
If installing client only then use custom and select the following;
Select everything except Sybase Server
Creating the first database
1. Now we need to create your first database
cd /opt/sybase
You will find example resource files in ASE-/init/sample_resource_files
Select the one appropriate to your install
(This example will be for the adaptive_server.rs)
2. The resource file
Copy the srvbuild.adaptive_server.rs to /opt/sybase/ase.rs
Edit the file as follows;
sybinit.release_directory: /opt/sybase (or where you installed it)
sqlsrv.server_name: STEVE (SYBASE logical name of the database. This will be the name in the interfaces file, server instance)
sqlsrv.network_hostname_list: localhost (the real hostname of your server)
sqlsrv.network_port_list: 4000 (The port number you wish to run this instance on)
sqlsrv.master_device_physical: /dev/sdb1 (physical partition or filename for master database)
sqlsrv.sybsystemprocs_device_physical_name: /dev/sdb2
sqlsrv.sybsystemdb_device_physical_name: /dev/sdb3 (remember this applies to all databases created within this instance)
sqlsrv.default_backup_server:
3. Update root's enviroment using the SYBASE.sh script
. ./SYBASE.sh
4. srvbuildres -r ase.rs
5. If the above command results in "Server 'STEVE' was successfully created'
find . -name RUN*
Should return /opt/sybase/ASE-12_5/install/RUN_STEVE
6. Test your connection
isql -Usa -S STEVE
You should be prompted for a password, just press ENTER
You should eventually get the 1> prompt
Type quit and press enter
Creating the start up script so that SYBASE starts on reboot
1. vi /etc/init.d/sybase
2. Add the following to the file;
#!/bin/bash
# chkconfig: 35 95 95
# description: Start sybase
case $1 in
'start')
unset LANG
export LD_POINTER_GUARD=0
. /opt/sybase/SYBASE.sh
startserver -f /opt/sybase/ASE-12_5/install/RUN_STEVE
;;
'stop')
pkill dataserver
;;
esac
3. Save the script and then do;
chmod +x /etc/init.d/sybase
4. Add the script to the start up and shutdown sequence
chkconfig --add sybase
5. Test the script;
- Shutdown the server
