defaria.com/blogs/Status/archives/cat_tellabs.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: Tellabs Archives</title>
  13 </head>
  14 <body class="layout-one-column">
  15    <div id="container">
  16       <div id="container-inner" class="pkg">
  17
  18          <div id="banner">
  19             <div id="banner-inner" class="pkg">
  20                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  21                <h2 id="banner-description">Searchable status reports and work log</h2>
  22             </div>
  23          </div>
  24
  25          <div id="pagebody">
  26             <div id="pagebody-inner" class="pkg">
  27                <div id="alpha">
  28                   <div id="alpha-inner" class="pkg">
  29
  30                      <p class="content-nav">
  31                         <a href="http://defaria.com/blogs/Status/">Main</a>
  32                      </p>
  33
  34
  35                      <!--
  36 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  37          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  38          xmlns:dc="http://purl.org/dc/elements/1.1/">
  39 <rdf:Description
  40     rdf:about="http://defaria.com/blogs/Status/archives/cat_tellabs.html#entry-000748"
  41     trackback:ping="http://defaria.com/mt/mt-tb.cgi/112"
  42     dc:title="Remote Editing"
  43     dc:identifier="http://defaria.com/blogs/Status/archives/cat_tellabs.html#entry-000748"
  44     dc:subject="Tellabs"
  45     dc:description="Setting: ;; Set default tramp-default-method to ssh as well as ;; insert &quot;:&quot; into shell-prompt-pattern (setq tramp-default-method &quot;ssh&quot;) (setq shell-prompt-pattern &quot;^[^#$%&gt;:\n]*[#$%&gt;:] *&quot;) helps tremendously in getting tramp to work using ssh. Now just get ssh pre-shared key working through Cygwin..."
  46     dc:creator=""
  47     dc:date="2011-10-11T11:13:02-06:00" />
  48 </rdf:RDF>
  49 -->
  50
  51
  52                      <h2 class="date-header">October 11, 2011</h2>
  53                      <a id="a000748"></a>
  54                      <div class="entry" id="entry-748">
  55                         <h3 class="entry-header">Remote Editing</h3>
  56                         <div class="entry-content">
  57                            <div class="entry-body">
  58                               <p>Setting:</p>
  59
  60 <div type=code><pre>
  61 ;; Set default tramp-default-method to ssh as well as
  62 ;; insert ":" into shell-prompt-pattern
  63 (setq tramp-default-method "ssh")
  64 (setq shell-prompt-pattern "^[^#$%>:\n]*[#$%>:] *")
  65 </pre></div>
  66
  67 <p>helps tremendously in getting tramp to work using ssh. Now just get ssh pre-shared key working through Cygwin and run xemacs (or emacs) through Cygwin and tramp should work fine!</p>
  68
  69 <p>But even better may be to get editing of remote files working in Eclipse. Here's how you do that:</p>
  70
  71 <ol>
  72   <li>Install the following from http://download.eclipse.org/releases/helios:</li>
  73     <ul>
  74       <li>Remote System Explorer End-User Adapter</li>
  75       <li>Remote System Explorer User Actions</li>
  76       <li>PTP RDT Remote Tools Support</lib>
  77       <li>PTP Remote Development Tools (RDT)</li>
  78       <li>PTP Remote System Explorer</li>
  79     </ul>
  80
  81     <li>Configure new systems through the Remote Systems view</li>
  82 </ol>
  83
  84 <p>System monitor can be very useful to pin various deeply nested remote folders to.</p>
  85
  86                               <p class="entry-footer">
  87                                  <span class="post-footers">Posted by  at 11:13 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000748.html">Permalink</a>
  88
  89                                  | <a href="http://defaria.com/blogs/Status/archives/000748.html#trackback">TrackBacks (0)</a>
  90                               </p>
  91                            </div>
  92                         </div>
  93                      </div>
  94
  95                      <!--
  96 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  97          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  98          xmlns:dc="http://purl.org/dc/elements/1.1/">
  99 <rdf:Description
 100     rdf:about="http://defaria.com/blogs/Status/archives/cat_tellabs.html#entry-000747"
 101     trackback:ping="http://defaria.com/mt/mt-tb.cgi/111"
 102     dc:title="rlwrap and sqlplus"
 103     dc:identifier="http://defaria.com/blogs/Status/archives/cat_tellabs.html#entry-000747"
 104     dc:subject="Tellabs"
 105     dc:description="As you know I&apos;m a fan of the CLI in many (but not all) instances, especially ones who are engineered to work well for CLI&apos;ers. I prefer mysql over Oracle and sqlplus over the heavy handed SQL Developer. The SQL..."
 106     dc:creator=""
 107     dc:date="2011-07-14T01:25:34-06:00" />
 108 </rdf:RDF>
 109 -->
 110
 111
 112                      <h2 class="date-header">July 14, 2011</h2>
 113                      <a id="a000747"></a>
 114                      <div class="entry" id="entry-747">
 115                         <h3 class="entry-header">rlwrap and sqlplus</h3>
 116                         <div class="entry-content">
 117                            <div class="entry-body">
 118                               <p>As you know I'm a fan of the CLI in many (but not all) instances, especially ones who are engineered to work well for CLI'ers. I prefer mysql over Oracle and sqlplus over the heavy handed SQL Developer. The SQL Developer weighs in at over 181 Meg and while it has a nice GUI and extensive set of trees and widgets to explore every innard of Oracle's SQL implementation it's slow, slow, slow to load and run and ended up taking > 250 Meg of my memory when running. Suffice it say it was not very workable and definitely overkill for the simple selects and the like that I wanted to do.</p>
 119
 120 <p>Oracle's sqlplus weighs in at 700K or so, is light and quick to load and quick to execute commands. However it has a horrid CLI interface, not history, no re-editing of previous commands, etc. I'm surprised that backspace works honestly. However I could not continue to have SQL Developer bogging down my system and get any meaningful work done. My problems were twofold: 1) how to connect to the database (Oracle makes this so hard) and 2) how to improve on sqlplus' horrid CLI.</p>
 121
 122 <p>We actually have sqlplus at /data/tools/OraInstantClient_10_2 but when I run it it prompts for username and password then complains "ORA-12162: TNS:net service name is incorrectly specified". Trying sqlplus <username>/<password>@<SID> was no better. I have no clue what's defined in tsnnames.ora on the server and can't even log into it to check if there's one at all. I've always detested Oracles tsnnames.ora approach anyway. Finally I figured out the following will work:</p>
 123
 124 <div class=code>
 125 $ &lt;path_to&gt;/sqlplus -L &lt;username&gt;/&lt;password&gt;@&lt;server&gt;/&lt;sid&gt;<br>
 126 $ # or<br>
 127 $ /data/tools/OraInstantClient_10_2/sqlplus qcread/******@pdbgen02/pettd1p<br>
 128 </div>
 129
 130 <p>However it still has a crummy CLI so it's rlwrap to the rescue! rlwrap is a little program that wraps a CLI with ReadLine giving you most of ReadLine's functionality. So now I have a simple alias of:</p>
 131
 132 <div class=code>
 133 alias sqlplus='rlwrap /data/tools/OraInstantClient_10_2/sqlplus -L &lt;username&gt;/&lt;password&gt;@&lt;server&gt;/&lt;sid&gt;'
 134 </div>
 135
 136                               <p class="entry-footer">
 137                                  <span class="post-footers">Posted by  at  1:25 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000747.html">Permalink</a>
 138
 139                                  | <a href="http://defaria.com/blogs/Status/archives/000747.html#trackback">TrackBacks (0)</a>
 140                               </p>
 141                            </div>
 142                         </div>
 143                      </div>
 144
 145                   </div>
 146                </div>
 147             </div>
 148          </div>
 149       </div>
 150    </div>
 151 </body>
 152 </html>