Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Solve the problem that sqlplus keys and Back Space keys cannot be used.

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

When using Sqlplus, we will find that when we want to delete the wrong words with Back Space, we will find ^ H garbled. There are two ways to solve this problem:

One:

You can delete it by directly using the key combination of Ctrl+Back Space

Two:

Add: stty erase'^ H' to the. bash_profile file under the root user

Then use cource .bash _ profile to take effect again.

When using Sqlplus, it can be a headache if you want to scroll through the code up and down and the left and right keys are not available.

Here is how to solve the problem that the left and right keys are not available:

One: install readline (available on the readline package installation CD)

[root@db1 ~] # yum-y install readline*

Two: install rlwrap

Download the rlwrap installation package http://rpmfind.net/linux/rpm2html/search.php?query=rlwrap on the official website

Unzip the installation:

[root@db1 rlwrap] # tar-xvf rlwrap-0.42.tar.gz

[root@db1 rlwrap] # cd rlwrap-0.42

[root@db1 rlwrap-0.42] #. / configure

[root@db1 rlwrap-0.42] # make & & make install

Three: easy to use rlwrap

[root@db1 rlwrap-0.42] # vi / home/oracle/.bash_profile add the following two sentences

Alias sqlplus='rlwrap sqlplus'

Alias rman='rlwrap rman'

[root@db1 rlwrap-0.42] # soruce / home/oracle/.bash_profile give him effect

Switch to the oracle user and execute sqlplus to be ready for normal use.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database