Re: Find out the name of Oracle DB on a solaris server?

lazyboy_2k_at_yahoo.com wrote:
> Hi,
>
> Is there a way to find out how many oracle db & their names on a
> solaris server? I run ps -ef |grep ora, however the output is too
> broad & I'd like to narrow it down. Any helps are appreciated.
>
> TIA,
> -Chris

Don't forget, not every db may be up. Look for oratab (perhaps somewhere under /opt or /etc). Look in directories that have an SID listed for other SID's. Look for similar directory structures, for example, if you have /u02/oradata/PROD, see if there is /u*/oradata/*. Look for oracle homes, and directories named dbs under them. Look for files named [si]*ora and lk*. Look everywhere (including client systems) for tnsnames.ora.

There's a lot of creativity out there, unfortunately, not to mention sloppiness.

jg

--
@home.com is bogus.
"Oracle apparently won an ugly contest." - Pete Lindstrom