also make sure the Oracle listener is listening on <default Port 1521> e.g. netstat -a | grep 1521
M-- ----- Original Message ----- From: "Jared Still" <[EMAIL PROTECTED]> To: "Michael Muratet" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Wednesday, January 16, 2008 11:29 AM Subject: Re: All tests fail for any other than user 'oracle' > On Tue, 2008-01-15 at 16:29 -0600, Michael Muratet wrote: > > > I am trying now to get DBD::Oracle working. The DBI install came off > > without a hitch. The DBD perl build and the make worked OK (logs are > > at the end). The first attempt at testing failed. I recalled something > > I had read about file permissions and the user 'oracle'. I logged in > > as oracle and all the tests were successful. sqlplus works but only > > for user oracle. > > > > Installing Oracle by RPM? Not familiar with that. > > Also not too familiar with instant client. > > The problem you are experiencing is likely due to a lack of SGID > on the oracle binary. > > In ORACLE_HOME there is likely a shell script named 'root.sh'. > > Shut down oracle and run root.sh, as root. > It sets a number of permisions. > > That should take care of it. > > >
