Sybase ASE – Error while loading shared libraries: libkonavm.so: cannot open shared object file

Sometimes due to missing library you can get following error in the errorlog:- error while loading shared libraries: libkonavm.so: cannot open shared object file: No such file or directory To fix such issues, find the path where libkonavm.so file is kept:- locate libkonavm.so Once the path is located, lets say its kept in /opt/sybase/ASE-16_0/symlib/libkonavm.so, create…

Sybase ASE – Kernel kistartup: could not create shared memory on Linux server

Sometimes if the shared memory is not configured correctly you can get following error when starting a Sybase Instance:- kernel os_create_region: can’t allocate … byteskernel kbcreate: couldn’t create kernel region.kernel kistartup: could not create shared memory These error messages mean that the shared memory is not correctly set on the Linux machine, please adjust the…

Sybase ASE – Recover a lost or Unknown “sa” password

This post describes how to generate a temporary “sa” password in case the the existing password is lost or unknown. First of all the ASE needs to be shutdown, since you don’t have the “sa” password you need to shutdown ASE by killing the dataserver. kill -9 <PID of the dataserver> Now go to the…

Sybase ASE – Read a dumpfile with headeronly

We can use the “headeronly” qualifier when reading a dumpfile to extract useful information which we can use to work out what is needed to setup a new database to load the given dump file. Using following command to read the dumpfile:- load database headerfrom “compress::<dumpfile_path_and_name>”with headeronlygo This would generate a output something like:- Backup…

Sybase ASE – Dump/Load a database to/from multiple stripes

Following command can be used to dump a Sybase ASE database into multiple stripes:- dump database to ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_02.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_03.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_04.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_05.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_06.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_07.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_08.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_09.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_10.dmp’go Following command can be used to load a Sybase ASE database from multiple stripes:- load database from ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on…