Can't edit in sqlplus

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 10 Nov 2006 07:50:02 -0700
Message-ID: <3c5f7820611100650w23542be5s293ce718ccc98770@mail.gmail.com>

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.

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
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

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

Received on Fri Nov 10 2006 - 08:50:02 CST