This content has been marked as final. Show 8 replies
if you just want to use SQLDeveloper to access a remote Oracle database then you do not need to install instant client or a tnsnames.ora.
I use it every day. When you create a database connection in SQLDeveloper use the "Basic" option and specify the IP address of the database host machine in "Hostname" and the port and the SID. You can lift all this from the tnsnames.ora on you windows box.
If you want to use SQLPlus then you need instant client. This works with no hassle. If you are having to create the oinstall group, oracle user etc, then it sounds like you have downloaded the full Oracle database which will install on PPC but not on Intel Macs. It does not need OSX server but does need a few tweaks.
Make sure you download instant client which is a small download and does not need an oracle user to be created. This will give you a tnsnames.ora file and an sqlplus executable for Mac OS X. You will need to put entries for PATH, TNS_ADMIN and ORACLE_HOME in your .profile and .bashrc files in your default home directory.
l000032:~ skiv$ pwd
l000032:~ skiv$ cat .bashrc
export TNS_ADMIN DYLD_LIBRARY_PATH
export CLASSPATH JAVA_HOME ORACLE_HOME
l000032:~ skiv$ cat .profile
export TNS_ADMIN DYLD_LIBRARY_PATH CLASSPATH JAVA_HOME ORACLE_HOME
I hope this helps.
I've done that. (ok, i´m from Chile so, sorry my english)
The problem is at work i have installed the Oracle81 client. So i connect with PL/SQL DEveloper (from all around automations or SQL Navigator. And when i log in i have the descriptions for all the tables for example, that the owner is ownfm, but i connect with expfm another account.
In MAC, until today i can't see the description of the tables. I don´t know why. I think is because of the connection. I've tried Oracle SQLDeveloper, but it says that i cant connect to an oracle 8 database. I've tried other clients, like SQL Aqua Studio and the same thing.
So there i've tried to install oracle client for mac, but fails in the part where i've told you. Then i succesfully install instant client, and i was trying to use ruby-oci driver, but the results are the same, except that now on Oracle SQLDeveloper i can see when i select TNS, the list of my tnsnames.ora.
I not quite sure that you undersand my problem. but thanks for your help. And if you have something more to say i will be good, and tryed.
Another thing, do you know another sql client database for oracle and mac, maybe i could try another one, but i still think is the connection, that or is too thin, or something is going wrong that i can't have the same environment that i have at work. This is being very frustrating.
Thanks a lot for your help.
- your English is better than my Spanish, so no need to apologise. Sorry if I have not understood the problem.
You could try using JDeveloper. I have used that to talk to an oracle 8 Database (that was some time ago now!)
Are you running on a PPC or an Intel Mac? I have installed full database 10g on PPC and Instant client on Intel Mac. I think the full client does not install - other people on this forum have had problems with it.