RE: Connection question?

From: Todd Carlson <tcarlson_at_tripos.com>
Date: Wed, 28 Nov 2001 10:54:26 -0800
Message-ID: <F001.003CF641.20011128103332@fatcity.com>

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

Todd

-----Original Message----- From: root_at_fatcity.com
[mailto:root_at_fatcity.com] 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:Harry.Lowes_at_northern-electric.co.uk] 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
<a
href="mailto:harry.lowes_at_northern-electric.co.uk">mailto:harry.lowes_at_northern-electric.co.uk

<<a
href="mailto:harry.lowes_at_northern-electric.co.uk">mailto:harry.lowes_at_northern-electric.co.uk>

-----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 <glossary.htm> 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" <lisa.koivu_at_efairfield.com> 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:oracledbam_at_hotmail.com] 


>

> 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 

> <a

href="http://explorer.msn.com/intl.asp" target="_blank">http://explorer.msn.com/intl.asp
<http://explorer.msn.com/intl.asp>



>

> 

>

> -- 

>

> Please see the official ORACLE-L FAQ: 

> <a

href="http://www.orafaq.com" target="_blank">http://www.orafaq.com <<a
href="http://www.orafaq.com" target="_blank">http://www.orafaq.com>



>

> -- 

>

> Author: Seema Singh 

>

>   INET: oracledbam_at_hotmail.com 

>

> 

>

> 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: ListGuru_at_fatcity.com (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). 


>



<span
style='font-size:12.0pt'>        <font
size=2 face=Arial>__________________________________________________

Do You
Yahoo!? 
Yahoo!
GeoCities - quick and easy web site hosting, just $8.95/month. 
<a
href="http://geocities.yahoo.com/ps/info1" target="_blank">http://geocities.yahoo.com/ps/info1
<http://geocities.yahoo.com/ps/info1>

--

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

<<a
href="http://www.orafaq.com" target="_blank">http://www.orafaq.com>

--

Author:
Deepak Thapliyal 
 
INET: deepakthapliyal_at_yahoo.com 

<span
style='font-size:12.0pt'>        <font
size=2 face=Arial>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:
ListGuru_at_fatcity.com (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). 

<span style='font-size:
10.0pt;font-family:Arial'>********************************************************************************************

E mail
Disclaimer 

<span style='font-size:
10.0pt;font-family:Arial'>You agree that you have read and understood this
disclaimer and you agree to be bound by its terms. 

<span style='font-size:
10.0pt;font-family:Arial'>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 postmaster_at_northern-electric.co.uk. 

<span style='font-size:
10.0pt;font-family:Arial'>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.


<span style='font-size:
10.0pt;font-family:Arial'>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.


<span style='font-size:
10.0pt;font-family:Arial'>Northern Electric plc 
Carliol
House 
Market
Street 
Newcastle-upon-Tyne

NE1
6NE 
Registered
in England and Wales: Number 2366942 

<span style='font-size:
10.0pt;font-family:Arial'>********************************************************************************************

--

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

--

Author:
Lowes, Harry (NESL-IT) 
 
INET: Harry.Lowes_at_northern-electric.co.uk 

<span style='font-size:
10.0pt;font-family:Arial'>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:
ListGuru_at_fatcity.com (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).

Received on Wed Nov 28 2001 - 12:54:26 CST