2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content="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...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>rlwrap and sqlplus - 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/2011/07/rlwrap-and-sqlp-1.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/2010/09/ucm-compositeco.html" title="UCM Composite/Component">
20 <link rel="next" href="http://defaria.com/blogs/Status/2011/10/remote-editing.html" title="Remote Editing">
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="rlwrap and sqlplus">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2011/07/rlwrap-and-sqlp-1.html">
26 <meta property="og:description" content="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...">
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="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...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2011/07/rlwrap-and-sqlp-1.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">rlwrap and sqlplus</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1968" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">rlwrap and sqlplus</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2011-07-14T01:25:34-08:00" itemprop="datePublished">July 14, 2011</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/tellabs/">Tellabs</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
84 <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>
86 <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>
88 <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>
91 $ <path_to>/sqlplus -L <username>/<password>@<server>/<sid><br>
93 $ /data/tools/OraInstantClient_10_2/sqlplus qcread/******@pdbgen02/pettd1p<br>
96 <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>
99 alias sqlplus='rlwrap /data/tools/OraInstantClient_10_2/sqlplus -L <username>/<password>@<server>/<sid>'
103 <nav class="page-navigation entry-navigation pagination content-nav">
104 <ul class="page-navigation-list">
106 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2010/09/ucm-compositeco.html" title="UCM Composite/Component">Previous entry</a></li>
109 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2011/10/remote-editing.html" title="Remote Editing">Next entry</a></li>
114 <aside id="zenback" class="zenback feedback">
115 Please paste Zenback script code here.
122 <aside class="widgets related" role="complementary">
123 <nav class="widget-search widget">
124 <div class="widget-content">
125 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
127 <input type="text" name="search" value="" placeholder="Search...">
129 <input type="hidden" name="IncludeBlogs" value="8">
131 <input type="hidden" name="limit" value="20">
132 <button type="submit" name="button">
133 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
139 <nav class="widget-archive-category widget">
140 <h3 class="widget-header">Categories</h3>
141 <div class="widget-content">
144 <ul class="widget-list">
147 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
155 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
163 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
171 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
247 <nav class="widget-archive-dropdown widget">
248 <h3 class="widget-header">Archives</h3>
249 <div class="widget-content">
251 <option>Select a Month...</option>
253 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
257 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
261 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
265 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
269 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
273 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
277 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
281 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
285 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
289 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
293 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
297 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
301 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
305 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
309 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
313 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
317 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
321 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
325 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
329 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
333 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
337 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
341 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
345 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
349 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
353 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
357 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
361 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
365 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
369 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
373 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
377 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
381 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
385 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
389 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
401 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
405 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
409 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
413 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
417 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
421 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
425 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
429 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
433 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
445 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
449 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
453 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
457 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
461 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
465 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
469 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
473 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
477 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
493 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
497 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
501 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
505 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
509 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
513 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
517 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
521 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
525 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
533 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
537 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
545 <div class="widget-syndication widget section">
546 <div class="widget-content">
547 <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>
555 <footer id="footer" role="contentinfo">
556 <div id="footer-inner">
557 <div id="footer-content">
558 <nav role="navigation">
560 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
566 <p class="license">© Copyright 2016.</p>
567 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
573 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
574 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>