RE: Connection question?

[Hallas John]

Title: RE: Connection question?





Harry,
I am not sure that BEQ connections use the standard listener at all. In fact on VMS systems you cannot make an internal connection if the bequeath listener is not started (BEQLSNR START|STOP|STATUS). Once you start that listener then you can connect internal even if the normal listener LSNRCTL START|STOP|STATUS) is not running.

I think you are probably correct in what you say but the term listener is used slightly inaccurately.


John 


-Original Message-
From: Lowes, Harry (NESL-IT)
[mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:31
To: Multiple recipients of list ORACLE-L
Subject: RE: Connection question?



Afternoon Lisa,
 
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
 




Thanks, 


Harry Lowes 
Database Administrator, 
npower Northern Limited 
mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>  


 


-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L




Hi Deepak 


Here's what the doco says 


The Bequeath protocol  enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally. 


Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine 


Tell me if I'm wrong but here's my take on it:  When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server.  Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.  


Am I wrong?  If so let me know. 


    -Original Message- 
Sent:   Tuesday, November 27, 2001 5:25 PM 
To: Multiple recipients of list ORACLE-L 


    hey lisa 


    Thats what i was temted to reply as well {lol} .. but 
if you look closely .. both her conn are bequeth .. i 
was under the impression that bequeth was used only 
for local and not remote .. thats why we chose beq 
over tcp for db's that resided in same box for 
performance reasons .. or so i thought until now ;) 


    thoughts ..? 


    Thx 
Deepak 
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: 
> One is LOCAL=YES and one is LOCAL=NO 
> 
> One is Local, one isn't. 
> 
> Lisa Koivu 
> Oracle Database Monkey 
> Fairfield Resorts, Inc. 
> 954-935-4117 
> 
> 
> > -Original Message- 
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, November 27, 2001 1:05 PM 
> > To: Multiple recipients of list ORACLE-L 
> > Subject:    Connection question? 
> > 
> > Hi 
> > WHen I execute ps -ef |grep LOCAL on Solaris 
> server the following output i 
> > 
> > see in 
> > 
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 
> > What is the diffrence between 1 and 2. 
> > 
> > Thanks 
> > Seema 
> > 
> > 
> 
_ 
> > Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp <http://explorer.msn.com/intl.asp>  
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: 
> http://www.orafaq.com <http://www.orafaq.com>  
> > -- 
> > Author: Seema Singh 
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services    -- (858) 538-5051 
> FAX: (858) 538-5051 
> > San Diego, California    -- Public Internet 
> access / Mailing Lists 
> > 
> 
 
> > To REMOVE yourself from this mailing list, send an 
> E-Mail message 
> > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB 
> ORACLE-L 
> > (or the name of mailing list you want to be 
> removed from).  You may 
> > also send the HELP command for other information 
> (like subscribing). 
> 



    ___

RE: Connection question?

[Lowes, Harry (NESL-IT)]

Alright Paul,

Not too sure myself (as I said in my post). I know on VMS the bequeath
listener is a job started using the BEQLSNR utility. After a bit of digging
on Metalink, I found Note: 62142.1 that illustrates the bequeath connection
quite well. Looks like it's a direct one-home one-server connection, where
the app spawns it's own server-side process to connect to a db in the same
oracle home. This connection is performed using Unix pipes. The listener
spawns the server-side process for IPC connections, and these communicate
using Unix Domain Sockets. Amazing what you can learn with a little
digging.. ;-)


Thanks,

Harry Lowes
Database Administrator,
npower Northern Limited
Tel: (0191) 210 2278 Fax: (0191) 210 2647
mailto:[EMAIL PROTECTED]


-Original Message-
Sent: 28 November 2001 17:41
To: Multiple recipients of list ORACLE-L


Harry, you say that IPC and BEQ both use the listener to spawn a
server-side process -- but the docs say that BEQ "...enables clients
that exist on the same machine as the server to retrieve information
from the database without using the listener".  

