OraFAQ Forum: Server Administration » hunting for rogue installations

Home » RDBMS Server » Server Administration » hunting for rogue installations - how can i tell if oracle is installed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

hunting for rogue installations - how can i tell if oracle is installed [message #117688]

Thu, 28 April 2005 18:24

ca133799
Messages: 1
Registered: April 2005

Junior Member

I am Solaris system administrator.
An Oracle DBA came to me with assignment to identify rogue (non-standard, non-approved, etc) installations of oracle on many servers. He suggested using:
find / -local -name dbhome -exec ls -la {} \;

This would file files named dbhome for sure. However, is that foolproof? I'm suspicious enough to think that someone wanting to disguise an installation might be able to get around that naming convention.

Are there some other telltale fingerprints to look for?

I should add, we're looking for oracle having been installed, not necessarily running.
thanks,
joe

Report message to a moderator

Re: hunting for rogue installations - how can i tell if oracle is installed [message #117761 is a reply to message #117688]

Fri, 29 April 2005 08:36

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Your procedure will work fine for database-type installations.

You may also want to check for some of the other files normally found in a typical $ORACLE_HOME/bin directory.

Another approach would be to just check what ORACLE_HOMES are listed in your machine's "oratab" file.

Best regards.

Frank

Report message to a moderator

Re: hunting for rogue installations - how can i tell if oracle is installed [message #117940 is a reply to message #117761]

Sun, 01 May 2005 22:24

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

If you try a -
ps -ef | grep ora

That should identify any oracle processes running - unless someone's done some serious renaming to avoid detection.

Dougie

Report message to a moderator

Re: hunting for rogue installations - how can i tell if oracle is installed [message #118097 is a reply to message #117940]

Tue, 03 May 2005 01:17

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

If you try a -
ps -ef | grep ora

That should identify any oracle processes running - unless someone's done some serious renaming to avoid detection.

Dougie

This will work only if oracle instance is running at that time. It wont detect those installations which are not having a running instance at the time of check.

Report message to a moderator

Previous Topic:	ORA-00018
Next Topic:	Error in SYS.OLAPIHISTORYRETENTION procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 04:47:05 CST 2025