erwadba 2018/04/28 08:18:54 /u01/app/12.2.0.1/grid/cdata/erwadba/backup_20180428_081854.olr 0
2018/04/28 08:18:55 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@erwadba ~]#
5. 添加 asm 资源
- $ srvctl add asm
- [grid@erwadba ~]$ srvctl add asm
6. 启动 asm 资源
- $ srvctl start asm
- [grid@erwadba ~]$ srvctl start asm
- [grid@erwadba ~]$
7. 创建 asm 的 spfile
- [grid@erwadba ~]$ sqlplus / as sysasm
- SQL*Plus: Release 12.2.0.1.0 Production on Sat Apr 28 08:24:37 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- SQL> select name,state from v$asm_diskgroup;
- NAME STATE
- ------------------------------ -----------
- TEST DISMOUNTED
- SQL> alter diskgroup test mount;
Diskgroup altered.
SQL> ho cat asm.txt
- +ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
- *.asm_diskstring='/dev/sd*'
- *.asm_power_limit=1
- *.large_pool_size=12M
- *.remote_login_passwordfile='EXCLUSIVE'
- SQL> create spfile='+TEST' from pfile='/home/grid/asm.txt';
File created.
SQL>
8. 重启 has stack
[root@erwadba ~]# /u01/app/12.2.0.1/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba'
- CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba'
- CRS-2673: Attempting to stop 'ora.TEST.dg' on 'erwadba'
- CRS-2677: Stop of 'ora.TEST.dg' on 'erwadba' succeeded
- CRS-2673: Attempting to stop 'ora.asm' on 'erwadba'
- CRS-2677: Stop of 'ora.evmd' on 'erwadba' succeeded
- CRS-2677: Stop of 'ora.asm' on 'erwadba' succeeded
- CRS-2673: Attempting to stop 'ora.CSSd' on 'erwadba'
- CRS-2677: Stop of 'ora.cssd' on 'erwadba' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@erwadba ~]# /u01/app/12.2.0.1/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@erwadba ~]#
9. 添加数据库资源, 并启动
- [oracle@erwadba ~]$ srvctl add database -db CDB -oraclehome $ORACLE_HOME -spfile +TEST/CDB/PARAMETERFILE/spfile.274.974547727
- [oracle@erwadba ~]$ srvctl start database -db cdb
10. 添加 listener, 并启动
- [grid@erwadba admin]$ srvctl add listener
- [grid@erwadba admin]$ srvctl start listener
- [grid@erwadba admin]$
来源: http://www.bubuko.com/infodetail-2578065.html