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
原创粉丝点击