Oracle Instant Client Package Basic & SQL*Plus installation on a Mac Book Pro help

(Warning:  SQL Server expert, Oracle and Mac absolute N00b)

Hi all

I'm at a new client site and have been told to install Oracle on a MacBook Pro with OS X Yosemite v10.10.5.  

I downloaded the .zip filesVersion 11.2.0.4.0 (64-bit) Instant Client Package-Basic and Instant Client Package - SQL*Plus from this page fine, unzipped fine.  

When I open Finder and attempt to double-click on any of the executable files it displays a '<file name> can't be opened because it is from an unidentified developer' error message.

When I open a Terminal app it opens, freezes for a minute, then displays [Process completed] and does not allow for any keyboard entry.

Anyone know the process to install Oracle on a Mac?

Thanks in advance.
Jim
LVL 67
Jim HornMicrosoft SQL Server Data DudeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gerwin Jansen, EE MVETopic Advisor Commented:
Can you try ctrl-click that setup file and then choose 'Open' from the context menu? You should get a warning where you can select 'Open' again.
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
The basic file does not have a Setup.  The executible file names are adrci, genezi, libclntsh.dylib.11.1, libocci.dylib.11.1, and uidrvci.

The SQL*Plus has a Setup file, and when I do a control-click > Open it give the error messagsqlplus is from an unidentified developer.  Are you sure you want to open it ' error message.  When I hit Open it displays a Terminal window for sqlplus with [Process completed] at the end, and does nothing.

btw what's the process for capturing a screen shot on a Mac?
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
I see the below instructions on a company wiki, but this is way over my head.

Add DYLD_LIBRARY_PATH=<instant client folder> to your system PATH (through .bash_profile usually)
  add the following to your ~/.bash_profile
   export DYLD_LIBRARY_PATH=<instant client folder>
   export PATH=$DYLD_LIBRARY_PATH:$PATH
in command line: source ~/.bash_profile
in command line: sqlplus
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

strungCommented:
When you get the unidentified developer error message, pull down the Apple Menu to System Preferences and go to Security and Privacy. There should be a button warning you that that particular application came from an unidentified developer and giving you the option to "open anyway". Click on "open anyway" and try to open the installer again. It should now work.

If not, the in the general tab of the Security and Privacy preferences, click on "Allow Apps Dowloaded from Anywhere". If that is greyed out, click on the lock icon at the bottom left and supply an admin password.

After your installation remember to change the security settings back to what they were as this is an important Apple security setting which prevents installation of malware.
Tim LapinComputer Consultant (Desktop analyst)Commented:
Screen shot captures can be done via the keyboard:

Cmd-Shift-4:
-  Allows a user select-able rectangular area.  The cursor changes appropriately.
-  Once the area is selected, the picture is taken and appears as a .png file on the desktop

There are other refinements that allow for topmost window and so on but most situations can be dealt with by the above trick.
Tim LapinComputer Consultant (Desktop analyst)Commented:
Jim Horn wrote:

Add DYLD_LIBRARY_PATH=<instant client folder> to your system PATH (through .bash_profile usually)
   add the following to your ~/.bash_profile
   export DYLD_LIBRARY_PATH=<instant client folder>
   export PATH=$DYLD_LIBRARY_PATH:$PATH
in command line: source ~/.bash_profile
in command line: sqlplus


I guess we need to ask:  how familiar are you with UNIX?

The ~/.bash_profile file is a profile for that user and would add to the basic (system supplied) profile found in /etc/profile.  Usually created by the user him/herself, it allows for specific environment variables to be set, among other things.

The <instant client folder> is the location where you placed the unzipped contents of the Oracle database.

The command line items after that are in fact commands:
source ~/.bash_profile    =    run the file called .bash_profile located in the user's home directory

At this point I should point out that my Oracle skills are similar to yours:  a complete  newbie.  I've installed the Oracle client on PCs only occasionally and found the level of complexity to be high.  Definitely NOT for the uninitiated.

Hope this helps.
serialbandCommented:
You should probably go learn some basic unix command line, before you start this.

To add those lines to the bash profile, you need to first know where your instant client folder is.  Then do the following in the terminal:

