Category Archives: Oracle

If like me you are surprised by the fact that dbstart or dbshut does not do anything when launching it, just make sure to edit the /etc/oratab and have the last char as Y and not N. Like if it … Continue reading →

Renaming Oracle Database is a pain, coming from OpenSource DB like MySQL or PostGres where we do that all the time i did not think that Oracle have to be such a pain. My only way i can find. – … Continue reading →

After installing Oracle instant client, if you have them in /usr/local/lib/instantclient_10_2, this is the command line i use : ./configure –with-instant-client=/usr/local/lib/instantclient_10_2 –with-oracle-includes=/usr/local/lib/instantclient_10_2/sdk/include –with-oracle-libraries=/usr/local/lib/instantclient_10_2 –with-oci-version=10G Let me know ny email if you want the deb for ubuntu linux.

If you are using a pam_ldap or pam_nis environement and it happend that sqlplus does not want to connect as user but it does as root, waiting for : socket(PF_FILE, SOCK_STREAM, 0) = 3 connect(3, {sa_family=AF_FILE, path=”/var/run/.nscd_socket”}, 110) = -1 … Continue reading →

If you like me when running oracle on x86_64 get that damn : Error loading native library: libnjni9.so when launching dbca and you have googled the thousands five hundred useless answer. Just add the path of the libs $ORACLE_HOME/lib and … Continue reading →