in reply to Getting error while using dbi:oracle

Be sure that you have ORACLE_HOME exported in your environment. Normally I would export ORACLE_HOME and ORACLE_SID before running scripts against the database.

export ORACLE_HOME=/usr/ora10g export ORACLE_SID=mcdb