Re: some process flooding oracle's .sh_history file

On Jul 31, 4:33 pm, EdStevens <quetico_...@xxxxxxxxx> wrote:
On Jul 31, 2:39 pm, sybra...@xxxxxxxxx wrote:



On Tue, 31 Jul 2007 11:02:36 -0700, EdStevens <quetico_...@xxxxxxxxx>
wrote:

Platform: Oracle 10.2.0.2.0 on HP-UX B.11.11

This began just recently. While logged on to the sever with the
'oracle' account, I noticed my command line history returning a bunch
of stuff I hadn't entered. This is a very small shop, so I have a
pretty good feel for when someone else may be logged on, and the
commands in the history didn't look like anything any of us would have
entered at the command line.

Looking into oracle's .sh_history file, I found scores of entries like
this:

2 echo Start Command;LC_ALL=C;export LC_ALL;netstat -i; echo Finish
Command
3 echo Start Command; LC_ALL=C;export LC_ALL;/etc/swapinfo -t | grep
total;echo Finish Command

( I've left the vi line numbers, to deliniate individual records.)

Looks like something the dbcontrol agent would be doing to gather
stats, but if so, I've never seen it show up in the .sh_history file
before.

Anyone seen anything like this, or have and educated idea?

You could of course have
HISTFILE=<any filename>$$
in your profile.

--
Sybrand Bakker
Senior Oracle DBA

Yes, but I'd like to find out where this history is coming from, not
simply how to dodge it.

You could set your HISTFILE variable to something like...

export HISTFILE=`echo $(who am i) | cut -f2 -d\( | cut -f1 -d\)`

which would set it to the remote machine from which the user has
logged in.

HTH,

Steve





.

Relevant Pages

  • Re: some process flooding oracles .sh_history file
    ... commands in the history didn't look like anything any of us would have ... entered at the command line. ... Senior Oracle DBA ... slow enough to grab a transient process like that. ...
    (comp.databases.oracle.server)
  • Re: Need ideas: automating history dump
    ... > shell's history once a day, or whenever the shell exits normally ... zsh sessions will all have their history lists added to the ... history file, in the order they are killed. ... command line, setting this option will cause the oldest history ...
    (comp.unix.shell)
  • [TOOL] ComLog.pl, a WIN32 Command Prompt Logger
    ... administrator to keep a history of commands typed in the DOS command ... prompt and the associated output, for example on an IIS server. ... # This program captures the input/output of the Windows NT Command Promt ... sub getcurrentdrive ...
    (Securiteam)
  • Release : ComLog 1.0, a WIN32 command prompt logger
    ... a WIN32 command prompt logger ... DOS sessions on Windows NT/2K (should also work on XP, ... This tool can be used by administrator to keep a history of commands ... typed in the DOS command prompt and the associated output, ...
    (Focus-IDS)
  • [Full-Disclosure] Release : ComLog 1.0, a WIN32 command prompt logger
    ... a WIN32 command prompt logger ... DOS sessions on Windows NT/2K (should also work on XP, ... This tool can be used by administrator to keep a history of commands ... typed in the DOS command prompt and the associated output, ...
    (Full-Disclosure)