http://www.perlmonks.org?node_id=925088


in reply to How to connect Oracle DB in Linux Env.

From your post I see missing either the SID or SERVICE and port elements on the connect parameters.

my $dbh = DBI->connect('dbi:Oracle:host=localhost;sid=ORCL;port=1521', + 'scott', 'tiger', { RaiseError => 1, AutoCommit => 0 }); my $dbh = DBI->connect('dbi:Oracle:host=localhost;service=my.service.n +ame.com;port=1521','scott', 'tiger', { RaiseError => 1, AutoCommit => + 0 });