Programming Blog Directory
«  
Home
  »

Perl: Installing DBD::Oracle + Oracle Instant Client on Ubuntu 9.04

A couple of weeks ago I finally got a new laptop at work - which meant of course that I had to reinstall everything. Although we use Windows XP, there's one app that I have to run through Linux. The solution was Sun's VirtualBox running Ubuntu 9.04. When I tried to run the app, I realized that I still needed to install DBI and DBD::Oracle - which brings me to this article. Nothing better than a reinstall to generate article material :)

DBD::Oracle is usually a pain to install if you haven't already done it a gazillion times. After that, it's just an annoying itch. In this article I'll cover installing DBD::Oracle using Oracle Instant Client, Ubuntu 9.04, and Perl 5.10. Since we're using the Instant Client, you'll need some Oracle DB you can connect to in order to do the testing. You can choose to skip testing altogether, but you might be into a surprise later.

 

DBI and DBD::Oracle

Installing the DBI is always easy - regardless if you're running Windows or Linux. Just follow the steps.

  1. Get root password if you don't already have one: sudo passwd root
  2. Switch to root: su -
  3. Run CPAN: perl -MCPAN -e shell
  4. Check if DBI is already installed: m DBI
  5. If it's not installed, install it: install DBI

That should do the trick for the DBI. The DBD::Oracle is a bit more complicated and we'll just use CPAN to download it for us. The rest is manual.

  1. Check for DBD::Oracle: m DBD::Oracle
  2. Download it: get DBD::Oracle
  3. Exit CPAN: q

Now we should have the DBD::Oracle distribution downloaded to our CPAN build directory. If you don't know where to find it, look for .cpan dir under your root home or (if you started CPAN for the first time doing sudo from your main user, look for it under your main user's home directory). We'll leave that distro aside for a moment and work on the other pre-requisites.

 

Oracle Instant Client

Download the instant client packages you'll need. I chose to download the RPMs and convert them to .deb files using alien. Oracle also provides .zip files if you don't want to do it the alien way.

Oracle Instant Client Download Site i386
Oracle Instant Client Download Site AMD64 32- and 64-bit

Accept the license agreement by clicking the Accept radio button. Since the i386 and amd64 files have different names, check the bold words in the file names to know which ones to download (the names below are for the i386 platform). Also, if you don't have a user_id for Oracle, you'll be prompted to register one once you click the link. It's free of charge.

  • oracle-instantclient11.1-basic-xx.x.x.x.x-x.i386.rpm
  • oracle-instantclient11.1-sqlplus-xx.x.x.x.x-x.i386.rpm
  • oracle-instantclient11.1-devel-xx.x.x.x.x-x.i386.rpm

AMD64 has only zip files from what I could find, and they're named a bit differently, too (remove the 32 for the 64-bit version:

  • instantclient-basic-linuxAMD64-32-xx.x.x.x.x-yyyymmdd.zip
  • instantclient-sqlplus-linuxAMD64-32-xx.x.x.x.x-yyyymmdd.zip
  • instantclient-sdk-linuxAMD64-32-xx.x.x.x.x-yyyymmdd.zip

Note: Extract the zips into a directory called instantclient and skip to the Set Up your Environment Variables section if you're using the AMD64 or i386 zip files.

 

 

Install alien and libaio

Now is the time to install alien, which is an application that converts rpm files into .deb format to be used with dpkg. Instant Client also requires libaio. Both can be installed through the Synaptic Package Manager. Just open it, look for alien, mark it for install and do the same for libaio and libaio-dev. Once they're installed, you're good to move on to install the Instant Client. Just don't forget to exit Synaptic Package Manager, since we'll be using dpkg and it won't work if Synaptic is open.

 

Install Oracle Instant Client

First step to install Oracle Instant Client from rpm files is to convert them into .deb files. Do that with alien by running the following command (from a command line in the directory where you downloaded your RPMs):

$ sudo alien --scripts *.rpm

It takes a little while to run, so be patient. Once it's complete, install the newly created .deb files:

$ dpkg -i *.deb

 

Set up your Environment Variables

The nasty thing about rpm files is that it's not always easy to know where the files were installed. If you opted for the zip file approach, your install will most definitely be different. For RPM install, add this to your .bashrc file (swap xx.x for your oracle version):


export ORACLE_HOME=/usr/lib/oracle/xx.x/client
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Update: If you get an ELFCLASS64 error, try setting LD_LIBRARY_PATH to $ORACLE_HOME/lib32 instead.

Reload your .bashrc file:
$. ~/.bashrc

Note: by default, Oracle Instant Client doesn't come with a tnsnames.ora file or the directory structure where it's usually found. We'll have to create that ourselves -

$ mkdir -p $ORACLE_HOME/network/admin; touch $ORACLE_HOME/network/admin/tnsnames.ora

 

Install DBD::Oracle

It's time to finally install DBD::Oracle. Go to your CPAN build directory and cd into DBD-Oracle-*. As a user having the environment variable set from the previous section, run Makefile.PL portion.

$ perl Makefile.PL

There's no need to set INC or LIB with the alien approach, but if you run into any issues, try giving Makefile.PL the path to your include dir for INC, and lib dir for LIB.

Next, run

$ make.

It will raise a few warnings, but unless it exits with an error, you should be OK.

The next logical step is to run make test. However, this will undoubtedly fail unless you have a valid entry in your tnsnames.ora file. If you don't, you can skip this test and hope that everything works later on. Otherwise, update your tnsnames.ora file with a valid entry, and set one more environment variable before running the test:

$ export ORACLE_USERID="user/passwd@tns_entry_name"
$ make test

This is usually the hardest part to pass with total success. Many things can go wrong. In my case, the valid entry I use doesn't have full grants to the user I log in as. This always triggers an error on the create/access sequences portion of the testing. I simply ignore it nowadays - make sure you analyze your test results thoroughly before choosing to ignore the errors as well.

Now that the testing is over, simply run
$ make install
as a super user and you're all set!

July 12th, 2009 | Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Category: Oracle, Perl