Which is correct?



--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Hi Harry, 
> 
> I admit ignorance.  Networking was never my strong point.  IN fact
> sometimes
> I wonder if I still have one. 
> 
> Thanks for your response. 
> 
> Lisa
> 
> > -Original Message-
> > From:   Lowes, Harry (NESL-IT)
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, November 28, 2001 10:31 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Connection question?
> > 
> > Afternoon Lisa,
> >  
> > I thought that BEQ and (for example) IPC protocols both used the
> listener
> > to
> > spawn a server-side process. The difference is in the protocol used
> in the
> > communication between the remote and local processes. IPC uses Unix
> Domain
> > Sockets to communicate between the client-side and server-side
> processes,
> > where BEQ uses Unix pipes. I had assumed that this was why BEQ
> connections
> > had to be local. This is the view expounded in Note: 1014940.6. If
> I've
> > got
> > it wrong, it'd be nice to know. Any comments, Gurus?
> >  
> > 
> > 
> > 
> > Thanks, 
> > 
> > Harry Lowes 
> > Database Administrator, 
> > npower Northern Limited 
> > mailto:[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>  
> > 
> >  


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with
it (if any) are confidential and intended for the addressee only.  If you have
received this e-mail in error please notify the originator or telephone
0191 210 2060 or e-mail [EMAIL PROTECTED]  

This e-mail and any attachments have been scanned for certain 
viruses prior to sending but neither Northern Electric plc nor any of the companies in 
the Northern Electric group of companies from whom this e-mail originates shall be 
liable for any losses as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained in this 
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

Northern Electric plc
Carliol House
Market Street
Newcastle-upon-Tyne
NE1 6NE
Registered in England and Wales: Number 2366942



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lowes, Harry (NESL-IT)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California   

RE: Connection question?

[Todd Carlson]

On my systems, SUN, the Oracle JDBC connections
show up as BEQ local=no OS sessions.

 



Todd



 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Anjan
Thakuria
Sent: Wednesday, November 28, 2001
12:02 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Connection question?

 

But were these not both BEQ one in Caps and the other
in lower case (BEQ and beq) .. 

Anjan 

"Koivu, Lisa" wrote: 



  

Hi Harry,


I admit
ignorance.  Networking was never my strong point.  IN fact sometimes
I wonder if I still have one. 

Thanks for your
response. 

Lisa 

-Original Message-

From:   Lowes, Harry (NESL-IT)
[SMTP:[EMAIL PROTECTED]] 
Sent:   Wednesday, November 28, 2001 10:31 AM

To: Multiple recipients
of list ORACLE-L 
Subject:   
RE:
Connection question? 

Afternoon Lisa, 

I thought that BEQ and (for example) IPC protocols
both used the listener to 
spawn
a server-side process. The difference is in the protocol used in the

communication
between the remote and local processes. IPC uses Unix Domain 
Sockets
to communicate between the client-side and server-side processes,

where
BEQ uses Unix pipes. I had assumed that this was why BEQ connections

had to
be local. This is the view expounded in Note: 1014940.6. If I've got

it
wrong, it'd be nice to know. Any comments, Gurus? 
  
  

Thanks, 

Harry Lowes 
Database
Administrator, 
npower
Northern Limited 
mailto:[EMAIL PROTECTED]

<mailto:[EMAIL PROTECTED]>

  
  

-Original Message- 
Sent:
28 November 2001 14:00 
To:
Multiple recipients of list ORACLE-L 
  

Hi Deepak 

Here's what the doco says 

The Bequeath protocol  enables
clients that exist on the same 
machine
as the server to retrieve information from the database without 
using
the listener. The Bequeath protocol internally spawns a dedicated

server
process for each client applications. In a sense, it does the same

operation
that a remote network listener does for your connection, yet 
locally.


Bequeath is used for local connections where an
Oracle client application, 
such
as SQL*Plus, communicates with an Oracle server running on the same

machine


Tell me if I'm wrong but here's my take on it: 
When I connect from my pc, 
there's
a process on my PC and there's a corresponding process on the 
database,
say on a Unix server.  Though the connection was initiated 
remotely,
the process itself on the db server is still a local process that

exists
to communicate with the database. 

Am I wrong?  If so let me know. 

    -Original
Message- 
Sent:  
Tuesday, November 27, 2001 5:25 PM 
To:
Multiple recipients of list ORACLE-L 

    hey lisa


    Thats what i
was temted to reply as well {lol} .. but 
if you
look closely .. both her conn are bequeth .. i 
was
under the impression that bequeth was used only 
for
local and not remote .. thats why we chose beq 
over
tcp for db's that resided in same box for 
performance
reasons .. or so i thought until now ;) 

    thoughts ..?


    Thx

Deepak

---
"Koivu, Lisa" <[EMAIL PROTECTED]> wrote: 
>
One is LOCAL=YES and one is LOCAL=NO 
>

>
One is Local, one isn't. 
>

>
Lisa Koivu 
>
Oracle Database Monkey 
>
Fairfield Resorts, Inc. 
>
954-935-4117 
>

>

>
> -Original Message- 
>
> From:   Seema Singh
[SMTP:[EMAIL PROTECTED]] 
>
> Sent:   Tuesday, November 27, 2001 1:05
PM 
>
> To: Multiple recipients of list ORACLE-L 
>
> Subject:    Connection question? 
>
> 
>
> Hi 
>
> WHen I execute ps -ef |grep LOCAL on Solaris 
>
server the following output i 
>
> 
>
> see in 
>
> 
>
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 
>
> 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 
>
> What is the diffrence between 1 and 2. 
>
> 
>
> Thanks 
>
> Seema 
>
> 
>
> 
>

_

>
> Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp
<http://explorer.msn.com/intl.asp>

>
> 
>
> -- 
>
> Please see the official ORACLE-L FAQ: 
> http://www.orafaq.com <http://www.orafaq.com>

>
> -- 
>
> Author: Seema Singh 
>
>   INET: [EMAIL PROTECTED] 
>
> 
>
> Fat City Network Services    -- (858) 538-5051

>
FAX: (858) 538-5051 
>
> San Diego, California    -- Public
Internet 
>
access / Mailing Lists 
>
> 
>



>
> To REMOVE yourself from this mailing list, send an 
>
E-Mail message 
>
> to: [EMAIL PROTECTED] (note EXACT spelling of 
>
'ListGuru') and in 
>
> the message BODY, include a line containing: UNSUB 
>
ORACLE-L 
>
> (or the name

Re: Connection question?

[Anjan Thakuria]

But were these not both BEQ one in Caps and the other in lower case (BEQ
and beq) ..
Anjan
"Koivu, Lisa" wrote:
 
Hi Harry,
I admit ignorance. 
Networking was never my strong point.  IN fact sometimes I wonder
if I still have one.
Thanks for your response.
Lisa
-Original Message-
From:  
Lowes, Harry (NESL-IT) [SMTP:[EMAIL PROTECTED]]
Sent:  
Wednesday, November 28, 2001 10:31 AM
To:
Multiple recipients of list ORACLE-L
Subject:   
RE: Connection question?
Afternoon Lisa,
I thought that BEQ and (for example)
IPC protocols both used the listener to
spawn a server-side process. The difference
is in the protocol used in the
communication between the remote and
local processes. IPC uses Unix Domain
Sockets to communicate between the
client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed
that this was why BEQ connections
had to be local. This is the view
expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any
comments, Gurus?
 
 
Thanks,
Harry Lowes
Database Administrator,
npower Northern Limited
mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
 
 
-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L
 
Hi Deepak
Here's what the doco says
The Bequeath protocol 
enables clients that exist on the same
machine as the server to retrieve
information from the database without
using the listener. The Bequeath protocol
internally spawns a dedicated
server process for each client applications.
In a sense, it does the same
operation that a remote network listener
does for your connection, yet
locally.
Bequeath is used for local connections
where an Oracle client application,
such as SQL*Plus, communicates with
an Oracle server running on the same
machine
Tell me if I'm wrong but here's my
take on it:  When I connect from my pc,
there's a process on my PC and there's
a corresponding process on the
database, say on a Unix server. 
Though the connection was initiated
remotely, the process itself on the
db server is still a local process that
exists to communicate with the database.
Am I wrong?  If so let me know.
    -Original
Message-
Sent:   Tuesday, November
27, 2001 5:25 PM
To: Multiple
recipients of list ORACLE-L
    hey
lisa
    Thats
what i was temted to reply as well {lol} .. but
if you look closely .. both her conn
are bequeth .. i
was under the impression that bequeth
was used only
for local and not remote .. thats
why we chose beq
over tcp for db's that resided in
same box for
performance reasons .. or so i thought
until now ;)
    thoughts
