さるがSQL*Plusって何?って思ったのでインストールしてみた。

SQL*Plusは、OracleのDB用のCUIクライアントツールです。

SQL*Plusは、Oracle Databaseのインストール時にインストールされる対話型のバッチ問合せツールです。SQL*Plusでは、コマンドライン・ユーザー・インタフェースを使用できます。

また、SQL*Plus Instant Clientもあります。これは、OCI Instant Client対応のプラットフォームで使用できるスタンドアロンコマンドライン・インタフェースです。SQL*Plus Instant Clientは使用可能なすべてのOracle Databaseに接続されますが、専用のOracle Databaseをインストールする必要はありません。
SQL*Plusのクイック・スタート

SQL*Plus とは SQL を実行するためのインターフェイスユーティリティである。
インスタンスの起動とマニュアル操作によるインタラクティブSQL の実行が主であるが shell などのスクリプト言語と サイレントモード を併用することで簡単なバッチ処理にも使用できる(※)。
www.shift-the-oracle.com

sqlplusはoracleに対して処理を指示するための最も基本的なCUISQLクライアントツールです。 実質oracle databaseがインストールされている環境にはほぼすべてsqlplusもインストールされているため以下のような様々な用途で使用されています。
WalkingAlone sqlplusとは

e-words.jp

何となく分かるようなわからないのでインストールします。

インストールしてみた。

  • インストールする環境:Windows10 Pro 64bit
1. Oracle Technology Network(OTN)からパッケージをダウンロードします。
2. ダウンロードしたものをすべて解凍して1つのフォルダにまとめます。
  • 解凍したファイルの中身の一部
    • sqlplus.exe : SQL*Plus実行可能ファイル
    • orasqlplusicXX.dll : SQL*Plusデータ共有ライブラリ
    • oci.dll : クライアント・コード・ライブラリ
    • oraociicusXX.dll : OCI Instant Clientデータ共有ライブラリ(英語のみ)
    • orannzsbbXX.dll : セキュリティ・ライブラリ
3. 解凍したフォルダを `C:\app\oracle\instantclient_xx_x` に配置します。
# 接続先がOracle Database 18c (Version 18.3.0.0.0)の場合
$ find /c/app/oracle/ -type d
/c/app/oracle/
/c/app/oracle/instantclient_18_3
/c/app/oracle/instantclient_18_3/help
/c/app/oracle/instantclient_18_3/help/ja
/c/app/oracle/instantclient_18_3/help/ja/img
/c/app/oracle/instantclient_18_3/help/ja/img_text
/c/app/oracle/instantclient_18_3/help/us
/c/app/oracle/instantclient_18_3/help/us/img
/c/app/oracle/instantclient_18_3/help/us/img_text
/c/app/oracle/instantclient_18_3/sdk
/c/app/oracle/instantclient_18_3/sdk/admin
/c/app/oracle/instantclient_18_3/sdk/demo
/c/app/oracle/instantclient_18_3/sdk/include
/c/app/oracle/instantclient_18_3/sdk/lib
/c/app/oracle/instantclient_18_3/sdk/lib/bc
/c/app/oracle/instantclient_18_3/sdk/lib/msvc
/c/app/oracle/instantclient_18_3/sdk/lib/msvc/vc14
/c/app/oracle/instantclient_18_3/vc14
4. Instant Clientファイルを含むディレクトリをシステム環境変数PATHに追加します。
# 接続先がOracle Database 18c (Version 18.3.0.0.0)の場合
$ printenv | grep -i oracle
SQL_PLUS=C:\app\oracle\instantclient_18_3 # 何のパスかすぐわからなくなるので環境変数を1つ作ってそれをPATHに設定しました。
PATH=<省略>/c/app/oracle/instantclient_18_3:/c/ProgramData/Oracle/Java/javapath:<省略>
ORIGINAL_PATH=<省略>/c/app/oracle/instantclient_18_3:/c/ProgramData/Oracle/Java/javapath:<省略>

f:id:ponsuke_tarou:20180905001008p:plain

5. ユーザ環境変数にTNS_ADMINとNLS_LANGを設定します。

SQL*Plusの環境変数

# 接続先がOracle Database 18c (Version 18.3.0.0.0)の場合
TNS_ADMIN=C:\app\oracle\instantclient_18_3
NLS_LANG=Japanese_Japan.AL32UTF8
6. ORACLE ODBCドライバをインストールします。

