linux系统odbc远程连oracle,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/localtar -zxvf unixODBC-2.3.2.tar.gzcd unixODBC-2.3.2./configure --prefix=/usr/local/unixODBC-2.3.2 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etcMakeMake install

oracle-xe-11.2.0-1.0.x86_64.rpm的安装查看本机IP：ifconfig2.安装依赖包依赖包有：binutils-.6-2.el5compat-libstdc++-33-3.2.3-61elfutils-libelf-0.125-3.el5elfutils-libelf-devel-0.125glibc-2.5-12glibc-common-2.5-12glibc-devel-2.5-12glibc-headers-2.5-12gcc-4.1.1-52gcc-c++-4.1.1-52libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.1-52libstdc++-4.1.1libstdc++-devel-4.1.1-52.e15make-3.81-1.1numactl-devel-0.9.8.i386sysstat-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 gdb3.安装cd /usr/localunzip oracle-xe-11.2.0-1.0.x86_64.rpm.zipcd Disk1rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm/etc/init.d/oracle-xe configure一直回车，遇见password输入密码；密码是oracle用户的密码Vi /etc/profile在最后一行添加# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/xe; export ORACLE_HOMEORACLE_SID=XE; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHTNS_ADMIN=$ORACLE_HOME/network/adminLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/easysoft/lib; export LD_LIBRARY_PATHSHLIB_PATH=/usr/local/easysoft/lib； export SHLIB_PATHCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHif [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536else ulimit -u 16384 -n 65536fifisource /etc/profile

测试方法:Su oraclebash-4.1$Sqlplus /nologSQL> Conn /as sysdba;成功会显示Connected

Linux