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
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:
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.
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.
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 ??
"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.