Oracle 10g TAF配置
来源:互联网 发布:炒股入门 知乎 编辑:程序博客网 时间:2024/04/30 15:13
RAC_TAF = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.129.128.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.129.128.35 )(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devrac) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )---------------------------------------------------------------------------C:\>sqlplus mbfe/mbfe@RAC_TAFSQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 8 16:18:26 2015Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management,OLAP,Data Mining and Real Application Testing optionsSQL>10.129.128.35 上看到的信息:SQL> select username,machine,program from v$session where username='MBFE';USERNAME MACHINEPROGRAM------------------------------ ---------------------------------------------------------------- ------------------------------------------------MBFE WORKGROUP\CZCB-01642sqlplus.exeSQL> select username,machine,program,port from v$session where username='MBFE';USERNAME MACHINEPROGRAM PORT------------------------------ ---------------------------------------------------------------- ------------------------------------------------ ----------MBFE WORKGROUP\CZCB-01642sqlplus.exe 3431SQL> ! netstat -na | grep 3431tcp 0 0 10.129.128.35:1521 10.129.254.46:3431 ESTABLISHED unix 3 [ ] STREAM CONNECTED 53431 10.129.128.35 上执行SQL> shutdown abort;ORACLE instance shut down.SQL> select username,machine,program,port from v$session where username='MBFE';USERNAME MACHINE PROGRAMPORT---------- ------------------------------ --------------- ----------MBFE WORKGROUP\CZCB-01642 sqlplus.exe3535SQL> ! netstat -na | grep 3535tcp 0 0 10.129.128.34:1521 10.129.254.46:3535 ESTABLISHED C:\Documents and Settings\user>netstat -nao | findstr 3535 TCP 10.129.254.46:3535 10.129.128.34:1521 ESTABLISHED 4712端口号为3535 进程号为4712,4712为sqlplus进程。关闭10.129.128.34数据库,此时连接到10.129.128.35SQL> select username,machine,program,port from v$session where username='MBFE';USERNAMEMACHINE PROGRAM PORT--------------- --------------- ------------------------------------------------ ----------MBFEWORKGROUP\CZCB- sqlplus.exe 368201642SQL> ! netstat -na | grep 3682tcp 0 0 10.129.128.35:1521 10.129.254.46:3682 ESTABLISHED C:\Documents and Settings\user>netstat -nao | findstr 3682 TCP 10.129.254.46:3682 10.129.128.35:1521 ESTABLISHED 4712C:\Documents and Settings\user>进程号还是4712
0 0
- Oracle 10g TAF配置
- Oracle 10g RAC Server-Side TAF配置
- ORACLE 10g R2 RAC TAF配置与测试
- Oracle 10g RAC TAF介绍
- Oracle 10g RAC TAF测试
- oracle 10G LOAD_BALANCE、FAILOVER、TAF简介
- Oracle 10g RAC TAF介绍
- 【转】Oracle 10g RAC TAF
- Oracle 10g RAC TAF介绍
- Oracle 10g RAC TAF介绍
- Oracle 11g RAC TAF 服务端配置实现failover
- Oracle TAF的配置
- 10g RAC TAF介绍
- ORACLE 11G R2 DGBROKER 之TAF
- DataGuard 11g 之客户端TAF 配置
- Oracle 11G RAC环境的load balance + TAF配置 -- Alibaba DBA Team
- Oracle Faq(Oracle TAF的配置)
- 10g RAC 使用service实现taf
- OC学习之道:关于OC中的协议与代理模式,
- Activity生命周期一些注意的地方
- JPA的cannot simultaneously fetch multiple bags异常的解决
- 第五周项目1-体验常成员函数
- 图解Adobe Flash Player 浏览器插件安装
- Oracle 10g TAF配置
- VLC架构剖析
- “格式化HDFS后,HMaster进程启动失败”的问题解决
- No resource found that matches the given name 'Theme.AppCompat.Light'
- 动态规划 最长递增子序列
- 全排列 DFS
- c++ template(5)模板实战
- 大三学生的几个问题
- 第五周项目2-对象作为数据成员