defaria.com/blogs/Status/archives/week_2007_08_26.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: August 26, 2007 - September  1, 2007 Archives</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/week_2007_08_19.html" title="August 19, 2007 - August 25, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_09_02.html" title="September  2, 2007 - September  8, 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/week_2007_08_19.html">&laquo; August 19, 2007 - August 25, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_09_02.html">September  2, 2007 - September  8, 2007 &raquo;</a>
  38                      </p>
  39
  40
  41                      <!--
  42 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  43          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  44          xmlns:dc="http://purl.org/dc/elements/1.1/">
  45 <rdf:Description
  46     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000670"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/57"
  48     dc:title="Building Oracle 10.x for Linux"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000670"
  50     dc:subject="General Dynamics"
  51     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..."
  52     dc:creator=""
  53     dc:date="2007-08-30T14:35:08-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">August 30, 2007</h2>
  59                      <a id="a000670"></a>
  60                      <div class="entry" id="entry-670">
  61                         <h3 class="entry-header">Building Oracle 10.x for Linux</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <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>
  66
  67   <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>
  68 </ol>
  69
  70                               <h2>Building Qt OCI</h2>
  71
  72 <p>Pat, I managed to install the Oracle Client 10.x for Linux - Will
  73 had gotten a 64 bit version. I even managed to use sqlplus to connect
  74 to RANCQ_RANDBS from Linux!</p>
  75
  76 <p>Now it's time to build Qt's OCI interface so that I can ultimately
  77 build the Linux version of ucmwb.</p>
  78
  79 <p>Trolltech, makers of Qt, state:</p>
  80
  81 <blockquote>
  82   <h3>How to Build the OCI Plugin on Unix and Mac OS X</h3>
  83
  84   </p>For Oracle 10g, all you need is the "Instant Client Package -
  85   Basic" and "Instant Client Package - SDK". For Oracle prior to 10g,
  86   you require the standard Oracle client and the SDK packages.</p>
  87
  88   <p>Oracle library files required to build the driver:</p>
  89
  90   <ul>
  91     <li>libclntsh.so (all versions)</li>
  92
  93     <li>libwtc9.so (only Oracle 9)</li>
  94   </ul>
  95
  96   <p>Tell qmake where to find the Oracle header files and shared
  97   libraries and run make:</p>
  98
  99   <h3>For Oracle version 9:</h3>
 100
 101   <pre>
 102 cd $QTDIR/src/plugins/sqldrivers/oci
 103 qmake -o Makefile "INCLUDEPATH+=$ORACLE_HOME/rdbms/public $ORACLE_HOME/rdbms/demo" "LIBS+=-L$ORACLE_HOME/lib -lclntsh -lwtc9" oci.pro
 104 make
 105   </pre>
 106
 107   <p>For Oracle version 10, we assume that you installed the RPM
 108   packages of the Instant Client Package SDK (you need to adjust the
 109   version number accordingly):</p>
 110
 111   <pre>
 112 cd $QTDIR/plugins/src/sqldrivers/oci
 113 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
 114 make
 115   </pre>
 116 </blockquote>
 117
 118 <p>Unfortunately, after installing the Oracle client I didn't have a
 119 /usr/include/oracle... And I didn't have a /usr/lib/oracle either. Nor
 120 did I see an include directory under where I installed the Oracle
 121 client (/opt/oracle). Before I ask Trolltech support what the
 122 appropriate paths should be I thought I'd ask you. Perhaps I have not
 123 properly installed a portion of Oracle...</p>
 124
 125
 126                               <p class="entry-footer">
 127                                  <span class="post-footers">Posted by  at  2:35 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000670.html">Permalink</a>
 128
 129                                  | <a href="http://defaria.com/blogs/Status/archives/000670.html#trackback">TrackBacks (0)</a>
 130                               </p>
 131                            </div>
 132                         </div>
 133                      </div>
 134
 135                      <!--
 136 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 137          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 138          xmlns:dc="http://purl.org/dc/elements/1.1/">
 139 <rdf:Description
 140     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000669"
 141     trackback:ping="http://defaria.com/mt/mt-tb.cgi/56"
 142     dc:title="Installing... err... I mean building Oracle"
 143     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000669"
 144     dc:subject="General Dynamics"
 145     dc:description=" Started building cqtalk, a Perl process to interact with Clearquest Spent time attempting to install/build Oracle client for Linux..."
 146     dc:creator=""
 147     dc:date="2007-08-29T16:13:56-06:00" />
 148 </rdf:RDF>
 149 -->
 150
 151
 152                      <h2 class="date-header">August 29, 2007</h2>
 153                      <a id="a000669"></a>
 154                      <div class="entry" id="entry-669">
 155                         <h3 class="entry-header">Installing... err... I mean building Oracle</h3>
 156                         <div class="entry-content">
 157                            <div class="entry-body">
 158                               <ul>
 159   <li>Started building cqtalk, a Perl process to interact with Clearquest</li>
 160
 161   <li>Spent time attempting to install/build Oracle client for Linux</li>
 162 </ul>
 163
 164                               <h2>Installing/Building Oracle</h2>
 165
 166 <p>We have an application, ucmwb, which uses Oracle to talk directly
 167 to our Clearquest databases. This application runs on Solaris and
 168 hopefully soon Linux. In particular it talks to RANCQ on
 169 RANDBS. AFAICT RANDBS is an Oracle 9.2 server.</p>
 170
 171 <p>I would love to go to Oracle 10.x because with 10.x comes regexs
 172 and they would help ucmwb tremendously. However I can't get a 10.x
 173 client to talk to this 9.x server.</p>
 174
 175 <p>Working on the Solaris side for now, I can use the 9.2 version of
 176 sqlplus to connect to our RANCQ database:</p>
 177
 178 <div class=code><pre>
 179 <b><font color="#3366ff">Randws016:</font></b><u>echo $ORACLE_HOME</u>
 180 /usr/local/oracle/product/9.2
 181 <b><font><b><font color="#3366ff">Randws016:</font></b></font></b><u>$ORACLE_HOME/bin/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS</u>
 182 SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 29 14:46:53 2007
 183
 184 Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 185
 186 Connected to:
 187 Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
 188 With the Partitioning, OLAP and Oracle Data Mining options
 189 JServer Release 9.2.0.6.0 - Production
 190
 191 SQL&gt;
 192 </pre></div>
 193
 194 <p>but I cannot use the 10.2 version of sqlplus to connect to RANCQ:</p>
 195
 196 <div class=code><pre>
 197 <b><font><b><font><b><font><b><font color="#3366ff">Randws016:</font></b></font></b></font></b></font></b><u>echo $ORACLE_HOME</u>
 198 /home/p6258c/Solaris/10.2.0.3/instantclient_10_2
 199 <b><font><b><font><b><font><b><font color="#3366ff">Randws016:</font></b></font></b></font></b></font></b><u>$ORACLE_HOME/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS</u>
 200 SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 14:48:21 2007
 201
 202 Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
 203
 204 ERROR:
 205 ORA-12154: TNS:could not resolve the connect identifier specified
 206
 207 Enter user-name:
 208 </pre></div>
 209
 210 <p>Will had stated that he thought that 10.2 clients could talk to 9.2
 211 servers. Is that true? If so why can't I run sqlplus and connect to
 212 RANCQ?</p>
 213
 214
 215                               <p class="entry-footer">
 216                                  <span class="post-footers">Posted by  at  4:13 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000669.html">Permalink</a>
 217
 218                                  | <a href="http://defaria.com/blogs/Status/archives/000669.html#trackback">TrackBacks (0)</a>
 219                               </p>
 220                            </div>
 221                         </div>
 222                      </div>
 223
 224                      <!--
 225 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 226          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 227          xmlns:dc="http://purl.org/dc/elements/1.1/">
 228 <rdf:Description
 229     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000668"
 230     trackback:ping="http://defaria.com/mt/mt-tb.cgi/55"
 231     dc:title="backBench.pl"
 232     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_08_26.html#entry-000668"
 233     dc:subject="General Dynamics"
 234     dc:description=" Added link and createWor to backBench.pl..."
 235     dc:creator=""
 236     dc:date="2007-08-28T15:55:40-06:00" />
 237 </rdf:RDF>
 238 -->
 239
 240
 241                      <h2 class="date-header">August 28, 2007</h2>
 242                      <a id="a000668"></a>
 243                      <div class="entry" id="entry-668">
 244                         <h3 class="entry-header">backBench.pl</h3>
 245                         <div class="entry-content">
 246                            <div class="entry-body">
 247                               <ul>
 248   <li>Added link and createWor to backBench.pl</li>
 249 </ul>
 250
 251                               <p class="entry-footer">
 252                                  <span class="post-footers">Posted by  at  3:55 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000668.html">Permalink</a>
 253
 254                                  | <a href="http://defaria.com/blogs/Status/archives/000668.html#trackback">TrackBacks (0)</a>
 255                               </p>
 256                            </div>
 257                         </div>
 258                      </div>
 259
 260                   </div>
 261                </div>
 262             </div>
 263          </div>
 264       </div>
 265    </div>
 266 </body>
 267 </html>