Get Database Service Names

Shell Programming and Scripting
1

Hi Everyone,

I want to know which database (Oracle,SQL,Informix...) are installed on Unix Machine.
I have very limited experience on Unix Environment, :confused: 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

2

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

3

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..) ?

4

use ps command for that

5

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

6

Thank You guys...!!!