ODBC and EZCONNECT or my way out of active directory

The traditional way of connecting Excel (or Access) to Oracle (and other databases) is to use ODBC and TNSNAMES. You install an Oracle client, you create a connection and specify your tnsnames connection alias as server, here below DB01 tnsnames.ora DB01 = (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP)(host=srv01)(Port=1521) ) (CONNECT_DATA= (SERVICE_NAME=DB01) ) ) But the file is often […]

installing OID 10.1.4.2 Preview 1

Download oracle-oid-10.1.4.2.0-1.0.i386.rpm Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm Install the rpm # rpm -i oracle-*.i386.rpm In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh # ln -s /usr/bin/cut /bin/cut Run the configure script as root # /etc/init.d/oracle-oid configure That’s all folks! It created an Oracle XE 10gR2 database, […]