??斗地主捕鱼电竞提现秒到 广告位招租 - 15元/月全站展示
??支付宝搜索579087183领大额红包 ??伍彩集团官网直营彩票
??好待遇→招代理 ??伍彩集团官网直营彩票
??络茄网 广告位招租 - 15元/月全站展示
ora.racdb2.vipFAILOVER(代码实例)

转载   2018-02-06   浏览量:434


ora.racdb2.vipFAILOVER(代码实例)

Connecting to 192.168.6.167:10286...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.

Last successful login:       Thu Feb  1 15:57:26 2018 racdb2  
Last authentication failure: Thu Feb  1 09:34:34 2018 ::ffff:192.168.5.7  
Last login: Thu Feb  1 15:41:43 2018 from 192.168.5.253
(c)Copyright 1983-2006 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993  The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2006 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.

Confidential computer software. Valid license from HP required for
possession, use or copying.  Consistent with FAR 12.211 and 12.212,
Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government
under vendor's standard commercial license.

You have mail.
                                                                                                                                                                                                        
Value of TERM has been set to "xterm". 
WARNING:  YOU ARE SUPERUSER !!

racdb2#[/]netstat -iwn
Name              Mtu        Network         Address         Ipkts               Ierrs      Opkts               Oerrs      Coll
lo0               32808      127.0.0.0       127.0.0.1       3146426             0          3146424             0          0         
lan900:801*       1500       none            none            0                   0          0                   0          0         
lan901            1500       192.1x8.2x.0   192.168.x2.x  520584              0          474449              0          0         
lan900            1500       192.1x.5.0     192.168.x.x   570296430           0          141300498           0          0         
lan901:801        1500       169.2x.0.0     169.254.x1.1x   6245102             0          5465989             0          0         
racdb2#[/]ifconfig lan900:801 0.0.0.0
racdb2#[/]netstat -iwn
Name              Mtu        Network         Address         Ipkts               Ierrs      Opkts               Oerrs      Coll
lo0               32808      127.0.0.0       127.0.0.1       3146607             0          3146605             0          0         
lan901            1500       192.1x.x.0   192.168.x.10  520778              0          474624              0          0         
lan900            1500       192.x8.x.0     192.168.x.x   570296511           0          141300565           0          0         
lan901:801        1500       169.x4.0.0     169.254.x.1x   6258240             0          5476589             0          0         
racdb2#[/]srvct
racdb2#[/]su - grid
(c)Copyright 1983-2006 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993  The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2006 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.

Confidential computer software. Valid license from HP required for
possession, use or copying.  Consistent with FAR 12.211 and 12.212,
Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government
under vendor's standard commercial license.

racdb2#[/home/grid]crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG01DATA.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGCRS.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGREDO01.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGREDO02.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       racdb1                                       
               ONLINE  OFFLINE      racdb2                                       
ora.asm
               ONLINE  ONLINE       racdb1                   Started             
               ONLINE  ONLINE       racdb2                   Started             
ora.gsd
               OFFLINE OFFLINE      racdb1                                       
               OFFLINE OFFLINE      racdb2                                       
ora.net1.network
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.ons
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racdb1                                       
ora.cvu
      1        ONLINE  ONLINE       racdb1                                       
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.racdb1.vip
      1        ONLINE  ONLINE       racdb1                                       
ora.racdb2.vip
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  ONLINE       racdb1                                       
ora.unicx.db
      1        ONLINE  ONLINE       racdb1                   Open                
      2        ONLINE  ONLINE       racdb2                   Open                
racdb2#[/home/grid]crsctl start res ora.net1.network
CRS-5702: Resource 'ora.net1.network' is already running on 'racdb1'
CRS-4000: Command Start failed, or completed with errors.
racdb2#[/home/grid]srvctl start vip -n racdb2
racdb2#[/home/grid]crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG01DATA.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGCRS.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGREDO01.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.DGREDO02.dg
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.asm
               ONLINE  ONLINE       racdb1                   Started             
               ONLINE  ONLINE       racdb2                   Started             
ora.gsd
               OFFLINE OFFLINE      racdb1                                       
               OFFLINE OFFLINE      racdb2                                       
ora.net1.network
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
ora.ons
               ONLINE  ONLINE       racdb1                                       
               ONLINE  ONLINE       racdb2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racdb1                                       
ora.cvu
      1        ONLINE  ONLINE       racdb1                                       
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.racdb1.vip
      1        ONLINE  ONLINE       racdb1                                       
ora.racdb2.vip
      1        ONLINE  ONLINE       racdb2                                       
ora.scan1.vip
      1        ONLINE  ONLINE       racdb1                                       
ora.unxm.db
      1        ONLINE  ONLINE       racdb1                   Open                
      2        ONLINE  ONLINE       racdb2                   Open                
racdb2#[/home/grid]

转载自:https://www.2cto.com/database/201802/718549.html

招聘 不方便扫码就复制添加关注:程序员招聘谷,微信号:jobs1024



DB2V9备份数据的恢复教程
DB2V9备份数据的恢复教程。在DB2V9的情况下,如果使用自动存储的数据库,备份之后恢复的话可能出现上述报错,必须使用如下办法恢复
DB2 MERGE INTO的使用实例讲解
DB2MERGEINTO的使用实例讲解。DB2中的Merge语句可以将一个表中的数据合并到另一个表中,在合并的同时可以根据条件进行插入、删除、更新等操作,功能非常强大。
MSSQLServer2000、Oracle、DB2取中间几条数据及连接方法
MSSQLServer2000、Oracle、DB2取中间几条数据及连接方法。1)在MSSQLServer2000中取前5用top,取第六名开始3个人的信息。首先将前5名的主键取出来,在检索时排除这5名的前3人即可。
DB2存储过程,循环插入数据(用户自测造大量数据)教程
DB2存储过程,循环插入数据(用户自测造大量数据)教程。表结构如下
DB2SQLError:SQLCODE=-668,SQLSTATE=57016,SQLERRMC=7;ZJTEG.MDS_FXSPOTRATE,DRIVER=3.64.106异常问题解决
DB2SQLError:SQLCODE=-668,SQLSTATE=57016,SQLERRMC=7;ZJTEGMDS_FXSPOTRATE,DRIVER=364106异常问题解决。在dbvisualizer客户端执行下面sql:
ora.racdb2.vipFAILOVER(代码实例)
oraracdb2vipFAILOVER(代码实例)。
db2_data_server_client客户端安装与配置
db2_data_server_client客户端安装与配置。一安装:
一些---DB2数据库操作注意
11W比以下采用方法:deletefromtablewhere……condition……说明:产生交易日志,删除大量数据时,有机会出现交易日志满,出现SQLCODE=-9642全部数据采用方法:truncatetable说明:不会产生交易日志,为最快方式,用于清理临时表等
DB2数据库使用存储过程详解
存储过程(StoredProcedure)是在大型数据库系统中,一组为了完成特定功能的SQL语句集,经编译后存储在数据库中,用户通过指定存储过程的名字并给出参数(如果该存储过程带有参数)来执行它。
db2锁
db2锁