sarf13 has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks
i am trying to connect oracle databse which is on network.
i am usning resourcePool and DBI module for this.
while i am running perl script on which i used resourcePool and DBI module for connecting oracle database through unix box.
after runing this script this giving me this error

ResourcePool::Resource::DBI: Connect
to 'dbi:Oracle:host=91.200.41.43;sid=orcl' failed:
ResourcePool> sleeping 0 seconds...
ResourcePool(DBI): Downsizing
ResourcePool: Downsized... still 0 open (0)

i am not able to understand what exactly this error is.can any one help me out for understanding this error.
Appreciated for your kind help
  • Comment on perl resourcePool:DBI connection error in oracle

Replies are listed 'Best First'.
Re: perl resourcePool:DBI connection error in oracle
by mje (Curate) on Jan 05, 2012 at 10:52 UTC

    Looks as though you failed to connect to the Oracle database at 91.200.41.42 using sid orcl. It could be as simple as your username/password is wrong but as we cannot see the error we've no idea. There must be a way for ResourcePool to show the error it got from DBI connect.