defaria.com/blogs/Status/archives/000669.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: Installing... err... I mean building Oracle</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/000668.html" title="backBench.pl" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000670.html" title="Building Oracle 10.x for Linux" />
  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/000669.html"
  24     trackback:ping="http://defaria.com/mt/mt-tb.cgi/56"
  25     dc:title="Installing... err... I mean building Oracle"
  26     dc:identifier="http://defaria.com/blogs/Status/archives/000669.html"
  27     dc:subject="General Dynamics"
  28     dc:description=" Started building cqtalk, a Perl process to interact with Clearquest Spent time attempting to install/build Oracle client for Linux..."
  29     dc:creator=""
  30     dc:date="2007-08-29T16:13:56-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/000668.html">&laquo; backBench.pl</a> |
  57                         <a href="http://defaria.com/blogs/Status/">Main</a>
  58                         | <a href="http://defaria.com/blogs/Status/archives/000670.html">Building Oracle 10.x for Linux &raquo;</a>
  59                      </p>
  60
  61                      <a id="a000669"></a>
  62                      <div class="entry" id="entry-669">
  63                         <h3 class="entry-header">Installing... err... I mean building Oracle</h3>
  64                         <div class="entry-content">
  65                            <div class="entry-body">
  66                               <ul>
  67   <li>Started building cqtalk, a Perl process to interact with Clearquest</li>
  68
  69   <li>Spent time attempting to install/build Oracle client for Linux</li>
  70 </ul>
  71                            </div>
  72                            <div id="more" class="entry-more">
  73                               <h2>Installing/Building Oracle</h2>
  74
  75 <p>We have an application, ucmwb, which uses Oracle to talk directly
  76 to our Clearquest databases. This application runs on Solaris and
  77 hopefully soon Linux. In particular it talks to RANCQ on
  78 RANDBS. AFAICT RANDBS is an Oracle 9.2 server.</p>
  79
  80 <p>I would love to go to Oracle 10.x because with 10.x comes regexs
  81 and they would help ucmwb tremendously. However I can't get a 10.x
  82 client to talk to this 9.x server.</p>
  83
  84 <p>Working on the Solaris side for now, I can use the 9.2 version of
  85 sqlplus to connect to our RANCQ database:</p>
  86
  87 <div class=code><pre>
  88 <b><font color="#3366ff">Randws016:</font></b><u>echo $ORACLE_HOME</u>
  89 /usr/local/oracle/product/9.2
  90 <b><font><b><font color="#3366ff">Randws016:</font></b></font></b><u>$ORACLE_HOME/bin/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS</u>
  91 SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 29 14:46:53 2007
  92
  93 Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  94
  95 Connected to:
  96 Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
  97 With the Partitioning, OLAP and Oracle Data Mining options
  98 JServer Release 9.2.0.6.0 - Production
  99
 100 SQL&gt;
 101 </pre></div>
 102
 103 <p>but I cannot use the 10.2 version of sqlplus to connect to RANCQ:</p>
 104
 105 <div class=code><pre>
 106 <b><font><b><font><b><font><b><font color="#3366ff">Randws016:</font></b></font></b></font></b></font></b><u>echo $ORACLE_HOME</u>
 107 /home/p6258c/Solaris/10.2.0.3/instantclient_10_2
 108 <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>
 109 SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 14:48:21 2007
 110
 111 Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
 112
 113 ERROR:
 114 ORA-12154: TNS:could not resolve the connect identifier specified
 115
 116 Enter user-name:
 117 </pre></div>
 118
 119 <p>Will had stated that he thought that 10.2 clients could talk to 9.2
 120 servers. Is that true? If so why can't I run sqlplus and connect to
 121 RANCQ?</p>
 122
 123                            </div>
 124                         </div>
 125                         <p class="entry-footer">
 126                            <span class="post-footers">Posted by  on August 29, 2007  4:13 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000669.html">Permalink</a>
 127                         </p>
 128                      </div>
 129
 130
 131                      <div class="trackbacks">
 132                         <h3 id="trackback" class="trackbacks-header">TrackBack</h3>
 133                         <div id="trackbacks-info">
 134                            <p>TrackBack URL for this entry:<br />http://defaria.com/mt/mt-tb.cgi/56</p>
 135                         </div>
 136                         <div class="trackbacks-content">
 137
 138                         </div>
 139                      </div>
 140
 141
 142
 143                   </div>
 144                </div>
 145             </div>
 146          </div>
 147       </div>
 148    </div>
 149 </body>
 150 </html>