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 [...]
Filed under: Oracle on February 7th, 2007 | No Comments »
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.
Filed under: Oracle on January 4th, 2007 | 5 Comments »
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) [...]
Filed under: Oracle on January 2nd, 2007 | 4 Comments »
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 [...]
Filed under: Oracle on December 21st, 2006 | No Comments »
