The warning: unless you’re going to make a career of it, run screaming from any 
suggestion that you install and configure Oracle. I set up Postgres and MySQL 
regularly. You’d think that would help, but NOOO.

The suggestion: if you *must* install and set up Oracle, it is somewhat less 
scream-inducing to do it on Windows than on Linux.

The question: now how do I connect to it? The only way I’ve gotten to work is 
from DOS:

sqlplus <user>@<database>

This comes back:

ORA-12154: TNS:could not resolve the connect identifier specified

at which point it asks me to enter user name and password. The <user> I just 
entered above and its password then work fine.

I can’t do this either:

sqlplus <user>/<password>@<database>

What I *really* need is to connect from IRB on my Mac. I have oci8 gem 
installed.

The amount of subtly and grossly different advice I get when I try to google 
this issue is truly astounding: listener.ora, tnsnames.ora, connection strings, 
setting environment variables, using various Oracle utilities (many of which I 
don’t appear to have), and every one advises me to do something slightly 
different, and assumes I understand some other thing that’s just as confusing.

Does anyone here have experience with this situation who might advise me?

-- 
-- 
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
--- 
You received this message because you are subscribed to the Google Groups "SD 
Ruby" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to