Greetings
I finally got it to work. For the benefit of anyone who might find
this in the archive:
Installed Instant Client from zip files (forget the rpms)
Set ORACLE_HOME and LD_LIBRARY_PATH to the new Instant Client directory
Build DBD::Oracle
Set ORACLE_HOME back to the Oracle tree
Make sure there is o+r access down the ORACLE_HOME tree to
tnsnames.ora file
Set ORACLE_SID to dbname
Set ORACLE_USERID to usr/[EMAIL PROTECTED] (may be redundant)
make test now works
Thanks to all for the replies and suggestions.
Mike
On Jan 17, 2008, at 9:55 AM, Jared Still wrote:
On Jan 17, 2008 7:55 AM, Michael Muratet <[EMAIL PROTECTED]> wrote:
I
On Jan 17, 2008, at 5:42 AM, Jared Still wrote:
> even better, make sure it's working.
>
> tnsping <SID>
It works. sqlplus user/**** works for all users, but only if the unix
user is oracle. The problem is more subtle.
connecting as 'sqlplus user/****' does not tell you anything about tns
connecting as 'sqlplus user/[EMAIL PROTECTED]" will tell you something.
I found some documentation for the Instant Client (my candidate for
the world's poorest documented application) that mentions TNS_ADMIN
which I tried with the same result. I've also found recommendations to
change ORACLE_HOME to where ever Instant Client reside but since I
installed by rpm I'm not sure exactly where that is. I may just
uninstall the rpms and reinstall from source.
I don't remember where the files are located.
If you still have the rpm's try 'rpm -qpl <filename> to see where
they may go.
-
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
