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 is like this : change it to this :
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 import it to another tablespace called tablesp2 in an another Oracle 9i tablespace with the user...
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 ENOENT (No such file or directory) close(3) = 0 open("/etc/hosts", O_RDONLY) = 3 fcntl64(3, F_GETFD) = 0 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0 fstat64(3, {st_mode=S_IFREG|0644, st_size=286, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE |MAP_ANONYMOUS, -1, 0) = 0x45b78000 read(3, "127....
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 jump to a console after you add this line before it launching dbca and run a ldconfig -v as root....