..?
    Thx
Deepak
--- "Koivu, Lisa" <[EMAIL PROTECTED]>
wrote:
> One is LOCAL=YES and one is LOCAL=NO
>
> One is Local, one isn't.
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
>
>
> > -Original Message-
> > From:  
Seema Singh [SMTP:[EMAIL PROTECTED]]
> > Sent:  
Tuesday, November 27, 2001 1:05 PM
> > To: Multiple recipients of list
ORACLE-L
> > Subject:    Connection
question?
> >
> > Hi
> > WHen I execute ps -ef |grep LOCAL
on Solaris
> server the following output i
> >
> > see in
> >
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> > What is the diffrence between
1 and 2.
> >
> > Thanks
> > Seema
> >
> >
>
_
> > Get your FREE download of MSN
Explorer at
> http://explorer.msn.com/intl.asp
<http://explorer.msn.com/intl.asp>
> >
> > --
> > Please see the official ORACLE-L
FAQ:
> http://www.orafaq.com
<http://www.orafaq.com>
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services   
-- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California   
-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing
list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note
EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line
containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you
want to be
> removed from).  You may
> > also send the HELP command for
other information
> (like subscribing).
>
    __
Do You Yahoo!?
Yahoo! GeoCities - quick and easy
web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
<http://geocities.yahoo.com/ps/info1>
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
<http://www.orafaq.com>
--
Author: Deepak

RE: Connection question?

[Paul Baumgartel]

Harry, you say that IPC and BEQ both use the listener to spawn a
server-side process -- but the docs say that BEQ "...enables clients
that exist on the same machine as the server to retrieve information
from the database without using the listener".  

Which is correct?



