Oracle sqlplus in Linux cannot be used properly.

Source: Internet
Author: User
When Oracle sqlplus is used in linux, the arrow keys do not move the cursor left or right by default, and the commands are up and down. Therefore, if you want to execute the commands that have already been executed

When Oracle sqlplus is used in linux, the arrow keys do not move the cursor left or right by default, and the commands are up and down. Therefore, if you want to execute the commands that have already been executed

When Oracle sqlplus is used in linux, the arrow keys do not move the cursor left or right by default, and the commands are up and down. Therefore, if you want to execute the commands that have already been executed, you should try again or use the CV method of other terminal tools. To modify a command, you only need to use the edit command to call vi or another editor, and then save it to a buffer file (the default file name is afiedt. buf) for execution. In short, it is inconvenient.

Rlwrap, a small tool, is a "readline wrapper" tool. You can use the left and right arrows to move the cursor between the left and right sides of a row, and use the up and down arrows to flip up and down the callback command, very easy to use. I use the 0.24 source code version. Installation and Simplicity:

./Configure

Make

Make install

For other installation situations, such as non-root installation, you can check the readme and install files, which is also very simple. And now there is an rpm version. After installation, add two sentences to the. bash_profile file of the Oracle user:

Alias sqlplus = "rlwrap sqlplus"

Alias rman = "rlwrap rman"

Log on to Oracle again or execute./home/oracle/. bash_profile to make the change take effect. The arrow keys can be used as expected in sqlplus and rman.

Run the "du-sh" command to view the folder size.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.