Front page | perl.dbi.users |
Postings from January 2008
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@wsr.ac.at | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-usersThread Previous | Thread Next