管理者権限でプロンプトやGitBashなどを起動します。

# 接続先がOracle Database 18c (Version 18.3.0.0.0)の場合
$ cd $SQL_PLUS # 作った環境変数です。
$ odbc_install JA
Oracle ODBC Driver is installed successfully.

qiita.com

7. SQL*Plusを起動してみます。
$ sqlplus

SQL*Plus: Release 18.0.0.0.0 - Production on 水 95 00:50:15 2018
Version 18.3.0.0.0

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

ユーザー名を入力してください:

バージョン違いの実行記録

Windows10 + Oracle Database 12c (12.2.0.1.0)のInstant Client 64bit

  1. Oracle Technology Network(OTN)からパッケージをダウンロードします。
    • instantclient-basic-windows.x64-12.2.0.1.0.zip
    • instantclient-sqlplus-windows.x64-12.2.0.1.0.zip
    • instantclient-sdk-windows.x64-12.2.0.1.0.zip
    • instantclient-jdbc-windows.x64-12.2.0.1.0.zip
    • instantclient-odbc-windows.x64-12.2.0.1.0-2.zip
# ダウンロードしたものをすべて解凍して1つのフォルダにまとめて配置します。
$ cd /c/apps/oracle

$ unzip ~/Downloads/instantclient-basic-windows.x64-12.2.0.1.0.zip
Archive:  /c/Users/ponsuke/Downloads/instantclient-basic-windows.x64-12.2.0.1.0.zip
   creating: instantclient_12_2/
  inflating: instantclient_12_2/uidrvci.sym
  inflating: instantclient_12_2/oci.sym
  inflating: instantclient_12_2/oraocci12d.sym
  inflating: instantclient_12_2/oraons.dll
  inflating: instantclient_12_2/genezi.sym
  inflating: instantclient_12_2/ociw32.dll
  inflating: instantclient_12_2/oraocci12d.dll
  inflating: instantclient_12_2/oci.dll
  inflating: instantclient_12_2/ociw32.sym
  inflating: instantclient_12_2/adrci.exe
  inflating: instantclient_12_2/oramysql12.sym
  inflating: instantclient_12_2/adrci.sym
  inflating: instantclient_12_2/xstreams.jar
  inflating: instantclient_12_2/oraociei12.dll
  inflating: instantclient_12_2/ocijdbc12.dll
  inflating: instantclient_12_2/orasql12.sym
  inflating: instantclient_12_2/oraocci12.sym
  inflating: instantclient_12_2/orannzsbb12.dll
  inflating: instantclient_12_2/ocijdbc12.sym
  inflating: instantclient_12_2/oraociei12.sym
  inflating: instantclient_12_2/genezi.exe
  inflating: instantclient_12_2/ojdbc8.jar
  inflating: instantclient_12_2/orannzsbb12.sym
  inflating: instantclient_12_2/uidrvci.exe
  inflating: instantclient_12_2/oraocci12.dll
   creating: instantclient_12_2/vc14/
  inflating: instantclient_12_2/vc14/oraocci12d.sym
  inflating: instantclient_12_2/vc14/oraocci12d.dll
  inflating: instantclient_12_2/vc14/oraocci12.dll
  inflating: instantclient_12_2/vc14/oraocci12.sym
  inflating: instantclient_12_2/orasql12.dll
  inflating: instantclient_12_2/oramysql12.dll
  inflating: instantclient_12_2/BASIC_README

$ unzip ~/Downloads/instantclient-sqlplus-windows.x64-12.2.0.1.0.zip
Archive:  /c/Users/ponsuke/Downloads/instantclient-sqlplus-windows.x64-12.2.0.1.0.zip
   creating: instantclient_12_2/
  inflating: instantclient_12_2/sqlplus.exe
  inflating: instantclient_12_2/SQLPLUS_README
  inflating: instantclient_12_2/glogin.sql
  inflating: instantclient_12_2/orasqlplusic12.dll
  inflating: instantclient_12_2/sqlplus.sym

