"I have a script which is not working in Production environment."

So this script works in a non production environment? If so you need to work out what differences there are between these two systems. Did you install DBD::Oracle properly on this production system, or simply try to copy files between systems? Are you sure the environment variables are set correctly?

As an aside, to avoid potential problems I'd leave both the system perl and the perl which ships with Oracle alone and install my own elsewhere.