Im not near my mac, but if you have instant client installed, I have gotten it to work by setting ORACLE_HOME (instant client dir) ,LD_LIBRARY_PATH (oracle home/lib) , and TNS_ADMIN environment vars before running sqlplus or irb for oci8. Drop a tnsnames.ora into a dir in your home folder and set the TNS_ADMIN path to it.
I can help you with specifics next monday when I get home. It probably won't help, but google for "oracle 2 day dba". On May 14, 2013 1:02 AM, "Guyren Howe" <[email protected]> wrote: > 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. > > > -- -- 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.
