ORA-12504 TNS-12504 – TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

This error occurs when there was no default service configured for the listener and SERVICE_NAME was missing from the request received by the listener. When a user tries to connect to the listener, it may be servicing several different databases. If user specifies a service name in the connect request then the listener will connect…

ORA-12502 TNS-12502 TNS:listener received no CONNECT_DATA from client

TNS:listener received no CONNECT_DATA from clientCause: No CONNECT_DATA was passed to the listener.Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. Below is the sample entry of tnsnames.ora:- #When using SERVICE_NAME in CONNECT_DATA componentorcl.example.com = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT =…

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…