even better, make sure it's working. tnsping <SID>
On Jan 16, 2008 11:11 AM, Martin Gainty <[EMAIL PROTECTED]> wrote: > 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. > > > > > > > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
