Re: Can't edit in sqlplus

EDITOR=`which vi`

perhaps it's set in a system-wide profile on the other node, which doesn't
exist on this one.

Stefan

On 11/10/06, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:

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

Other related posts: