Re: DBD::Oracle



Dave Mitchell wrote:
On Wed, Nov 08, 2006 at 03:35:30PM -0500, Robert Fausey wrote:
I am trying to install DBD::Oracle perl module on FC4. I can connect to
Oracle via sqlplus, and I have ORACLE_HOME, ORACLE_SID, ORACLE_USERID
environment variables defined. When I compile the module I keep getting
the following error

Permission denied
at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.

Most likely either the oracle library or the DBD driver .so file has got
bad permissions set on it.

Try whatever command gives you the above, prefixed with

strace -o /tmp/tr.dbd -f

then look in the file /tmp/tr.dbd for lines containing things like EACCESS


Agreed. Running as a normal user, a perl script with Oracle DBI connections will fail if:

$ORACLE is not set

The net libraries and tnsnames.ora are not readable by the user.

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list



Relevant Pages

  • AW: dynamic lib ignored even after "found" in "install_driver(Oracle) failed: Cant load..." cgi prob
    ... permission denied" possibly ... Oracle 10.2.0 ... a process needs execute permissions on that directory. ... really using a different oracle client installation. ...
    (perl.dbi.users)
  • Re: problem in exporting table from MSAccess to Oracle....
    ... and i dont think this user is not needed a read permission... ... "Joe Fallon" wrote: ... > I would create the table in Oracle. ... >> With best regards ...
    (microsoft.public.access.externaldata)
  • Re: How my other Unix account can access oracle binaries?
    ... Other than change file permission by chmod or add dba group in my ... make sure the suid bit of the Oracle executable is set. ... Your installation is incorrect, otherwise you wouldn't have faced this ...
    (comp.databases.oracle.server)
  • ORA 10G -ORA-12546 Error
    ... Being logged in as standard user:(all members of oinstall group) ... sqlplus scott/tiger does not work and ends with ORA-12546:TNS permission denied. ... Being logged in as oracle works in both cases. ... I suppose it is some kind of file permission but have no idea. ...
    (comp.databases.oracle.server)
  • Re: ORA 10G -ORA-12546 Error
    ... Being logged in as standard user:(all members of oinstall group) ... sqlplus scott/tiger does not work and ends with ORA-12546:TNS permission denied. ... Being logged in as oracle works in both cases. ... I suppose it is some kind of file permission but have no idea. ...
    (comp.databases.oracle.server)