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.
Sounds like the user you're using doesn't have rights to write to the DB to create a table. If it installed correctly, then you may be ok anyway, you can just treat those as warnings. If it still failed
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines