Re: ps -ef |grep ora HELP!!

Scott Urman (surman_at_oracle.com) wrote:

[snip]

: These are Oracle shadow processes, started when a user process connects to
: the database. The DESCRIPTION means that these are connections using SQL*Net
: version 2, specificly the V2 bequeath adapter (the PROTOCOL part). This is
: the default adapter when you are connecting to a database on the same
: machine as your program. Try connecting with a connect string of 'p:' which
: will use the V1 pipe driver instead, and see what the process list says.
: --

Hmmm, I wonder if you could elaborate on the V1/V2 aspect. Are you saying the unix pipe driver is using V1 sqlnet? Example, here's the process that gets started when I use sqlplus on the same machine that has the instance:
  oracle 8828 8827 31 08:12:39 ? 0:00 oracleCMP P:4096,8,11,

Is this using V1? How can I make it use V2 ( and MTS )? Change the entry in the PROTOCOL part of TNSNAMES.ORA, LISTENER.ORA ??

Thanks,
Tony Damon Received on Mon Apr 01 1996 - 00:00:00 CEST