12.2 DBCA fails with ORA-17502:ksfdcre:4 Failed to create file (Doc ID 2291438.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

12.2 DBCA fails with following error while creating the database.

CREATE DATABASE "trn"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete

DBCA trace:

[Thread-258] [ 2017-07-17 17:03:16.133 BRT ] [DBEntryStep.executeImpl:494] CREATEDB without passwords = CREATE DATABASE "trn"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE SIZE 700M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 200M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 SIZE 500M,
GROUP 2 SIZE 500M,
GROUP 3 SIZE 500M
[Thread-258] [ 2017-07-17 17:03:29.477 BRT ] [SQLEngine.done:2314] Done called
[Thread-258] [ 2017-07-17 17:03:29.478 BRT ] [SQLEngine.spoolOff:2160] Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/trn/CreateDB.log
[Thread-258] [ 2017-07-17 17:03:29.479 BRT ] [BasicStep.configureSettings:383] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@37ffc17e
[Thread-258] [ 2017-07-17 17:03:29.479 BRT ] [StepContext$ModeRunner.run:2961] ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete

oracle.sysman.assistants.dbca.backend.DBEntryStep.executeImpl(DBEntryStep.java:652)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:278)
oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2941)
java.lang.Thread.run(Thread.java:745)
[Thread-258] [ 2017-07-17 17:03:31.397 BRT ] [SQLEngine.done:2314] Done called

We can see the disk group is mounted already in ASM.

SQL> select name,state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
DATA MOUNTED
ARCHIVE MOUNTED

ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 1048576 20480 20426 0 20426 0 N ARCHIVE/
MOUNTED EXTERN N 512 512 4096 4194304 102400 102300 0 102300 0 N DATA/

SQL> select name,path,os_mb,total_mb,free_mb,mode_status,header_status from v$asm_disk;

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
OS_MB TOTAL_MB FREE_MB MODE_ST HEADER_STATU
---------- ---------- ---------- ------- ------------
ARCHIVE_0000
/dev/oracleasm/ARCH_DISK01
10240 10240 10213 ONLINE MEMBER

DATA_0000
/dev/oracleasm/DATA_DISK01
102400 102400 102300 ONLINE MEMBER

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
OS_MB TOTAL_MB FREE_MB MODE_ST HEADER_STATU
---------- ---------- ---------- ------- ------------

ARCHIVE_0001
/dev/oracleasm/ARCH_DISK02
10240 10240 10213 ONLINE MEMBER

 

Strace output /tmp/kfod.strace kfod :

strace -f -o /tmp/kfod.strace kfod disks=all asm_diskstring='/dev/oracleasm/*'

30122 read(7, "\f\0d\0\0\0P\0e\0\0\0c\0f\0\0\0\200\0g\0\0\0\253\0h\0\0\0\336\0"..., 512) = 512
30122 close(7) = 0
30122 mmap(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f0129535000
30122 munmap(0x7f0129535000, 266240) = 0
30122 stat("/etc/sysconfig/64bit_strstr_via_64bit_strstr_sse2_unaligned", 0x7ffed274a060) = -1 ENOENT (No such file or directory)
30122 openat(AT_FDCWD, "/dev/oracleasm", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 7
30122 getdents(7, /* 5 entries */, 32768) = 144
30122 newfstatat(7, "DATA_DISK01", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 80), ...}, 0) = 0
30122 newfstatat(7, "ARCH_DISK02", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 64), ...}, 0) = 0
30122 newfstatat(7, "ARCH_DISK01", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 48), ...}, 0) = 0
30122 getdents(7, /* 0 entries */, 32768) = 0
30122 close(7) = 0
30122 stat("/dev/oracleasm/DATA_DISK01", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 80), ...}) = 0
30122 open("/dev/oracleasm/DATA_DISK01", O_RDONLY) = -1 EACCES (Permission denied)                                      <<-----
30122 stat("/dev/oracleasm/ARCH_DISK02", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 64), ...}) = 0
30122 open("/dev/oracleasm/ARCH_DISK02", O_RDONLY) = -1 EACCES (Permission denied)                                       <<-----
30122 stat("/dev/oracleasm/ARCH_DISK01", {st_mode=S_IFBLK|0660, st_rdev=makedev(8, 48), ...}) = 0
30122 open("/dev/oracleasm/ARCH_DISK01", O_RDONLY) = -1 EACCES (Permission denied)
30122 open("/u01/app/oracle/product/12.2.0/db/oracore/mesg/lrmus.msb", O_RDONLY) = 7

The OS disk does not have exact permission. It has to be grid:dba instead of grid:root.

The softlink is created for the disks

[root@bdgrd ~]# ls -trlh /dev/oracleasm/
total 0
lrwxrwxrwx 1 root root 6 Jul 20 10:33 DATA_DISK02 -> ../sdh  
lrwxrwxrwx 1 root root 6 Jul 20 10:33 ARCH_DISK02 -> ../sde
lrwxrwxrwx 1 root root 6 Jul 20 10:33 DATA_DISK01 -> ../sdg 
lrwxrwxrwx 1 root root 6 Jul 20 10:33 ARCH_DISK03 -> ../sdf
lrwxrwxrwx 1 root root 6 Jul 20 10:33 ARCH_DISK01 -> ../sdd

oracle@bdtrn database]$ ls -l /dev/sd*
brw-rw---- 1 root disk 8, 0 Jul 14 17:19 /dev/sda
brw-rw---- 1 root disk 8, 1 Jul 14 17:19 /dev/sda1
brw-rw---- 1 root disk 8, 2 Jul 14 17:19 /dev/sda2
brw-rw---- 1 root disk 8, 3 Jul 14 17:19 /dev/sda3
brw-rw---- 1 root disk 8, 4 Jul 14 17:19 /dev/sda4
brw-rw---- 1 root disk 8, 5 Jul 14 17:19 /dev/sda5
brw-rw---- 1 root disk 8, 16 Jul 14 17:19 /dev/sdb
brw-rw---- 1 root disk 8, 32 Jul 14 17:19 /dev/sdc
brw-rw---- 1 grid root 8, 48 Jul 20 17:53 /dev/sdd            
brw-rw---- 1 grid root 8, 64 Jul 20 17:32 /dev/sde
brw-rw---- 1 grid root 8, 80 Jul 20 17:53 /dev/sdf

 

[oracle@bdtrn trn]$ ls -trlh $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 390M Jul 17 14:40 /u01/app/oracle/product/12.2.0/db/bin/oracle             

[oracle@bdtrn ~]$ ls -ltr /u01/app/oracle/product/12.2.0/grid/bin/oracle
-rwsr-s--x 1 grid oinstall 372714122 Jul 17 13:57 /u01/app/oracle/product/12.2.0/grid/bin/oracle



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms