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.
| | | [EMAIL PROTECTED] | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
pgpJqLxyXLyrJ.pgp
Description: PGP signature
