defaria.com/blogs/Status/2007/08/building-oracle.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" 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...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>Building Oracle 10.x for Linux - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2007/08/building-oracle.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2007/08/installing-err.html" title="Installing... err... I mean building Oracle">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2007/09/ucmwb-123-2.html" title="UCMWB 1.2.3">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="Building Oracle 10.x for Linux">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2007/08/building-oracle.html">
  26     <meta property="og:description" content=" 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...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" 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...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2007/08/building-oracle.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">Building Oracle 10.x for Linux</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1917" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">Building Oracle 10.x for Linux</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2007-08-30T14:35:08-08:00" itemprop="datePublished">August 30, 2007</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <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>
  86
  87   <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>
  88 </ol>
  89                   <h2>Building Qt OCI</h2>
  90
  91 <p>Pat, I managed to install the Oracle Client 10.x for Linux - Will
  92 had gotten a 64 bit version. I even managed to use sqlplus to connect
  93 to RANCQ_RANDBS from Linux!</p>
  94
  95 <p>Now it's time to build Qt's OCI interface so that I can ultimately
  96 build the Linux version of ucmwb.</p>
  97
  98 <p>Trolltech, makers of Qt, state:</p>
  99
 100 <blockquote>
 101   <h3>How to Build the OCI Plugin on Unix and Mac OS X</h3>
 102
 103   </p>For Oracle 10g, all you need is the "Instant Client Package -
 104   Basic" and "Instant Client Package - SDK". For Oracle prior to 10g,
 105   you require the standard Oracle client and the SDK packages.</p>
 106
 107   <p>Oracle library files required to build the driver:</p>
 108
 109   <ul>
 110     <li>libclntsh.so (all versions)</li>
 111
 112     <li>libwtc9.so (only Oracle 9)</li>
 113   </ul>
 114
 115   <p>Tell qmake where to find the Oracle header files and shared
 116   libraries and run make:</p>
 117
 118   <h3>For Oracle version 9:</h3>
 119
 120   <pre>
 121 cd $QTDIR/src/plugins/sqldrivers/oci
 122 qmake -o Makefile "INCLUDEPATH+=$ORACLE_HOME/rdbms/public $ORACLE_HOME/rdbms/demo" "LIBS+=-L$ORACLE_HOME/lib -lclntsh -lwtc9" oci.pro
 123 make
 124   </pre>
 125
 126   <p>For Oracle version 10, we assume that you installed the RPM
 127   packages of the Instant Client Package SDK (you need to adjust the
 128   version number accordingly):</p>
 129
 130   <pre>
 131 cd $QTDIR/plugins/src/sqldrivers/oci
 132 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
 133 make
 134   </pre>
 135 </blockquote>
 136
 137 <p>Unfortunately, after installing the Oracle client I didn't have a
 138 /usr/include/oracle... And I didn't have a /usr/lib/oracle either. Nor
 139 did I see an include directory under where I installed the Oracle
 140 client (/opt/oracle). Before I ask Trolltech support what the
 141 appropriate paths should be I thought I'd ask you. Perhaps I have not
 142 properly installed a portion of Oracle...</p>
 143                 </div>
 144                 <nav class="page-navigation entry-navigation pagination content-nav">
 145                   <ul class="page-navigation-list">
 146
 147                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/08/installing-err.html" title="Installing... err... I mean building Oracle">Previous entry</a></li>
 148
 149
 150                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/09/ucmwb-123-2.html" title="UCMWB 1.2.3">Next entry</a></li>
 151
 152                   </ul>
 153                 </nav>
 154                 <!--
 155 <aside id="zenback" class="zenback feedback">
 156   Please paste Zenback script code here.
 157 </aside>
 158 -->
 159
 160
 161               </article>
 162             </div>
 163             <aside class="widgets related" role="complementary">
 164               <nav class="widget-search widget">
 165   <div class="widget-content">
 166     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 167       <div>
 168         <input type="text" name="search" value="" placeholder="Search...">
 169
 170         <input type="hidden" name="IncludeBlogs" value="8">
 171
 172         <input type="hidden" name="limit" value="20">
 173         <button type="submit" name="button">
 174           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 175         </button>
 176       </div>
 177     </form>
 178   </div>
 179 </nav>
 180 <nav class="widget-archive-category widget">
 181   <h3 class="widget-header">Categories</h3>
 182   <div class="widget-content">
 183
 184
 185     <ul class="widget-list">
 186
 187
 188       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 189
 190
 191       </li>
 192
 193
 194
 195
 196       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 197
 198
 199       </li>
 200
 201
 202
 203
 204       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 205
 206
 207       </li>
 208
 209
 210
 211
 212       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 213
 214
 215       </li>
 216
 217
 218
 219
 220       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 221
 222
 223       </li>
 224
 225
 226
 227
 228       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 229
 230
 231       </li>
 232
 233
 234
 235
 236       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 237
 238
 239       </li>
 240
 241
 242
 243
 244       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 245
 246
 247       </li>
 248
 249
 250
 251
 252       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 253
 254
 255       </li>
 256
 257
 258
 259
 260       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 261
 262
 263       </li>
 264
 265
 266
 267
 268       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 269
 270
 271       </li>
 272
 273
 274
 275
 276       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 277
 278
 279       </li>
 280
 281     </ul>
 282
 283
 284   </div>
 285 </nav>
 286
 287
 288 <nav class="widget-archive-dropdown widget">
 289   <h3 class="widget-header">Archives</h3>
 290   <div class="widget-content">
 291     <select>
 292       <option>Select a Month...</option>
 293
 294       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 295
 296
 297
 298       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 299
 300
 301
 302       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 303
 304
 305
 306       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 307
 308
 309
 310       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 311
 312
 313
 314       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 315
 316
 317
 318       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 319
 320
 321
 322       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 323
 324
 325
 326       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 327
 328
 329
 330       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 331
 332
 333
 334       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 335
 336
 337
 338       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 339
 340
 341
 342       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 343
 344
 345
 346       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 347
 348
 349
 350       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 351
 352
 353
 354       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 355
 356
 357
 358       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 359
 360
 361
 362       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 363
 364
 365
 366       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 367
 368
 369
 370       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 371
 372
 373
 374       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 375
 376
 377
 378       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 379
 380
 381
 382       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 383
 384
 385
 386       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 387
 388
 389
 390       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 391
 392
 393
 394       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 395
 396
 397
 398       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 399
 400
 401
 402       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 403
 404
 405
 406       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 407
 408
 409
 410       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 411
 412
 413
 414       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 415
 416
 417
 418       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 419
 420
 421
 422       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 423
 424
 425
 426       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 427
 428
 429
 430       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 431
 432
 433
 434       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 435
 436
 437
 438       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 439
 440
 441
 442       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 443
 444
 445
 446       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 447
 448
 449
 450       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 451
 452
 453
 454       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 455
 456
 457
 458       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 459
 460
 461
 462       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 463
 464
 465
 466       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 467
 468
 469
 470       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 471
 472
 473
 474       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 475
 476
 477
 478       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 479
 480
 481
 482       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 483
 484
 485
 486       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 487
 488
 489
 490       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 491
 492
 493
 494       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 495
 496
 497
 498       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 499
 500
 501
 502       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 503
 504
 505
 506       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 507
 508
 509
 510       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 511
 512
 513
 514       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 515
 516
 517
 518       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 519
 520
 521
 522       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 523
 524
 525
 526       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 527
 528
 529
 530       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 531
 532
 533
 534       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 535
 536
 537
 538       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 539
 540
 541
 542       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 543
 544
 545
 546       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 547
 548
 549
 550       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 551
 552
 553
 554       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 555
 556
 557
 558       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 559
 560
 561
 562       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 563
 564
 565
 566       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 567
 568
 569
 570       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 571
 572
 573
 574       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 575
 576
 577
 578       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 579
 580     </select>
 581   </div>
 582 </nav>
 583
 584
 585
 586 <div class="widget-syndication widget section">
 587   <div class="widget-content">
 588     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 589
 590   </div>
 591 </div>
 592
 593             </aside>
 594           </div>
 595         </div>
 596         <footer id="footer" role="contentinfo">
 597           <div id="footer-inner">
 598             <div id="footer-content">
 599   <nav role="navigation">
 600           <ul>
 601             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 602
 603
 604           </ul>
 605         </nav>
 606
 607   <p class="license">&copy; Copyright 2016.</p>
 608   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 609 </div>
 610           </div>
 611         </footer>
 612       </div>
 613     </div>
 614     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 615     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 616   </body>
 617 </html>