数保软件服务热线
新闻中心

您当前的位置:主页 > 新闻中心 > 技术交流 > 技术交流

oracle 10g rac 操作手册

打印 打印 来源 数保计算机 点击:
编辑:数保计算机 时间:2014-05-11 00:00

1启动过程
 
 
[oracle@zddb02 ~]$crs_start   - all
Attempting to start `ora.zddb.dbsrv.zddb01.srv` on member `zddb01`
Attempting to start `ora.zddb.dbsrv.cs` on member `zddb01`
Attempting to start `ora.zddb.dbsrv.zddb02.srv` on member `zddb02`
Start of `ora.zddb.dbsrv.cs` on member `zddb01` succeeded.
Start of `ora.zddb.dbsrv.zddb01.srv` on member `zddb01` succeeded.
Start of `ora.zddb.dbsrv.zddb02.srv` on member `zddb02` succeeded.
 
最后的状态:
[oracle@zddb02 ~]$crs_stat -t
名称           类型           目标      状态      主机       
------------------------------------------------------------
ora.zddb.db    application    ONLINE    ONLINE    zddb02     
ora....bsrv.cs application       ONLINE    ONLINE    zddb01     
ora....b01.srv application       ONLINE    ONLINE    zddb01     
ora....b02.srv application       ONLINE    ONLINE    zddb02     
ora....01.inst application        ONLINE    ONLINE    zddb01     
ora....02.inst application        ONLINE    ONLINE    zddb02     
ora....01.lsnr application        ONLINE    ONLINE    zddb01     
ora.zddb01.gsd application      ONLINE    ONLINE    zddb01     
ora.zddb01.ons application      ONLINE    ONLINE    zddb01     
ora.zddb01.vip application      ONLINE    ONLINE    zddb01     
ora....02.lsnr application        ONLINE    ONLINE    zddb02     
ora.zddb02.gsd application      ONLINE    ONLINE    zddb02     
ora.zddb02.ons application       ONLINE    ONLINE    zddb02     
ora.zddb02.vip application       ONLINE    ONLINE    zddb02     
[oracle@zddb02 ~]$
 
 
 
$ crs_stop –all
 
[oracle@zddb02 ~/db_1/network/admin]$crs_stat -t
名称           类型           目标      状态      主机       
------------------------------------------------------------
ora.zddb.db    application    OFFLINE   OFFLINE              
ora....bsrv.cs application    OFFLINE   OFFLINE              
ora....b01.srv application    OFFLINE   OFFLINE              
ora....b02.srv application    OFFLINE   OFFLINE              
ora....01.inst application    OFFLINE   OFFLINE              
ora....02.inst application    OFFLINE   OFFLINE              
ora....01.lsnr application    OFFLINE   OFFLINE              
ora.zddb01.gsd application    OFFLINE   OFFLINE              
ora.zddb01.ons application    OFFLINE   OFFLINE              
ora.zddb01.vip application    OFFLINE   OFFLINE              
ora....02.lsnr application    OFFLINE   OFFLINE              
ora.zddb02.gsd application    OFFLINE   OFFLINE              
ora.zddb02.ons application    OFFLINE   OFFLINE              
ora.zddb02.vip application    OFFLINE   OFFLINE              
 
 
[oracle@zddb02 ~/db_1/network/admin]$crs_stat –t
 
群集状态:
 
#scstat
 
 
 
 
root@zddb01 # scstat
------------------------------------------------------------------
 
-- Cluster Nodes --
 
                    Node name           Status
                    ---------           ------
  Cluster node:     zddb02              Online
  Cluster node:     zddb01              Online
 
------------------------------------------------------------------
 
-- Cluster Transport Paths --
 
                    Endpoint               Endpoint               Status
                    --------               --------               ------
  Transport path:   zddb02:nxge3           zddb01:nxge3           Path online
  Transport path:   zddb02:nxge2           zddb01:nxge2           Path online
 
------------------------------------------------------------------
 
-- Quorum Summary --
 
  Quorum votes possible:      3
  Quorum votes needed:        2
  Quorum votes present:       3
 
 
-- Quorum Votes by Node --
 
                    Node Name           Present Possible Status
                    ---------           ------- -------- ------
  Node votes:       zddb02              1        1       Online
  Node votes:       zddb01              1        1       Online
 
 
