Re: All tests fail for any other than user 'oracle'
- From: jkstill@xxxxxxxxx (Jared Still)
- Date: Thu, 17 Jan 2008 03:42:22 -0800
even better, make sure it's working.
tnsping <SID>
On Jan 16, 2008 11:11 AM, Martin Gainty <mgainty@xxxxxxxxxxx> 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" <jkstill@xxxxxxxxxxx>
To: "Michael Muratet" <mikemuratet@xxxxxxx>
Cc: <dbi-users@xxxxxxxx>
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
- References:
- All tests fail for any other than user 'oracle'
- From: Michael Muratet
- Re: All tests fail for any other than user 'oracle'
- From: Jared Still
- Re: All tests fail for any other than user 'oracle'
- From: Martin Gainty
- All tests fail for any other than user 'oracle'
- Prev by Date: Re: All tests fail for any other than user 'oracle'
- Next by Date: Re: All tests fail for any other than user 'oracle'
- Previous by thread: Re: All tests fail for any other than user 'oracle'
- Next by thread: Re: All tests fail for any other than user 'oracle'
- Index(es):
Relevant Pages
|
