📝 BLOG.IK.AM

@making's memo
(🗃 Categories 🏷 Tags)

Mac OS X 10.6にsqlplusをインストールする

🗃 {Middleware/RDBMS/Oracle}

🗓 Updated at 2012-01-01T13:27:29Z by Toshiaki Maki  🗓 Created at 2012-01-01T13:27:29Z by Toshiaki Maki  {✒️️ Edit  ⏰ History}


💣 Danger: This content is obsolete. You should avoid reading. If you really want to read, please click .

ここから次の4つのzipをダウンロード

  • instantclient-basic-10.2.0.4.0-macosx-x86.zip
  • instantclient-jdbc-10.2.0.4.0-macosx-x86.zip
  • instantclient-sdk-10.2.0.4.0-macosx-x86.zip
  • instantclient-sqlplus-10.2.0.4.0-macosx-x86.zip

ここでは/usr/local/oracle以下にインストールする

$ unzip -d /usr/local/oracle instantclient-basic-10.2.0.4.0-macosx-x86.zip 
$ unzip -d /usr/local/oracle instantclient-jdbc-10.2.0.4.0-macosx-x86.zip 
$ unzip -d /usr/local/oracle instantclient-sdk-10.2.0.4.0-macosx-x86.zip 
$ unzip -d /usr/local/oracle instantclient-sqlplus-10.2.0.4.0-macosx-x86.zip 

DYLD_LIBRARY_PATHを設定。

$ export DYLD_LIBRARY_PATH=/usr/local/oracle/instantclient_10_2

あとはPATHに追加

$ export PATH=$PATH:$DYLD_LIBRARY_PATH

$ sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Jan 1 22:43:45 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: 

一応メモっとくけど、sqlplus [username][/password]@//[hostname][:port][/database]