如何yum部署oracle客户端?

Linux基础

1 前言

笔者需要一个Oracle客户端用于测试与服务器之间的连通性,于是此文产生。

2 最佳实践

2.1 系统环境

OS = CentOS 6.8 x86_64
IP Address = any
Host Name = any.cmdschool.org

2.2 基础配置

2.2.1 配置yum源

vim /etc/yum.repos.d/oracle-client.repo

加入如下配置,

[oracle-client]
name=oracle-client
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/oracle/instantclient/x86_64
gpgcheck=0

2.2.2 配置yum源

yum search oracle

可见如下显示,

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
oracle-client                                                                                               | 1.2 kB     00:00
======================================================= N/S Matched: oracle =======================================================
kmod-oracleasm.x86_64 : oracleasm kernel module(s)
oracle-instantclient18.3-basic.x86_64 : Oracle Instant Client Basic package
oracle-instantclient18.3-basiclite.x86_64 : Oracle Instant Client Light package
oracle-instantclient18.3-jdbc.x86_64 : Supplemental JDBC features for the Oracle Instant Client
oracle-instantclient18.3-odbc.x86_64 : Oracle Instant Client ODBC
oracle-instantclient18.3-tools.x86_64 : Tools for Oracle Instant Client
oracle-instantclient18.5-basic.x86_64 : Oracle Instant Client Basic package
oracle-instantclient18.5-basiclite.x86_64 : Oracle Instant Client Light package
oracle-instantclient18.5-jdbc.x86_64 : Supplemental JDBC features for the Oracle Instant Client
oracle-instantclient18.5-odbc.x86_64 : Oracle Instant Client ODBC
oracle-instantclient18.5-tools.x86_64 : Tools for Oracle Instant Client
tuned-profiles-oracle.noarch : Additional tuned profile(s) targeted to Oracle loads
oracle-instantclient18.3-devel.x86_64 : Development headers for Instant Client.
oracle-instantclient18.3-sqlplus.x86_64 : SQL*Plus for Instant Client.
oracle-instantclient18.5-devel.x86_64 : Development headers for Instant Client.
oracle-instantclient18.5-sqlplus.x86_64 : SQL*Plus for Instant Client.

  Name and summary matches only, use "search all" for everything.

如果下载异常或需要其他版本,请参阅如下链接,
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

2.3 安装配置SQLPlus

2.3.1 安装rpm包

yum install -y oracle-instantclient18.5-sqlplus

2.3.2 设置环境变量

vim /etc/profile.d/oracle-lient.sh

加入如下定义,

export ORACLE_CLIENT_HOME=/usr/lib/oracle/18.5/client64
export LD_LIBRARY_PATH=${ORACLE_CLIENT_HOME}/lib:$LD_LIBRARY_PATH
export PATH=${ORACLE_CLIENT_HOME}/bin:$PATH

使用如下命令加载环境变量,

source /etc/profile

另外,亦可使用如下快速命令实现,

echo 'export ORACLE_CLIENT_HOME=/usr/lib/oracle/18.5/client64' > /etc/profile.d/oracle-lient.sh
echo 'export LD_LIBRARY_PATH=${ORACLE_CLIENT_HOME}/lib:$LD_LIBRARY_PATH' >> /etc/profile.d/oracle-lient.sh
echo 'export PATH=${ORACLE_CLIENT_HOME}/bin:$PATH' >> /etc/profile.d/oracle-lient.sh
source /etc/profile

环境变量“LD_LIBRARY_PATH”用于声明库文件的路径,否则运行命令行将会收到如下提示,

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

2.3.3 测试命令行运行

sqlplus -V

可见如下提示,

SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.5.0.0.0

2.3.4 获取使用帮助

sqlplus -h

可见如下提示,

SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.

Usage 1: sqlplus -H | -V

    -H             Displays the SQL*Plus version and the
                   usage help.
    -V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [] [{logon | /nolog}] [] ]

   is: [-AC] [-C ] [-F] [-L] [-M ""] [-NOLOGINTIME]
               [-R ] [-S]

    -AC            Enable Application Continuity.
    -C    Sets the compatibility of affected commands to the
                   version specified by .  The version has
                   the form "x.y[.z]".  For example, -C 10.2.0
    -F             This option improves performance in general. It changes
                   the default values settings.
                   See SQL*Plus User's Guide for the detailed settings.
    -L             Attempts to log on just once, instead of
                   reprompting on error.
    -M "" Sets automatic HTML or CSV markup of output.  The options
                   have the form:
                   {HTML html_options|CSV csv_options}
                   See SQL*Plus User's Guide for detailed HTML and CSV options.
    -NOLOGINTIME   Don't display Last Successful Login Time.
    -R      Sets restricted mode to disable SQL*Plus commands
                   that interact with the file system.  The level can
                   be 1, 2 or 3.  The most restrictive is -R 3 which
                   disables all user commands interacting with the
                   file system.
    -S             Sets silent mode which suppresses the display of
                   the SQL*Plus banner, prompts, and echoing of
                   commands.

   is: {[/][@] | / }
              [AS {SYSDBA | SYSOPER | SYSASM | SYSBACKUP | SYSDG
              | SYSKM | SYSRAC}] [EDITION=value]

    Specifies the database account username, password and connect
    identifier for the database connection.  Without a connect
    identifier, SQL*Plus connects to the default database.

    The AS SYSDBA, AS SYSOPER, AS SYSASM, AS SYSBACKUP, AS SYSDG,
    AS SYSKM and AS SYSRAC options are database administration privileges.

     can be in the form of Net Service Name
    or Easy Connect.

      @[ | [//]Host[:Port]/]

         is a simple name for a service that resolves
        to a connect descriptor.

        Example: Connect to database using Net Service Name and the
                 database net service name is ORCL.

           sqlplus myusername/mypassword@ORCL

        Host specifies the host name or IP address of the database
        server computer.

        Port specifies the listening port on the database server.

         specifies the service name of the database you
        want to access.

        Example: Connect to database using Easy Connect and the
                 Service name is ORCL.

           sqlplus myusername/mypassword@Host/ORCL

    The /NOLOG option starts SQL*Plus without connecting to a
    database.

    The EDITION specifies the value for Session Edition.


   is: @|[.] [ ...]

    Runs the specified SQL*Plus script from a web server (URL) or the
    local file system (filename.ext) with specified parameters that
    will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run.  The files may
contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

参阅资料
===================

安装说明
—————-
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html#ic_x64_inst

安装源地址
—————–
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

安装客户端首页
—————-
https://www.oracle.com/database/technologies/instant-client.html

没有评论

发表评论

Linux基础
如何二进制部署Metabase?

1 基础知识 1.1 Metabase的简介 – Metabase是一款简单、开源商业智 …

Linux基础
如何熟悉跨站点攻击CSRF?

1 CSRF的概念 – CSRF是英文“Cross-site request forge …

Linux基础
如何安装配置Oracle客户端?

1 前言 一个问题,一篇文章,一出故事。 笔者生产环境有一台服务器需要连接Oracle数据库,于是整 …