1.首先下载以下两个安装包:
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
下载路径:
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
根据需要选择对应版本的包,共5个包,其中三个是必须的,两个可选,建议五个都下载安装。 # 必须下载安装 oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm # 可安装 oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
2.然后用rpm 命令安装(root权限)
rpm–ivh oracle-instantclient19.16-basic-19.16.0.0.0-1.x86_64.rpm
rpm–ivh oracle-instantclient19.16-sqlplus-19.16.0.0.0-1.x86_64.rpm
注意:两个包有安装顺序
3.安装成功后,可以看到/usr/lib目录下自动生成/oracle/12.1/client64里面的bin和lib文件:
在此目录下创建并设置tnsnames.ora文件,保存并退出
4.此时就应该配置属性文件了(回到用户根目录,vi .bash_profile),记得先切换到使用oracle客户端的那个用户再设置:
[oracle@test-cdh03 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin # User specific environment and startup programs PATH=$PATH:$HOME/bin #export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/usr/lib/oracle/19.16/client64 export ORACLE_SID=KGDB export TWO_TASK=KGDB export TNS_ADMIN=/usr/lib/oracle/19.16/client64 export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export LD_LIBRARY_PATH=/usr/lib/oracle/19.16/client64/lib export LANG=en_US #export LANG=C export EDITOR=vi export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK #export NLS_LANG=AMERICAN.utf8 stty erase ^H export PATH export PATH
5.此时便可登录验证是否配置正确:
标签:x86,rpm,sqlplus,64,PATH,oracle,export,Hat From: https://www.cnblogs.com/mumianhuasayyes/p/16768599.html