Re: ps -ef |grep ora HELP!!

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