Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't edit in sqlplus

Re: Can't edit in sqlplus

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 10 Nov 2006 15:55:12 +0100
Message-ID: <486b2b610611100655y49d9f294ldd7f532ec8f5cd53@mail.gmail.com>


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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 10 2006 - 08:55:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US