Linux_x86_64 配置oracle sqlplus

本文档指导如何在Linux及UNIX环境下配置Oracle SQL*Plus即时客户端。主要步骤包括:设置包含即时客户端文件的目录路径至LD_LIBRARY_PATH环境变量中;更新PATH环境变量以指向即时客户端所在目录;设置SQLPATH确保能找到glogin.sql文件;最后设定所需的Oracle全球化变量。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm

 

Configuring SQL*Plus Instant Client on Linux (from Client Media or Zip File) and UNIX

  1. Add the name of the directory containing the Instant Client files to the appropriate shared library path LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH. Remove any other Oracle directories.

    For example on Solaris in the Bourne or Korn shells:

    LD_LIBRARY_PATH=/home/instantclient10_1:${LD_LIBRARY_PATH}
    export LD_LIBRARY_PATH
    
  2. Add the directory containing the Instant Client files to the PATH environment variable. If it is not set, then an absolute or relative path must be used to start SQL*Plus. Remove any other Oracle directories from PATH. For example:

    PATH=/home/instantclient10_1:${PATH}
    export PATH
    
  3. Set SQLPATH to the directory containing the Instant Client files so glogin.sql can be found. For example:

    SQLPATH=/home/instantclient10_1:${SQLPATH}
    export SQLPATH
    
  4. Set Oracle globalization variables required for your locale. A default locale will be assumed if no variables are set. See the Oracle Database Globalization Support Guide for more information.

    For example:

    NLS_LANG=AMERICAN_AMERICA.UTF8
    export NLS_LANG

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值