本文共 2082 字，大约阅读时间需要 6 分钟。

Oracle BEQ?????????

Oracle BEQ?Bequeath Protocol????????????????????????Oracle???????????????????Oracle 8I?10.2.0.5 RAC?????BEQ????????????

1. tnnsnames.ora????

?BEQ????tnsnames.ora?????TNS???????????????????????????racbeq?TNS???????Oracle RAC???

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????

????TNS???????????tnsping????????????racbeq TNS????ping????

[oracle@oradb27 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. SQL*Plus????

??BEQ?????????SQL*Plus?????????????racbeq TNS????????

[oracle@oradb27 admin]$ sqlplus system/oracle@racbeqSQL*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    00:00:00 /bin/bash -c ps -ef|grep BEQSQL>

??

???????????Oracle RAC???????BEQ???????????????????tnsnames.ora??????????tnsping????TNS????????????????????????