I'm trying to install the DBD::Oracle module for Perl. I'm doing this through the command line on a Suse Linux box.
First I enter: perl -MCPAN -e shell
Once the CPAN shell comes up, I enter: install DBD::Oracle
Afterwards, the installation fails. From looking at the output I see this error repeated over and over again: DBI connect('','scott/tiger',...) failed: ORA-12162: TNS:net service name is incorrectly specified (DBD ERROR: OCIServerAttach)
I should also mention that it first looks for an Oracle client when I try to install it the first time. I'm using the Oracle Instant Client 10.2. Once it prompts me with the error the first time I provide a means for it to find the client. I exit out of the CPAN shell and they enter: export LD_LIBRARY_PATH=/this/directory/instantclient_10_2. Afterwards, it doesn't give me trouble with that and leads me to the problem at hand.
I've looked around for hours today and I still don't understand what the problem is. I saved the entire output, so I can provide more information if needed.