Re: All tests fail for any other than user 'oracle'
- From: hjp@xxxxxxxxx (Peter J. Holzer)
- Date: Thu, 17 Jan 2008 13:23:36 +0100
On 2008-01-15 16:29:39 -0600, Michael Muratet wrote:
I installed the Oracle Instant Client packages by rpm back in December. Because
of the install or more likely coincidentally I had problems with corruption of
the system files of the database. The database was empty at the time and I
simply rebuilt it.
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.
Are you sure you are using the instant client and not an oracle server
installation on the same machine? I am asking for two reasons:
1) For some time now an Oracle database *server* installation includes
all the client libraries and tools (sqlplus, etc.), but the
permissions are set so that only the oracle user (or maybe the dba
group) can use them. This sounds exactly like your problem.
(I am not sure why Oracle did this - maybe they want to encourage
people to separate server and client installations even if they are
on the same machine - anyway, there is a script to "soften" the
permissions).
2) You said you corrupted the system files of the database and rebuilt
it. Since it is extremely unlikely that installing a software on
one host will damage software on a different host, I conclude that
your database and the Instant Client packages are installed on the
same machine - so you need to be careful to set the environment to
point to the right installation.
hp
--
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@xxxxxxxxx | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
Attachment:
pgpY681QGcphD.pgp
Description: PGP signature
- References:
- All tests fail for any other than user 'oracle'
- From: Michael Muratet
- 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: Perl DBD::Sybase and AIX 5.3
- Previous by thread: RE: All tests fail for any other than user 'oracle'
- Next by thread: Re: DBD::Pg 2.0.0 release candidate available for testing
- Index(es):
Relevant Pages
|
