oracle protocol=beq 不可用,关于BEQ连接的问题

参考一下metalink note  181317.1

Beq connection can be used between client and server on the same machine.

Connection is not using listener, so no listener configuration is required.

In tnsnames.ora add tns alias:

=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = BEQ)

(PROGRAM = )

(ARGV0 = oracle)

(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')

(ENVS = 'ORACLE_HOME=,ORACLE_SID=

')

)

)

(CONNECT_DATA = (SID = ))

)

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/manager@T816-BEQ