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_TAF

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 8 16:18:26 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

SQL>




10.129.128.35 上看到的信息:

SQL> select username,machine,program from v$session where username='MBFE';

USERNAME           MACHINE                PROGRAM
------------------------------ ---------------------------------------------------------------- ------------------------------------------------
MBFE             WORKGROUP\CZCB-01642           sqlplus.exe

SQL> select username,machine,program,port from  v$session where username='MBFE';

USERNAME           MACHINE                PROGRAM                  PORT
------------------------------ ---------------------------------------------------------------- ------------------------------------------------ ----------
MBFE             WORKGROUP\CZCB-01642           sqlplus.exe                3431

SQL> ! netstat -na | grep 3431
tcp        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        PROGRAM   PORT
---------- ------------------------------ --------------- ----------
MBFE     WORKGROUP\CZCB-01642     sqlplus.exe   3535

SQL> ! netstat -na | grep 3535
tcp        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.35

SQL> select username,machine,program,port  from v$session where username='MBFE';

USERNAME  MACHINE   PROGRAM                  PORT
--------------- --------------- ------------------------------------------------ ----------
MBFE    WORKGROUP\CZCB- sqlplus.exe                3682
01642


SQL> ! netstat -na | grep 3682
tcp        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     4712

C:\Documents and Settings\user>


进程号还是4712