$ unzip ~/Downloads/instantclient-sdk-windows.x64-12.2.0.1.0.zip
Archive:  /c/Users/ponsuke/Downloads/instantclient-sdk-windows.x64-12.2.0.1.0.zip
   creating: instantclient_12_2/sdk/
   creating: instantclient_12_2/sdk/include/
  inflating: instantclient_12_2/sdk/include/oci8dp.h
  inflating: instantclient_12_2/sdk/include/occiCommon.h
  inflating: instantclient_12_2/sdk/include/occiControl.h
  inflating: instantclient_12_2/sdk/include/oci1.h
  inflating: instantclient_12_2/sdk/include/ociap.h
  inflating: instantclient_12_2/sdk/include/orl.h
  inflating: instantclient_12_2/sdk/include/oratypes.h
  inflating: instantclient_12_2/sdk/include/nzt.h
  inflating: instantclient_12_2/sdk/include/xa.h
  inflating: instantclient_12_2/sdk/include/odci.h
  inflating: instantclient_12_2/sdk/include/occi.h
  inflating: instantclient_12_2/sdk/include/ociapr.h
  inflating: instantclient_12_2/sdk/include/ldap.h
  inflating: instantclient_12_2/sdk/include/ocixstream.h
  inflating: instantclient_12_2/sdk/include/ocixmldb.h
  inflating: instantclient_12_2/sdk/include/oro.h
  inflating: instantclient_12_2/sdk/include/ocixml.h
  inflating: instantclient_12_2/sdk/include/oci.h
  inflating: instantclient_12_2/sdk/include/occiAQ.h
  inflating: instantclient_12_2/sdk/include/ocidef.h
  inflating: instantclient_12_2/sdk/include/ociextp.h
  inflating: instantclient_12_2/sdk/include/orid.h
  inflating: instantclient_12_2/sdk/include/ort.h
  inflating: instantclient_12_2/sdk/include/ocidem.h
  inflating: instantclient_12_2/sdk/include/ocikpr.h
  inflating: instantclient_12_2/sdk/include/occiObjects.h
  inflating: instantclient_12_2/sdk/include/ocidfn.h
  inflating: instantclient_12_2/sdk/include/ori.h
  inflating: instantclient_12_2/sdk/include/occiData.h
  inflating: instantclient_12_2/sdk/include/nzerror.h
   creating: instantclient_12_2/sdk/lib/
   creating: instantclient_12_2/sdk/lib/msvc/
  inflating: instantclient_12_2/sdk/lib/msvc/oci.lib
  inflating: instantclient_12_2/sdk/lib/msvc/oramysql12.lib
   creating: instantclient_12_2/sdk/lib/msvc/vc14/
  inflating: instantclient_12_2/sdk/lib/msvc/vc14/oraocci12d.lib
  inflating: instantclient_12_2/sdk/lib/msvc/vc14/oraocci12.lib
  inflating: instantclient_12_2/sdk/lib/msvc/oraocci12.lib
  inflating: instantclient_12_2/sdk/lib/msvc/oraocci12d.lib
  inflating: instantclient_12_2/sdk/lib/msvc/ociw32.lib
   creating: instantclient_12_2/sdk/lib/bc/
  inflating: instantclient_12_2/sdk/lib/bc/oci.lib
 extracting: instantclient_12_2/sdk/ottclasses.zip
  inflating: instantclient_12_2/sdk/SDK_README
  inflating: instantclient_12_2/sdk/ott.bat
   creating: instantclient_12_2/sdk/admin/
  inflating: instantclient_12_2/sdk/admin/oraaccess.xsd
   creating: instantclient_12_2/sdk/demo/
  inflating: instantclient_12_2/sdk/demo/bcmake.bat
  inflating: instantclient_12_2/sdk/demo/make.bat
  inflating: instantclient_12_2/sdk/demo/cdemo81.c
  inflating: instantclient_12_2/sdk/demo/occidemod.sql
  inflating: instantclient_12_2/sdk/demo/occiobj.typ
  inflating: instantclient_12_2/sdk/demo/occidml.cpp
  inflating: instantclient_12_2/sdk/demo/occiobj.cpp
  inflating: instantclient_12_2/sdk/demo/oraaccess.xml
  inflating: instantclient_12_2/sdk/demo/occidemo.sql

$ unzip ~/Downloads/instantclient-jdbc-windows.x64-12.2.0.1.0.zip
Archive:  /c/Users/ponsuke/Downloads/instantclient-jdbc-windows.x64-12.2.0.1.0.zip
  inflating: instantclient_12_2/JDBC_README
  inflating: instantclient_12_2/orai18n-mapping.jar
  inflating: instantclient_12_2/heteroxa12.sym
  inflating: instantclient_12_2/heteroxa12.dll
  inflating: instantclient_12_2/orai18n.jar

