Posted in 7 February, 2007 ¬ 03:32h.chmouel
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.
- If i have the tablespace named tablesp1 and owned by the
user user1, and i want to [...]
Read the rest of this entry »
Posted in 4 January, 2007 ¬ 16:19h.chmouel
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.
Read the rest of this entry »
Posted in 2 January, 2007 ¬ 20:24h.chmouel
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 ENOENT (No such file or directory)
close(3) [...]
Read the rest of this entry »
Posted in 21 December, 2006 ¬ 18:29h.chmouel
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 $ORACLE_HOME/lib32 to your /etc/ld.so.conf (or /etc/ld.so.conf.d/oracle.conf on RH derivative) and rerun ldconfig.
If this is during install just [...]
Read the rest of this entry »