Oracle 10g 补丁1、切换到oracle用户关闭节点2的数据库实例(类似节点2服务器宕机了)
[oracle@node2 ~]$
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 14 08:58:36 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
在切换到grid用户,查看数据库启动情况
[grid@node2 ~]$ crs_stat -t
Name Type
Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE
node1
ora.FLASH.dg ora....up.type ONLINE ONLINE
node1
ora.GRIDDG.dg ora....up.type ONLINE ONLINE
node1
ora....ER.lsnr ora....er.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node2
ora.asm ora.asm.type ONLINE
ONLINE node1
ora.eons ora.eons.type ONLINE ONLINE
node1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE
node1
ora....E1.lsnr application ONLINE ONLINE
node1
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application ONLINE ONLINE
node1
ora.node1.vip ora....t1.type ONLINE ONLINE
node1
ora....SM2.asm application ONLINE ONLINE
node2
ora....E2.lsnr application ONLINE ONLINE
node2
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application ONLINE ONLINE
node2
ora.node2.vip ora....t1.type ONLINE ONLINE
node2
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE
ONLINE node1
ora.racdb.db ora....se.type ONLINE ONLINE
node1
ora.scan1.vip ora....ip.type ONLINE ONLINE
node2
[grid@node2 ~]$
[grid@node2 ~]$
[grid@node2 ~]$ ps
-ef |grep ora_
grid 9122 8641 0 08:59 pts/2
00:00:00 grep ora_
这时我们在用客户端来测试数据库的连接情况,先看一下之前连接的客户端情况
SQL> select
INST_ID,username,sid,serial# from gv$session where username='XIA';
INST_ID USERNAME
SID SERIAL#
---------- ------------------------------ ---------- ----------
1 XIA
51 788
1 XIA
53 1322
SID为57的节点2的连接就没有了;在看一下之前在节点2的客户端连接,结束了会话;
SQL> select * from dual;
select * from dual
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结尾
进程 ID: 8835
会话 ID:
57 序列号: 4992
最后重新登录。
阅读(2651) | 评论(0) | 转发(0) |