RE: Connection question?
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?
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?
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?
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?
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?
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?
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 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
RE: Connection question?
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?
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?
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?
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).
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).
