Re: Bequeath protocol for Net8

the bequeath adapter is automatically used by sqlplus/svrmgrl, if you don't specify a service name in your connect request. Make sure that the TWO_TASK environment variable is *not* set.

> /tmp> sqlplus abc/xyz <==
 ***BEQUEATH***
> SQL*Plus: Release 8.1.6.0.0 - Production on Mon Aug 21 08:02:46 2000
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
> SQL> !ps -fu oracle | tail -1
> oracle 24075 24072 0.0 08:02:46 ?? 0:00.16 oracleBMFB1
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> SQL> !ps -fp24072
> UID PID PPID C STIME TTY TIME CMD
> perf 24072 16629 0.0 08:02:46 ttyp2 0:00.08 sqlplus
> SQL> exit
> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 -
 Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
 

> /tmp> TWO_TASK=bmfb1 sqlplus abc/xyz <== ***LISTENER***
> SQL*Plus: Release 8.1.6.0.0 - Production on Mon Aug 21 08:05:08 2000
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
> SQL> !ps -fu oracle | tail -1
> oracle 24084 1 0.6 08:05:08 ?? 0:00.15 oracleBMFB1
> (DESCRIPTION=(LOCAL=NO)(SDU=32768))
> SQL> exit
> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 -
 Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production

You can also set up a service name in tnsnames.ora and specify bequeath as protocol adapter:

> /tmp> cat ./tnsnames.ora
> BMFB1-BEQ.world =
> (DESCRIPTION =
> (SDU=32768)
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = BEQ)
> (PROGRAM = /usr/oracle/oracode/8.1.6.1/bin/oracle)
> (ARGV0 = oracleBMFB1)
> (ARGS ='(description=(local=yes)(address=(protocol=beq)))')
> )
> )
> (CONNECT_DATA =
> (SID = BMFB1)
> (GLOBAL_NAME = BMFB1.world)
> )
> )
> /tmp> TNS_ADMIN=/tmp TWO_TASK=bmfb1-beq sqlplus abc/xyz
> SQL*Plus: Release 8.1.6.0.0 - Production on Mon Aug 21 08:25:27 2000
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
> SQL> !ps -fu oracle | tail -1
> oracle 24111 1 0.0 08:25:27 ?? 0:00.14 oracleBMFB1
> (description=(local=yes)(address=(protocol=beq)))
> SQL> exit
> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 -
 Production
> With the Partitioning option
> JServer Release 8.1.6.1.0 - Production
Received on Mon Aug 21 2000 - 01:44:39 CDT