defaria.com/blogs/Status/archives/000670.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml" />
  11
  12    <title>Status for Andrew DeFaria: Building Oracle 10.x for Linux</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/000669.html" title="Installing... err... I mean building Oracle" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000671.html" title="UCMWB 1.2.3" />
  17
  18    <!--
  19 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  20          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  21          xmlns:dc="http://purl.org/dc/elements/1.1/">
  22 <rdf:Description
  23     rdf:about="http://defaria.com/blogs/Status/archives/000670.html"
  24     trackback:ping="http://defaria.com/mt/mt-tb.cgi/57"
  25     dc:title="Building Oracle 10.x for Linux"
  26     dc:identifier="http://defaria.com/blogs/Status/archives/000670.html"
  27     dc:subject="General Dynamics"
  28     dc:description=" Managed to get a 10.2 sqlplus client to talk to our 9.2 database server from Solaris. Regular expressions, however, do not work. Since there is no 9.2 Oracle 64 bit client for Linux I decided to attempt to get..."
  29     dc:creator=""
  30     dc:date="2007-08-30T14:35:08-06:00" />
  31 </rdf:RDF>
  32 -->
  33
  34
  35
  36
  37    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  38 </head>
  39 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  40    <div id="container">
  41       <div id="container-inner" class="pkg">
  42
  43          <div id="banner">
  44             <div id="banner-inner" class="pkg">
  45                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  46                <h2 id="banner-description">Searchable status reports and work log</h2>
  47             </div>
  48          </div>
  49
  50          <div id="pagebody">
  51             <div id="pagebody-inner" class="pkg">
  52                <div id="alpha">
  53                   <div id="alpha-inner" class="pkg">
  54
  55                      <p class="content-nav">
  56                         <a href="http://defaria.com/blogs/Status/archives/000669.html">&laquo; Installing... err... I mean building Oracle</a> |
  57                         <a href="http://defaria.com/blogs/Status/">Main</a>
  58                         | <a href="http://defaria.com/blogs/Status/archives/000671.html">UCMWB 1.2.3 &raquo;</a>
  59                      </p>
  60
  61                      <a id="a000670"></a>
  62                      <div class="entry" id="entry-670">
  63                         <h3 class="entry-header">Building Oracle 10.x for Linux</h3>
  64                         <div class="entry-content">
  65                            <div class="entry-body">
  66                               <ul>
  67   <li>Managed to get a 10.2 sqlplus client to talk to our 9.2 database server from Solaris. Regular expressions, however, do not work.</li>
  68
  69   <li>Since there is no 9.2 Oracle 64 bit client for Linux I decided to attempt to get the 10.2 Oracle 64 bit client installed. Managed to get a 10.2 sqlplus client to talk to our 9.2 database server from Linux! Went to build the Qt OCI portion and failed.</li>
  70 </ol>
  71                            </div>
  72                            <div id="more" class="entry-more">
  73                               <h2>Building Qt OCI</h2>
  74
  75 <p>Pat, I managed to install the Oracle Client 10.x for Linux - Will
  76 had gotten a 64 bit version. I even managed to use sqlplus to connect
  77 to RANCQ_RANDBS from Linux!</p>
  78
  79 <p>Now it's time to build Qt's OCI interface so that I can ultimately
  80 build the Linux version of ucmwb.</p>
  81
  82 <p>Trolltech, makers of Qt, state:</p>
  83
  84 <blockquote>
  85   <h3>How to Build the OCI Plugin on Unix and Mac OS X</h3>
  86
  87   </p>For Oracle 10g, all you need is the "Instant Client Package -
  88   Basic" and "Instant Client Package - SDK". For Oracle prior to 10g,
  89   you require the standard Oracle client and the SDK packages.</p>
  90
  91   <p>Oracle library files required to build the driver:</p>
  92
  93   <ul>
  94     <li>libclntsh.so (all versions)</li>
  95
  96     <li>libwtc9.so (only Oracle 9)</li>
  97   </ul>
  98
  99   <p>Tell qmake where to find the Oracle header files and shared
 100   libraries and run make:</p>
 101
 102   <h3>For Oracle version 9:</h3>
 103
 104   <pre>
 105 cd $QTDIR/src/plugins/sqldrivers/oci
 106 qmake -o Makefile "INCLUDEPATH+=$ORACLE_HOME/rdbms/public $ORACLE_HOME/rdbms/demo" "LIBS+=-L$ORACLE_HOME/lib -lclntsh -lwtc9" oci.pro
 107 make
 108   </pre>
 109
 110   <p>For Oracle version 10, we assume that you installed the RPM
 111   packages of the Instant Client Package SDK (you need to adjust the
 112   version number accordingly):</p>
 113
 114   <pre>
 115 cd $QTDIR/plugins/src/sqldrivers/oci
 116 qmake -o Makefile "INCLUDEPATH+=/usr/include/oracle/10.1.0.3/client/" "LIBS+=-L/usr/lib/oracle/10.1.0.3/client/lib" oci.pro
 117 make
 118   </pre>
 119 </blockquote>
 120
 121 <p>Unfortunately, after installing the Oracle client I didn't have a
 122 /usr/include/oracle... And I didn't have a /usr/lib/oracle either. Nor
 123 did I see an include directory under where I installed the Oracle
 124 client (/opt/oracle). Before I ask Trolltech support what the
 125 appropriate paths should be I thought I'd ask you. Perhaps I have not
 126 properly installed a portion of Oracle...</p>
 127
 128                            </div>
 129                         </div>
 130                         <p class="entry-footer">
 131                            <span class="post-footers">Posted by  on August 30, 2007  2:35 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000670.html">Permalink</a>
 132                         </p>
 133                      </div>
 134
 135
 136                      <div class="trackbacks">
 137                         <h3 id="trackback" class="trackbacks-header">TrackBack</h3>
 138                         <div id="trackbacks-info">
 139                            <p>TrackBack URL for this entry:<br />http://defaria.com/mt/mt-tb.cgi/57</p>
 140                         </div>
 141                         <div class="trackbacks-content">
 142
 143                         </div>
 144                      </div>
 145
 146
 147
 148                   </div>
 149                </div>
 150             </div>
 151          </div>
 152       </div>
 153    </div>
 154 </body>
 155 </html>