Skip to Content
Author's profile photo Alan Han

Hands-on Sybase SQLAnywhere 12.0.1 Installation on Linux

Environment: Red Hat or SUSE Linux


Installation Steps:

  1. On your linux machine, create a new user ‘sybase’
  2. Switch to this new user, create the database installation directory (e.g. /databases/sybase)
  3. Create another folder for the installer (e.g. /databases/installation)
  4. Upload and unzip the installer
    $ unzip 
  5. Folder structure after unzip
    $ ls -al 
    total 421004 
    drwxr-xr-x 4 root root 4096 Jan 25 11:00 . 
    drwxr-xr-x 6 sybase dba 4096 Jan 25 10:59 .. 
    -r--r--r-- 1 root root 0 Feb 1 2011 linux-x86-x64 
    dr-xr-xr-x 8 root root 4096 Feb 1 2011 monitor 
    -r--r--r-- 1 root root 387 Feb 1 2011 readme.txt 
    -rw-r--r-- 1 root root 431087213 Jan 25 11:00 
    dr-xr-xr-x 8 root root 4096 Feb 1 2011 sqlanywhere 
  6. Under the ‘Sybase’ user, start the installer
    $ ./sqlanywhere/setup 
  7. Follow the on-screen instruction
    7.1. Press ENTER
    7.2. Select the country you are in
    7.3. In the terms of license screen, click q to skip, then type Y to agree
    7.4. Type 1 for new installation
    7.5. Enter license key
    7.6. Select the components you’d like to install
    7.7. Once everything is selected, type S to continue
    7.8. Enter your desired installation directory (the one you created in step 2)
    7.9. Finally, confirm and start the installation
  8. After the installation is completed, go to the installation directory, you should see the following files and folders:$ ls
    bin32     demo.db                   
    java      readme_de.txt  res           selinux          tix bin32s    demo.log                   lib32     readme_en.txt  samonitor.db  sun              ultralite bin64     deployment                 lib64     readme_ja.txt  samples       support bin64s    install_20130125-1107.log  mobilink  readme_zh.txt  scripts       vcsagent charsets  installed.ini              readme    relayserver    sdk           thirdpartylegal


New Database Configuration Steps:

  1. Under the new ‘sybase’ user, edit .bash_profile
    $ vim ~/.bash_profile 
    add the following lines: 
    export LD_LIBRARY_PATH export LANG=en_US.utf8 
  2. Logout from Sybase user and log in again to apply new profile
  3. Check that the new environment variables are added
    $ env | grep LANG 
    $ env | grep LD 
  4. In your SQL Anywhere installation directory, create a new folder for your new database
    $ mkdir <database_name> 
  5. Create temp folder in database directory
    $ cd <dir_from_step_4> 
    $ mkdir tmp 
  6. Source SQLAnywhere environment
    $ source <installation_dir>/bin64/ 
  7. Learn dbinit options
    $ </installation_dir><installation_dir>/bin64/dbinit -h 
  8. Go to your new database folder, create startup script
    $ vim init.conf 
    copy and paste the following lines:     
    -p 8192     
    -ze utf8     
    -dba <admin_username>,<password>     
    -dbs 2G     
    -o <dir_from_step_4>/output_msg.trc     
    -t </dir_from_step_4><dir_from_step_4>/transaction.log     
    -m </dir_from_step_4><dir_from_step_4>/transaction_mirror.log     
  9. Initialize new database
    $ <installation_dir>/bin64/dbinit @<dir_from_step_4>/init.conf 
  10. Learn dbsrv12 options
    $ <installation_dir>/bin64/dbsrv12 -h 
  11. Create new database configuration parameters file
    $ vim <dir_from_step_4>/db.conf 
    copy and paste the following lines:     
    -n <new_db_name>     
    -x "tcpip (PORT=65000)"     
    -gm 64     
    -c 128M     
    -ch 512M     
    -dt <dir_from_step_5>     
    -gn 10     
    -o <dir_from_step_4>/sysa12d01.trc     
    -os 10M     
  12. Start db server
    $ <installation_dir>/bin64/dbsrv12 @<dir_from_step_4>/db.conf & 
  13. Stop db server
    $ <installation_dir>/bin64/dbstop –y –c “eng=<new_db_name>;uid=<admin_username>;pwd=<password>” 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.