Oracle beq Mode Connection Configuration

Server and client on the same machine, can use BEQ connection, beq connection can be understood as the direct communication between processes, do not need to go network monitoring, higher performance.

Reference mos:how to Connect Using the-bequeath Protocol (BEQ) in 8I (Document ID 181317.1)

Beq connection can be used between client and server on the same machine.
Connection is not a using listener, so no listener configuration is required.
In Tnsnames.ora add TNS alias:

Under Microsoft Windows operating systems program should contain only "
Oracle ":
(Program = Oracle)
Without any path or suffix.
For example, connecting to T816 through BEQ protocol with Oracle_home=
/u08/oracle/product/8.1.6/bin/oracle
Can be-done using folowing TNS alias:
T816-beq. World =
(DESCRIPTION =
(Address_list =
(ADDRESS =
(PROTOCOL = BEQ)
(program =/u08/oracle/product/8.1.6/bin/oracle)
(ARGV0 = oracleT816)
(ARGS = ' (description= (Local=yes) (address= (PROTOCOL=BEQ)))
(Envs = ' oracle_home=/u08/oracle/product/8.1.6,oracle_sid=t816 ')
)
)
(Connect_data = (SID = T816))
)
To connect to T816 using Bequeth protocol now use:
Sqlplus system/[email protected]

For example, we configured the BEQ connection test on instance 1 of the 10.2.0.5 RAC

1. Add the following in the Tnsnames.ora configuration file:

RACBEQ =  (DESCRIPTION =    (ADDRESS =       (PROTOCOL = BEQ)      (PROGRAM = /u01/app/oracle/product/10.2.0.5/dbhome_1/bin/oracle)      (ARGV0 = oraclejyrac1)          (ARGS = ‘(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))‘)      (ENVS = ‘ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/dbhome_1,ORACLE_SID=jyrac1‘)    )    (CONNECT_DATA =      (SERVICE_NAME = jyrac)      (INSTANCE_NAME = jyrac1)    )  )

2. Tnsping Test Pass:

[[email protected] admin]$ tnsping racbeqTNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 24-JAN-2017 18:05:48Copyright (c) 1997,  2010, Oracle.  All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = /u01/app/oracle/product/10.2.0.5/dbhome_1/bin/oracle) (ARGV0 = oraclejyrac1) (ARGS = ‘(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))‘) (ENVS = ‘ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/dbhome_1,ORACLE_SID=jyrac1‘)) (CONNECT_DATA = (SERVICE_NAME = jyrac) (INSTANCE_NAME = jyrac1)))OK (30 msec)

3. Connect to the database locally via the BEQ protocol:

[[email protected] admin]$ sqlplus system/[email protected]SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 24 17:37:08 2017Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> !ps -ef|grep BEQoracle    8102     1  0 17:37 ?        00:00:00 oraclejyrac1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))oracle    8133  8100  0 17:37 pts/3    

The above review process can also determine that the process is indeed connected through the BEQ protocol.

Oracle beq Mode Connection Configuration