Category Archives: oracle

oracle ucm

Runs oracle db 11g XE on  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_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/  /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


Follow, 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

Posted in oracle, python | Leave a comment