Since sqlplus is not built against readline library, rlwrap is just doing the job. Rpm resource rlwrap rlwrap is a readline wrapper that uses the gnu readline library to allow the editing of keyboard input for any other command. Mar 06, 20 when it was finished, i had a nice sqlplus. Apr 26, 2010 this way, every time you call sqlplus in the future, you will keep a really useful history of your commands for future reference. Jun 15, 2016 create an alias in your bashrc for sqlplus. To log in as the root user, complete one of the following procedures. I find this tool very useful, for example for correcting mistyped commands.
Download the latest rlwrap software from the following url. Here some basic examples how you can use the utility. On solaris, rlwrap can be installed with the sunfreeware package whereas on linux, the easiest way is to compile it on the specific host as described in this section. May 03, 2011 sqlplus command line history doskey functionality in sqlplus on linux platform sqlplus history sql doskey like old days on dos sqlplus.
Aug 09, 2009 sqlplus command line history completion. By following users and tags, you can catch up information on. Rlwrap utility for sqlplus and rman mursel bakay oracle blog. Install rlwrap to enable command line history with sqlplus. Now create alias so that alias will execute rlwrap with sqlplus and rman as an argument. Oracle 11g instalation on solaris 11 express experiences. Since i often work on prod and dev databases at the same time, it is important to me that i know where i am when i am executing disastrous sql well, rlwrap to the rescue. Jun 14, 2015 how to install rlwrap on linux rlwrap is an utility that allows you to use up and down arrows like in dos environment.
Oracle database didnt have contain sqlplus history before release 12. Launch sqlplus with rlwrap i sqlplus or add alias sqlplus rlwrap i sqlplus to your shell dot file. Oraclebase rlwrap for command line history and editing in. The remainder of this guide discusses how to download, compile, install, and. Youll need to do three small things, and you are good to go, add an alias. Personnaly i do alias qrlwrap sqlplus so that i can always use sqlplus to run important script, and keep rlwrap for notproductive stuff. How to install rlwrap on linux james huang databases.
Other versions of the linux os can also be used for this obe, namely. May 27, 2011 here is the oracles installation of solaris 11 download oracle 11g dowload oracle11g from oracle webiste for sparc file1 file2 for x86 file1 file2 before installing oracle 1. Of course the correct installation is from official packages like above download instant client downloads, but you can get a full working sqlplus just by copying these files you can found it in any computer with oracle client installed, and some msb are optitional. Sep 17, 2007 alias sqlplusrlwrap sqlplus this will make sure that every time you login and run sqlplus, rlwrap captures all sqlplus commands which you can just recall with updown arrow key. Making up arrow key work for sqlplus, rman, dgmgrl, adrci. Installing rlwrap on linux saves you time oracle in the field. Install rlwrap to enable command line history with sqlplus and rman. Centos install rlwrap for oracle sqlplus mysql and sql. Another useful trick is to alias the wrapped version of sqlplus so you dont have to type rlwrap sqlplus every time. I dont recommend using alias sqlplusrlwrap sqlplus, because rlwrap doesnt allow to execute commands in a interactive way.
Apr 05, 2015 rlwrap is an utility that allows you to use up and down arrows like in dos environment. This readline wrapper is able to call programs that are deficient in modern amenities like history, color, and tab completion, intercept inputoutput, and replace it as necessary with useful goodies. Sep, 2016 it is nice to have up arrow key working in sqlplus, rman, dgmgrl, adrci. Configuring sqlplus to use history thinkingmonster. How to install rlwrap on linux rlwrap is an utility that allows you to use up and down arrows like in dos environment. The install document is pretty straightforward for compiling and installing it.
I guess its best to leave the sqlplus and rman commands clean and alias using a. How to get commandline history in sqlplus with rlwrap. May 30, 20 rlwrap is a wrapper that uses the gnu readline library to allow the editing of keyboard input for any other command. Run the following commands, or better still append then to the. Launch sqlplus with rlwrap i sqlplus or add alias sqlplusrlwrap i sqlplus to your shell dot file. It adds readline support to sqlplus, allowing you to use the cursor keys to navigate to previous queries it retains a history, and edit them when youve made a mistake.
Download the packages from the oracle technology network otn copy the same files that are in the packages from an oracle database 10 g client administrator installation both the sqlplus and oci packages must be from the same oracle database version, for example. Command line history in sql for linux an oracle blog. Install the package rlwrap verify the rlwrap package function. And what program could be more deficient than sqlplus sorry. How to make sqlplus more pleasant with rlwrap and a nice. Its always been frustrating to me that sqlplus does not have repl behavior, so you cant arrow through your history, etc. From what i can see the alias doesnt seem to work from within a shell script bash, ksh. Sqlplus instant client can be installed in two ways.
Sqlplus starts and connects to the default database. Sqlplus users working on linux platforms have the opportunity to use a readline wrapper rlwrap. The rlwrap software installs easily on unixlinux with these standard gnu unzip and make commands. This oraclebyexample obe tutorial covers installing oracle goldengate version 12. Include it on profile so that this alias will be executed for all the users. In the uncharted backwaters of the internet there exists a really awesome tool called rlwrap.
As johnny suggested, you can install the rlwrap utility to manage command history for any other command, including sqlplus. Rlwrap in sqlplus to keep a command history oracle dba tips. Input history is kept between invocations, separately for each command. This is a really handy addition to sqlplus and rman on linux. For oracle commands like sqlplus, rman, adrci, we can do the same as in dos environment to choose one of the history command instead of type the same command again. The remainder of this guide discusses how to download, compile, install, and configure the rlwrap tool for use with oracles sqlplus and rman commandline utilities. Before you install the oracle software, you must complete several tasks as the root user. After installing the package rlwrap, we can use it via the command rlwrap. It is very much irritating for linux guys who are in the habit of using upward arrow on terminal to go through the commands typed previously and when they use sqlplus utility, history does not works.
You can download the freeware rlwrap utility at this link. For oracle commands like sqlplus, rman, adrci, we can do the same as in dos environment to choose one of the. It means that with the help of rlwrap we are able not only to edit commandline but also to do a search through previous commands and to use words completion during. The text widget allows you to add text or html to your sidebar. Aug 31, 2015 now create alias so that alias will execute rlwrap with sqlplus and rman as an argument. How to install oracle sqlplus and oracle client in mac os. It is nice to have up arrow key working in sqlplus, rman, dgmgrl, adrci. Enable sql plus up and down arrow keys step by step. Download rlwrap download the rlwrap archive here, and extract it to a temporary directory. Open a unix or a windows terminal and enter the sqlplus command. In addition, the default sql prompt is not very informative.
This utilitys benefit is you can work with sqlplus andor rman prompts history, and you win time that is very important for dbas. With rlwrap you can instantly have history in sqlplus by pressing the up key. Input history is remembered across invocations, separately for each command. The rlwrap readline wrapper utility provides a command history and editing of keyboard input for any other command.
Because the rlwrap readlinewrapper utility is very useful for oracle dbas who administrate database on linuxunix systems. You can use a text widget to display text, links, images, html, or a combination of these. After downloading to the server, i just had to do an rpm install. This way, every time you call sqlplus in the future, you will keep a really useful history of your commands for future reference. To automate the use of rlwrap, add the following line in your. The readline wrapper rlwrap utility uses the gnu readline library.
Now you can start entering and executing sql, plsql and sqlplus statements and commands at the sql prompt. How to make sqlplus more pleasant with rlwrap and a nice prompt. Add history and tab completion to sqlplus oracle alchemist. The final thing you need to do is tell your system to use rlwrap whenever you use sqlplus. I dont recommend using alias sqlplus rlwrap sqlplus, because rlwrap doesnt allow to execute commands in a interactive way. Hence, rlwrap is not oraclecentric, its a standard os utility available for all flavors of unix, linux and even windows. We can fire up rlwrap again, this time with the i flag which tells rlwrap to ignore case for tab complete, and the f flag which tells it where the dictionary file is. This article explains how to save sqlplus commands history on linux within the package rlwrap readline wapper. From what i can see the alias doesnt seem to work from within a shell script bash, ksh or csh, so it doesnt really present a danger. I guess its best to leave the sqlplus and rman commands clean and alias using a different name, just in case. Simple pleasuresrlwrap and sqlplus command line editing on. I hate having to manage a linux system without this. Download and install rlwrap on solaris, rlwrap can be installed with the sunfreeware package whereas on linux, the easiest way is to compile it on the specific host as described in.
Oraclebase rlwrap for command line history and editing. To start sqlplus and connect to a database other than the default. The following commands download and configure the epel repository. Once its installed, you can create an alias using rlwrap, such that itll provide a keyboard wrapper for sqlplus, allowing you to use the arrow keys.