Shell Programming and Scripting

Hi Everyone,

I want to know which database (Oracle,SQL,Informix...) are installed on Unix Machine.
I have very limited experience on Unix Environment, So I have no idea of getting this information. But in windows we can get Service names using WMI. Is there any similar way of Doing so?

I would like to know the command which can list the running processes from which i can recognize the processes belonging to database.

Thank You in Advance

Roshan

there can be more than one database installed on the machine.

generally, you are able to see the environment variable exported in your env.

e.g for oracle
for sybase
etc etc..

you can also use find utility to search for any database utility
like.. sqlplus, isql, mysql, tsql, bcp .....

Thank You for your help ...
Also, Is it good way to list running processes and Filter processes related to Db(s) (Provided we have list of predefined process names for Diff. Database like oracle,SQL..) ?

use ps command for that

Depending on your Unix flavour, you might want to check commands like
top, prstat etc and then grep for "oracle|sybase|informix"


cheers,
Devaraj Takhellambam

Thank You guys...!!!