官方文档是这样子写的 1) The first part of the process is to download and install the latest version of Active Perl from http://www.activeperl.com/.2) Use the PPM application to get the latest version of DBI3) Download the latest DBD::Oracle from http://svn.perl.org/modules/dbd-oracle/trunk/4) Download and unzip the Oracle Instant Client (10.2.0.1 or 10.1.0.5) 32 bit from http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html You will need all three of these products i. Instant Client Package - Basic ii. Instant Client Package - SQL*Plus: iii. Instant Client Package - SDK: or
install oracle 10XE http://www.oracle.com/technology/products/database/xe/index.html 5) You will now need the Microsoft Visual C++ toolkit 2003. Unfortunately this product is no longer available from Microsoft. The file name was VCToolkitSetup.exe and is available at this mirror site http://www.filewatcher.com/m/VCToolkitSetup.exe.32952488.0.0.html at the time of writing. Microsoft's replacement for this tool kit is Visual C++ 2005 Express Edition and all attempts to compile DBD::Oracle with this product fail. It has been successfully compiled using a complete edition of Microsoft Visual Studio 2005. Download and then install this product.6) You will also need the Windows SDK. Which can be found at http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en You have the choice to of either to download the entire SDK and install or run an online install from the page. Both have been tested and proven to work.7) Next download and install the Microsoft .net framework 1.1 skd from http://www.microsoft.com/downloads/details.aspx?FamilyID=9b3a2ca6-3647-4070-9f41-a333c6b9181d&displaylang=en 8) Enough Downloading and installing go have a coffee.9) You should at this time attempt to connect to an Oracle database with the version SQL*Plus that you installed in step 4. If you are unable to connect at this stage then any problems you encounter later may have nothing to do with DBD::Oracle10) On the path where you installed Visual C++ find and edit the vcvars32.bat file as follows. You may have to modify these path values depending where you installed the products on you computer, i. Add the local path to the windows platform SDK include directory to the Set INCLUDE Command Line to include the needed files from the Windows SDK.
e.g. "C:\Program Files\Microsoft Platform SDK\Include;"
ii. Add the local path to the .net Vc7 lib directory to the Set LIB command to include the needed library file from the .Net SKD
e.g. C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\lib;
iii. Add the local path to the windows platform SDK Lib directory to the Set Lib command to include the needed library files from the Windows SDK
e.g. C:\Program Files\Microsoft Platform SDK\Lib;11) Open a Windows Visual C++ command window from the start menu.12) Add the path to the instant client to the Path command. If you are compiling aginst a 10XE db/client then you can skip steps 12 to 14. e.g. PATH = C:/Oracle/instantclient;%PATH%
13) Using the "Set" command add "ORACLE_HOME=path to Instant client" to the environment variables. e.g. Set ORACLE_HOME=C:\Oracle\instantclient
14) Using the "Set" command add "NLS_LANG=.WE8ISO8859P15" to the environment variables. The globalization variable is required, with this or another compatible value, by Oracle instantclient in order for it to compile correctly. e.g. Set NLS_LANG=.WE8ISO8859P1515) Using the "Set" command add "ORACLE_USERID=test/test@test" substituting test with the username/password@database you wish to run the make test files against. Note: it is not necessary to do this step for the compile and install to work. However: The self-test programs included with Oracle-DBD will mostly fail.16) Move to the DBD-Oracle directory in the Visual C++ window DOS prompt and enter the following. c:\oracle-dbd\>perl Makefile.PL The Makefile should then run and compile Oracle-dbd without reporting any errors.17) From this DOS prompt enter the following command c:\oracle-dbd\>nmake The Visual C++ make executable will then build you DBD-execuable. There should be no errors at this point.18) You can test the compile by either entering c:\oracle-dbd\>nmake test As long as you have given a valid user name, password and database name in step 15 you will see some results. If it appears to run but you do not get a connection check the following. i. User name password and DB Name ii. Ensure the a valid TNSNAMES.ORA file is in the Instantclient directory iii. Attempt to log into the version of SQLPLUS that comes with Instantclient. If you manage to log on use the username password and TNS name with the Set ORACLE_USERID = and rerun the tests. iv If you are compiling against 10XE and have skiped steps 12 to 14 try again bu this time carry out these steps19) You can now install DBD-Oracle into you system by entering the following command from the Visual C++ window dos prompt; c:\oracle-dbd\>nmake install20) You should now be able to run DBD-Oracle on you system
实际上只需这样做: 1、安装ActivePerl 2、oracle客户端要装的,至少环境变量要设好 3、PPM>install DBI PPM>install DBD-ORACLE 4、Enough Downloading and installing go have a coffee.
http://www.oradb.net/setup/perlora_001.htm
1) The first part of the process is to download and install the latest version of
Active Perl from http://www.activeperl.com/.2) Use the PPM application to get the latest version of DBI3) Download the latest DBD::Oracle from http://svn.perl.org/modules/dbd-oracle/trunk/4) Download and unzip the Oracle Instant Client (10.2.0.1 or 10.1.0.5) 32 bit from
http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
You will need all three of these products
i. Instant Client Package - Basic
ii. Instant Client Package - SQL*Plus:
iii. Instant Client Package - SDK:
or
install oracle 10XE http://www.oracle.com/technology/products/database/xe/index.html 5) You will now need the Microsoft Visual C++ toolkit 2003. Unfortunately this product is no longer available from Microsoft.
The file name was VCToolkitSetup.exe and is available at this mirror site http://www.filewatcher.com/m/VCToolkitSetup.exe.32952488.0.0.html at the time of writing.
Microsoft's replacement for this tool kit is Visual C++ 2005 Express Edition and all attempts to compile DBD::Oracle with this product fail. It has been successfully compiled
using a complete edition of Microsoft Visual Studio 2005.
Download and then install this product.6) You will also need the Windows SDK. Which can be found at
http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en
You have the choice to of either to download the entire SDK and install or run an online install from the page.
Both have been tested and proven to work.7) Next download and install the Microsoft .net framework 1.1 skd from
http://www.microsoft.com/downloads/details.aspx?FamilyID=9b3a2ca6-3647-4070-9f41-a333c6b9181d&displaylang=en 8) Enough Downloading and installing go have a coffee.9) You should at this time attempt to connect to an Oracle database with the version SQL*Plus that
you installed in step 4. If you are unable to connect at this stage then any problems you encounter
later may have nothing to do with DBD::Oracle10) On the path where you installed Visual C++ find and edit the vcvars32.bat file as follows. You may have to modify
these path values depending where you installed the products on you computer, i. Add the local path to the windows platform SDK include directory to the Set INCLUDE
Command Line to include the needed files from the Windows SDK.
e.g. "C:\Program Files\Microsoft Platform SDK\Include;"
ii. Add the local path to the .net Vc7 lib directory to the Set LIB command
to include the needed library file from the .Net SKD
e.g. C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\lib;
iii. Add the local path to the windows platform SDK Lib directory to the Set Lib command
to include the needed library files from the Windows SDK
e.g. C:\Program Files\Microsoft Platform SDK\Lib;11) Open a Windows Visual C++ command window from the start menu.12) Add the path to the instant client to the Path command. If you are compiling aginst a 10XE db/client then you can skip steps
12 to 14.
e.g. PATH = C:/Oracle/instantclient;%PATH%
13) Using the "Set" command add "ORACLE_HOME=path to Instant client" to the environment variables.
e.g. Set ORACLE_HOME=C:\Oracle\instantclient
14) Using the "Set" command add "NLS_LANG=.WE8ISO8859P15" to the environment variables. The globalization variable is required,
with this or another compatible value, by Oracle instantclient in order for it to compile correctly.
e.g. Set NLS_LANG=.WE8ISO8859P1515) Using the "Set" command add "ORACLE_USERID=test/test@test" substituting test with the username/password@database
you wish to run the make test files against.
Note: it is not necessary to do this step for the compile and install to work.
However: The self-test programs included with Oracle-DBD will mostly fail.16) Move to the DBD-Oracle directory in the Visual C++ window DOS prompt and enter the following. c:\oracle-dbd\>perl Makefile.PL The Makefile should then run and compile Oracle-dbd without reporting any errors.17) From this DOS prompt enter the following command c:\oracle-dbd\>nmake The Visual C++ make executable will then build you DBD-execuable. There should be no errors at this point.18) You can test the compile by either entering c:\oracle-dbd\>nmake test As long as you have given a valid user name, password and database name in step 15 you will see some results. If it appears to
run but you do not get a connection check the following. i. User name password and DB Name
ii. Ensure the a valid TNSNAMES.ORA file is in the Instantclient directory
iii. Attempt to log into the version of SQLPLUS that comes with Instantclient.
If you manage to log on use the username password and TNS name with
the Set ORACLE_USERID = and rerun the tests.
iv If you are compiling against 10XE and have skiped steps 12 to 14 try again bu this time carry out these steps19) You can now install DBD-Oracle into you system by entering the following command from the Visual C++ window dos prompt; c:\oracle-dbd\>nmake install20) You should now be able to run DBD-Oracle on you system
1、安装ActivePerl
2、oracle客户端要装的,至少环境变量要设好
3、PPM>install DBI
PPM>install DBD-ORACLE
4、Enough Downloading and installing go have a coffee.