Author: byterock Date: Tue May 6 04:08:39 2008 New Revision: 11202 Modified: dbd-oracle/trunk/Changes dbd-oracle/trunk/README.64bit.txt dbd-oracle/trunk/README.wingcc.txt dbd-oracle/trunk/Todo
Log: note keeping on who did what and some additions to the readmes Modified: dbd-oracle/trunk/Changes ============================================================================== --- dbd-oracle/trunk/Changes (original) +++ dbd-oracle/trunk/Changes Tue May 6 04:08:39 2008 @@ -1,3 +1,6 @@ +=head1 Changes in DBD-Oracle 1.22(svn rev xxxx) 2008 + Makefile.PL now working without flags for Linux 11.1.0.6 instant client and regular client from John Scoles, Andy Sautins, H.Merijn Brand and Nathan Vonnahme + =head1 Changes in DBD-Oracle 1.21(svn rev 11067) 11th April 2008 Added Notes to README.win32.txt on installing Instant Client 11.1.0.6.0 from John Scoles Added the oci_typecode_name method to get the name rather than just the number of an OCI_TYPECODE from John Scoles Modified: dbd-oracle/trunk/README.64bit.txt ============================================================================== --- dbd-oracle/trunk/README.64bit.txt (original) +++ dbd-oracle/trunk/README.64bit.txt Tue May 6 04:08:39 2008 @@ -3,6 +3,91 @@ which sort of defeats the purpose of having a 64bit box. So until 64bit Perl comes out we will be posing in this README any success stories we have come across +-------- Original Message -------- + +Subject: DBD::Oracle 64-bit success story +From: H.Merijn Brand +Date: On Mon, 14 Apr 2008 09:48:41 +Priority: Normal + +I finally got round trying Oracle Instant Client on Linux with no +Oracle installed, connecting to a 64bit Oracle 9.2.0.8 on HP-UX +11.11/64. I had to do some fiddling with Makefile.PL (see bottom). +Sorry for this being long. Feel free to mold it into anything useful. + +1. Before you start on DBD::Oracle, make sure DBD::ODBC works. That will + assure your DSN works. Install unixODBC before anything else. + +2. Assuming you've got OIC from the rpm's, you will have it here: + + /usr/include/oracle/11.1.0.1/client + /usr/lib/oracle/11.1.0.1/client + /usr/share/oracle/11.1.0.1/client + + +3. for the 64 bit clienat we have these rpm + oracle-instantclient-basic-11.1.0.1-1.x86_64.rpm + oracle-instantclient-devel-11.1.0.1-1.x86_64.rpm + oracle-instantclient-jdbc-11.1.0.1-1.x86_64.rpm + oracle-instantclient-odbc-11.1.0.1-1.x86_64.rpm + oracle-instantclient-sqlplus-11.1.0.1-1.x86_64.rpm + + and to add to the confusement, they install to + + /usr/include/oracle/11.1.0.1/client64 + /usr/lib/oracle/11.1.0.1/client64 + /usr/share/oracle/11.1.0.1/client64 + +4. To make DBD::ODBC work, I had to create a tnsnames.ora, and I chose + + /usr/lib/oracle/11.1.0.1/admin/tnsnames.ora + + /usr/lib/oracle/11.1.0.1/admin > cat sqlnet.ora + NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME) + /usr/lib/oracle/11.1.0.1/admin > cat tnsnames.ora + ODBCO = ( + DESCRIPTION = + ( ADDRESS_LIST = + ( ADDRESS = + ( PROTOCOL = TCP ) + ( PORT = 1521 ) + ( HOST = rhost ) + ) + ) + ( CONNECT_DATA = + ( SERVICE_NAME = odbctest ) + ) + ) + /usr/lib/oracle/11.1.0.1/admin > + + Real world example changed to hide the obvious. Important bits are + "ODBCO", which is the ODBC name, and it can be anything, as long as + you use this in ORACLE_DSN too (please don't use whitespace, colons, + semicolons and/or slashes. "rhost" is the hostname of where the DB + is running, and "odbctest" is available on "rhost". To check that, + run "lsnrctl services" on "rhost". + Set the environment (TWO_TASK is not needed) + + > setenv LD_LIBRARY_PATH /usr/lib/oracle/11.1.0.1/client/lib + > setenv TNS_ADMIN /usr/lib/oracle/11.1.0.1/admin + > setenv ORACLE_HOME /usr/lib/oracle/11.1.0.1/client + > setenv ORACLE_DSN dbi:Oracle:ODBCO + > setenv ORACLE_USERID ORAUSER/ORAPASS + + Check if the connection works: + > isql -v ODBCO + + And for Oracle: + > sqlplus ORAUSER/[EMAIL PROTECTED] + and + > sqlplus ORAUSER/[EMAIL PROTECTED]/odbctest + + should both work + + +Note by JPS: + +Merijn patched the trunk version of Makeifle.PL to account for the above it will be in release 1.22 -------- Original Message -------- Modified: dbd-oracle/trunk/README.wingcc.txt ============================================================================== --- dbd-oracle/trunk/README.wingcc.txt (original) +++ dbd-oracle/trunk/README.wingcc.txt Tue May 6 04:08:39 2008 @@ -1,3 +1,56 @@ +29th April 2008 +From Nathan Vonnahme (nathan.vonnahme at bannerhealth.com) + +Hi! Thanks for maintaining DBD::Oracle! + +It might help people like me in the future to include these notes in +README.wingcc.txt or README.win32.txt (hopefully Outlook won't destroy +them)... there might be better ways of doing some of the details too but +it seems to have worked for me: + + +Compiling DBD::Oracle using the Oracle Instant Client, Cygwin Perl and +gcc + + 1. Download these two packages from Oracle's Instant Client for +Windows site +(http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs +/winsoft.html): + + Instant Client Package - Basic: All files required to run OCI, +OCCI, and JDBC-OCI applications + Instant Client Package - SDK: Additional header files and an +example makefile for developing Oracle applications with Instant Client + + (I usually just use the latest version of the client) + + 2. Unpack both into C:\oracle\instantclient_11_1 + 3. Download and unpack DBD::Oracle from CPAN to some place with no +spaces in the path (I used /tmp/DBD-Oracle) and cd to it. + 4. Set up some environment variables (it didn;t work until I got the +DSN right): + + ORACLE_DSN=DBI:Oracle:host=oraclehost;sid=oracledb1 + ORACLE_USERID=username/password + + 5. + + perl Makefile.PL + make + make test + make install + +Note, the TNS Names stuff doesn't always seem to work with the instant +client so Perl scripts need to explicitly use host/sid in the DSN, like +this: + +my $dbh = DBI->connect('dbi:Oracle:host=oraclehost;sid=oracledb1', +'username', 'password'); + + + + + 14-Sep-2002 -- Michael Chase Makefile.PL should now create liboci.a for you. If it fails, follow the Modified: dbd-oracle/trunk/Todo ============================================================================== --- dbd-oracle/trunk/Todo (original) +++ dbd-oracle/trunk/Todo Tue May 6 04:08:39 2008 @@ -4,7 +4,12 @@ For release 1.22 or later +Drop support for Oralce 8 and earlier + +add support for $dbh->trace('SQL'); + Replace OCIInitialize + OCIEnvInit, with OCIEnvCreate + Add in the DBD only debugging flag Add new method oci_exe_mode to get the Name of the Execution Modes
