精华内容
下载资源
问答
  • 一、RAC启动关闭顺序启动RAC顺序:1 启动HA (建议两节点分别启动,重起机器第一次...关闭RAC顺序:1 关闭instance (详见第2节)2 关闭CRS (两节点都要执行)3 关闭HA软件 (如果没有必要可以不关闭HA)二、启停instance ...

    一、RAC启动关闭顺序

    启动RAC顺序:

    1 启动HA (建议两节点分别启动,重起机器第一次启动HA软件oracle会自动启动)

    2 启动CRS (两节点都要执行)

    3 启动instance 默认会跟着CRS一并启动,如果没有启动可以单独启动。

    关闭RAC顺序:

    1 关闭instance (详见第2节)

    2 关闭CRS (两节点都要执行)

    3 关闭HA软件 (如果没有必要可以不关闭HA)

    二、启停instance (oracle用户执行)

    注意:PSDSS/SGDC 的RAC存在两个instance (dcods , bietl),需要分别启停

    2.1启动指定instance (三种方法)

    (1) 启动DCODS实例 (包括两节点)

    srvctl start database -d dcods

    (2) 启动DCODS实例中的两个节点实例

    srvctl start instance –d dcods –i dcods1

    srvctl start instance –d dcods –i dcods2

    (3) export ORACLE_SID=dcods1 (单节点)

    sqlplus /nolog

    conn / as sysdba

    shutdown immediate

    export ORACLE_SID=dcods2 (单节点)

    sqlplus /nolog

    conn / as sysdba

    shutdown immediate

    2.2停止指定instance

    (1) 停止DCODS实例

    srvctl stop database -d bietl

    (2) 停止DCODS实例中的两个节点实例

    srvctl stop instance –d dcods –i dcods1

    srvctl stop instance –d dcods –i dcods2

    (–d代表database –i代表每个节点的SID)

    2.3启停Listener

    (1) 启动listener

    dcods实例

    srvctl start listener -n dcods1

    srvctl start listener -n dcods2

    (2) 停止listener

    dcods实例

    srvctl stop listener -n dcods1

    srvctl stop listener -n dcods2

    2.3启停srv服务(一般会默认启动)

    如果使用crs_stat -t查看发现.srv没有启动可以使用一下方法启动

    启动关闭service

    srvctl start service –d dcods (–s dcods)

    srvctl stop service –d dcods (–s dcods)

    三、启停CRS (ROOT用户执行)

    3.1启动CRS (两节点分别都要执行)

    AIX 系统 /etc/init.crs start

    HP-UX系统 /sbin/init.d/init.crs start

    Linux 系统 /etc/init.d/init.crs start

    默认:CRS启动后会自动启动instance

    等待3分钟左右

    再用oracle用户登陆运行crs_stat –t命令查看实例是否启动

    3.2停止CRS (两节点分别都要执行)

    AIX 系统 /etc/init.crs stop

    HP-UX系统 /sbin/init.d/init.crs stop

    Linux 系统 /etc/init.d/init.crs stop

    等待3分钟左右

    ps -ef|grep crs

    停止前会显示两个进程:init.csd 和 grep crs

    四、启停HACMP (ROOT用户执行)

    4.1启动HA

    (1)smitty clstart

    先选择启动的两个节点(dcods1+dcods2)

    (2)选择需要启动的两个节点(按ESC+7 选择多节点)

    (3)按回车确认启动的节点

    如果选择错误可以取消

    取消键是F3

    列表键是F4

    (4)检查VG是否挂载成功 (两节点都要执行)

    4.2停止HA

    首先执行smitty clstop

    五、启停Service Guard (ROOT用户执行)

    5.1 查看Service Guard状态

    # cmviewcl

    CLUSTER STATUS

    cluster up

    NODE STATUS STATE

    sxjydb1 up running

    PACKAGE STATUS STATE AUTO_RUN NODE

    jydbpkg1 up running enabled sxjydb1

    NODE STATUS STATE

    sxjydb2 up running

    PACKAGE STATUS STATE AUTO_RUN NODE

    jydbpkg2 up running enabled sxjydb2

    5.2 启动 Service Guard

    (1)

    sxjydb1# cmrunnode sxjydb1

    sxjydb2# cmrunnode sxjydb2

    cmrunnode: Validating network configuration...

    cmrunnode: Network validation complete

    cmrunnode: Validating cluster lock disk .... Done

    Waiting for nodes to join ..... done

    Cluster successfully formed.

    Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.

    (如果是开机后第一次启动Service Guard,可以自动把oracle启动起来)

    5.3 关闭Service Guard

    sxjydb1# cmhaltnode -f sxjydb1

    Disabling all packages from starting on nodes to be halted.

    Warning: Do not modify or enable packages until the halt operation is completed.

    Disabling automatic failover for failover packages to be halted.

    Halting package jydbpkg1

    Successfully halted package jydbpkg1

    Waiting for nodes to halt .... done

    Successfully halted all nodes specified.

    Halt operation complete.

    sxjydb2# cmviewcl

    CLUSTER STATUS

    cluster up

    NODE STATUS STATE

    sxjydb1 down halted

    sxjydb2 up running

    PACKAGE STATUS STATE AUTO_RUN NODE

    jydbpkg2 up running enabled sxjydb2

    UNOWNED_PACKAGES

    PACKAGE STATUS STATE AUTO_RUN NODE

    jydbpkg1 down halted enabled unowned

    sxjydb2# cmhaltnode -f sxjydb2

    5.4 Service Guard的package管理

    停止package

    cmhaltpkg jydbpkg1

    cmhaltpkg jydbpkg2

    启动package

    # cmrunpkg

    # cmrunpkg -n jydbpkg1

    # cmrunpkg -n jydbpkg2

    六、重起机器

    6.1 AIX系统重起计算机

    root用户:# cd /

    # shutdown -Fr

    关闭计算机

    root用户:# cd /

    # shutdown

    6.2 HP-UX系统重起计算机

    root用户:# cd /

    # shutdown -ry 0

    关闭计算机

    root用户:# cd /

    # shutdown

    6.3 Linux系统

    重启计算机 : reboot

    展开全文
  • oracle rac 启停命令

    千次阅读 2018-06-21 21:01:57
    转载:https://blog.csdn.net/wmjcode/article/details/53558327-----关闭RAC数据库-----1.关闭监听(grid用户),阻止新的程序在连接进来srvctl stop listener2.写脏块alter systerm checkpoint;(多执行几次)3....

    转载:https://blog.csdn.net/wmjcode/article/details/53558327

    -----关闭RAC数据库-----

    1.关闭监听(grid用户),阻止新的程序在连接进来
    srvctl stop listener
    2.写脏块
    alter systerm checkpoint;(多执行几次)
    3.关闭数据库(grid用户下) racdb指的是数据库全局唯一名。执行时间会较长,不要终止
    /u01/app/11.2.0/grid/bin/srvctl stop database -d racdb -o immediate
    4.关闭集群件(root用户)
    /u01/app/11.2.0/grid/bin/crsctl stop cluster -all
    5.查看资源状态
    /u01/app/11.2.0/grid/bin/crsctl status resource -t
    6.关闭操作系统(root)
     shutdown -h now


    -----------启动RAC数据库-----
    1.默认情况下,集群软件会随着操作系统的启动而启动(root)。
    检查集群资源:/u01/app/11.2.0/grid/bin/crsctl status resource -t   --所有都需要是online状态
    启动集群资源:/u01/app/11.2.0/grid/bin/crsctl start cluster -all


    2.启动数据库(grid)
    srvctl start database -d racdb
    3.查看监听状态。默认情况下监听会随着集群软件启动(grid)。
    srvctl status listener   --查看监听状态
    srvctl start listener    --启动监听
    4.登录plsql进行连接测试。
    展开全文
  • oracle RAC数据库启停

    千次阅读 2016-12-10 14:40:20
    ------关闭RAC数据库----- 1.关闭监听(grid用户),阻止新的程序在连接进来 srvctl stop listener 2.写脏块 alter systerm checkpoint;(多执行几次) 3.关闭数据库(grid用户下) racdb指的是数据库全局唯一名。...
    ------关闭RAC数据库-----
    
    1.关闭监听(grid用户),阻止新的程序在连接进来
    srvctl stop listener
    2.写脏块
    alter systerm checkpoint;(多执行几次)
    3.关闭数据库(grid用户下) racdb指的是数据库全局唯一名。执行时间会较长,不要终止
    /u01/app/11.2.0/grid/bin/srvctl stop database -d racdb -o immediate
    4.关闭集群件(root用户)
    /u01/app/11.2.0/grid/bin/crsctl stop cluster -all
    5.查看资源状态
    /u01/app/11.2.0/grid/bin/crsctl status resource -t
    6.关闭操作系统(root)
     shutdown -h now


    -----------启动RAC数据库-----
    1.默认情况下,集群软件会随着操作系统的启动而启动(root)。
    检查集群资源:/u01/app/11.2.0/grid/bin/crsctl status resource -t   --所有都需要是online状态
    启动集群资源:/u01/app/11.2.0/grid/bin/crsctl start cluster -all


    2.启动数据库(grid)
    srvctl start database -d racdb
    3.查看监听状态。默认情况下监听会随着集群软件启动(grid)。
    srvctl status listener   --查看监听状态
    srvctl start listener    --启动监听
    4.登录plsql进行连接测试。
    展开全文
  • oracle 11g rac启停

    千次阅读 2017-06-06 14:26:20
    1.熟悉主要进程的启停顺序 1.1 启动节点rac1: 1 [root@rac1 bin]# ./crsctl start crs -excl 2 CRS-4123: Oracle High Availability Services has been started. --启动OHASD进程 3 CRS-2672: ...

    1.熟悉主要进程的启停顺序

    1.1 启动节点rac1:

    复制代码
     1 [root@rac1 bin]# ./crsctl start crs -excl
     2 CRS-4123: Oracle High Availability Services has been started.  --启动OHASD进程
     3 CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
     4 CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
     5 CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded             --启动ora.gipcd
     6 CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded             --启动ora.mdnsd
     7 CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
     8 CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded             --启动ora.gpnpd
     9 CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
    10 CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded       --启动ora.cssdmonitor
    11 CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
    12 CRS-2679: Attempting to clean 'ora.diskmon' on 'rac1'
    13 CRS-2681: Clean of 'ora.diskmon' on 'rac1' succeeded           --清除ora.diskmon
    14 CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
    15 CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded           --启动ora.diskmon
    16 CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded              --启动ora.cssd
    17 CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
    18 CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'
    19 CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded             --启动ora.ctssd
    20 CRS-2676: Start of 'ora.drivers.acfs' on 'rac1' succeeded      --启动ora.drivers.acfs
    21 CRS-2672: Attempting to start 'ora.asm' on 'rac1'             
    22 CRS-2676: Start of 'ora.asm' on 'rac1' succeeded               --启动ora.asm
    23 CRS-2672: Attempting to start 'ora.crsd' on 'rac1'             
    24 CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded              --启动ora.crsd
    25 
    26 观察节点rac2:                                                 --节点未启动,说明 crsctl start crs -excl 只启动单节点进程
    27 [root@rac2 bin]# ps -ef|grep grid          
    28 root      5823  4165  0 23:26 pts/1    00:00:00 grep grid
    29 [root@rac2 bin]# 
    复制代码

    1.2 关闭节点rac1

    复制代码
     1 [root@rac1 bin]# ./crsctl stop crs -f
     2 CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' 
     3 CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'                                            
     4 CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded                               --关闭ora.crsd
     5 CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'                                      
     6 CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
     7 CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
     8 CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
     9 CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
    10 CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeeded                        --关闭ora.cssdmonitor         
    11 CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded                              --关闭ora.mdnsd
    12 CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded                              --关闭ora.ctssd
    13 CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded                       --关闭ora.drivers.acfs
    14 CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded                                --关闭ora.asm   
    15 CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
    16 CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded                               --关闭ora.cssd
    17 CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
    18 CRS-2673: Attempting to stop 'ora.diskmon' on 'rac1'
    19 CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded                              --关闭ora.gpnpd
    20 CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
    21 CRS-2677: Stop of 'ora.diskmon' on 'rac1' succeeded                            --关闭ora.diskmon
    22 CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded                              --关闭ora.gipcd
    23 CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed --关闭OHASD进程
    24 CRS-4133: Oracle High Availability Services has been stopped.
    25 [root@rac1 bin]#
    复制代码

      总结:重要进程的启动顺序为:OHASD -> ora.gpnpd -> ora.cssd -> ora.asm -> ora.crsd

    2. 了解独占模式 -excl

      既然是以独占模式启动,那么有些资源一定是不能被其他节点共享的。出现抢占资源会出现什么情况

    2.1 启动节点rac1:

    复制代码
     1 [root@rac1 bin]# ./crsctl start crs -excl                   -- -excl表示以独占模式启动
     2 CRS-4123: Oracle High Availability Services has been started.
     3 CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
     4 CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
     5 CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
     6 CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
     7 CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
     8 CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
     9 CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
    10 CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
    11 CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
    12 CRS-2679: Attempting to clean 'ora.diskmon' on 'rac1'
    13 CRS-2681: Clean of 'ora.diskmon' on 'rac1' succeeded
    14 CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
    15 CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
    16 CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
    17 CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
    18 CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'
    19 CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
    20 CRS-2676: Start of 'ora.drivers.acfs' on 'rac1' succeeded
    21 CRS-2672: Attempting to start 'ora.asm' on 'rac1'
    22 CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
    23 CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
    24 CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded
    25 [root@rac1 bin]#
    复制代码

    2.2 RAC1在独占模式下时,看看节点RAC2抢占资源时会发生什么:

    复制代码
     1 [root@rac2 bin]# ./crsctl start crs -excl
     2 CRS-4123: Oracle High Availability Services has been started.
     3 CRS-2672: Attempting to start 'ora.gipcd' on 'rac2'
     4 CRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'
     5 CRS-2676: Start of 'ora.gipcd' on 'rac2' succeeded
     6 CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeeded
     7 CRS-2672: Attempting to start 'ora.gpnpd' on 'rac2'
     8 CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeeded
     9 CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'
    10 CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded
    11 CRS-2672: Attempting to start 'ora.cssd' on 'rac2'
    12 CRS-2679: Attempting to clean 'ora.diskmon' on 'rac2'
    13 CRS-2681: Clean of 'ora.diskmon' on 'rac2' succeeded
    14 CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'
    15 CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded
    16 CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminating
    17 CRS-2674: Start of 'ora.cssd' on 'rac2' failed
    18 CRS-2679: Attempting to clean 'ora.cssd' on 'rac2'
    19 CRS-2681: Clean of 'ora.cssd' on 'rac2' succeeded
    20 CRS-2673: Attempting to stop 'ora.diskmon' on 'rac2'
    21 CRS-2677: Stop of 'ora.diskmon' on 'rac2' succeeded
    22 CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac2'
    23 CRS-2677: Stop of 'ora.cssdmonitor' on 'rac2' succeeded
    24 CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'
    25 CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded
    26 CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'
    27 CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded
    28 CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
    29 CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
    30 CRS-4000: Command Start failed, or completed with errors.
    31 [root@rac2 bin]# 
    复制代码

      出现状况了(CRS-4402,CRS-2674),现在看看两个节点的的进程状况.

    2.3 查看两个节点此时的进程状况

    复制代码
     1 节点RAC1的进程状态:
     2 [root@rac1 bin]# ps -ef|grep grid
     3 root     16810     1  0 00:56 ?        00:00:01 /u01/grid/bin/ohasd.bin exclusive
     4 grid     16944     1  0 00:56 ?        00:00:00 /u01/grid/bin/oraagent.bin
     5 grid     16959     1  0 00:56 ?        00:00:00 /u01/grid/bin/gipcd.bin
     6 grid     16964     1  0 00:56 ?        00:00:00 /u01/grid/bin/mdnsd.bin
     7 grid     16983     1  0 00:56 ?        00:00:00 /u01/grid/bin/gpnpd.bin
     8 root     17020     1  0 00:56 ?        00:00:00 /u01/grid/bin/orarootagent.bin
     9 grid     17640     1  0 01:02 ?        00:00:00 /u01/grid/bin/diskmon.bin -d -f
    10 root     17708 14498  0 01:06 pts/1    00:00:00 grep grid
    11 [root@rac1 bin]#
    12 
    13 节点RAC2的进程状态:
    14 [root@rac2 bin]# ps -ef|grep grid
    15 root      8557     1  0 01:01 ?        00:00:01 /u01/grid/bin/ohasd.bin exclusive
    16 root      8929  7581  0 01:08 pts/1    00:00:00 grep grid
    17 [root@rac2 bin]#
    复制代码

      哈哈,在争夺资源时RAC1,RAC2两败俱伤!独占模式一般用于数据库恢复,升级时。

          以非独占模式启动则是去掉 -excl:crsctl start crs

    3. crsctl start crs与crsctl start cluster 区别

    复制代码
     1 启动命令:crsctl start  cluster
     2 --[root@rac1 bin]# ./crsctl start  cluster
     3 CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
     4 CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
     5 CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
     6 CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
     7 CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
     8 CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
     9 CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
    10 CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
    11 CRS-2672: Attempting to start 'ora.asm' on 'rac1'
    12 CRS-2672: Attempting to start 'ora.evmd' on 'rac1'
    13 CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded
    14 CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
    15 CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
    16 CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded
    17 [root@rac1 bin]#
    复制代码

      crsctl start/stop cluster 命令只是控制Start CRS stack(ora.cssdmonitor,ora.cssd,ora.diskmon,ora.ctssd,ora.asm,ora.crsd)。

          使用命令 crsctl start/stop cluster 的前提是OHASD进程已经被启动

    结论:crsctl start/stop crs  管理 CRS 包含进程 OHASD ;

       crsctl start/stop cluster 不包含OHASD进程,必须要先启动 OHASD 进程才可以使用

    展开全文
  • HACMP&RAC启停操作

    2014-02-28 09:26:05
    AIX操作系统双机HACMP以及oracle数据库双机RAC启停简易操作步骤。
  • oracle 10g rac 启停归档模式 假设Oracle数据库执行在归档模式,当进行数据库维护时,可能须要暂停数据库的归档,在完毕维护后,再又一次启动归档模式。 通过下面步骤能够从归档模式转换为非归档模式: ...
  • ORACLE RAC单节点启停

    千次阅读 2018-10-10 16:02:36
    Oracle Product集群因OS需要打patch需要单独关闭节点进行维护,机器为个人测试Oracle 11g R2测试集群 操作步骤 --确认集群的db_unique_name,本初的db_unique_name为orcl SQL> show parameter name NAME TYPE ...
  • Oacle RAC 启停命令

    2020-05-25 14:58:52
    一、RAC启停 --停止 1、关闭监听,阻止新的程序在连接进来 [grid@gsrzdb01 ~]$ srvctl stop listener 2、写脏块(多执行几次) SQL> alter system checkpoint; 3.关闭数据库 [grid@gsrzdb01 bin]$ /u01/11.2.0/...
  • 关闭第一个节点:通过 ssh 方式登录至主机上,执行如下命令:$ emctl stop dbconsole$ srvctl stop instance -d jzcddb -i jzcddb1 -o immediate $ srvctl stop nodeapps -n sxcddb1# crsctl stop crs开启第一个节点...
  • ORACLE 12C RAC数据库的启停

    千次阅读 2018-07-18 22:53:59
    【前言】Oracle 12c RAC已经慢慢开始普及使用了,这边简单整理了RAC服务的启停操作。 【环境说明】 数据库版本:12.2.0.1 操作系统:Center OS 7.0 ...
  • 在安装Oracle RAC集群环境后,与集群有关的进程会自动启动。这样就带来了一个问题,似乎这里有不可控的因素在里面。在默认情况下,主机重新启动后集群进程会随操作系统而启动,因主机在启动的过程中会消耗比较大的...
  • 在安装Oracle RAC集群环境后,与集群有关的进程会自动启动。这样就带来了一个问题,似乎这里有不可控的因素在里面。在默认情况下,主机重新启动后集群进程会随操作系统而启动,因主机在启动的过程中会消耗比较大的...
  • 对于unknown的进程要crs_stop -f 加进程名再startcrs启动失败 crs_start -all CRS-0184: ...因为crs_start属于应用层的指令,启动crs的时候会失败[oracle@host1 ~]$ crs_start -allCRS-0184: Cannot communicate ...
  • 数据库rac启停步骤.txt

    千次阅读 2014-12-09 15:52:09
    用root用户登录10.13.32.10/12数据库服务器执行下列操作: 查询oracle安装目录 1、root用户登录 2、su - oracle 3、echo $ORA_CRS_HOME (/u01/oracle/crs) 切换回root用户 
  • sysPassword Oracle123 -systemPassword Oracle123 -emConfiguration NONE -dbsnmpPassword Oracle123 -sysmanPassword Oracle123 -storageType ASM -asmsnmpPassword oracle -diskGroupName DATADG -sampleSchema ...
  • rac启停方法

    2013-01-29 00:14:46
    [oracle@rac2 admin]$ srvctl stop nodeapps -n rac1 [oracle@rac2 admin]$ crs_stat -t Name Type Target State Host  ------------------------------------------------------------ ora.oradb.db ...
  • Oracle10g RAC关闭及启动步骤   情况1:需要关闭DB(所有实例),OS及Server。 a.首先停止Oracle10g环境 $ lsnrctl stop (每个节点上停止监听,也可以用srvctl来操作) 或者 $ srvctl stop listener -n ...
  • oracle 12C RAC 服务的启停

    千次阅读 2016-07-06 13:32:38
    单节点数据库起 srvctl stop instance -d vmtoradb -i vmtoradb1 srvctl stop instance -d vmtoradb -i vmtoradb2 srvctl start instance -d vmtoradb -i vmtoradb1 srvctl start instance...
  • 检查cluster状态[root@rac1bin]# ./crsctl stat res -tCRS-4535:Cannot communicate with Cluster Ready ServicesCRS-4000:Command Status failed, or completed with errors.[root@rac1bin]# ./crsctl check ...
  • 本文主要分享一些Oracle RAC日常基本维护命令,希望对你有所帮助。1、所有实例和服务的状态$srvctlstatusdatabase-dorclInstanceorcl1isrunningonnodelinux1Instanceorcl2isrunningonnodelinux22、单个实例的状态$...
  • Oracle 12.1 RAC集群arfs文件系统 OGG启停命令 查看当前ogg运行状态 /u01/app/12.1.0/grid/bin/agctl status goldengate oggapp 以CRS方式 启动ogg进程 /u01/app/12.1.0/grid/bin/agctl start goldengate oggapp 以...
  • ORACLE数据库启停概述

    2019-05-28 09:15:02
    只要使用过oracle database,那么肯定执行过很多次的startup和shutdown的操作,但是你是否关心过这个过程发生了什么?这篇文章主要讲讲oracle启动与停止过程oracle后台发生的事情。 实例与数据库  首先需要弄清楚...
  • RAC集群启停的总结

    千次阅读 2018-02-01 14:52:54
    方法一:srvctl操作rac集群启停的用法 一、RAC集群的分步关闭 rac集群的关闭顺序: 关闭数据库实例>关闭asm实例>关闭集群服务 1.关闭数据库实例 #su - grid $cd /u01/app/11.2.0/grid/bin $...
  • 谈谈ORACLE启停

    千次阅读 2018-03-18 08:29:16
    (例如RAC就是 one to many 的),但是绝对不存在一个实例对应多个数据库的情况。  实例启动的时候,会为其分配一个叫System Global Area(SGA)的系统全局区的内存区域以及一系列的后台进程,它们的主要任务是: *...
  • 只要使用过oracle database,那么肯定执行过很多次的startup和shutdown的操作,但是你是否关心过这个过程发生了什么?这篇文章主要讲讲oracle启动与停止过程oracle后台发生的事情。实例与数据库首先需要弄清楚一些...
  • oracle数据库启停错误

    2017-12-05 10:30:29
    oracle遇到启动和停止错误为: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist linux: export ORACLE_SID=orcl2 sqlplus /nolog   windows: set...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 648
精华内容 259
关键字:

oraclerac启停