WEB开发网
开发学院数据库Oracle Oracle 10g RAC 的部署(2) 阅读

Oracle 10g RAC 的部署(2)

 2008-09-02 12:49:02 来源:WEB开发网   
核心提示: (2)检查Oracle集群件的状态$crsctlcheckcrsCSSappearshealthyCRSappearshealthyEVMappearshealthy$crsctlcheckcrsCSSappearshealthyCRSappearshealthyEVMappearshea

(2)检查Oracle集群件的状态

$crsctlcheckcrs 
  CSSappearshealthy 
  CRSappearshealthy 
  EVMappearshealthy 
  $crsctlcheckcrs 
  CSSappearshealthy 
  CRSappearshealthy 
  EVMappearshealthy

(3)列出RAC实例 

SQL>select 
  2instance_name, 
  3host_name, 
  4archiver, 
  5thread#, 
  6status 
  7fromgv$instance; 
  INSTANCE_NAMEHOST_NAMEARCHIVETHREAD#STATUS 
  -------------------------------------------------------- 
  gemnids1.mycorpdomain.comSTARTED1OPEN 
  gemnids2.mycorpdomain.comSTARTED2OPEN

(4)检查连接

验证您能够连接到每个节点上的实例和服务。

sqlplussystem@gemni

(5) 检查数据库配置

$exportORACLE_SID=gemni 
  $sqlplus/assysdba

//显示sga参数

SQL>showsga 
  TotalSystemGlobalArea209715200bytes 
  FixedSize1218556bytes 
  VariableSize104859652bytes 
  DatabaseBuffers100663296bytes 
  RedoBuffers2973696bytes

//显示数据库物理文件的位置

SQL>selectfile_name,bytes/1024/1024fromdba_data_files; 
  FILE_NAMEBYTES/1024/1024 
  ---------------------------------------------------------- 
  +DG1/gemni/datafile/users.259.6064684495 
  +DG1/gemni/datafile/sysaux.257.606468447240 
  +DG1/gemni/datafile/undotbs1.258.60646844930 
  +DG1/gemni/datafile/system.256.606468445480 
  +DG1/gemni/datafile/undotbs2.264.60646867725

上一页  4 5 6 7 8 9 10  下一页

Tags:Oracle RAC 部署

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接