本文共 2082 字,大约阅读时间需要 6 分钟。
Oracle BEQ?Bequeath Protocol????????????????????????Oracle???????????????????Oracle 8I?10.2.0.5 RAC?????BEQ????????????
?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) ))
????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)
??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????????????????????????
转载地址:http://dppfk.baihongyu.com/