Re: All tests fail for any other than user 'oracle'

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/****@dbname (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 <mikemuratet@xxxxxxx> 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/****@$ORACLE_SID" 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

.