Linux平台Oracle 11g单实例 + ASM存储 安装部署 快速参考(四)

2015-04-07 14:09:39 · 作者: · 浏览: 93
d/S999rc.local &&


ln -sf /etc/rc.d/rc.local /etc/rc.d/rc2.d/S999rc.local &&


ln -sf /etc/rc.d/rc.local /etc/rc.d/rc3.d/S999rc.local &&


ln -sf /etc/rc.d/rc.local /etc/rc.d/rc4.d/S999rc.local &&


ln -sf /etc/rc.d/rc.local /etc/rc.d/rc5.d/S999rc.local &&


ln -sf /etc/rc.d/rc.local /etc/rc.d/rc6.d/S999rc.local


15.重启测试


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


15.1 关闭数据库


# su - oracle


$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 12 14:14:38 2015


Copyright (c) 1982, 2013, Oracle.? All rights reserved.


Connected to:


Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


With the Partitioning, Automatic Storage Management, OLAP, Data Mining


and Real Application Testing options


?


SQL> shutdown immediate


Database closed.


Database dismounted.


ORACLE instance shut down.


SQL>


15.2 关闭has


$ su - grid


Password:


$ crsctl stop has


CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jy-db'


CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'jy-db'


CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'jy-db'


CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'jy-db' succeeded


CRS-2677: Stop of 'ora.DATA1.dg' on 'jy-db' succeeded


CRS-2679: Attempting to clean 'ora.DATA1.dg' on 'jy-db'


CRS-2681: Clean of 'ora.DATA1.dg' on 'jy-db' succeeded


CRS-2673: Attempting to stop 'ora.asm' on 'jy-db'


CRS-2677: Stop of 'ora.asm' on 'jy-db' succeeded


CRS-2673: Attempting to stop 'ora.cssd' on 'jy-db'


CRS-2677: Stop of 'ora.cssd' on 'jy-db' succeeded


CRS-2673: Attempting to stop 'ora.evmd' on 'jy-db'


CRS-2677: Stop of 'ora.evmd' on 'jy-db' succeeded


CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jy-db' has completed


CRS-4133: Oracle High Availability Services has been stopped.


15.3 重启主机


# sync


# sync


# sync


# shutdown -Fr now


?


Broadcast message from root@JY-DB


? ? ? ? (/dev/pts/0) at 14:20 ...


?


The system is going down for reboot NOW!


15.4主机启动后,查看crs状态


# /u01/app/11.2.0/grid/bin/crsctl stat res -t


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


NAME? ? ? ? ? TARGET? STATE? ? ? ? SERVER? ? ? ? ? ? ? ? ? STATE_DETAILS? ? ?


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


Local Resources


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


ora.DATA1.dg


? ? ? ? ? ? ? ONLINE? ONLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


ora.LISTENER.lsnr


? ? ? ? ? ? ? ONLINE? ONLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


ora.asm


? ? ? ? ? ? ? ONLINE? ONLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? Started? ? ? ? ? ?


ora.ons


? ? ? ? ? ? ? OFFLINE OFFLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


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


Cluster Resources


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


ora.cssd


? ? ? 1? ? ? ? ONLINE? ONLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


ora.diskmon


? ? ? 1? ? ? ? OFFLINE OFFLINE? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


ora.evmd


? ? ? 1? ? ? ? ONLINE? ONLINE? ? ? jy-db? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?


ora.jyzhao.db


? ? ? 1? ? ? ? OFFLINE OFFLINE? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Instance Shutdown?


15.5 启动数据库


# /u01/app/11.2.0/grid/bin/srvctl start database -d jyzhao


# /u01/app/11.2.0/grid/bin/crsctl stat res -t


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


NAME? ? ? ? ? TARGET? STATE? ? ? ? SERVER? ? ? ? ? ? ? ? ? STATE_DETAILS? ? ?


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