$ unzip ~/Downloads/instantclient-odbc-windows.x64-12.2.0.1.0-2.zip
Archive:  /c/Users/ponsuke/Downloads/instantclient-odbc-windows.x64-12.2.0.1.0-2.zip
   creating: instantclient_12_2/help/
   creating: instantclient_12_2/help/ja/
  inflating: instantclient_12_2/help/ja/blafdoc.css
  inflating: instantclient_12_2/help/ja/cpyr.htm
   creating: instantclient_12_2/help/ja/img/
  inflating: instantclient_12_2/help/ja/img/odbcdrvarch.gif
  inflating: instantclient_12_2/help/ja/img/odbcmodel.gif
  inflating: instantclient_12_2/help/ja/img/setup_app.gif
  inflating: instantclient_12_2/help/ja/img/setup_ora.gif
  inflating: instantclient_12_2/help/ja/img/setup_ssmig.gif
  inflating: instantclient_12_2/help/ja/img/setup_work.gif
   creating: instantclient_12_2/help/ja/img_text/
  inflating: instantclient_12_2/help/ja/img_text/odbcdrvarch.htm
  inflating: instantclient_12_2/help/ja/img_text/odbcmodel.htm
  inflating: instantclient_12_2/help/ja/img_text/setup_app.htm
  inflating: instantclient_12_2/help/ja/img_text/setup_ora.htm
  inflating: instantclient_12_2/help/ja/img_text/setup_ssmig.htm
  inflating: instantclient_12_2/help/ja/img_text/setup_work.htm
  inflating: instantclient_12_2/help/ja/map.xml
  inflating: instantclient_12_2/help/ja/oracle.gif
  inflating: instantclient_12_2/help/ja/sqora.htm
  inflating: instantclient_12_2/help/ja/toc.htm
   creating: instantclient_12_2/help/us/
  inflating: instantclient_12_2/help/us/blafdoc.css
  inflating: instantclient_12_2/help/us/cpyr.htm
   creating: instantclient_12_2/help/us/img/
  inflating: instantclient_12_2/help/us/img/odbcdrvarch.gif
  inflating: instantclient_12_2/help/us/img/odbcmodel.gif
  inflating: instantclient_12_2/help/us/img/setup_app.gif
  inflating: instantclient_12_2/help/us/img/setup_ora.gif
  inflating: instantclient_12_2/help/us/img/setup_ssmig.gif
  inflating: instantclient_12_2/help/us/img/setup_work.gif
   creating: instantclient_12_2/help/us/img_text/
  inflating: instantclient_12_2/help/us/img_text/odbcdrvarch.htm
  inflating: instantclient_12_2/help/us/img_text/odbcmodel.htm
  inflating: instantclient_12_2/help/us/img_text/setup_app.htm
  inflating: instantclient_12_2/help/us/img_text/setup_ora.htm
  inflating: instantclient_12_2/help/us/img_text/setup_ssmig.htm
  inflating: instantclient_12_2/help/us/img_text/setup_work.htm
  inflating: instantclient_12_2/help/us/map.xml
  inflating: instantclient_12_2/help/us/oracle.gif
  inflating: instantclient_12_2/help/us/sqora.htm
  inflating: instantclient_12_2/help/us/toc.htm
  inflating: instantclient_12_2/ODBC_IC_Readme_Win.html
  inflating: instantclient_12_2/odbc_install.exe
  inflating: instantclient_12_2/odbc_uninstall.exe
  inflating: instantclient_12_2/sqora32.dll
  inflating: instantclient_12_2/sqoras32.dll
  inflating: instantclient_12_2/sqresja.dll
  inflating: instantclient_12_2/sqresus.dll

