二, GI静默安装
1, vi .bash_profile 节点一
-
export EDITOR=vi
-
export ORACLE_SID=+ASM1
-
export ORACLE_BASE=/u01/app/oracle
-
export ORACLE_HOME=/u01/11.2.0/grid
-
export GRID_HOME=/u01/11.2.0/grid
-
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
-
export THREADS_FLAG=native
-
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
-
umask 022
节点2
export ORACLE_SID=+ASM1 改成 +ASM2
2, 验证是否满足安装条件 节点一操作
[grid@huy1 grid]$ ./runcluvfy.sh stage -pre crsinst -n huy1,huy2 -fixup -verbose
验证结果
验证通过
3, 编写 response文件 静默安装,没有图形化安装的 人机交互的机会,必须把图形安装的那些输入值 用 response文件传进去
安装包解压后,response文件的模板在response目录下的 crs_install.rsp。可以借用它来修改。
我的response文件如下。( 图形安装配置结束时,可以保存当前配置 到 response文件。以后也可以基于这个response文件来调整)
-
###############################################################################
-
## Copyright(c) Oracle Corporation 1998,2008. All rights reserved. ##
-
## ##
-
## Specify values for the variables listed below to customize ##
-
## your installation. ##
-
## ##
-
## Each variable is associated with a comment. The comment ##
-
## can help to populate the variables with the appropriate ##
-
## values. ##
-
## ##
-
## IMPORTANT NOTE: This file contains plain text passwords and ##
-
## should be secured to have read permission only by oracle user ##
-
## or db administrator who owns this installation. ##
-
## ##
-
###############################################################################
-
-
###############################################################################
-
## ##
-
## Instructions to fill this response file ##
-
## To install and configure \'Grid Infrastructure for Cluster\' ##
-
## - Fill out sections A,B,C,D,E,F and G ##
-
## - Fill out section G if OCR and voting disk should be placed on ASM ##
-
## ##
-
## To install and configure \'Grid Infrastructure for Standalone server\' ##
-
## - Fill out sections A,B and G ##
-
## ##
-
## To install software for \'Grid Infrastructure\' ##
-
## - Fill out sections A,B and C ##
-
## ##
-
## To upgrade clusterware and/or Automatic storage management of earlier ##
-
## releases ##
-
## - Fill out sections A,B,C,D and H ##
-
## ##
-
###############################################################################
-
#------------------------------------------------------------------------------
-
# Do not change the following system generated value.
-
#------------------------------------------------------------------------------
-
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
-
-
###############################################################################
-
# #
-
# SECTION A - BASIC #
-
# #
-
###############################################################################
-
-
#-------------------------------------------------------------------------------
-
# Specify the hostname of the system as set during the install. It can be used
-
# to force the installation to use an alternative hostname rather than using the
-
# first hostname found on the system. (e.g., for systems with multiple hostnames
-
# and network interfaces)
-
#-------------------------------------------------------------------------------
-
ORACLE_HOSTNAME=huy1
-
-
#-------------------------------------------------------------------------------
-
# Specify the location which holds the inventory files.
-
#-------------------------------------------------------------------------------
-
INVENTORY_LOCATION=/u01/app/oraInventory
-
-
#-------------------------------------------------------------------------------
-
# Specify the languages in which the components will be installed.
-
#
-
# en : English ja : Japanese
-
# fr : French ko : Korean
-
# ar : Arabic es : Latin American Spanish
-
# bn : Bengali lv : Latvian
-
# pt_BR: Brazilian Portuguese lt : Lithuanian
-
# bg : Bulgarian ms : Malay
-
# fr_CA: Canadian French es_MX: Mexican Spanish
-
# ca : Catalan no : Norwegian
-
# hr : Croatian pl : Polish
-
# cs : Czech pt : Portuguese
-
# da : Danish ro : Romanian
-
# nl : Dutch ru : Russian
-
# ar_EG: Egyptian zh_CN: Simplified Chinese
-
# en_GB: English (Great Britain) sk : Slovak
-
# et : Estonian sl : Slovenian
-
# fi : Finnish es_ES: Spanish
-
# de : German sv : Swedish
-
# el : Greek th : Thai
-
# iw : Hebrew zh_TW: Traditional Chinese
-
# hu : Hungarian tr : Turkish
-
# is : Icelandic uk : Ukrainian
-
# in : Indonesian vi : Vietnamese
-
# it : Italian
-
#
-
# Example : SELECTED_LANGUAGES=en,fr,ja
-
#-------------------------------------------------------------------------------
-
SELECTED_LANGUAGES=en
-
-
#-------------------------------------------------------------------------------
-
# Specify the installation option.
-
# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY
-
# CRS_CONFIG - To configure Grid Infrastructure for cluster
-
# HA_CONFIG - To configure Grid Infrastructure for stand alone server
-
# UPGRADE - To upgrade clusterware software of earlier release
-
# CRS_SWONLY - To install clusterware files only (can be configured for cluster
-
# or stand alone server later)
-
#-------------------------------------------------------------------------------
-
oracle.install.option=CRS_CONFIG
-
-
#-------------------------------------------------------------------------------
-
# Specify the complete path of the Oracle Base.
-
#-------------------------------------------------------------------------------
-
-
ORACLE_BASE=/u01/app/oracle
-
-
#-------------------------------------------------------------------------------
-
# Specify the complete path of the Oracle Home.
-
#-------------------------------------------------------------------------------
-
ORACLE_HOME=/u01/11.2.0/grid
-
-
################################################################################
-
# #
-
# SECTION B - GROUPS #
-
# #
-
# The following three groups need to be assigned for all GI installations. #
-
# OSDBA and OSOPER can be the same or different. OSASM must be different #
-
# than the other two. #
-
# #
-
################################################################################
-
#-------------------------------------------------------------------------------
-
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.OSDBA=asmdba
-
-
#-------------------------------------------------------------------------------
-
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.OSOPER=asmoper
-
-
#-------------------------------------------------------------------------------
-
# The OSASM_GROUP is the OS group which is to be granted OSASM privileges. This
-
# must be different than the previous two.
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.OSASM=asmadmin
-
-
################################################################################
-
# #
-
# SECTION C - SCAN #
-
# #
-
################################################################################
-
#-------------------------------------------------------------------------------
-
# Specify a name for SCAN
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.gpnp.scanName=huy-scan
-
-
#-------------------------------------------------------------------------------
-
# Specify a unused port number for SCAN service
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.gpnp.scanPort=1521
-
-
################################################################################
-
# #
-
# SECTION D - CLUSTER & GNS #
-
# #
-
################################################################################
-
#-------------------------------------------------------------------------------
-
# Specify a name for the Cluster you are creating.
-
#
-
# The maximum length allowed for clutername is 15 characters. The name can be
-
# any combination of lower and uppercase alphabets (A - Z), (0 - 9), hyphen(-)
-
# and underscore(_).
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.clusterName=huy-cluster
-
-
#-------------------------------------------------------------------------------
-
# Specify \'true\' if you would like to configure Grid Naming Service(GNS), else
-
# specify \'false\'
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.gpnp.configureGNS=false
-
-
#-------------------------------------------------------------------------------
-
# Applicable only if you choose to configure GNS
-
# Specify the GNS subdomain and an unused virtual hostname for GNS service
-
# Additionally you may also specify if VIPs have to be autoconfigured
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.gpnp.gnsSubDomain=
-
oracle.install.crs.config.gpnp.gnsVIPAddress=
-
oracle.install.crs.config.autoConfigureClusterNodeVIP=false
-
-
#-------------------------------------------------------------------------------
-
# Specify a list of public node names, and virtual hostnames that have to be
-
# part of the cluster.
-
#
-
# The list should a comma-separated list of nodes. Each entry in the list
-
# should be a colon-separated string that contains 2 fields.
-
#
-
# The fields should be ordered as follows:
-
# 1. The first field is for public node name.
-
# 2. The second field is for virtual host name
-
# (specify as AUTO if you have chosen \'auto configure for VIP\'
-
# i.e. autoConfigureClusterNodeVIP=true)
-
#
-
# Example: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.clusterNodes=huy1:huy1-vip,huy2:huy2-vip
-
-
#-------------------------------------------------------------------------------
-
# The value should be a comma separated strings where each string is as shown below
-
# InterfaceName:SubnetMask:InterfaceType
-
# where InterfaceType can be either \"1\" or \"2\"(2 indicates private, and 1 indicates public)
-
#
-
# For example: eth0:140.87.24.0:1,eth1:140.87.40.0:2,eth2:140.87.52.0:1
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.privateInterconnects=eth0:192.168.56.0:1,eth1:10.10.10.0:2
-
-
################################################################################
-
# #
-
# SECTION E - STORAGE #
-
# #
-
################################################################################
-
-
#-------------------------------------------------------------------------------
-
# Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting
-
# Disks files
-
# - ASM_STORAGE
-
# - FILE_SYSTEM_STORAGE
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.storageOption=ASM_STORAGE
-
-
-
#-------------------------------------------------------------------------------
-
# THIS PROPERTY NEEDS TO BE FILLED ONLY IN CASE OF WINDOWS INSTALL.
-
# Specify a comma separated list of strings where each string is as shown below:
-
# Disk Number:Partition Number:Drive Letter:Format Option
-
# The Disk Number and Partition Number should refer to the location which has to
-
# be formatted. The Drive Letter should refer to the drive letter that has to be
-
# assigned. \"Format Option\" can be either of the following -
-
# 1. SOFTWARE - Format to place software binaries.
-
# 2. DATA - Format to place the OCR/VDSK files.
-
#
-
# For example: 1:2:P:DATA,1:3:Q:SOFTWARE,1:4:R:DATA,1:5:S:DATA
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
-
-
#-------------------------------------------------------------------------------
-
# These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for
-
# storing OCR and voting disk
-
# Specify the location(s) and redundancy for OCR and voting disks
-
# Multiple locations can be specified, seprated by commas.
-
# In case of windows, mention the drive location that is specified to be
-
# formatted for DATA in the above property.
-
# Redundancy can be one of these:
-
# NORMAL - one(1) location should be specified for OCR and voting disk
-
# EXTERNAL - three(3) locations should be specified for OCR and voting disk
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
-
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
-
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
-
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
-
-
################################################################################
-
# #
-
# SECTION F - IPMI #
-
# #
-
################################################################################
-
-
#-------------------------------------------------------------------------------
-
# Specify \'true\' if you would like to configure Intelligent Power Management interface
-
# (IPMI), else specify \'false\'
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.useIPMI=false
-
-
#-------------------------------------------------------------------------------
-
# Applicable only if you choose to configure IPMI
-
# i.e. oracle.install.crs.config.useIPMI=true
-
# Specify the username and password for using IPMI service
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.config.ipmi.bmcUsername=
-
oracle.install.crs.config.ipmi.bmcPassword=
-
-
################################################################################
-
# #
-
# SECTION G - ASM #
-
# #
-
################################################################################
-
#-------------------------------------------------------------------------------
-
# Specify a password for SYSASM user of the ASM instance
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.SYSASMPassword=
-
-
#-------------------------------------------------------------------------------
-
# The ASM DiskGroup
-
#
-
# Example: oracle.install.asm.diskGroup.name=data
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.diskGroup.name=OCR_VOTE
-
-
#-------------------------------------------------------------------------------
-
# Redundancy level to be used by ASM.
-
# It can be one of the following
-
# - NORMAL
-
# - HIGH
-
# - EXTERNAL
-
# Example: oracle.install.asm.diskGroup.redundancy=NORMAL
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.diskGroup.redundancy=NORMAL
-
-
#-------------------------------------------------------------------------------
-
# List of disks to create a ASM DiskGroup
-
#
-
# Example: oracle.install.asm.diskGroup.disks=/oracle/asm/disk1,/oracle/asm/disk2
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.diskGroup.disks=ORCL:OCR_VOTE1,ORCL:OCR_VOTE2,ORCL:OCR_VOTE3
-
-
#-------------------------------------------------------------------------------
-
# The disk discovery string to be used to discover the disks used create a ASM DiskGroup
-
#
-
# Example: oracle.install.asm.diskGroup.diskDiscoveryString=/oracle/asm/*
-
#
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.diskGroup.diskDiscoveryString=
-
-
#-------------------------------------------------------------------------------
-
# oracle.install.asm.monitorPassword=password
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.monitorPassword=
-
-
################################################################################
-
# #
-
# SECTION H - UPGRADE #
-
# #
-
################################################################################
-
#-------------------------------------------------------------------------------
-
# Specify nodes for Upgrade.
-
# Example: oracle.install.crs.upgrade.clusterNodes=node1,node2
-
#-------------------------------------------------------------------------------
-
oracle.install.crs.upgrade.clusterNodes=
-
-
#-------------------------------------------------------------------------------
-
# For RAC-ASM only. oracle.install.asm.upgradeASM=true/false
-
#-------------------------------------------------------------------------------
-
oracle.install.asm.upgradeASM=false
4, 开始静默安装 节点一操作
[grid@huy1 grid]$ ./runInstaller -ignorePrereq -silent -force -responseFile /home/grid/grid.rsp
反馈信息如下
-
Starting Oracle Universal Installer...
-
-
Checking Temp space: must be greater than 80 MB. Actual 8521 MB Passed
-
Checking swap space: must be greater than 150 MB. Actual 3071 MB Passed
-
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-11_04-04-17PM. Please wait ...[grid@huy1 grid]$ Xlib: connection to \"localhost:10.0\" refused by server
-
Xlib: SSH gateway: X11 authentication failed.
-
-
[grid@huy1 grid]$ [WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
-
CAUSE: Oracle recommends that the SYS password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
-
ACTION: Provide a password that conforms to the Oracle recommended standards.
-
[WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
-
CAUSE: Oracle recommends that the ASMSNMP password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
-
ACTION: Provide a password that conforms to the Oracle recommended standards.
-
[WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
-
CAUSE: Oracle recommends that the SYS password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
-
ACTION: Provide a password that conforms to the Oracle recommended standards.
-
[WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
-
CAUSE: Oracle recommends that the ASMSNMP password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
-
ACTION: Provide a password that conforms to the Oracle recommended standards.
-
You can find the log of this install session at:
-
/u01/app/oraInventory/logs/installActions2014-09-11_04-04-17PM.log
-
The following configuration scripts need to be executed as the \"root\" user.
-
#!/bin/sh
-
#Root scripts to run
-
-
/u01/app/oraInventory/orainstRoot.sh
-
/u01/11.2.0/grid/root.sh
-
To execute the configuration scripts:
-
1. Open a terminal window
-
2. Log in as \"root\"
-
3. Run the scripts
-
4. Return to this window and hit \"Enter\" key to continue
-
-
Configuration assistants have not been run. This can happen for following reasons - either root.sh is to be run before config or Oracle Universal Installer was invoked with the -noConfig option.
-
\"/u01/11.2.0/grid/cfgtoollogs/configToolAllCommands\" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
-
-
-
Successfully Setup Software.
-
-
[grid@huy1 grid]$ /u01/11.2.0/grid/cfgtoollogs/configToolAllCommands
-
Setting the invPtrLoc to /u01/11.2.0/grid/oraInst.loc
-
-
perform - mode is starting for action: configure
-
-
-
perform - mode finished for action: configure
-
-
You can see the log file: /u01/11.2.0/grid/cfgtoollogs/oui/configActions2014-09-11_04-20-21-PM.log
安装过程中,在两边的节点都用root运行
/u01/app/oraInventory/orainstRoot.sh 和 /u01/11.2.0/grid/root.sh 两个脚本。跟图形安装一样的。
5, 编写配置脚本的 response文件 节点一操作
[grid@huy1 ~]$ vi /u01/11.2.0/grid/cfgrsp.properties 内容填写
-
oracle.assistants.server|S_SYSPASSWORD=oracle
-
oracle.assistants.server|S_SYSTEMPASSWORD=oracle
-
oracle.assistants.server|S_SYSMANPASSWORD=oracle
-
oracle.assistants.server|S_DBSNMPPASSWORD=oracle
-
oracle.assistants.server|S_HOSTUSERPASSWORD=oracle
-
oracle.assistants.server|S_ASMSNMPPASSWORD=oracle
6, 运行配置脚本 节点一操作
[grid@huy1 ~]$ /u01/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/u01/11.2.0/grid/cfgrsp.properties
验证结果
监听配置
-
[grid@huy1 grid]$ lsnrctl
-
-
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-SEP-2014 16:20:34
-
-
Copyright (c) 1991, 2009, Oracle. All rights reserved.
-
-
Welcome to LSNRCTL, type \"help\" for information.
-
-
LSNRCTL> status
-
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
-
STATUS of the LISTENER
-
------------------------
-
Alias LISTENER
-
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
-
Start Date 11-SEP-2014 16:20:28
-
Uptime 0 days 0 hr. 0 min. 7 sec
-
Trace Level off
-
Security ON: Local OS Authentication
-
SNMP OFF
-
Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
-
Listener Log File /u01/app/oracle/diag/tnslsnr/huy1/listener/alert/log.xml
-
Listening Endpoints Summary...
-
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
-
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.101)(PORT=1521)))
-
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=1521)))
-
Services Summary...
-
Service \"+ASM\" has 1 instance(s).
-
Instance \"+ASM1\", status READY, has 1 handler(s) for this service...
-
The command completed successfully
口令文件
-
[grid@huy1 ~]$ cd $ORACLE_HOME/dbs
-
[grid@huy1 dbs]$ ls
-
ab_+ASM1.dat hc_+ASM1.dat init.ora orapwd+ASM peshm_+ASM_1
crs 资源状态
-
[grid@huy1 dbs]$ crs_stat -t
-
Name Type Target State Host
-
------------------------------------------------------------
-
ora....ER.lsnr ora....er.type ONLINE ONLINE huy1
-
ora....N1.lsnr ora....er.type ONLINE ONLINE huy1
-
ora....VOTE.dg ora....up.type ONLINE ONLINE huy1
-
ora.asm ora.asm.type ONLINE ONLINE huy1
-
ora.eons ora.eons.type ONLINE ONLINE huy1
-
ora.gsd ora.gsd.type OFFLINE OFFLINE
-
ora....SM1.asm application ONLINE ONLINE huy1
-
ora....Y1.lsnr application ONLINE ONLINE huy1
-
ora.huy1.gsd application OFFLINE OFFLINE
-
ora.huy1.ons application ONLINE ONLINE huy1
-
ora.huy1.vip ora....t1.type ONLINE ONLINE huy1
-
ora....SM2.asm application ONLINE ONLINE huy2
-
ora....Y2.lsnr application ONLINE ONLINE huy2
-
ora.huy2.gsd application OFFLINE OFFLINE
-
ora.huy2.ons application ONLINE ONLINE huy2
-
ora.huy2.vip ora....t1.type ONLINE ONLINE huy2
-
ora....network ora....rk.type ONLINE ONLINE huy1
-
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
-
ora.ons ora.ons.type ONLINE ONLINE huy1
-
ora....ry.acfs ora....fs.type ONLINE ONLINE huy1
-
ora.scan1.vip ora....ip.type ONLINE ONLINE huy1
7, 创建其他ASM磁盘组
-
[grid@huy1 dbs]$ sqlplus \'/as sysasm\'
-
-
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 11 16:36:59 2014
-
-
Copyright (c) 1982, 2009, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
-
With the Real Application Clusters and Automatic Storage Management options
-
-
SQL> select instance_name, host_name, status from v$instance;
-
-
INSTANCE_NAME
-
----------------
-
HOST_NAME STATUS
-
---------------------------------------------------------------- ------------
-
+ASM1
-
huy1 STARTED
-
-
-
SQL> select instance_name, host_name, status from gv$instance;
-
-
INSTANCE_NAME
-
----------------
-
HOST_NAME STATUS
-
---------------------------------------------------------------- ------------
-
+ASM1
-
huy1 STARTED
-
-
+ASM2
-
huy2 STARTED
-
-
SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
-
-
NAME STATE TYPE TOTAL_MB FREE_MB
-
------------------------------ ----------- ------ ---------- ----------
-
OCR_VOTE MOUNTED NORMAL 2892 1966
-
-
SQL> create diskgroup DATA external redundancy disk \'/dev/oracleasm/disks/DATA1\',\'/dev/oracleasm/disks/DATA2\';
-
-
Diskgroup created.
-
-
SQL> create diskgroup RCY normal redundancy failgroup fg1 disk \'/dev/oracleasm/disks/RCY1\'
-
2 failgroup fg2 disk \'/dev/oracleasm/disks/RCY2\';
-
-
Diskgroup created.
-
-
SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
-
-
NAME STATE TYPE TOTAL_MB FREE_MB
-
------------------------------ ----------- ------ ---------- ----------
-
OCR_VOTE MOUNTED NORMAL 2892 1966
-
DATA MOUNTED EXTERN 9554 9502
-
RCY MOUNTED NORMAL 5976 5874
-
-
SQL> show parameter asm
-
-
NAME TYPE VALUE
-
------------------------------------ ----------- ------------------------------
-
asm_diskgroups string DATA, RCY
-
asm_diskstring string /dev/oracleasm/disks/*
-
asm_power_limit integer 1
-
asm_preferred_read_failure_groups string
-
SQL>
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12238525/viewspace-1290619/
,如需转载,请注明出处,否则将追究法律责任。