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

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.




.

Relevant Pages

  • Oracle Listener problem in Solaris 9
    ... We are running Solaris 9, Veritas 3.5 storage foundation and Oracle ... Our DBA shutdown the Oracle listener and now she could not ... bring it backup due to the error messages below: ...
    (comp.unix.admin)
  • Oracle Listener problem in Solaris 9
    ... We are running Solaris 9, Veritas 3.5 storage foundation and Oracle ... Our DBA shutdown the Oracle listener and now she could not ... bring it backup due to the error messages below: ...
    (comp.unix.solaris)
  • Re: Problem Connecting w Perl/DBD::Oracle as SYSDBA
    ... Is your Oracle environment correct (I see you set ORACLE_SID, ... > NOT for the other (database BB). ... > I have tried many variations of the syntax on the connect statement. ... > bypasses/ignores the Oracle listener process. ...
    (comp.lang.perl.misc)
  • Re: All tests fail for any other than user oracle
    ... All tests fail for any other than user 'oracle' ... without a hitch. ... I had read about file permissions and the user 'oracle'. ...
    (perl.dbi.users)
  • Re: Oracle 9i and VMS multihome configuration
    ... This system runs Oracle 9i and it ... Seems like failSAFE IP is not the issue here, but I include it in the ... The Oracle listener has been restarted ... running a similar configuration. ...
    (comp.os.vms)