$ find /c/apps/oracle/instantclient_12_2/ -type d
/c/apps/oracle/instantclient_12_2/
/c/apps/oracle/instantclient_12_2/help
/c/apps/oracle/instantclient_12_2/help/ja
/c/apps/oracle/instantclient_12_2/help/ja/img
/c/apps/oracle/instantclient_12_2/help/ja/img_text
/c/apps/oracle/instantclient_12_2/help/us
/c/apps/oracle/instantclient_12_2/help/us/img
/c/apps/oracle/instantclient_12_2/help/us/img_text
/c/apps/oracle/instantclient_12_2/sdk
/c/apps/oracle/instantclient_12_2/sdk/admin
/c/apps/oracle/instantclient_12_2/sdk/demo
/c/apps/oracle/instantclient_12_2/sdk/include
/c/apps/oracle/instantclient_12_2/sdk/lib
/c/apps/oracle/instantclient_12_2/sdk/lib/bc
/c/apps/oracle/instantclient_12_2/sdk/lib/msvc
/c/apps/oracle/instantclient_12_2/sdk/lib/msvc/vc14
/c/apps/oracle/instantclient_12_2/vc14

# Instant Clientファイルを含むディレクトリをシステム環境変数PATHに追加します。
$ printenv | grep -i oracle
ORACLE_INSTANT_CLIENT=C:\apps\oracle\instantclient_12_2
PATH=<省略>/c/apps/oracle/instantclient_12_2:<省略>
ORIGINAL_PATH=<省略>/c/apps/composer:/c/apps/oracle/instantclient_12_2:<省略>

# ユーザ環境変数にTNS_ADMINとNLS_LANGを設定します。
$ printenv | grep -e TNS_ADMIN -e NLS_LANG
NLS_LANG=Japanese_Japan.AL32UTF8
TNS_ADMIN=C:\apps\oracle\instantclient_12_2

# ORACLE ODBCドライバをインストールします。
$ cd $ORACLE_INSTANT_CLIENT

$ odbc_install JA
Oracle ODBC Driver is installed successfully.

# SQL*Plusを起動してみます。
$ sqlplus {ユーザ名}/{パスワード}@{データベース}:1521/{サービス名}

SQL*Plus: Release 12.2.0.1.0 Production on 火 128 10:18:28 2020

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

最終正常ログイン時間: 水 1002 2019 11:27:17 +09:00


Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
に接続されました。
SQL>

Windows10 + Oracle Database 12c (12.2.0.1.0)のInstant Client 32bit

  1. Instant Client for Windows 32-bitからパッケージをダウンロードします。
    • instantclient-basiclite-nt-12.2.0.1.0.zip
    • instantclient-sqlplus-nt-12.2.0.1.0.zip
    • instantclient-sdk-nt-12.2.0.1.0.zip
    • instantclient-jdbc-nt-12.2.0.1.0.zip
    • instantclient-odbc-nt-12.2.0.1.0-2.zip
# ダウンロードしたものをすべて解凍して1つのフォルダにまとめて配置します。
$ find ~/Downloads/ -name '*.zip' | xargs -n1 unzip -d /c/app/oracle/
Archive:  /c/Users/m-uki/Downloads/instantclient-basiclite-nt-12.2.0.1.0.zip
   creating: /c/app/oracle/instantclient_12_2/
  inflating: /c/app/oracle/instantclient_12_2/oraocci12.sym
  inflating: /c/app/oracle/instantclient_12_2/oraociicus12.dll
  inflating: /c/app/oracle/instantclient_12_2/uidrvci.sym
  inflating: /c/app/oracle/instantclient_12_2/ocijdbc12.dll
  inflating: /c/app/oracle/instantclient_12_2/xstreams.jar
  inflating: /c/app/oracle/instantclient_12_2/orasql12.sym
  inflating: /c/app/oracle/instantclient_12_2/oraocci12d.dll
  inflating: /c/app/oracle/instantclient_12_2/genezi.exe
  inflating: /c/app/oracle/instantclient_12_2/ojdbc8.jar
  inflating: /c/app/oracle/instantclient_12_2/adrci.exe
  inflating: /c/app/oracle/instantclient_12_2/BASIC_LITE_README
  inflating: /c/app/oracle/instantclient_12_2/oraocci12d.sym
  inflating: /c/app/oracle/instantclient_12_2/orasql12.dll
  inflating: /c/app/oracle/instantclient_12_2/oraociicus12.sym
  inflating: /c/app/oracle/instantclient_12_2/oraocci12.dll
  inflating: /c/app/oracle/instantclient_12_2/ocijdbc12.sym
  inflating: /c/app/oracle/instantclient_12_2/orannzsbb12.dll
  inflating: /c/app/oracle/instantclient_12_2/ociw32.sym
  inflating: /c/app/oracle/instantclient_12_2/adrci.sym
   creating: /c/app/oracle/instantclient_12_2/vc14/
  inflating: /c/app/oracle/instantclient_12_2/vc14/oraocci12d.sym
  inflating: /c/app/oracle/instantclient_12_2/vc14/oraocci12d.dll
  inflating: /c/app/oracle/instantclient_12_2/vc14/oraocci12.dll
  inflating: /c/app/oracle/instantclient_12_2/vc14/oraocci12.sym
  inflating: /c/app/oracle/instantclient_12_2/oci.dll
  inflating: /c/app/oracle/instantclient_12_2/oraons.dll
  inflating: /c/app/oracle/instantclient_12_2/genezi.sym
  inflating: /c/app/oracle/instantclient_12_2/ociw32.dll
  inflating: /c/app/oracle/instantclient_12_2/oci.sym
  inflating: /c/app/oracle/instantclient_12_2/uidrvci.exe
  inflating: /c/app/oracle/instantclient_12_2/orannzsbb12.sym
