Linux下,unixODBC连接Oracle数据库(完整版).docx

CentOS 64-bit下unixODBC-2.3.2连接 oracle-xe-11.2.0-1.0x86_64 unxiODBC-2.3.2.tar.gz的安装 cd /usr/local tar -zxvf unixODBC-2.3.2.tar.gz cd unixODBC-2.3.2 ./configure --prefix=/usr/local/unixODBC-2.3.2 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etc Make Make install oracle-xe-11.2.0-1.0.x86_64.rpm的安装 查看本机IP：ifconfig 2.安装依赖包 依赖包有： binutils-.6-2.el5 compat-libstdc++-33-3.2.3-61 elfutils-libelf-0.125-3.el5 elfutils-libelf-devel-0.125 glibc-2.5-12 glibc-common-2.5-12 glibc-devel-2.5-12 glibc-headers-2.5-12 gcc-4.1.1-52 gcc-c++-4.1.1-52 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.1-52 libstdc++-4.1.1 libstdc++-devel-4.1.1-52.e15 make-3.81-1.1 numactl-devel-0.9.8.i386 sysstat-7.0.0 执行命令，可安装依赖包 yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make sysstat pdksh numactl-devel glibc-headers gdb 3.安装 cd /usr/local unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip cd Disk1 rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm /etc/init.d/oracle-xe configure 一直回车，遇见password输入密码；密码是oracle用户的密码 Vi /etc/profile 在最后一行添加 # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/xe; export ORACLE_HOME ORACLE_SID=XE; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH TNS_ADMIN=$ORACLE_HOME/network/admin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/easysoft/lib; export LD_LIBRARY_PATH SHLIB_PATH=/usr/local/easysoft/lib； export SHLIB_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = oracle ]; then if [ $SHELL = /bin/ksh ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi source /etc/profile 测试方法: Su oracle bash-4.1$Sqlplus /nolog SQL Conn /as sysdba; 成功会显示Connected Linux配置uni