Category Archives: oracle

oracle ucm

Runs oracle db 11g XE on 10.10.1.158:1521.  sudo /etc/init.d/oracle-xe start netstat -anpt | grep 1521 to verify listener put the following into .bashrc . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh ORACLE_SID=XE sqlplus  use TNS defined in $ORACLE_HOME/network/admin/tnsnames.ora sqlplus system/oracle or sqlplus dev_ocs/oracle  select * from global_name … Continue reading

Posted in oracle, ucm | Leave a comment

install oracle instance client on ubuntu 11.10 x64

download *.rpm from oracle sudo alien to install rpms vi /etc/ld.so.conf.d/oracle-instantclient11.2-basic.conf  /lib /usr/lib/oracle/11.2/client64/lib sudo ldconfig

Posted in oracle | Leave a comment

Oracle Net: TNS and EasyConnect

sqlplus id/pwd@ sqlplus id/pwd@server:port/service (service is schema that is given by DBA)

Posted in oracle | Leave a comment

cx_Oracle

Follow http://mostperfect.net/blog/2010/07/28/installing-cx_oracle-on-windows/, A looking at cx_Oracle.pyd with dependency walker (from MS) will show it depends on OCI.dll.As a result, we need to install Oracle Instant Client from here http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Posted in oracle, python | Leave a comment