Monday, 31 July 2017

Install Oracle instant client and sqlplus using Homebrew

Background

 In one of the previous posts we say how to install and run sql plus  and Oracle instant client  on Ubuntu operating system -
In this post we will see the same for a Mac.

This post expects you have homebrew installed. If not please refer -

 Install Oracle instant client and sqlplus using Homebrew

For this you need to download following two files -
  1. instantclient-basic-macos.x64-12.1.0.2.0.zip 
  2. instantclient-sqlplus-macos.x64-12.1.0.2.0.zip 
You can download these files from oracle site - http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

Once download copy these files into following folder-
  •  ~/Library/Caches/Homebrew 
 Once done run following commands -
  • brew tap InstantClientTap/instantclient
  • brew install instantclient-basic
  • brew install instantclient-sqlplus
 This should install sqlplus for you.


Related Links

Posted by at
Labels: , , ,

9 comments:

  1. Aniket Thakur2 October 2018 at 04:41

    Username/password to connect to your database. You should have configured it when setting up the DB.

    ReplyDelete
  2. Unknown4 October 2018 at 02:39

    ORACLE is not compatiable with mac os ...how to configure oracle set up..plz rovide necessary steps too

    ReplyDelete
  3. Unknown4 October 2018 at 02:40

    ORACLE is not compatiable with mac os.. plz provide the necessary steps..i have tried this on my mac but its nt working..

    ReplyDelete
    Replies
    1. Aniket Thakur4 October 2018 at 03:41

      Hi Maduri,
      What do you mean not compatible? Are you talking about Oracle database or the client? Can you share the issue that you are facing? Thanks.

      Delete
  4. Akash15 October 2018 at 06:39

    There was no configuration during the setup. And thus, we need a default username/password to login as the root user.

    ReplyDelete
  5. ahinkle30 November 2018 at 11:16

    Hmm I keep seeing this error: ➜ ~ sqlplus
    Error 6 initializing SQL*Plus
    SP2-0667: Message file sp1.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
    ➜ ~

    ReplyDelete
  6. Unknown6 August 2019 at 10:58

    How do I do the steps if the current version is 18 and I need 12?

    ReplyDelete
  7. Vsodisetti4 December 2020 at 08:20

    What is the default user and password to log in sqlplus

    ReplyDelete
  8. Vsodisetti4 December 2020 at 08:21

    please provide the default user and pwd

    ReplyDelete

Subscribe to: Post Comments (Atom)
t> UA-39527780-1 back to top