oracle 12c静默建库,oracle 12c 12.2 rac 静默建库报错 [FATAL] [DBT-05801] There are no ASM disk groups detected....

oracle 12c 12.2 静默安装oracle(建库)

1、dbca应答文件

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0

gdbName=dbsec

sid=dbsec

databaseConfigType=RAC

RACOneNodeServiceName=

policyManaged=false

createServerPool=false

serverPoolName=

cardinality=

force=false

pqPoolName=

pqCardinality=

createAsContainerDatabase=false

numberOfPDBs=1

pdbName=app

useLocalUndoForPDBs=true

pdbAdminPassword=Admin123i

nodelist=node1,node2

templateName=/u01/app/oracle/12c/assistants/dbca/templates/General_Purpose.dbc

sysPassword=Admin123i

systemPassword=Admin123i

oracleHomeUserPassword=

emConfiguration=

emExpressPort=5500

runCVUChecks=true

dbsnmpPassword=Admin123i

omsHost=

omsPort=

emUser=

emPassword=

dvConfiguration=false

dvUserName=

dvUserPassword=

dvAccountManagerName=

dvAccountManagerPassword=

olsConfiguration=false

datafileJarLocation=

datafileDestination=+data1/{DB_UNIQUE_NAME}/

recoveryAreaDestination=+archive

storageType=asm

diskGroupName=+data1/{DB_UNIQUE_NAME}/

asmsnmpPassword=Admin123i

recoveryGroupName=+archive

characterSet=AL32UTF8

nationalCharacterSet=AL16UTF16

registerWithDirService=false

dirServiceUserName=

dirServicePassword=

walletPassword=

listeners=LISTENER

variablesFile=

variables=DB_UNIQUE_NAME=dbsec,ORACLE_BASE=/u01/app/oracle,PDB_NAME=app,DB_NAME=dbsec,ORACLE_HOME=/u01/app/oracle/12c,SID=dbsec

initParams=node2.undo_tablespace=UNDOTBS2,db_recovery_file_dest_size=90000MB,sga_target=4GB,node1.thread=1,node2.thread=2,diagnostic_dest={ORACLE_BASE},cluster_database=true,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,db_create_file_dest=+DATA1/{DB_UNIQUE_NAME}/,local_listener=-oraagent-dummy-,compatible=12.2.0,node1.instance_number=1,open_cursors=300,node2.instance_number=2,family:dw_helper.instance_mode=read-only,processes=1920,nls_language=AMERICAN,pga_aggregate_target=1GB,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_recovery_file_dest=+ARCHIVE,db_block_size=8192BYTES,nls_territory=AMERICA,log_archive_format=%t_%s_%r.dbf,db_name=dbsec,audit_trail=db,node1.undo_tablespace=UNDOTBS1,remote_login_passwordfile=exclusive

sampleSchema=

memoryPercentage=40

databaseType=multipurpose

automaticMemoryManagement=

totalMemory=

2、资源状态

[grid@node2 ~]$ crsctl stat res -t

Name Target State Server State details

Local Resources

ora.ARCHIVE.dg

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.ASMNET1LSNR_ASM.lsnr

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.DATA1.dg

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.ORC.dg

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.net1.network

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.ons

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

Cluster Resources

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node2 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE node1 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE node1 STABLE

ora.MGMTLSNR

1 OFFLINE OFFLINE STABLE

ora.asm

1 ONLINE ONLINE node1 Started,STABLE

2 ONLINE ONLINE node2 Started,STABLE

3 OFFLINE OFFLINE STABLE

ora.cvu

1 ONLINE ONLINE node1 STABLE

ora.node1.vip

1 ONLINE ONLINE node1 STABLE

ora.node2.vip

1 ONLINE ONLINE node2 STABLE

ora.qosmserver

1 ONLINE ONLINE node1 STABLE

ora.scan1.vip

1 ONLINE ONLINE node2 STABLE

ora.scan2.vip

1 ONLINE ONLINE node1 STABLE

ora.scan3.vip

1 ONLINE ONLINE node1 STABLE

[grid@node2 ~]$

[grid@node2 ~]$ crsctl stat res -t -init

Name Target State Server State details

Cluster Resources

ora.asm

1 ONLINE ONLINE node2 STABLE

ora.cluster_interconnect.haip

1 ONLINE ONLINE node2 STABLE

ora.crf

1 ONLINE ONLINE node2 STABLE

ora.crsd

1 ONLINE ONLINE node2 STABLE

ora.cssd

1 ONLINE ONLINE node2 STABLE

ora.cssdmonitor

