Arrow Key Does Not Show Command History When Using SQL*Plus (Doc ID 567215.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version 10.1.0.2 and later
Linux x86

Symptoms

The command line history (that is, the arrow keys UP/DOWN to see past commands) does not work when running SQL*Plus on UNIX. 

For example:

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 7 16:35:01 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>
SQL> select * from v$instance;
...
SQL> ^[[A <--- this is what appears when you press UP-arrow within SQL*Plus


Instead of seeing the past commands, you get junk characters when using UP or DOWN arrow.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms