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 (for db)
• show user
• creates a doamin ucm_domain
• starts wls admin server: startWeblogic.sh
• starts wls managed server for cs: startManagedLogic.sh UCM_server1 http://localhost:7001/

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

Oracle Net: TNS and EasyConnect

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

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