1 ONLINE ONLINE node2 STABLE

ora.ctssd

1 ONLINE ONLINE node2 ACTIVE:0,STABLE

ora.diskmon

1 OFFLINE OFFLINE STABLE

ora.evmd

1 ONLINE ONLINE node2 STABLE

ora.gipcd

1 ONLINE ONLINE node2 STABLE

ora.gpnpd

1 ONLINE ONLINE node2 STABLE

ora.mdnsd

1 ONLINE ONLINE node2 STABLE

ora.storage

1 ONLINE ONLINE node2 STABLE

[grid@node2 ~]$

[grid@node2 ~]$ ps -ef | grep asm

grid 3591 1 0 Mar13 ? 00:00:01 asm_pmon_+ASM2

grid 3593 1 0 Mar13 ? 00:00:00 asm_clmn_+ASM2

grid 3595 1 0 Mar13 ? 00:00:03 asm_psp0_+ASM2

grid 3598 1 2 Mar13 ? 00:03:33 asm_vktm_+ASM2

grid 3602 1 0 Mar13 ? 00:00:01 asm_gen0_+ASM2

grid 3604 1 0 Mar13 ? 00:00:00 asm_mman_+ASM2

grid 3608 1 0 Mar13 ? 00:00:01 asm_gen1_+ASM2

grid 3612 1 0 Mar13 ? 00:00:14 asm_diag_+ASM2

grid 3614 1 0 Mar13 ? 00:00:01 asm_ping_+ASM2

grid 3616 1 0 Mar13 ? 00:00:01 asm_pman_+ASM2

grid 3618 1 0 Mar13 ? 00:00:58 asm_dia0_+ASM2

grid 3621 1 0 Mar13 ? 00:00:23 asm_lmon_+ASM2

grid 3623 1 0 Mar13 ? 00:00:30 asm_lmd0_+ASM2

grid 3625 1 0 Mar13 ? 00:00:54 asm_lms0_+ASM2

grid 3629 1 0 Mar13 ? 00:00:24 asm_lmhb_+ASM2

grid 3631 1 0 Mar13 ? 00:00:00 asm_lck1_+ASM2

grid 3633 1 0 Mar13 ? 00:00:00 asm_dbw0_+ASM2

grid 3635 1 0 Mar13 ? 00:00:00 asm_lgwr_+ASM2

grid 3637 1 0 Mar13 ? 00:00:01 asm_ckpt_+ASM2

grid 3639 1 0 Mar13 ? 00:00:00 asm_smon_+ASM2

grid 3641 1 0 Mar13 ? 00:00:00 asm_lreg_+ASM2

grid 3643 1 0 Mar13 ? 00:00:00 asm_pxmn_+ASM2

grid 3645 1 0 Mar13 ? 00:00:06 asm_rbal_+ASM2

grid 3647 1 0 Mar13 ? 00:00:02 asm_gmon_+ASM2

grid 3649 1 0 Mar13 ? 00:00:02 asm_mmon_+ASM2

grid 3651 1 0 Mar13 ? 00:00:11 asm_mmnl_+ASM2

grid 3653 1 0 Mar13 ? 00:00:39 asm_imr0_+ASM2

grid 3657 1 0 Mar13 ? 00:00:36 asm_gcr0_+ASM2

grid 3666 1 0 Mar13 ? 00:00:04 asm_lck0_+ASM2

grid 3684 1 0 Mar13 ? 00:00:28 asm_ppa7_+ASM2

grid 3699 1 0 Mar13 ? 00:00:00 asm_asmb_+ASM2

grid 3701 1 0 Mar13 ? 00:00:02 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 29662 28911 0 01:55 pts/0 00:00:00 grep --color=auto asm

[grid@node2 ~]$

SQL> show parameter asm

NAME TYPE VALUE

asm_diskgroups string ARCHIVE, DATA1

asm_diskstring string /dev/oracleasm/disks/*

asm_power_limit integer 1

asm_preferred_read_failure_groups string

SQL>

所有磁盘都是在线与挂载状态

/dev/oracleasm/disks/ 下的磁盘是grid:asmadmin

3、安装

dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp

4、报错

[oracle@node2 ~]$ dbca -force -silent -createDatabase -responseFile /home/oracle/dbca_install.rsp

[FATAL] [DBT-05801] There are no ASM disk groups detected.

CAUSE: ASM may not be configured, or ASM disk groups are not created yet.

ACTION: Create ASM disk groups, or change the storage location to File System.

[oracle@node2 ~]$

5、请问大概要怎么处理，谢谢！