oracle oci driver setting

http://myjdbc.tripod.com/basic/jdbcoci.html

Windows

1. Set ORACLE_HOME environment variable
2. Add ORACLE_HOME\lib to System PATH
3 Set CLASSPATH environment variable to use Oracle JDBC driver from ORACLE_HOME\jdbc\lib

*nix ( Linux / Unix )

1. Set ORACLE_HOME environment variable
2. Add ORACLE_HOME/lib to LD_LIBRARY_PATH env variable
3 Set CLASSPATH environment variable to use Oracle JDBC driver from ORACLE_HOME/jdbc/lib.

C:\oc4j\jdbc\lib => oc4j의 jdbc 드라이버가 위치한곳에 C:\oracle\ora92\jdbc\lib의 같은 파일 복사

java.lang.UnsatisfiedLinkError: /export/home3/oracle/product/9.2.0.4/lib/libocijdbc9.so: ld.so.1: java:

fatal: /export/home3/oracle/product/9.2.0.4/lib/libocijdbc9.so: wrong ELF class: ELFCLASS64
-------------------------------------------------------------------------------
Everything I've read says this is caused by using the 64bit libraries instead of the 32bit ones. Change your LD_LIBRARY_PATH to point to $ORACLE_HOME/lib32.

And indeed, doing:

### Change your LD_LIBRARY_PATH to point to $ORACLE_HOME/lib32.

LD_LIBRARY_PATH=$ORACLE_HOME/lib32:${LD_LIBRARY_PATH}

export LD_LIBRARY_PATH