(Be sure to replace {instant client folder} with your correct instant client folder.
cat "export DYLD_LIBRARY_PATH={instant client folder}"  >> ~/.bash_profile
cat "export PATH=$DYLD_LIBRARY_PATH:$PATH" >> ~/.bash_profile
source ~/.bash_profile
sqlplus

Open in new window


That source command tells your terminal environment to load the newly updated .bash_profile.  You only have to do that if you've just updated and your terminal was open.  If you close your terminal and open a new one, your .bash_profile is loaded.  The last line calls sqlplus to start sql.  If you don't include the PATH in your profile, you'd have use the path name to the exectuble sqlplus command.  If you don't have DYLD_LIBRARY_PATH set up, then it won't know where to run the additional libraries that it needs.

While you can double click on the commands to start them, they will open a terminal screen to run.  These are terminal commands, not GUI programs.  That's why you should run it in a terminal.  It froze, because it finished processing and is probably still running and holding the session.  You could check the running processes in another terminal with ps aux |grep sqlplus.  You can quit the process with control c and the prompt and cursor should return to you.  You can also put it to sleep then you can background the process, to run it in the background (as a server process that's not attached to a console.) with control z then the bg command.  You can also just start it up directly as a background process with sqlplus&.
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
>unidentified developer error message ... Apple Menu to System Preferences and go to Security and Privacy.
Done and it worked, thanks.

>Screen shot captures can be done via the keyboard:
Very helpful thanks.

>I guess we need to ask:  how familiar are you with UNIX?
I can spell it, which in some languages when applied to a resume apparently translates to 'I have 2-3 years of experience with it.'

I was able to open up Profiler and enter the commands, and it got me to a sql*plus login prompt, which is not working for me..
strungCommented:
Can you post a screenshot of the sql log in window and the resulting error message (if any)?
serialbandCommented:
You got an sql*plus login prompt?  Are you saying that you entered the bash commands and set your environment variables correctly now?  That means it's installed and working.  You'll need to learn how to use Oracle's sql.
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
>To add those lines to the bash profile, ...
@serialband - The below is the top of my .bash_profile, so it appears that the Terminal exec script was done Screen-Shot-2015-11-16-at-9.38.52-AM.png
>You could check the running processes in another terminal with ps aux |grep sqlplus.
Done, but not sure how to interpret this. Screen-Shot-2015-11-16-at-9.41.34-AM.png
>You got an sql*plus login prompt?
Correct, asks for user/password prompt which fails, another issue, but I suspect that I still need to get SQL developer working correctly before SQL*Plus will work.

>Can you post a screenshot of the sql log in window and the resulting error message (if any)?
@strung - Not sure what you mean by 'sql log'.
Tim LapinComputer Consultant (Desktop analyst)Commented:
Hi Jim,

The 'ps' command results indicate that the only process running with the string 'sqlplus' is the ps command itself.  In other words, it doesn't look like sqlplus is running.
Tim LapinComputer Consultant (Desktop analyst)Commented:
The log file associated with installation, setup and/or use of an application can be found in the console application.  Opening that application will reveal a series of folders in specific groupings that contain log files.  Right (or "control") clicking on one of the parent folders, will offer an option to reveal its location in a Finder window.  The Finder is analogous to the Explorer on a Windows box.

The sql log file might be in a number of places.  If it is not visible already, I would look inside:
-  System Diagnostic Reports
-  Library/Logs
-  ~Library/Logs
-  /var/log
slightwv (䄆 Netminder) Commented:
>>but I suspect that I still need to get SQL developer working correctly before SQL*Plus will work.

Two different products.  They have nothing to do with one another.

Easiest way is manually create a network/admin folder under /opt/oracle/instantclient

Then copy a good tnsnames.ora and sqlnet.ora file into that folder.

Then sqlplus should connect.

If the alias in the tnsnames.ora file is BOB:
sqlplus username/password@BOB

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
Thanks for your contributions all.  I'm not at a solution yet, but there's enough value posted in this question to spread the wealth around, and when I'm on firmer ground I'll as this as a new v2.0 question.  -Jim
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.