Archive:  /c/Users/m-uki/Downloads/instantclient-jdbc-nt-12.2.0.1.0.zip
  inflating: /c/app/oracle/instantclient_12_2/orai18n-mapping.jar
  inflating: /c/app/oracle/instantclient_12_2/JDBC_README
  inflating: /c/app/oracle/instantclient_12_2/heteroxa12.dll
  inflating: /c/app/oracle/instantclient_12_2/heteroxa12.sym
  inflating: /c/app/oracle/instantclient_12_2/orai18n.jar
Archive:  /c/Users/m-uki/Downloads/instantclient-odbc-nt-12.2.0.1.0-2.zip
   creating: /c/app/oracle/instantclient_12_2/help/
   creating: /c/app/oracle/instantclient_12_2/help/ja/
  inflating: /c/app/oracle/instantclient_12_2/help/ja/blafdoc.css
  inflating: /c/app/oracle/instantclient_12_2/help/ja/cpyr.htm
   creating: /c/app/oracle/instantclient_12_2/help/ja/img/
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/odbcdrvarch.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/odbcmodel.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/setup_app.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/setup_ora.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/setup_ssmig.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img/setup_work.gif
   creating: /c/app/oracle/instantclient_12_2/help/ja/img_text/
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/odbcdrvarch.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/odbcmodel.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/setup_app.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/setup_ora.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/setup_ssmig.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/img_text/setup_work.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/map.xml
  inflating: /c/app/oracle/instantclient_12_2/help/ja/oracle.gif
  inflating: /c/app/oracle/instantclient_12_2/help/ja/sqora.htm
  inflating: /c/app/oracle/instantclient_12_2/help/ja/toc.htm
   creating: /c/app/oracle/instantclient_12_2/help/us/
  inflating: /c/app/oracle/instantclient_12_2/help/us/blafdoc.css
  inflating: /c/app/oracle/instantclient_12_2/help/us/cpyr.htm
   creating: /c/app/oracle/instantclient_12_2/help/us/img/
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/odbcdrvarch.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/odbcmodel.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/setup_app.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/setup_ora.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/setup_ssmig.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/img/setup_work.gif
   creating: /c/app/oracle/instantclient_12_2/help/us/img_text/
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/odbcdrvarch.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/odbcmodel.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/setup_app.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/setup_ora.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/setup_ssmig.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/img_text/setup_work.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/map.xml
  inflating: /c/app/oracle/instantclient_12_2/help/us/oracle.gif
  inflating: /c/app/oracle/instantclient_12_2/help/us/sqora.htm
  inflating: /c/app/oracle/instantclient_12_2/help/us/toc.htm
  inflating: /c/app/oracle/instantclient_12_2/ODBC_IC_Readme_Win.html
  inflating: /c/app/oracle/instantclient_12_2/odbc_install.exe
  inflating: /c/app/oracle/instantclient_12_2/odbc_uninstall.exe
  inflating: /c/app/oracle/instantclient_12_2/sqora32.dll
  inflating: /c/app/oracle/instantclient_12_2/sqoras32.dll
  inflating: /c/app/oracle/instantclient_12_2/sqresja.dll
  inflating: /c/app/oracle/instantclient_12_2/sqresus.dll