--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Hi Harry, 
> 
> I admit ignorance.  Networking was never my strong point.  IN fact
> sometimes
> I wonder if I still have one. 
> 
> Thanks for your response. 
> 
> Lisa
> 
> > -Original Message-
> > From:   Lowes, Harry (NESL-IT)
> [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, November 28, 2001 10:31 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Connection question?
> > 
> > Afternoon Lisa,
> >  
> > I thought that BEQ and (for example) IPC protocols both used the
> listener
> > to
> > spawn a server-side process. The difference is in the protocol used
> in the
> > communication between the remote and local processes. IPC uses Unix
> Domain
> > Sockets to communicate between the client-side and server-side
> processes,
> > where BEQ uses Unix pipes. I had assumed that this was why BEQ
> connections
> > had to be local. This is the view expounded in Note: 1014940.6. If
> I've
> > got
> > it wrong, it'd be nice to know. Any comments, Gurus?
> >  
> > 
> > 
> > 
> > Thanks, 
> > 
> > Harry Lowes 
> > Database Administrator, 
> > npower Northern Limited 
> > mailto:[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>  
> > 
> >  


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Connection question?

[Koivu, Lisa]

Title: RE: Connection question?





Hi Harry, 


I admit ignorance.  Networking was never my strong point.  IN fact sometimes I wonder if I still have one. 


Thanks for your response. 


Lisa


-Original Message-
From:   Lowes, Harry (NESL-IT) [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 28, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Connection question?


Afternoon Lisa,
 
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
 




Thanks, 


Harry Lowes 
Database Administrator, 
npower Northern Limited 
mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>  


 


-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L




Hi Deepak 


Here's what the doco says 


The Bequeath protocol  enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally. 


Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine 


Tell me if I'm wrong but here's my take on it:  When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server.  Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.  


Am I wrong?  If so let me know. 


    -Original Message- 
Sent:   Tuesday, November 27, 2001 5:25 PM 
To: Multiple recipients of list ORACLE-L 


    hey lisa 


    Thats what i was temted to reply as well {lol} .. but 
if you look closely .. both her conn are bequeth .. i 
was under the impression that bequeth was used only 
for local and not remote .. thats why we chose beq 
over tcp for db's that resided in same box for 
performance reasons .. or so i thought until now ;) 


    thoughts ..? 


    Thx 
Deepak 
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: 
> One is LOCAL=YES and one is LOCAL=NO 
> 
> One is Local, one isn't. 
> 
> Lisa Koivu 
> Oracle Database Monkey 
> Fairfield Resorts, Inc. 
> 954-935-4117 
> 
> 
> > -Original Message- 
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, November 27, 2001 1:05 PM 
> > To: Multiple recipients of list ORACLE-L 
> > Subject:    Connection question? 
> > 
> > Hi 
> > WHen I execute ps -ef |grep LOCAL on Solaris 
> server the following output i 
> > 
> > see in 
> > 
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 
> > What is the diffrence between 1 and 2. 
> > 
> > Thanks 
> > Seema 
> > 
> > 
> 
_ 
> > Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp <http://explorer.msn.com/intl.asp>  
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: 
> http://www.orafaq.com <http://www.orafaq.com>  
> > -- 
> > Author: Seema Singh 
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services    -- (858) 538-5051 
> FAX: (858) 538-5051 
> > San Diego, California    -- Public Internet 
> access / Mailing Lists 
> > 
> 
 
> > To REMOVE yourself from this mailing list, send an 
> E-Mail message 
> > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB 
> ORACLE-L 
> > (or the name of mailing list you want to be 
> removed from).  You may 
> > also send the HELP command for other information 
> (like subscribing). 
> 



    __ 
Do You Yahoo!? 
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. 
http://geocities.yahoo.com/ps/info1 <http://geocities.yahoo.com/ps/info1>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.co

RE: Connection question?

[Lowes, Harry (NESL-IT)]

Afternoon Lisa,
 
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
 



Thanks, 

Harry Lowes 
Database Administrator, 
npower Northern Limited 
mailto:[EMAIL PROTECTED]
  

 

-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L



Hi Deepak 

Here's what the doco says 

The Bequeath protocol  enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally. 

Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine 

Tell me if I'm wrong but here's my take on it:  When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server.  Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.  

Am I wrong?  If so let me know. 

-Original Message- 
Sent:   Tuesday, November 27, 2001 5:25 PM 
To: Multiple recipients of list ORACLE-L 

hey lisa 

Thats what i was temted to reply as well {lol} .. but 
if you look closely .. both her conn are bequeth .. i 
was under the impression that bequeth was used only 
for local and not remote .. thats why we chose beq 
over tcp for db's that resided in same box for 
performance reasons .. or so i thought until now ;) 

thoughts ..? 

Thx 
Deepak 
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: 
> One is LOCAL=YES and one is LOCAL=NO 
> 
> One is Local, one isn't. 
> 
> Lisa Koivu 
> Oracle Database Monkey 
> Fairfield Resorts, Inc. 
> 954-935-4117 
> 
> 
> > -Original Message- 
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, November 27, 2001 1:05 PM 
> > To: Multiple recipients of list ORACLE-L 
> > Subject:Connection question? 
> > 
> > Hi 
> > WHen I execute ps -ef |grep LOCAL on Solaris 
> server the following output i 
> > 
> > see in 
> > 
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 
> > What is the diffrence between 1 and 2. 
> > 
> > Thanks 
> > Seema 
> > 
> > 
> 
_ 
> > Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp   
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: 
> http://www.orafaq.com   
> > -- 
> > Author: Seema Singh 
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051 
> > San Diego, California-- Public Internet 
> access / Mailing Lists 
> > 
> 
 
> > To REMOVE yourself from this mailing list, send an 
> E-Mail message 
> > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB 
> ORACLE-L 
> > (or the name of mailing list you want to be 
> removed from).  You may 
> > also send the HELP command for other information 
> (like subscribing). 
> 


__ 
Do You Yahoo!? 
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. 
http://geocities.yahoo.com/ps/info1   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Deepak Thapliyal 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


E mail Disclaimer

You agree that you have read and understood this 

RE: Connection question?

[Koivu, Lisa]

Title: RE: Connection question?





Hi Deepak


Here's what the doco says


The Bequeath protocol  enables clients that exist on the same machine as the server to retrieve information from the database without using the listener. The Bequeath protocol internally spawns a dedicated server process for each client applications. In a sense, it does the same operation that a remote network listener does for your connection, yet locally. 

Bequeath is used for local connections where an Oracle client application, such as SQL*Plus, communicates with an Oracle server running on the same machine 

Tell me if I'm wrong but here's my take on it:  When I connect from my pc, there's a process on my PC and there's a corresponding process on the database, say on a Unix server.  Though the connection was initiated remotely, the process itself on the db server is still a local process that exists to communicate with the database.  

Am I wrong?  If so let me know.


-Original Message-
From:   Deepak Thapliyal [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Connection question?


hey lisa


Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)


thoughts ..?


Thx
Deepak
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> One is LOCAL=YES and one is LOCAL=NO
> 
> One is Local, one isn't. 
> 
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
> 
> 
> > -Original Message-
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, November 27, 2001 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:    Connection question?
> > 
> > Hi
> > WHen I execute ps -ef |grep LOCAL on Solaris
> server the following output i
> > 
> > see in
> >
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> > What is the diffrence between 1 and 2.
> > 
> > Thanks
> > Seema
> > 
> >
>
_
> > Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services    -- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California    -- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> 



__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Connection question?

[Deepak Thapliyal]

hey lisa

Thats what i was temted to reply as well {lol} .. but
if you look closely .. both her conn are bequeth .. i
was under the impression that bequeth was used only
for local and not remote .. thats why we chose beq
over tcp for db's that resided in same box for
performance reasons .. or so i thought until now ;)

thoughts ..?

Thx
Deepak
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> One is LOCAL=YES and one is LOCAL=NO
> 
> One is Local, one isn't. 
> 
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
> 
> 
> > -Original Message-
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, November 27, 2001 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Connection question?
> > 
> > Hi
> > WHen I execute ps -ef |grep LOCAL on Solaris
> server the following output i
> > 
> > see in
> >
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> > What is the diffrence between 1 and 2.
> > 
> > Thanks
> > Seema
> > 
> >
>
_
> > Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> 


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Connection question?

[Koivu, Lisa]

Title: RE: Connection question?





One is LOCAL=YES and one is LOCAL=NO


One is Local, one isn't. 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject:    Connection question?


Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i 
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.


Thanks
Seema


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Connection question?

[Behar, Rivaldi]

Title: RE: Connection question?





1. User connect to Oracle through Unix (for example telnet and then SQLPlus from Unix).
2. Client user.


HTH,
Rivaldi


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Connection question?



Hi
WHen I execute ps -ef |grep LOCAL on Solaris server the following output i 
see in
1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
What is the diffrence between 1 and 2.


Thanks
Seema


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).