44 comments to Perl: Installing DBD::Oracle + Oracle Instant Client on Ubuntu 9.04

  • ANIL
    July 17th, 2009 at 1:31 pm · Reply

    Hi,
    I trierd intall DBD::Oracle in UBUNTU,i am getting this error,please help me to solve this problem.

    Thanks!

    Can’t locate cpan.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .).
    BEGIN failed–compilation aborted.

  • Ubuntu804
    July 23rd, 2009 at 9:58 am · Reply

    Can I use the same for Ubunutu 8.04 ?
    In the line: export ORACLE_USERID=”user/passwd@tns_entry_name”
    What can I put in for example in user/passwd@tns_entry_name ? What is the correct TNS ?
    thx for help

    • Vinny
      July 23rd, 2009 at 11:01 am · Reply

      Can I use the same for Ubunutu 8.04 ?

      I haven’t tested it on 8.04, but it should be pretty much the same thing. You might need to install some extra packages, so be prepared.

      In the line: export ORACLE_USERID=”user/passwd@tns_entry_name”
      What can I put in for example in user/passwd@tns_entry_name ? What is the correct TNS ?

      In order to do the testing, you should have access to a working database somewhere. In my case, I have a working oracle database running in my local area network. My tnsnames.ora under linux has the entry pointing to it. There is no “correct” TNS – it has to be some database you have access to and can reach from database clients such as Toad.

  • Ubuntu804
    July 24th, 2009 at 2:02 am · Reply

    Hi Vinny,
    thx for the Informations. I want to say the I’am new in that, so sorry for some stupid questions or unclear sentences.
    My Situaion:
    I want to connect from a Ubuntu8.04 with the Perl Modul dbd::oracle to a remote OracleDB which is in den LAN.
    I know from the OracleDB the IP, Port, Username, Password and Databasename.
    I had success to connect to MySQL und Postgre Datebases with the dbd Perl moduls and I thought it is the same easy way to connect to an oracleDB but now I know I have to do a little bit more.
    So my first question is can connect without put someting in in the tnsnames.ora, because I have my Perl file with the content:
    $dbh = DBI->connect(“dbi:Oracle:$MyOracledbname”, $MyOracleuser, $MyOraclepassw);
    or should I create in addition tnsnames.ora with connet: MyOracleuser/MyOraclepassw@MyOracledbname ?
    Maybe my train of thought is not right.
    thx for help

    • Vinny
      July 24th, 2009 at 5:39 am · Reply

      Hey, we all have to start somewhere right? I see where you’re getting confused, so I’ll try to explain and give you a few suggestions to bypass the problem.

      When connecting to an oracle database, you can use 2 different formats of DSN:

      my $dbh = DBI->connect("dbi:Oracle:host=$hostname_or_ip;sid=$oracle_sid;port=$oracle_port",$username,$password);
      or
      my $dbh = DBI->connect("dbi:Oracle:$tns_name_entry",$username,$password);

      The first example performs a direct connection without going through your tnsnames.ora. The second, however, looks into the tnsnames.ora found under $ENV{ORACLE_HOME}/network/admin for the entry and does the connection.

      TNS entries typically look something like this (what you’d have in your tnsnames.ora file) :

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )

      In this case, you would use ORCL as $tns_name_entry in your DSN. Of course that will do you no good unless you have an oracle database running under 127.0.0.1 port 1521. So here are the suggestions to try to bypass your issue:

      1) I was going to suggest that you skip $ make test but I suddenly realized that if you want DBD::Oracle installed, it’s because you probably need to connect to an oracle database that is already available to you – check with your DBA to get the TNS entry for the database, add it to your tnsnames.ora and set the following variable before making test:

      $ export ORACLE_USERID="username/passwd@TNS_ENTRY"

      2) Install an Oracle Express DB in a windows somewhere (express because the install file about 200MB in comparison with the 1.8Gb for the 11g regular install), make sure you have connectivity between your Linux and your Windows and use that as testing DB. I tried installing the regular download on Ubuntu but ran into all sorts of trouble. I’ll add a post on how to install the express edition shortly.

      3) Skip the testing just to get the module installed. This might lead to problems though. For example, in my cygwin I had issues with ORACLE_HOME in the registry when I uninstalled Oracle 8 client to install 9i. It left the registry broken and DBD::Oracle on cygwin wouldn’t work for anything. I had to manually go in there and fix the registry in order to get it to work. Linux doesn’t have such problems, but who knows what other issues you might run into.

      I hope this helps. Good luck and let me know your progress.

  • Ubuntu804
    July 28th, 2009 at 9:40 am · Reply

    It wooooorks, thx Vinny :-)

    I choose the second example and than it works! But before had no connection because of two (!) Firewalls which blocked Port 1521 (if somebody want to check if a Port ist open, you can use the programm “nmap” and than use the command “nmap -p1521 yourIPyouWish”)
    The TNS entry don’t work but this is not important, because second example is better for me, maybe if I spent some time it will work but I don’t need it until now ( I tried you example tnsnames.ora with my informations).
    Maybe the main Problem for me was that I don’t undestand the sense of TNS and thought this is a necessary configuration to get a connection to an oracle db.
    Here are things for 8.04 LTS which worked in my case, and which differs from vinny manual:
    - instead of ~/.bashrc use the command: source ~/.bashrc
    - instead of libaio use libaio1 (with apt-get install like with alien and libaio-dev I used the command: “apt-get install YourToolYouWish”)
    - I downloaded manualy dbd::odbc1.23, untared it, go in the extracted folder an do it like in vinny’s manual.
    Addional Infos:
    - I use exactly this packages:
    oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm
    oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm
    oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm
    and converted them to deb.

    maybe this informations can help another one

    nice greetings

    ubu

  • scott
    August 11th, 2009 at 9:14 am · Reply

    w0w, thankyou for this great tutorial. You have no idea how nice it is. I spent about 2 hrs this morning trying to figure it out, kept getting the home error, then i found your tutorial and it took about < 5 min. This works in Debian – Lenny ;)

  • george
    August 18th, 2009 at 3:47 pm · Reply

    I just found this article googling around. It’s been weeks since you posted this article and I wanted to let you know it’s still helping! Let me see what else you’ve been writing…

  • Koen Dejonghe
    August 26th, 2009 at 8:44 am · Reply

    Cheers mate. That helped me a lot. Just wondering: isn’t it easier to work with the zip files rather than going through all the trouble with the rpm’s ? But then, in the process I learned to know alien. Great job.

    • Vinny
      August 26th, 2009 at 9:04 am · Reply

      Koen, thanks for your comment.

      Personally, I like Zip files because I can control where I place the files and stuff, but by using binary package files (RPM/DEB), I can control install/uninstall through Synaptic, although I can’t always easily find where a package was installed. I guess both have their down sides :)

  • subodh
    August 28th, 2009 at 4:24 pm · Reply

    Nice write up. It helped me set up DBD on ubuntu 8.04. However
    the make test failed with one test

    t/31lob……………..ok 4/9DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xa45570)] at t/31lob.t line 108.

    and any LOB based transactions get hung. I used the 11.1.0.7.0 client and the server is 11g. Googling this – led me to posts which suggest there might be a problem with this client. the advise was to use
    10.x.x.. client. Anyone see the same behaviour?

    Thanks

  • Ratna
    September 16th, 2009 at 8:06 am · Reply

    Hi Vinny,

    I got stucked where setting up the paths.
    I dont have oracle in my system.
    I dont know how to set remote oracle home in my system.
    Can you tell me That.

    thanks and Regards
    Ratna

    • Vinny
      September 16th, 2009 at 8:14 am · Reply

      Hey Ratna,

      I don’t know if it’s possible to set up a remote oracle home. However, the steps before “Set up your Environment Variables” should help you to get an oracle client installed. That way you can access remote databases through tnsnames.ora

      Let me know if you have any trouble with those steps…

      Vinny

  • Ratna
    September 16th, 2009 at 11:57 pm · Reply

    Hi Vinny,

    This might be silly question.
    Do we need oracle in our system before installing client.

    Thansk and Regards
    Ratna

    • Vinny
      September 18th, 2009 at 11:04 am · Reply

      Hi Ratna,

      No, you don’t need Oracle database to install the client. Actually, if you do have the Oracle DB installed, then you probably don’t need the client on that machine.

      Vinny

  • Ratna
    September 17th, 2009 at 2:20 am · Reply

    Hi Vinny,

    Please forget the last reply.
    I understand what is Oracle client.
    Now I installed oracle client using rpm file(converted to debian).
    I set up the envinroment variables properly as you explained.
    When I run perl Makefile.PL in DBD-Oracle-* folder.
    Its giving the following error message.
    Is that means do I need to install oracle in my machine???

    root@ratnak-laptop:~/.cpan/build/DBD-Oracle-1.23-LomXe3# perl Makefile.PL
    Using DBI 1.609 (for perl 5.010000 on x86_64-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.10.0/auto/DBI/

    Configuring DBD::Oracle for perl 5.010000 on linux (x86_64-linux-gnu-thread-multi)

    Remember to actually *READ* the README file! Especially if you have any problems.

    The ORACLE_HOME environment variable value (/usr/lib/oracle/10.2.0.3/client) is not valid.
    It must be set to hold the path to an Oracle installation directory
    on this machine (or a machine with a compatible architecture).
    For an Instant Client install, the directory should include an sdk subdirectory.
    See the appropriate README file for your OS for more information.
    ABORTED!

    Thanks and regards
    Ratna

    • Vinny
      September 18th, 2009 at 11:01 am · Reply

      Hey Ratna,

      Looks like you don’t have oracle installed under the path in your ORACLE_HOME (/usr/lib/oracle/10.2.0.3/client). Make sure your ORACLE_HOME points to the valid client install path.

      Vinny

  • Ratna
    September 17th, 2009 at 4:37 am · Reply

    Hi Vinny,

    I completed installing oracle client.
    I downloaded zip files and set path to that folder.
    Then it installed properly.

    Thanks and Regards
    Ratna

  • Jai
    September 17th, 2009 at 6:56 am · Reply

    Nice post, I am stuck in this installation for one hour, Thanks again …

  • Sri
    November 9th, 2009 at 3:56 am · Reply

    Vinny

    I’m trying to run a perl script having STAF framework using Perl installed during Oracle installation. But I’m getting an error like
    Data : Can’t locate PLSTAF.pm in @INC (@INC contains: usr/local/staf
    /bin /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/
    perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i38
    6-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr
    /lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.

    I think this is due to some Perl related environment variables set during Oracle installation.

    Any idea which perl related env vars are set during Oracle installation.

    Thanks
    Sandhya

    • Vinny
      November 9th, 2009 at 8:00 am · Reply

      Hi Sandhya,

      Perl is complaining that it cannot find PLSTAF.pm in any of the places configured for it to be found. It’s looking for PLSTAF.pm under user/local/staf instead of /user/local/staf (notice the leading slash). Are you adding it by use lib? It doesn’t look like it’s oracle related to me.

  • Asterix
    November 18th, 2009 at 9:17 am · Reply

    Hi Vinny,
    Nice article .I too seem to have run into the same problem that subodh has mentioned .I am trying to install DBD::Oracle and getting the below mentioned error
    t/31lob……………..DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xf3f5fa0)] at t/31lob.t line 108.

    Any feedback would be greatly appreciated.
    Regards
    Paramjit

  • Vinny
    November 18th, 2009 at 9:50 am · Reply

    Paramjit/Subodh,
    I did some digging, and found this post: http://www.nntp.perl.org/group/perl.dbi.users/2009/01/msg33612.html where they discuss the problem. In short – it does seem to be client related and others have said that only the tests have failed – no impact in Production scripts (maybe they weren’t using LOBs??)

    Cheers,
    Vinny

  • Chris_av
    November 25th, 2009 at 3:45 am · Reply

    HEllo,
    I work with an Oracle 8i in a machine A.
    I want to access in Perl 5.8.5 from another machine B to this Oracle8i-machine A
    Do I need just DBI and DBD ?
    Do I need Oracle-Client ?
    Regards

    Chris

    • Vinny
      November 25th, 2009 at 10:40 am · Reply

      Hi Chris,

      You will need DBI and DBD::Oracle. To be able to build DBD::Oracle, however, you will need an Oracle client. Just make sure you can perform a tnsping on the SID from machine B to machine A to make sure your tnsnames.ora is set up correctly. If you have several machines that you would like to set up (having the same architecture/OS), you could also check out this post to build DBD::Oracle on one machine only and use PAR so you won’t have to rebuild DBD::Oracle on all boxes every time you upgrade your client.

      And speaking of upgrading clients… I strongly recommend that you upgrade your Oracle to at least 9i.

      Cheers,
      Vinny

  • chris
    November 26th, 2009 at 7:01 am · Reply

    Hello Vinny,
    Thanks.
    No upgrading in the offing, because it’s existant’s recover.
    Actually, I succeeded with DBI 1.50.
    But now, the install of DBD::Oracle 1.17 doesn’t work ..See
    Trying to find an ORACLE_HOME
    Your LD_LIBRARY_PATH env var is set to ”
    The ORACLE_HOME environment variable is not set and I couldn’t guess it.
    I think I can obtain an old client.
    But I don’t know how it works.
    Regards,
    Chris

  • Vinny
    November 26th, 2009 at 10:12 am · Reply

    Chris,
    The DBI usually installs easy – never had any problems with it. The DBD::Oracle, however, is more tricky. Make sure you have an oracle client installed in that box. I’m not sure if 10g or 11g clients will work well with 8i server, but I’m pretty sure that the 9i will do fine. You can download 11g from here, and with some googling you might be able to find legacy clients.

    If you already have a client installed, then make sure you set your environment variables as explained in the tutorial.

    Let me know how it goes.
    Vinny

  • Chris
    November 27th, 2009 at 2:59 am · Reply

    Hello Vinny,
    Thanks for your answer.
    The problem is, the machine with Perl DBI is a Linux 2.6.9-42.EL x86_64. I can’t find a client8i for such a machine. It seems to recent to work with a client-Oracle8i. It’s not a Solaris nor a HP UX. So, maybe the 9i is OK … or the same problem will arrive ?
    The post ( Oracle WITHOUT having an installed client ) seems about 10g only.

    • Vinny
      November 27th, 2009 at 10:12 am · Reply

      Chris,

      Try installing the 11g client on your machine and using sqlplus to connect to the 8i server. If connection works, run some of the select queries you plan on running with perl. If all is good, then install DBD::Oracle against the 11g client. If not, please let me know and I’ll try to get you an 8i.

  • Chris
    December 2nd, 2009 at 2:14 pm · Reply

    Hello Vinny,
    I tried to install the 11g client. These are cascading difficulties. The last was to have a GDM Graphic Interface , on the Linux x86_64 which is a virtual machine. I don’t know if I have to work on the screen (console) of the Box. Or just copy some of them. But it’s to hard to deal with. To many files, to many parameters, variables. And I don’t know what I have to do . There is a genezi ( or smtg like that ) file but also a message error about not shared library…
    All this for only use Perl with Oracle ?
    I wish I could copy only a few zip or jar files.

    • Vinny
      December 2nd, 2009 at 3:10 pm · Reply

      Chris,
      Almost all of the steps of the tutorial above are to be run in the command line. If you don’t have a graphical interface to run Synaptic Package Manager, then use apt-get from the command line:

      sudo apt-get install libaio alien

      Where exactly are you getting the errors and what is the error message?

  • Chris
    December 7th, 2009 at 8:20 am · Reply

    HEllo Vinny,
    I found those 3 zip files :
    oracle-instantclient11.2-basic-11.2.0.0.2-1.x86_64.zip
    oracle-instantclient11.2-sqlplus-11.2.0.0.2-1.x86_64.zip
    oracle-instantclient11.2-devel-11.2.0.0.2-1.x86_64.zip
    They gave a directory
    instantclient_11_2
    with no bin nor lib.
    -rwxrwxr-x 1 root root 25412 avr 25 2009 adrci
    -rw-rw-r– 1 root root 437 avr 25 2009 BASIC_README
    -rwxrwxr-x 1 root root 44827 avr 25 2009 genezi
    -r–r–r– 1 root root 342 avr 25 2009 glogin.sql
    -rwxrwxr-x 1 root root 48090963 avr 25 2009 libclntsh.so.11.1
    -r-xr-xr-x 1 root root 7855714 avr 25 2009 libnnz11.so
    -rwxrwxr-x 1 root root 1260664 avr 25 2009 libocci.so.11.1
    -rwxrwxr-x 1 root root 87843274 avr 25 2009 libociei.so
    -r-xr-xr-x 1 root root 164318 avr 25 2009 libocijdbc11.so
    -r-xr-xr-x 1 root root 1494031 avr 25 2009 libsqlplusic.so
    -r-xr-xr-x 1 root root 1501081 avr 25 2009 libsqlplus.so
    -r–r–r– 1 root root 1982368 avr 25 2009 ojdbc5.jar
    -r–r–r– 1 root root 2096421 avr 25 2009 ojdbc6.jar
    drwxrwxr-x 4 root root 4096 avr 25 2009 sdk
    -r-xr-xr-x 1 root root 9304 avr 25 2009 sqlplus
    -rw-rw-r– 1 root root 441 avr 25 2009 SQLPLUS_README
    -rw-rw-r– 1 root root 37021 avr 25 2009 xstreams.jar

    So what could be my ORACLE_HOME ?

    Regards
    Chris

  • Geoff
    December 7th, 2009 at 8:18 pm · Reply

    Hi Vinny,

    Great tutorial, just wanted to let you know that it works Fine on Ubuntu Lenny. I had a pre deployed oracle instant client 11.1.0.7 that was hand rolled and it was just a matter of changing my $ORACLE_HOME path to match

    Thanks heaps, you’ve saved me a load of time :)

  • Carnifex
    December 15th, 2009 at 3:00 am · Reply

    Hi Vinny,

    Thanks for your useful tutorial!
    I followed all your instructions to install DBD:Oracle.
    Nevertheless when I try to run my script I get this error :

    install_driver(Oracle) failed: Can’t locate DBD/Oracle.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 3) line 3.
    Perhaps the DBD::Oracle perl module hasn’t been fully installed,
    or perhaps the capitalisation of ‘Oracle’ isn’t right.

    Any idea?

    Thank you

    • Vinny
      December 15th, 2009 at 5:53 am · Reply

      Hi Carnifex,

      Apparently the module didn’t finish installing. Please post the output of your perl Makefile.PL, make, make test, and make install so I can have a look at where it broke. The capitalizing is correct.

  • Pankaj
    May 21st, 2010 at 10:32 am · Reply

    Hi Vinny,

    I am geting blow error. can you please help me in that.
    nstall_driver(Oracle) failed: Can’t locate DBD/Oracle.pm in @INC (@INC contains: /usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at (eval 3) line 3.
    Perhaps the DBD::Oracle perl module hasn’t been fully installed,
    or perhaps the capitalisation of ‘Oracle’ isn’t right.
    Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
    at /softs/bmc/exploit/bin/em/process_alert line 210

    # perl Makefile.PL
    Multiple copies of Driver.xst found in: /opt/csw/lib/perl/site_perl/auto/DBI/ /opt/csw/lib/perl/csw/auto/DBI/ at Makefile.PL line 37
    Using DBI 1.611 (for perl 5.008008 on sun4-solaris-thread-multi) installed in /opt/csw/lib/perl/site_perl/auto/DBI/

    Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris-thread-multi)

    Remember to actually *READ* the README file! Especially if you have any problems.

    Installing on a solaris, Ver#2.8
    Using Oracle in /softs/bmc/sctme630/oracle/product/10.1.0.2
    DEFINE _SQLPLUS_RELEASE = “1001000300″ (CHAR)
    Oracle version 10.1.0.3 (10.1)
    Found /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo/demo_rdbms32.mk
    Using /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo/demo_rdbms32.mk
    Your LD_LIBRARY_PATH env var is set to ‘/lib’
    WARNING: Your LD_LIBRARY_PATH env var doesn’t include ‘/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32′ but probably needs to.
    Reading /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo/demo_rdbms32.mk
    Reading /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib/env_rdbms.mk

    Attempting to discover Oracle OCI build rules
    cc -c DBD_ORA_OBJ.c
    by executing: [make -f /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo/demo_rdbms32.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
    Oracle oci build prolog:
    [Building client shared library libclntsh.so ...]
    [Call script /softs/bmc/sctme630/oracle/product/10.1.0.2/bin/genclntsh ...]
    [genclntsh]
    [Built /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so ... DONE]
    Oracle oci build command:
    [true -xarch=v8 -L/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32/ -L/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib32/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/sysliblist` -R/softs/bmc/sctme630/oracle/product/10.1.0.2/lib -laio -lposix4 -lkstat -lm -lthread]

    Found header files in /softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public.

    Checking for functioning wait.ph

    System: perl5.008008 sunos ra 5.8 generic_117350-51 sun4u sparc sunw,sun-blade-1000
    Compiler: cc -xO3 -xtarget=ultra -xarch=v8 -D_REENTRANT -xO3 -xtarget=ultra -xarch=v8 -I/opt/csw/bdb44/include -I/opt/csw/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
    Linker: /usr/ccs/bin/ld
    Sysliblist: -lnsl -lsocket -lgen -ldl
    Oracle makefiles would have used these definitions but we override them:
    CC: cc
    CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
    $(SHARED_CFLAG) $(USRFLAGS)
    [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 -Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/plsql/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
    LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
    [-o $@ -L/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib/ -L$(LIBHOME)]
    Linking with OTHERLDFLAGS = -xarch=v8 -L/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32/ -L/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib32/ -lclntsh `cat /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/sysliblist` -R/softs/bmc/sctme630/oracle/product/10.1.0.2/lib -laio -lposix4 -lkstat -lm -lthread [from 'build' rule]

    Checking if your kit is complete…
    Looks good
    LD_RUN_PATH=/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32:/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib32
    Using DBD::Oracle 1.24.
    Using DBD::Oracle 1.24.
    Multiple copies of Driver.xst found in: /opt/csw/lib/perl/site_perl/auto/DBI/ /opt/csw/lib/perl/csw/auto/DBI/ at Makefile.PL line 1701
    Using DBI 1.611 (for perl 5.008008 on sun4-solaris-thread-multi) installed in /opt/csw/lib/perl/site_perl/auto/DBI/
    Writing Makefile for DBD::Oracle

    *** If you have problems…
    read all the log printed above, and the README and README.help.txt files.
    (Of course, you have read README by now anyway, haven’t you?)

    [root@sfrxsch1:/opt/DBD-ORA-PKG/DBD-Oracle-1.24]
    # make
    cp Oracle.pm blib/lib/DBD/Oracle.pm
    cp oraperl.ph blib/lib/oraperl.ph
    cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
    cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
    cp Oraperl.pm blib/lib/Oraperl.pm
    cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
    cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
    cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
    cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
    /opt/csw/bin/perl -p -e “s/~DRIVER~/Oracle/g” /opt/csw/lib/perl/site_perl/auto/DBI/Driver.xst > Oracle.xsi
    /opt/csw/bin/perl /opt/csw/share/perl/5.8.8/ExtUtils/xsubpp -typemap /opt/csw/share/perl/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
    cc -c -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/plsql/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/network/public -I/opt/csw/lib/perl/site_perl/auto/DBI -D_REENTRANT -xO3 -xtarget=ultra -xarch=v8 -I/opt/csw/bdb44/include -I/opt/csw/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xtarget=ultra -xarch=v8 -DVERSION=\”1.24\” -DXS_VERSION=\”1.24\” -KPIC “-I/opt/csw/lib/perl/5.8.8/CORE” -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\”10.1.0.3\” Oracle.c
    cc -c -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/plsql/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/network/public -I/opt/csw/lib/perl/site_perl/auto/DBI -D_REENTRANT -xO3 -xtarget=ultra -xarch=v8 -I/opt/csw/bdb44/include -I/opt/csw/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xtarget=ultra -xarch=v8 -DVERSION=\”1.24\” -DXS_VERSION=\”1.24\” -KPIC “-I/opt/csw/lib/perl/5.8.8/CORE” -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\”10.1.0.3\” dbdimp.c
    cc -c -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/demo -I/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/plsql/public -I/softs/bmc/sctme630/oracle/product/10.1.0.2/network/public -I/opt/csw/lib/perl/site_perl/auto/DBI -D_REENTRANT -xO3 -xtarget=ultra -xarch=v8 -I/opt/csw/bdb44/include -I/opt/csw/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xtarget=ultra -xarch=v8 -DVERSION=\”1.24\” -DXS_VERSION=\”1.24\” -KPIC “-I/opt/csw/lib/perl/5.8.8/CORE” -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\”10.1.0.3\” oci8.c
    Running Mkbootstrap for DBD::Oracle ()
    chmod 644 Oracle.bs
    rm -f blib/arch/auto/DBD/Oracle/Oracle.so
    LD_RUN_PATH=”/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32:/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib32″ cc -G -L/opt/csw/bdb44/lib -L/opt/csw/lib -L/usr/lib -L/usr/ccs/lib -L/opt/SUNWspro/prod/lib/v8plus -L/opt/SUNWspro/prod/lib -L/lib Oracle.o dbdimp.o oci8.o -xarch=v8 -L/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32/ -L/softs/bmc/sctme630/oracle/product/10.1.0.2/rdbms/lib32/ -lclntsh `cat /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/sysliblist` -R/softs/bmc/sctme630/oracle/product/10.1.0.2/lib -laio -lposix4 -lkstat -lm -lthread -o blib/arch/auto/DBD/Oracle/Oracle.so \
    \

    chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
    cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
    chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
    /opt/csw/bin/perl “-Iblib/arch” “-Iblib/lib” ora_explain.PL ora_explain
    Extracted ora_explain from ora_explain.PL with variable substitutions.
    cp ora_explain blib/script/ora_explain
    /opt/csw/bin/perl “-MExtUtils::MY” -e “MY->fixin(shift)” blib/script/ora_explain
    Manifying blib/man1/ora_explain.1
    Manifying blib/man3/DBD::Oracle.3perl
    Manifying blib/man3/DBD::Oraperl.3perl
    [root@sfrxsch1:/opt/DBD-ORA-PKG/DBD-Oracle-1.24]
    # make test
    PERL_DL_NONLAZY=1 /opt/csw/bin/perl “-MExtUtils::Command::MM” “-e” “test_harness(0, ‘blib/lib’, ‘blib/arch’)” t/*.t
    t/01base…………….# Test loading DBI, DBD::Oracle and version
    t/01base…………….ok 1/6
    # Failed test ‘install_driver’
    # at t/01base.t line 22.
    t/01base…………….NOK 4Failed to load Oracle extension and/or shared libraries:
    install_driver(Oracle) failed: Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at (eval 7) line 3
    Compilation failed in require at (eval 7) line 3.
    Perhaps a required shared library or dll isn’t installed where expected
    at t/01base.t line 19
    The remaining tests will probably also fail with the same error.

    *** Please read the README and README.help.txt files for help. ***

    t/01base…………….ok 5/6# Looks like you failed 1 test of 6.
    t/01base…………….dubious
    Test returned status 1 (wstat 256, 0×100)
    DIED. FAILED test 4
    Failed 1/6 tests, 83.33% okay (less 2 skipped tests: 3 okay, 50.00%)
    t/10general………….install_driver(Oracle) failed: Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at (eval 5) line 3
    Compilation failed in require at (eval 5) line 3.
    Perhaps a required shared library or dll isn’t installed where expected
    at /opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/lib/Oraperl.pm line 55
    Compilation failed in require at t/10general.t line 6.
    BEGIN failed–compilation aborted at t/10general.t line 6.
    # Looks like your test died before it could output anything.
    t/10general………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/12impdata………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/nchar_test_lib.pl line 6
    Compilation failed in require at t/nchar_test_lib.pl line 6.
    BEGIN failed–compilation aborted at t/nchar_test_lib.pl line 6.
    Compilation failed in require at t/12impdata.t line 27.
    # Looks like your test died before it could output anything.
    t/12impdata………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-7
    Failed 7/7 tests, 0.00% okay
    t/14threads………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/nchar_test_lib.pl line 6
    Compilation failed in require at t/nchar_test_lib.pl line 6.
    BEGIN failed–compilation aborted at t/nchar_test_lib.pl line 6.
    Compilation failed in require at t/14threads.t line 30.
    # Looks like your test died before it could output anything.
    t/14threads………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-19
    Failed 19/19 tests, 0.00% okay
    t/15nls……………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/nchar_test_lib.pl line 6
    Compilation failed in require at t/nchar_test_lib.pl line 6.
    BEGIN failed–compilation aborted at t/nchar_test_lib.pl line 6.
    Compilation failed in require at t/15nls.t line 9.
    # Looks like your test died before it could output anything.
    t/15nls……………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/20select…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/20select.t line 4
    Compilation failed in require at t/20select.t line 4.
    BEGIN failed–compilation aborted at t/20select.t line 4.
    # Looks like your test died before it could output anything.
    t/20select…………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/21nchar……………Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/21nchar.t line 12
    Compilation failed in require at t/21nchar.t line 12.
    BEGIN failed–compilation aborted at t/21nchar.t line 12.
    # Looks like your test died before it could output anything.
    t/21nchar……………dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/22nchar_al32utf8……Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/22nchar_al32utf8.t line 9
    Compilation failed in require at t/22nchar_al32utf8.t line 9.
    BEGIN failed–compilation aborted at t/22nchar_al32utf8.t line 9.
    # Looks like your test died before it could output anything.
    t/22nchar_al32utf8……dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/22nchar_utf8……….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/22nchar_utf8.t line 9
    Compilation failed in require at t/22nchar_utf8.t line 9.
    BEGIN failed–compilation aborted at t/22nchar_utf8.t line 9.
    # Looks like your test died before it could output anything.
    t/22nchar_utf8……….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/23wide_db………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/23wide_db.t line 9
    Compilation failed in require at t/23wide_db.t line 9.
    BEGIN failed–compilation aborted at t/23wide_db.t line 9.
    # Looks like your test died before it could output anything.
    t/23wide_db………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/23wide_db_8bit……..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/23wide_db_8bit.t line 9
    Compilation failed in require at t/23wide_db_8bit.t line 9.
    BEGIN failed–compilation aborted at t/23wide_db_8bit.t line 9.
    # Looks like your test died before it could output anything.
    t/23wide_db_8bit……..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/23wide_db_al32utf8….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/23wide_db_al32utf8.t line 9
    Compilation failed in require at t/23wide_db_al32utf8.t line 9.
    BEGIN failed–compilation aborted at t/23wide_db_al32utf8.t line 9.
    # Looks like your test died before it could output anything.
    t/23wide_db_al32utf8….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/24implicit_utf8…….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/24implicit_utf8.t line 12
    Compilation failed in require at t/24implicit_utf8.t line 12.
    BEGIN failed–compilation aborted at t/24implicit_utf8.t line 12.
    # Looks like your test died before it could output anything.
    t/24implicit_utf8…….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/25plsql……………Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/25plsql.t line 5
    Compilation failed in require at t/25plsql.t line 5.
    BEGIN failed–compilation aborted at t/25plsql.t line 5.
    # Looks like your test died before it could output anything.
    t/25plsql……………dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/26exe_array………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/26exe_array.t line 4
    Compilation failed in require at t/26exe_array.t line 4.
    BEGIN failed–compilation aborted at t/26exe_array.t line 4.
    t/26exe_array………..dubious
    Test returned status 2 (wstat 512, 0×200)
    t/28array_bind……….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/28array_bind.t line 22
    Compilation failed in require at t/28array_bind.t line 22.
    BEGIN failed–compilation aborted at t/28array_bind.t line 22.
    t/28array_bind……….dubious
    Test returned status 2 (wstat 512, 0×200)
    t/30long…………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/30long.t line 5
    Compilation failed in require at t/30long.t line 5.
    BEGIN failed–compilation aborted at t/30long.t line 5.
    t/30long…………….dubious
    Test returned status 2 (wstat 512, 0×200)
    t/31lob……………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/31lob.t line 5
    Compilation failed in require at t/31lob.t line 5.
    BEGIN failed–compilation aborted at t/31lob.t line 5.
    # Looks like your test died before it could output anything.
    t/31lob……………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-11
    Failed 11/11 tests, 0.00% okay
    t/31lob_extended……..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/31lob_extended.t line 16
    Compilation failed in require at t/31lob_extended.t line 16.
    BEGIN failed–compilation aborted at t/31lob_extended.t line 16.
    # Looks like your test died before it could output anything.
    t/31lob_extended……..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/32xmltype………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/32xmltype.t line 5
    Compilation failed in require at t/32xmltype.t line 5.
    BEGIN failed–compilation aborted at t/32xmltype.t line 5.
    # Looks like your test died before it could output anything.
    t/32xmltype………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-4
    Failed 4/4 tests, 0.00% okay
    t/34pres_lobs………..install_driver(Oracle) failed: Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at (eval 5) line 3
    Compilation failed in require at (eval 5) line 3.
    Perhaps a required shared library or dll isn’t installed where expected
    at /opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/lib/Oraperl.pm line 55
    Compilation failed in require at t/34pres_lobs.t line 6.
    BEGIN failed–compilation aborted at t/34pres_lobs.t line 6.
    # Looks like your test died before it could output anything.
    t/34pres_lobs………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/40ph_type………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/40ph_type.t line 6
    Compilation failed in require at t/40ph_type.t line 6.
    BEGIN failed–compilation aborted at t/40ph_type.t line 6.
    # Looks like your test died before it could output anything.
    t/40ph_type………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/50cursor…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/50cursor.t line 5
    Compilation failed in require at t/50cursor.t line 5.
    BEGIN failed–compilation aborted at t/50cursor.t line 5.
    # Looks like your test died before it could output anything.
    t/50cursor…………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/51scroll…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/51scroll.t line 5
    Compilation failed in require at t/51scroll.t line 5.
    BEGIN failed–compilation aborted at t/51scroll.t line 5.
    # Looks like your test died before it could output anything.
    t/51scroll…………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    DIED. FAILED tests 1-33
    Failed 33/33 tests, 0.00% okay
    t/55nested…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/55nested.t line 5
    Compilation failed in require at t/55nested.t line 5.
    BEGIN failed–compilation aborted at t/55nested.t line 5.
    # Looks like your test died before it could output anything.
    t/55nested…………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/56embbeded…………Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/56embbeded.t line 4
    Compilation failed in require at t/56embbeded.t line 4.
    BEGIN failed–compilation aborted at t/56embbeded.t line 4.
    t/56embbeded…………dubious
    Test returned status 2 (wstat 512, 0×200)
    t/58object…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/58object.t line 4
    Compilation failed in require at t/58object.t line 4.
    BEGIN failed–compilation aborted at t/58object.t line 4.
    t/58object…………..dubious
    Test returned status 2 (wstat 512, 0×200)
    t/60reauth…………..Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/nchar_test_lib.pl line 6
    Compilation failed in require at t/nchar_test_lib.pl line 6.
    BEGIN failed–compilation aborted at t/nchar_test_lib.pl line 6.
    Compilation failed in require at t/60reauth.t line 6.
    # Looks like your test died before it could output anything.
    t/60reauth…………..dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/70meta…………….Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/nchar_test_lib.pl line 6
    Compilation failed in require at t/nchar_test_lib.pl line 6.
    BEGIN failed–compilation aborted at t/nchar_test_lib.pl line 6.
    Compilation failed in require at t/70meta.t line 9.
    # Looks like your test died before it could output anything.
    t/70meta…………….dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/80ora_charset………Can’t load ‘/opt/DBD-ORA-PKG/DBD-Oracle-1.24/blib/arch/auto/DBD/Oracle/Oracle.so’ for module DBD::Oracle: ld.so.1: perl: fatal: /softs/bmc/sctme630/oracle/product/10.1.0.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /opt/csw/lib/perl/5.8.8/DynaLoader.pm line 230.
    at t/80ora_charset.t line 8
    Compilation failed in require at t/80ora_charset.t line 8.
    BEGIN failed–compilation aborted at t/80ora_charset.t line 8.
    t/80ora_charset………dubious
    Test returned status 2 (wstat 512, 0×200)
    Failed Test Stat Wstat Total Fail Failed List of Failed
    ——————————————————————————-
    t/01base.t 1 256 6 1 16.67% 4
    t/10general.t 255 65280 ?? ?? % ??
    t/12impdata.t 255 65280 7 14 200.00% 1-7
    t/14threads.t 255 65280 19 38 200.00% 1-19
    t/15nls.t 255 65280 ?? ?? % ??
    t/20select.t 255 65280 ?? ?? % ??
    t/21nchar.t 255 65280 ?? ?? % ??
    t/22nchar_al32utf8.t 255 65280 ?? ?? % ??
    t/22nchar_utf8.t 255 65280 ?? ?? % ??
    t/23wide_db.t 255 65280 ?? ?? % ??
    t/23wide_db_8bit.t 255 65280 ?? ?? % ??
    t/23wide_db_al32utf8.t 255 65280 ?? ?? % ??
    t/24implicit_utf8.t 255 65280 ?? ?? % ??
    t/25plsql.t 255 65280 ?? ?? % ??
    t/26exe_array.t 2 512 ?? ?? % ??
    t/28array_bind.t 2 512 ?? ?? % ??
    t/30long.t 2 512 ?? ?? % ??
    t/31lob.t 255 65280 11 22 200.00% 1-11
    t/31lob_extended.t 255 65280 ?? ?? % ??
    t/32xmltype.t 255 65280 4 8 200.00% 1-4
    t/34pres_lobs.t 255 65280 ?? ?? % ??
    t/40ph_type.t 255 65280 ?? ?? % ??
    t/50cursor.t 255 65280 ?? ?? % ??
    t/51scroll.t 255 65280 33 66 200.00% 1-33
    t/55nested.t 255 65280 ?? ?? % ??
    t/56embbeded.t 2 512 ?? ?? % ??
    t/58object.t 2 512 ?? ?? % ??
    t/60reauth.t 255 65280 ?? ?? % ??
    t/70meta.t 255 65280 ?? ?? % ??
    t/80ora_charset.t 2 512 ?? ?? % ??
    2 subtests skipped.
    Failed 30/30 test scripts, 0.00% okay. 75/80 subtests failed, 6.25% okay.
    *** Error code 2
    make: Fatal error: Command failed for target `test_dynamic’
    [root@sfrxsch1:/opt/DBD-ORA-PKG/DBD-Oracle-1.24]
    # make install
    Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
    Writing /opt/csw/lib/perl/site_perl/auto/DBD/Oracle/.packlist
    Appending installation info to /opt/csw/lib/perl/5.8.8/perllocal.pod

    • Vinny
      May 21st, 2010 at 10:42 am · Reply

      Hey Pankaj,

      Take a look at this comment by Tim Bunce. It looks like you have some old files lying around.

      http://www.nntp.perl.org/group/perl.dbi.users/2004/08/msg23651.html

      I see you’re also getting “wrong ELF class: ELFCLASS64″ errors. The Makefile.PL output warns you about your LD_LIBRARY_PATH variable, which ends up being the cause of the ELFCLASS64 error.

      Your LD_LIBRARY_PATH env var is set to ‘/lib’
WARNING: Your LD_LIBRARY_PATH env var doesn’t include ‘/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32′

      Make sure you add the lib32 dir to LD_LIBRARY_PATH, preferably as the first entry

      export LD_LIBRARY_PATH=/softs/bmc/sctme630/oracle/product/10.1.0.2/lib32:$LD_LIBRARY_PATH
perl Makefile.PL
  • Pankaj
    May 25th, 2010 at 5:26 am · Reply

    Hi Vinney,
    Thanks for ur prompt reply. Its working fine now
    -Pankaj

  • Allen Franco
    May 26th, 2010 at 2:45 pm · Reply

    Hey guys, i have a problem when do the last part:

    WARNING: Setting ORACLE_HOME env var to /usr/sbin for you.
    WARNING: If these tests fail you may have to set ORACLE_HOME yourself!
    The ORACLE_HOME environment variable value (/usr/sbin) is not valid.
    It must be set to hold the path to an Oracle installation directory
    on this machine (or a machine with a compatible architecture).
    For an Instant Client install, the directory should include an sdk subdirectory.
    See the appropriate README file for your OS for more information.
    ABORTED!
    Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=site]
    PYTHIAN/DBD-Oracle-1.24b.tar.gz
    /usr/bin/perl Makefile.PL INSTALLDIRS=site — NOT OK
    Running make test
    Make had some problems, won’t test
    Running make install
    Make had some problems, won’t install
    Failed during this command:
    PYTHIAN/DBD-Oracle-1.24b.tar.gz : writemakefile NO ‘/usr/bin/perl Makefile.PL INSTALLDIRS=site’ returned status 512

    Dont know to finish the installation of DBD::Oracle, and cant find a solution on the web… :-/

    • Vinny
      May 26th, 2010 at 3:52 pm · Reply

      Allen,
      You don’t seem to have set ORACLE_HOME correctly, so the module isn’t finding the client libs in order to build. Review the steps in “Set up your Environment Variables” and try again.

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>