Re: Working with a local DB with OracleClient?

Fabio wrote:
> I don't know what is the BEQUEATH protocol...
>
> Give me some examples about the tnsnames.ora that are written, thank
you.
>
> Fabio
>
> "IANAL_VISTA" <IANAL_Vista_at_hotmail.com> ha scritto nel messaggio
> news:Xns96534B02C6157SunnySD_at_68.6.19.6...
> > "Fabio" <corso0web_at_NOSPAMquipo.it> wrote in
> > news:DTkge.1477$795.38045_at_twister1.libero.it:
> >
> > > Is it possible to create a db on my local machine and to connect
to it
> > > with the only full Oracle Client version?
> > >
> >
> > YES. You do NOT require nor should you use SQL*Net to connect to
local DB.
> > You should use the BEQUEATH protocol.

BEQUEATH is SQL*Net V2 adapter from version 8.0 onwards. It replaced version 7 TWO_TASK driver to make local database connections.

BEQ adapter connects to local database without going thru the listener process... so basically you don't need the listener running for BEQ adapter.

Assuming your oracle sid is ORCL, you can either,

C:\> set oracle_sid=ORCL
C:\> sqlplus username/password
Note that there is no @ORCL in the connect string

OR

Put this in your tnsnames.ora file
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 = oracleORCL)(ARGS = '(DESCRIPTION =(LOCAL = YES)(ADDRESS = (PROTOCOL = BEQ)))'))
    (CONNECT_DATA = (SERVICE_NAME = ORCL))   )
then you can
C:\> sqlplus username/password_at_ORCL

In either case, you don't need a listener for local connections.

Regards
/Rauf Received on Wed May 11 2005 - 10:24:54 CDT