さるが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に対して処理を指示するための最も基本的なCUIのSQLクライアントツールです。 実質oracle databaseがインストールされている環境にはほぼすべてsqlplusもインストールされているため以下のような様々な用途で使用されています。
WalkingAlone sqlplusとは
何となく分かるようなわからないのでインストールします。
インストールしてみた。
- インストールする環境:Windows10 Pro 64bit
1. Oracle Technology Network(OTN)からパッケージをダウンロードします。
- ダウンロードサイト : Instant Client for Microsoft Windows (x64) 64-bit
- 以下のzipを全部ダウンロードします。
- 接続先がOracle Database 18c (Version 18.3.0.0.0)の場合
2. ダウンロードしたものをすべて解凍して1つのフォルダにまとめます。
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:<省略>
5. ユーザ環境変数にTNS_ADMINとNLS_LANGを設定します。
# 接続先が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.
7. SQL*Plusを起動してみます。
$ sqlplus SQL*Plus: Release 18.0.0.0.0 - Production on 水 9月 5 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
- Oracle Technology Network(OTN)からパッケージをダウンロードします。
# ダウンロードしたものをすべて解凍して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 火 1月 28 10:18:28 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. 最終正常ログイン時間: 水 10月 02 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
- Instant Client for Windows 32-bitからパッケージをダウンロードします。
# ダウンロードしたものをすべて解凍して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 火 1月 28 21:42:39 2020 Copyright (c) 1982, 2017, Oracle. All rights reserved. ユーザー名を入力してください: