oraclerac时钟差多少秒宕机

1分10秒。oraclerac的宕机情况下显示，在时钟差1分10秒宕机，但大部分都是随机的，时间不相同，RAC是realapplicationclusters的缩写，译为“实时应用集群”，是Oracle新版数据库中采用的一项新技术，是高可用性的一种，也是Oracle数据库支持网格计算环境的核心技术。

1,通过查看oratab文件确认oracle

home依存的实例(在/etc/目录下)

2,运行dbca，选择删除数据库，删除所有的数据库

3,如果未使用asm方式存储管理，请进行下一步

-bash-300$ export ORACLE_SID=+ASM1

-bash-300$ sqlplus '/as

sysdba'

SQLPlus: Release 102010 - Production on Mon Mar 15 00:15:19

2010

Copyright (c) 1982, 2005, Oracle All rights

reserved

Connected to:

Oracle Database 10g Enterprise Edition

Release 102010 - Production

With the Partitioning, Real Application

Clusters, OLAP and Data Mining options

SQL> select instance_name from

gv$asm_client;--进入asm实例，查看使用它的所有数据库实例

INSTANCE_NAME

----------------------------------------------------------------

capitek1

capitek1

capitek2

capitek2

-bash-300$

srvctl stop database -d capitek

---根据以上查询信息，停止使用asm的数据库;当然，为了保险，你可以再次运行gv$asm_client查看是否仍有使用asm实例的数据库实例

-bash-300$

crs_stat -t

Name Type Target State Host

------------------------------------------------------------

orak1inst

application OFFLINE OFFLINE

orak2inst application

OFFLINE OFFLINE

oracapitekdb application OFFLINE

OFFLINE

oraSM1asm application ONLINE ONLINE

capitek1

oraK1lsnr application ONLINE ONLINE capitek1

oraek1gsd application ONLINE ONLINE capitek1

oraek1ons application ONLINE ONLINE capitek1

oraek1vip application ONLINE ONLINE capitek1

oraSM2asm application ONLINE ONLINE capitek2

oraK2lsnr application ONLINE ONLINE capitek2

oraek2gsd application ONLINE ONLINE capitek2

oraek2ons application ONLINE ONLINE capitek2

oraek2vip application ONLINE ONLINE capitek2

oraocfs2db application OFFLINE OFFLINE

ora21inst application OFFLINE OFFLINE

ora22inst application OFFLINE OFFLINE

在Oracle Enterprise Linux 55 X86_64位的机器上配置完11gR2 RAC后，grid用户执行crs_stat -t查看服务状态时，我们会看到有一些服务是OFFLINE状态，其中就包括oraoc4j和oragsd这两类服务，具体状态，我们看下面的示例输出：

[root@rac1 ~]# uname -rm

2618-194el5xen x86_64

[root@rac1 ~]# su - grid

rac1-> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

oraDATADGdg orauptype ONLINE ONLINE rac1

oraGRIDDGdg orauptype ONLINE ONLINE rac1

oraERlsnr oraertype ONLINE ONLINE rac1

oraN1lsnr oraertype ONLINE ONLINE rac2

oraasmoraasmtype ONLINE ONLINE rac1

oradevdbdb orasetype ONLINE ONLINE rac1

oraeons oraeonstype ONLINE ONLINE rac1

oragsdoragsdtype OFFLINE OFFLINE

oranetwork orarktype ONLINE ONLINE rac1

oraoc4j oraoc4jtype OFFLINE OFFLINE

oraonsoraonstype ONLINE ONLINE rac1

oraSM1asm application ONLINE ONLINE rac1

oraC1lsnr application ONLINE ONLINE rac1

orarac1gsd application OFFLINE OFFLINE

orarac1ons application ONLINE ONLINE rac1

orarac1vip orat1type ONLINE ONLINE rac1

oraSM2asm application ONLINE ONLINE rac2

oraC2lsnr application ONLINE ONLINE rac2

orarac2gsd application OFFLINE OFFLINE

orarac2ons application ONLINE ONLINE rac2

orarac2vip orat1type ONLINE ONLINE rac2

oraryacfs orafstype ONLINE ONLINE rac1

orascan1vip oraiptype ONLINE ONLINE rac2

rac1->

那么，是我们的RAC配置有问题吗这两类服务没有ONLINE会不会影响RAC数据库呢？我们又该如何启动这些服务呢？

其实，我们的RAC配置是没有问题的，也不会影响数据库正常运行。在默认情况下，其中的oragsd服务状态是OFFLINE状态，我们可不予理会，除非需要在11g Cluster上配置Oracle 9iR2的RAC。但凡以grid用户执行crs_stat -t命令，看到Target和State这两列的状态均为OFFLINE，我们均可忽略。但是，我们该如何使之启动呢？

启动oraoc4j服务：

rac1-> srvctl start oc4j

OC4J could not be started

PRCR-1079 : Failed to start resource oraoc4j

