My os version:
ProductName: Mac OS X
The processor information is "Dual 800 MHz PowerPC G4 2MB L3 cache per processor"
Memory 1 GB SDRAM
120 gig hard drive
I would like to install the Oracle client software so i can run sql*Plus. I'm looking at the quick install guide and it says that "Only Mac OS X Server is supported." and it also says "The operating system version must be Apple Mac OS X Server 10.3.6"
Why would Oracle only create an Oracle client that runs on a mac server? Is this information correct? or can I go ahead and install the client on my machine?
I need the client so I can run Sql*Plus. I did not get a response to my thread and kept looking and saw in the documentation that sql*plus can be run with the instant client. I did not attempt to install the full client yet, but I was able to install the instant client to get sql*Plus working. Here are the steps:
1. Download instantclient-basic-macosx-10.1.0.3.zip and
2. Unzipped them in /usr/ora_instant_client
3. Set the DYLD_LIBRARY_PATH to /usr/ora_instant_client/instantclient10_1 and later added to my profile
4. Downloaded a copy of the tnsnames.ora file from one of the local servers and placed it in /usr/ora_instant_client/instantclient10_1
5. Did "export TNS_ADMIN=/usr/ora_instant_client/instantclient10_1" on the command line and later added to my profile
I was then able to run sql*Plus.
Awesome. That worked, although I didn't know the syntax for connecting and I had to talk to our DBA to find the tnsnames.ora file. I think (although I haven't tested this) that you can connect without that file with:
Plus, since I use tcsh, I didn't perform an explicit export of the TNS_ADMIN variable. I just did a setenv (as I did with the library path too, then updated my .cshrc).
Also, I should note that you must put the contents of the sqlplus unzip into the directory that results from the basic-macosx unzip.
Message was edited by:
If you're using the connection string <user>/<password>@//host:port/servicename you don't need to set TNS_ADMIN at all, since you're not using it to resolve the connection details (you've already specified everything).
Oracle also say you can only run the database itself on OSX server, though I've got 10.1 (latest available version for OSX) running on the normal OSX version (10.4.x) without problems. There are plenty of google-able references on how to set this up. NB- you will need to download the Apple XCode developer toolkit (to get the gcc compiler) which weighs in at about 1Gb, and you'll also need to configure the compiler to use version 3.3 (not the latest 4.x) to compile/link Oracle, otherwise it won't work properly. This is just a 1-line command. Again, plenty of web references on how to do this.
I am trying to install oracle instant client and followed davidxm's instruction. For some reason its still not working on my os. I'm getting following errors while running sqlplus:
dyld: Library not loaded: /b/729/sqlplus/lib/libsqlplus.dylib
Referenced from: /usr/ora_instant_client/instantclient10_1/ ./sqlplus group16@orca
Reason: image not found
Anyone has got any idea as what am I doing wrong in configuration setting?
My OS Version 10.4.8 is running on PowerPC G4.
I'm sure it is just an environment set up. See that you have the variables set that I have and the files in the right places. Check with find file that you have libsqlplus.dylib
If I do this at the terminal prompt:
l000373:/ skiv$ find . -name "libsqlplus.dylib"
Then I have enviromen t variables set up in .bashrc and .profile as follows
export TNS_ADMIN DYLD_LIBRARY_PATH
and it works:
l000373:/ skiv$ sqlplus cbm@MISTEST
SQL*Plus: Release 10.1.0.3.0 - Production on Wed Nov 15 13:20:41 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Oracle9i Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 188.8.131.52.0 - Production
Installing SQL plus on a Mac
Apparently this is not possible - or is exceedingly difficult. Too bad they can't figure out how to create a self-install package. I can't believe it is that difficult to create an installer.
Oracle does have SQLdeveloper - but I haven't had much luck with it.
I finally bought Aqua Data Studio (www.aquafold.com) and it so far has worked well with Oracle and every other server we have here.
hi all, first at all thanks for starting this post, it really helped me.
However, I found a gotcha that didn't allow the client to find the tnsnames.ora. I spent centuries until I found what it was. I moved the tnsnames.ora out of the /usr/ora_instant_client, to some folder where I have full permissions, and then everything started working. Bye bye to the TNS:could not resolve the connect identifier specified.
I have no clue about why that happened, as I have read permissions for that folder... Anyway, hope that this helps someone else, this one really annoyed me.
I noticed this tonight and thought pointing to my blog might help some. It has the steps with some screen shots for configuring VM Fusion and connecting to the VM from the Mac OS X directly.
In Step 2: How could I access the /usr/ folder with Finder ? Mac OS X Unzip the files directly to the Download folder !
In Step 3: How and where should I set that ? & How could I add it to my profile ? What profile ??
In Step 4: what are the "local servers" ? any URL ??
I had the same problem, on 10.6.x, in 2010.
"dyld: Library not loaded: /b/227/sqlplus/lib/libsqlplus.dylib"
The issue is that Apple quarantines downloaded files from the internet. The unzipped files must carry this quarantine.
You can tell in an ls -l listing. Each file with have an "@" for extended attributes.
View extended attributes with ls -l@
Remove quarantine attributes like this
sudo xattr -d com.apple.quarantine *
Now my sql plus works. I imagine that if you unzipped using the finder you would be prompted about the file from the internet, and the quarantine would be removed. If you use 'unzip' from the terminal as I did, the quarantine is kept.
I tried all the suggestions given above but could not get the sqlplus to work. Then I tried the following:
Edit /etc/bashrc as root, add the following lines:
ensure that tnsnames.ora file is created in the $ORACLE_HOME/admin folder.
After making this change, I was able to get the sqlplus to work without throwing the error "dyld: Library not loaded: /b/227/sqlplus/lib/libsqlplus.dylib"