在Linux下使用sqlplus或者rman时,经常需要调用上次或之前运行过的命令
SQL>
RMAN>
实现步骤:
1、安装名为rlwrap的对应版本的安装包(Linux 6 对应 rlwrap-0.37 版本)
- [root@C01TEST03 tmp]# rpm -ivh rlwrap-0.37-2.1.x86_64.rpm
- warning: rlwrap-0.37-2.1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 3dbdc284: NOKEY
- Preparing... ########################################### [100%]
- package rlwrap-0.37-2.1.x86_64 is already installed
2、配置
(1)在sqlplus、RMAN命令之前直接加上rlwrap
- oracle@C01TEST03:/home/oracle>rlwrap sqlplus / as sysdba
-
- SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 1 11:14:06 2016
-
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
-
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
- SQL>
(2) 在oracle账号的配置文件中加入别名
- oracle@C01TEST03:/home/oracle>vi .bash_profile
-
- alias sqlplus='rlwrap sqlplus'
- alias rman='rlwrap rman'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30776559/viewspace-2123085/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30776559/viewspace-2123085/