[svn:dbd-oracle] r11202 - dbd-oracle/trunk

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/ORAPASS@ODBCO
+   and
+   > sqlplus ORAUSER/ORAPASS@rhost/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

• [svn:dbd-oracle] r11202 - dbd-oracle/trunk by byterock