Re: HELP: Looking for Oracle 7 SQL*DBA XTERM resource files

From: Marcus Collins <ccmr_at_cplan109.ion.chevron.com>
Date: 26 Aug 94 14:58:36 GMT
Message-ID: <1994Aug26.145836.29504_at_london.chevron.com>


In article <mmaroldaCv3yC1.5tn_at_netcom.com>, mmarolda_at_netcom.com (Mike Marolda) says:
>
>In article <777740266snz_at_istellar.demon.co.uk>,
>Alligator Descartes <descarte_at_istellar.demon.co.uk> wrote:
>>The subject says it all really. I'll be damned if I can track down the
>>files SQL*DBA needs to allow me to use an xterm.
>>
>>If anyone can help, please let me know.
>>
>>Thanks in advance.
>>
>
>What? It's not intuitively obvious? ;-)
>
>Here's what I've done:
>
>1) make sure your ORAKITPATH environment variable is being set in your
>appropriate login script to:
>
>$ORACLE_HOME/guicommon/tk2/admin/terminal:$ORACLE_HOME/rdbms/admin/terminal
>
>2) start an xterm with the sun function keys enabled:
>xterm -sf -T Sqldba -n Sqldba -ls &
>
>3) set your TERM environment variable to sun or xsun (both work, but
>xsun seems to work better). You don't want this to be the case
>generally because then nothing else (like vi) will work. That's why I
>also set the xterm window and icon titles to Sqldba.
>

There seems to be files missing in the orakit directory, I'm running 7.0.16 on HP-UX. What I do rather than setting the $TERM env var is set the ORACLE_TERM one instead. That way it will not affect vi etc. Try the following piece of code in your .login (its csh). Add a sun clause if its appropriate.

  switch ($TERM)
    case xterm :

      setenv ORACLE_TERM vt100
      breaksw
    case hpterm :
      setenv ORACLE_TERM hp
      breaksw
    default :
      setenv ORACLE_TERM vt100
      breaksw

  endsw
--
 Marcus Collins                        Internet: eccmr_at_aberdeen.chevron.com
 Database Analyst.                   MS-Mail: CCMR
 Chevron (UK) Ltd.                    Phone: +44 224 242690. CTN 677-2690.
 Ninian House, Crawpeel Road, Altens, Aberdeen AB1 4LG.

         _/        _/   _/_/_/_/    _/_/_/_/
        _/_/ _/_/   _/             _/
       _/ _/_/_/   _/            _/
      _/  _/ _/   _/            _/
     _/     _/   _/            _/
    _/     _/   _/_/_/_/  _/_/_/_/
Received on Fri Aug 26 1994 - 16:58:36 CEST

Original text of this message