-- Quorum Votes by Device --
 
                    Device Name         Present Possible Status
                    -----------         ------- -------- ------
  Device votes:     /dev/did/rdsk/d4s2  1        1       Online
 
------------------------------------------------------------------
 
-- Device Group Servers --
 
                         Device Group        Primary             Secondary
                         ------------        -------             ---------
  Device group servers:  vgarch01            -                   -
  Device group servers:  vgarch02            -                   -
 
 
-- Device Group Status --
 
                              Device Group        Status             
                              ------------        ------             
  Device group status:        vgarch01            Offline
  Device group status:        vgarch02            Offline
 
 
-- Multi-owner Device Groups --
 
                              Device Group        Online Status
                              ------------        -------------
  Multi-owner device group:   vghnzd06            zddb01,zddb02
  Multi-owner device group:   vghnzd05            zddb01,zddb02
  Multi-owner device group:   vghnzd04            zddb01,zddb02
  Multi-owner device group:   vghnzd03            zddb01,zddb02
  Multi-owner device group:   vghnzd02            zddb01,zddb02
  Multi-owner device group:   vghnzd01            zddb01,zddb02
 
------------------------------------------------------------------
 
-- Resource Groups and Resources --
 
            Group Name     Resources
            ----------     ---------
 Resources: rac-framework-rg rac-framework-rs rac-udlm-rs rac-svm-rs
 
 
-- Resource Groups --
 
            Group Name     Node Name                State          Suspended
            ----------     ---------                -----          ---------
     Group: rac-framework-rg zddb01                   Online         No
     Group: rac-framework-rg zddb02                   Online         No
 
 
-- Resources --
 
            Resource Name  Node Name                State          Status Message
            -------------  ---------                -----          --------------
  Resource: rac-framework-rs zddb01                   Online         Online
  Resource: rac-framework-rs zddb02                   Online         Online
 
  Resource: rac-udlm-rs    zddb01                   Online         Online
  Resource: rac-udlm-rs    zddb02                   Online         Online
 
  Resource: rac-svm-rs     zddb01                   Online         Online
  Resource: rac-svm-rs     zddb02                   Online         Online
 
------------------------------------------------------------------
 
-- IPMP Groups --
 
              Node Name           Group   Status         Adapter   Status
              ---------           -----   ------         -------   ------
  IPMP Group: zddb02              sc_ipmp0 Online         nxge0     Online
 
  IPMP Group: zddb01              sc_ipmp0 Online         nxge0     Online
 
 
-- IPMP Groups in Zones --
 
              Zone Name           Group   Status         Adapter   Status
              ---------           -----   ------         -------   ------
------------------------------------------------------------------
root@zddb01 #
 
 
 
ORACLE 管理工具启动:
 
Zddb01 机器上运行:

 
 # su – oracle
 
 
 
 
 
 
管理工具配置与启动EM
oracle@zddb01 ~]$emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
https://zddb01:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........... started.
 
 
停应用数据库:
 
$crs_stop –all
就可以将所有的应用停下来。
 
 
Oracle .profile for 10g rac
 
[oracle@zddb02 ~]$more .profile
#       This is the default standard profile provided to a user.
#       They are expected to edit it to meet their own needs.
 
MAIL=/usr/mail/${LOGNAME:?}
umask 022
PS1='[\u@\h \w]\$';export PS1
ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/db_1;export ORACLE_HOME
ORACLE_TEM=xterm
ORACLE_SID=zddb02;export ORACLE_SID
CRS_HOME=$ORACLE_BASE/product/10.2.0.1/crs
export CRS_HOME
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOM/rdbms/jlib:$ORACLE_HOME/network/jlib;export CLASSPATH
export NLS_LANG="SIMPLIFIED CHINESE"_CHINA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
PATH=$ORACLE_HOME/bin:/oracle/app/oracle/product/10.2.0.1/crs/bin:/usr/ccs/bin:/usr/sbin:/etc/:/usr/openwin/bin:/opt/bin:/usr/local/
bin:$PATH
 




Copyright © 2015-2022 长沙数保信息科技有限公司 ┇ 湘ICP备08103633号 湘公网安备 43011102000746号

地址:长沙市岳麓区润花园D1-903 公司邮箱:dpisi@163.com
7*24小时技术支持服务热线:0731-85057097/13607439515 QQ: 400528 或 156462627

湘公网安备 43011102000746号