Archive:  /c/Users/m-uki/Downloads/instantclient-sdk-nt-12.2.0.1.0.zip
   creating: /c/app/oracle/instantclient_12_2/sdk/
   creating: /c/app/oracle/instantclient_12_2/sdk/admin/
  inflating: /c/app/oracle/instantclient_12_2/sdk/admin/oraaccess.xsd
  inflating: /c/app/oracle/instantclient_12_2/sdk/ott.bat
   creating: /c/app/oracle/instantclient_12_2/sdk/demo/
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/occidml.cpp
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/occiobj.typ
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/occiobj.cpp
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/cdemo81.c
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/occidemod.sql
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/make.bat
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/bcmake.bat
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/occidemo.sql
  inflating: /c/app/oracle/instantclient_12_2/sdk/demo/oraaccess.xml
  inflating: /c/app/oracle/instantclient_12_2/sdk/SDK_README
   creating: /c/app/oracle/instantclient_12_2/sdk/lib/
   creating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/oramysql12.lib
   creating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/vc14/
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/vc14/oraocci12d.lib
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/vc14/oraocci12.lib
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/ociw32.lib
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/oraocci12d.lib
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/oraocci12.lib
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/msvc/oci.lib
   creating: /c/app/oracle/instantclient_12_2/sdk/lib/bc/
  inflating: /c/app/oracle/instantclient_12_2/sdk/lib/bc/oci.lib
   creating: /c/app/oracle/instantclient_12_2/sdk/include/
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ociapr.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occiCommon.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ori.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/oci8dp.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ldap.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocixstream.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/odci.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ort.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occi.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occiObjects.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocixml.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occiData.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/oci1.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/oci.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/xa.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/oratypes.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/nzerror.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occiControl.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocidem.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/occiAQ.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/oro.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocidef.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/orid.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocixmldb.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ociextp.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/nzt.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocikpr.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/orl.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ocidfn.h
  inflating: /c/app/oracle/instantclient_12_2/sdk/include/ociap.h
 extracting: /c/app/oracle/instantclient_12_2/sdk/ottclasses.zip
Archive:  /c/Users/m-uki/Downloads/instantclient-sqlplus-nt-12.2.0.1.0.zip
  inflating: /c/app/oracle/instantclient_12_2/sqlplus.exe
  inflating: /c/app/oracle/instantclient_12_2/SQLPLUS_README
  inflating: /c/app/oracle/instantclient_12_2/glogin.sql
  inflating: /c/app/oracle/instantclient_12_2/orasqlplusic12.dll
  inflating: /c/app/oracle/instantclient_12_2/sqlplus.sym

$ find /c/app/oracle/instantclient_12_2/ -type d
/c/app/oracle/instantclient_12_2/
/c/app/oracle/instantclient_12_2/help
/c/app/oracle/instantclient_12_2/help/ja
/c/app/oracle/instantclient_12_2/help/ja/img
/c/app/oracle/instantclient_12_2/help/ja/img_text
/c/app/oracle/instantclient_12_2/help/us
/c/app/oracle/instantclient_12_2/help/us/img
/c/app/oracle/instantclient_12_2/help/us/img_text
/c/app/oracle/instantclient_12_2/sdk
/c/app/oracle/instantclient_12_2/sdk/admin
/c/app/oracle/instantclient_12_2/sdk/demo
/c/app/oracle/instantclient_12_2/sdk/include
/c/app/oracle/instantclient_12_2/sdk/lib
/c/app/oracle/instantclient_12_2/sdk/lib/bc
/c/app/oracle/instantclient_12_2/sdk/lib/msvc
/c/app/oracle/instantclient_12_2/sdk/lib/msvc/vc14
/c/app/oracle/instantclient_12_2/vc14

# Instant Clientファイルを含むディレクトリをシステム環境変数PATHに追加します。
# ユーザ環境変数にTNS_ADMINとNLS_LANGを設定します。
$ printenv | grep -i -e instant -e NLS_LANG
NLS_LANG=Japanese_Japan.AL32UTF8
TNS_ADMIN=C:\app\oracle\instantclient_12_2
PATH=<省略>/c/app/oracle/instantclient_12_2

# SQL*Plusを起動してみます。
$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on 火 128 21:42:39 2020

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

ユーザー名を入力してください:

Ubuntu18 + Oracle Database 12c (12.2.0.1.0)のInstant Client 64bit

ponsuke-tarou.hatenablog.com