CRS-2501: Resource 'oraoc4j' is disabled

rac1-> srvctl enable oc4j -h

Enable OC4J instance for Oracle Clusterware management

Usage: srvctl enable oc4j [-n <NODE_NAME>] [-v]

-n <NODE_NAME> Node name

-v Verbose output

-h Print usage

rac1-> srvctl enable oc4j

rac1-> srvctl start oc4j -v

OC4J has been started

rac1-> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

oraDATADGdg orauptype ONLINE ONLINE rac1

oraGRIDDGdg orauptype ONLINE ONLINE rac1

oraERlsnr oraertype ONLINE ONLINE rac1

oraN1lsnr oraertype ONLINE ONLINE rac2

oraasmoraasmtype ONLINE ONLINE rac1

oradevdbdb orasetype ONLINE ONLINE rac1

oraeons oraeonstype ONLINE ONLINE rac1

oragsdoragsdtype OFFLINE OFFLINE

oranetwork orarktype ONLINE ONLINE rac1

oraoc4j oraoc4jtype ONLINE ONLINE rac1

oraonsoraonstype ONLINE ONLINE rac1

oraSM1asm application ONLINE ONLINE rac1

oraC1lsnr application ONLINE ONLINE rac1

orarac1gsd application OFFLINE OFFLINE

orarac1ons application ONLINE ONLINE rac1

orarac1vip orat1type ONLINE ONLINE rac1

oraSM2asm application ONLINE ONLINE rac2

oraC2lsnr application ONLINE ONLINE rac2

orarac2gsd application OFFLINE OFFLINE

orarac2ons application ONLINE ONLINE rac2

orarac2vip orat1type ONLINE ONLINE rac2

oraryacfs orafstype ONLINE ONLINE rac1

orascan1vip oraiptype ONLINE ONLINE rac2

rac1->

2 启动oragsd服务：

rac1-> srvctl status nodeapps

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac1

Network is running on node: rac2

GSD is disabled

GSD is not running on node: rac1

GSD is not running on node: rac2

ONS is enabled

ONS daemon is running on node: rac1

ONS daemon is running on node: rac2

eONS is enabled

eONS daemon is running on node: rac1

eONS daemon is running on node: rac2

rac1->

从上,我们看到GSD服务状态是disabled，接下来enable GSD服务：

rac1-> srvctl enable nodeapps -g

rac1-> srvctl status nodeapps

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac1

Network is running on node: rac2

GSD is enabled

GSD is not running on node: rac1

GSD is not running on node: rac2

ONS is enabled

ONS daemon is running on node: rac1

ONS daemon is running on node: rac2

eONS is enabled

eONS daemon is running on node: rac1

eONS daemon is running on node: rac2

rac1->

然后，启动GSD服务

rac1-> srvctl start nodeapps -g

PRKO-2002 : Invalid command line option: -g

rac1-> srvctl start nodeapps

PRKO-2421 : Network resource is already started on node(s): rac1,rac2

PRKO-2420 : VIP is already started on node(s): rac1,rac2

PRKO-2420 : VIP is already started on node(s): rac1,rac2

PRKO-2422 : ONS is already started on node(s): rac1,rac2

PRKO-2423 : eONS is already started on node(s): rac1,rac2

rac1-> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

oraDATADGdg orauptype ONLINE ONLINE rac1

oraGRIDDGdg orauptype ONLINE ONLINE rac1

oraERlsnr oraertype ONLINE ONLINE rac1

oraN1lsnr oraertype ONLINE ONLINE rac2

oraasmoraasmtype ONLINE ONLINE rac1

oradevdbdb orasetype ONLINE ONLINE rac1

oraeons oraeonstype ONLINE ONLINE rac1

oragsdoragsdtype ONLINE ONLINE rac1

oranetwork orarktype ONLINE ONLINE rac1

oraoc4j oraoc4jtype ONLINE ONLINE rac1

oraonsoraonstype ONLINE ONLINE rac1

oraSM1asm application ONLINE ONLINE rac1

oraC1lsnr application ONLINE ONLINE rac1

orarac1gsd application ONLINE ONLINE rac1

orarac1ons application ONLINE ONLINE rac1

orarac1vip orat1type ONLINE ONLINE rac1

oraSM2asm application ONLINE ONLINE rac2

oraC2lsnr application ONLINE ONLINE rac2

orarac2gsd application ONLINE ONLINE rac2

orarac2ons application ONLINE ONLINE rac2

orarac2vip orat1type ONLINE ONLINE rac2

oraryacfs orafstype ONLINE ONLINE rac1

orascan1vip oraiptype ONLINE ONLINE rac2

rac1->

最后，我们看到所有的服务状态都是ONLINE状态

以上就是关于oraclerac时钟差多少秒宕机全部的内容，包括:oraclerac时钟差多少秒宕机、如何完全删载与清除oracle 10grac cluster、如何处理11gR2 RAC下oc4j和gsd服务为OFFLINE状态等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！