2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Started building cqtalk, a Perl process to interact with Clearquest Spent time attempting to install/build Oracle client for Linux...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>Installing... err... I mean building Oracle - 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/installing-err.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
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>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2007/08/backbenchpl.html" title="backBench.pl">
20 <link rel="next" href="http://defaria.com/blogs/Status/2007/08/building-oracle.html" title="Building Oracle 10.x for Linux">
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="Installing... err... I mean building Oracle">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2007/08/installing-err.html">
26 <meta property="og:description" content=" Started building cqtalk, a Perl process to interact with Clearquest Spent time attempting to install/build Oracle client for Linux...">
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">
30 <meta itemprop="description" content=" Started building cqtalk, a Perl process to interact with Clearquest Spent time attempting to install/build Oracle client for Linux...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2007/08/installing-err.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
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">Installing... err... I mean building Oracle</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1916" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">Installing... err... I mean building Oracle</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-29T16:13:56-08:00" itemprop="datePublished">August 29, 2007</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
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>
83 <div class="entry-content asset-content" itemprop="articleBody">
85 <li>Started building cqtalk, a Perl process to interact with Clearquest</li>
87 <li>Spent time attempting to install/build Oracle client for Linux</li>
89 <h2>Installing/Building Oracle</h2>
91 <p>We have an application, ucmwb, which uses Oracle to talk directly
92 to our Clearquest databases. This application runs on Solaris and
93 hopefully soon Linux. In particular it talks to RANCQ on
94 RANDBS. AFAICT RANDBS is an Oracle 9.2 server.</p>
96 <p>I would love to go to Oracle 10.x because with 10.x comes regexs
97 and they would help ucmwb tremendously. However I can't get a 10.x
98 client to talk to this 9.x server.</p>
100 <p>Working on the Solaris side for now, I can use the 9.2 version of
101 sqlplus to connect to our RANCQ database:</p>
103 <div class=code><pre>
104 <b><font color="#3366ff">Randws016:</font></b><u>echo $ORACLE_HOME</u>
105 /usr/local/oracle/product/9.2
106 <b><font><b><font color="#3366ff">Randws016:</font></b></font></b><u>$ORACLE_HOME/bin/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS</u>
107 SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 29 14:46:53 2007
109 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
112 Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
113 With the Partitioning, OLAP and Oracle Data Mining options
114 JServer Release 9.2.0.6.0 - Production
119 <p>but I cannot use the 10.2 version of sqlplus to connect to RANCQ:</p>
121 <div class=code><pre>
122 <b><font><b><font><b><font><b><font color="#3366ff">Randws016:</font></b></font></b></font></b></font></b><u>echo $ORACLE_HOME</u>
123 /home/p6258c/Solaris/10.2.0.3/instantclient_10_2
124 <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>
125 SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 14:48:21 2007
127 Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
130 ORA-12154: TNS:could not resolve the connect identifier specified
135 <p>Will had stated that he thought that 10.2 clients could talk to 9.2
136 servers. Is that true? If so why can't I run sqlplus and connect to
139 <nav class="page-navigation entry-navigation pagination content-nav">
140 <ul class="page-navigation-list">
142 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/08/backbenchpl.html" title="backBench.pl">Previous entry</a></li>
145 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/08/building-oracle.html" title="Building Oracle 10.x for Linux">Next entry</a></li>
150 <aside id="zenback" class="zenback feedback">
151 Please paste Zenback script code here.
158 <aside class="widgets related" role="complementary">
159 <nav class="widget-search widget">
160 <div class="widget-content">
161 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
163 <input type="text" name="search" value="" placeholder="Search...">
165 <input type="hidden" name="IncludeBlogs" value="8">
167 <input type="hidden" name="limit" value="20">
168 <button type="submit" name="button">
169 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
175 <nav class="widget-archive-category widget">
176 <h3 class="widget-header">Categories</h3>
177 <div class="widget-content">
180 <ul class="widget-list">
183 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
191 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
199 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
207 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
215 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
223 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
231 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
239 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
247 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
255 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
263 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
271 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
283 <nav class="widget-archive-dropdown widget">
284 <h3 class="widget-header">Archives</h3>
285 <div class="widget-content">
287 <option>Select a Month...</option>
289 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
293 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
297 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
301 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
305 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
309 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
313 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
317 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
321 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
325 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
329 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
333 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
337 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
341 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
345 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
349 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
353 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
357 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
361 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
365 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
369 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
373 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
377 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
381 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
385 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
389 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
393 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
417 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
421 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
425 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
429 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
433 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
437 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
461 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
465 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
469 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
473 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
477 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
481 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
509 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
513 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
517 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
521 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
525 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
529 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
549 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
553 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
557 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
561 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
565 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
569 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
573 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
581 <div class="widget-syndication widget section">
582 <div class="widget-content">
583 <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>
591 <footer id="footer" role="contentinfo">
592 <div id="footer-inner">
593 <div id="footer-content">
594 <nav role="navigation">
596 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
602 <p class="license">© Copyright 2016.</p>
603 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
609 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
610 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>