Re: ps -ef |grep ora HELP!!

Hugo Toledo, Jr. wrote:
>
> Sridhar Pandari wrote:
> >
> > We are running oracle 7.2.2 on HP/UX 10.01. When I grep for oracle processes
> > using ps -ef |grep ora command, I get the following:
> >
> > cs 916 846 0 21:45:51 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > cs 29362 1 0 21:40:19 ? 0:01 ora_smon_dcs8
> > slg 9613 9612 0 11:03:50 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > cs 937 868 0 21:45:52 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > cs 29344 1 0 21:40:17 ? 0:14 ora_lgwr_dcs8
> > cs 29259 1 0 21:40:13 ? 0:08 ora_pmon_dcs8
> > cs 29298 1 0 21:40:15 ? 0:23 ora_dbwr_dcs8
> >
> > My question is, Why is it showing the (DESCRIPTION part? Moreover, what is
> > protocol beq? Never heard of it before.
> >
> > Can anyone help?
> >
> > Sridhar Pandari
> > --
>
> Check your databases alert log in ORACLE_HOME/rdbms/log. I generally only
> see this when the database has or is aborting or when I am attempting to
> reach an unresolvable service name (right before I get the TNS error).
>
> Why do you typically not see this message? Because when you are using the
> internal listener (that is, the one not going across the network) you are
> generally not grepping for it.
>
> When I last got this (actually about three hours ago) it was because I
> had a SQLDBA session crash on me. The database crashed (or had already
> crashed) and what remained was evidence of the IPC listener.
>
> A similar problem occurs when you attempt to reach a remote database but
> cannot due to the inability to resolve the connect string. Unless you
> have disable IPC in SQLNET.ORA it will automatically launch to try to
> connect to the local DB. (This happens in Windows when PO7 has not been
> launched but an attempt to go outside of the box fails.)
>
> Hope this helps.
> --
> Hugo Toledo, Jr. Author of "Oracle Networking" from Oracle Press
> 312.951.8012 Oracle WebSystem - Oracle Mobile Agents
> mailto:hugo_at_mcs.com Oracle Power Objects - Windows - Unix - C
> http://www.mcs.com/~hugo/oracle.html CompuServe: 72700,1705

Running Oracle 7.2.1 under HP-UX 9, I get the same processes as mentioned above, but as far as I know, it's normal. From the Oracle manuals I have concluded that these are the processes of a dedicated server (dedicated to the single process of the user who logged on to Oracle).

Roald.

-- 

+-------------------------------------------------------+
| R.A. van Geleuken                     roald_at_xs4all.nl |
+-------------------------------------------------------+
| There's no such thing as impossibility, only          |
| extremely low chance                                  |
+-------------------------------------------------------+