Re: Oracle and UNIX integration...

From: <nomorekiss_at_yahoo.com>
Date: 7 Feb 2005 03:01:32 -0800
Message-ID: <1107774092.410311.98660@z14g2000cwz.googlegroups.com>

>How could I get informations about Oracle process in a >Solaris system
?

Just substitute "nw9i" in my command with your ORACLE_SID:

bash-2.05$ ps -ef | grep nw9i

   ora9i 18385     1  0   Jan 17 ?        0:32 ora_smon_nw9i
   ora9i 18377     1  0   Jan 17 ?        0:00 ora_pmon_nw9i
   ora9i 18383     1  0   Jan 17 ?        0:01 ora_ckpt_nw9i
   ora9i 18391     1  0   Jan 17 ?        0:00 ora_qmn0_nw9i
   ora9i 18379     1  0   Jan 17 ?        0:01 ora_dbw0_nw9i
   ora9i 18381     1  0   Jan 17 ?        0:02 ora_lgwr_nw9i
   ora9i 18389     1  0   Jan 17 ?        0:00 ora_cjq0_nw9i
   ora9i 18387     1  0   Jan 17 ?        0:00 ora_reco_nw9i
   ora9i  8769     1  0 11:55:08 ?        0:00 oraclenw9i (LOCAL=NO)

>How (from UNIX) could I get Oracle application´s >username ?

In the first column of the printout above you can see unix account name (ora9i). This is the owner of Oracle database software. Received on Mon Feb 07 2005 - 05:01:32 CST