RE: Can't edit in sqlplus

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Fri, 10 Nov 2006 09:54:54 -0500
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663B7FE@ENYC11P32005.corpny.csfb.com>

Sandy,

Define a SQL*Plus variable _EDITOR to point to the editor you want

> define _EDITOR="/usr/local/bin/emacs"

(or whatever)

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sandra Becker Sent: Friday, November 10, 2006 9:50 AM
To: oracle-l
Subject: Can't edit in sqlplus

I'm moving my production database to a new node. In the process I need to make a lots of changes and test everything. One of the problems I've encountered is editing while in sqlplus. I copied my .bash_profile and .bashrc files from the current production node and made the appropriate changes since I made the ORACLE_HOME a more generic name. (was 9.2.0.4.0, made it 920)

I'm using RHEL4, Oracle 9.2.0.8 <http://9.2.0.8> .

I key in my query and after I get the results I want to change something in the query so I type in edit. What I get back is the following:

Wrote file /u01/app/oracle/product/920/rdbms/admin/afiedt.buf 277

I have to use ctrl+d to get out of it. I'm sure it's just an environment setting that I've missed, but the same environment works on the current production node. Following are my environment settings. Does anyone have an idea what I need to change?

G_BROKEN_FILENAMES=1
HISTFILE=/home/oracle/.history/.hist8642 HISTSIZE=1000
HOME=/home/oracle
HOSTNAME= newhost.company.com <http://newhost.company.com> INPUTRC=/etc/inputrc
LANG=C
LD_ASSUME_KERNEL= 2.4.1
LD_LIBRARY_PATH=/u01/app/oracle/product/920/lib:/lib:/usr/lib LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/920
ORACLE_PATH=/u01/app/oracle/product/920/rdbms/admin:/home/oracle

ORACLE_SID=prdruby
ORA_NLS33=/u01/app/oracle/product/920/ocommon/nls/admin/data PATH=/home/oracle:/u01/app/oracle/product/920/bin:/u01/oracle/product/920/rdbms/admin:.:/home/oracle:/u01/app/oracle/product/920/bin:/u01/app/oracle/product/920/rdbms/admin:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/home/oracle/bin/OPatch PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SQL_PATH=/u01/app/oracle/product/920/bin SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass TERM=xterm
USER=oracle
_=/bin/env

This isn't critical, just annoying and a pain. I don't want to script every little query.

Thanks.

Sandy

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 10 2006 - 08:54:54 CST