Linux_x86_64 配置oracle sqlplus

配置SQL*Plus即时客户端

最新推荐文章于 2021-06-08 17:30:47 发布

最新推荐文章于 2021-06-08 17:30:47 发布 · 114 阅读

文章标签：

#Oracle #Linux #SQL #SQL Server #Solaris

数据库专栏收录该内容

17 篇文章

订阅专栏

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

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

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
```
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
```
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
```
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
```