Can't edit in sqlplus
- From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Nov 2006 07:50:02 -0700
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:
