Huaiyao's Notes

dbca issue

Got a dbca issue.

Issue

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
D01AC001:/opt/oracle/database/11gR203/dbs>dbca -silent -createDatabase -templateName General_Purpose.dbc \
> -gdbname D01DBA01 -sid D01DBA01 -sysPassword oracle -systemPassword oracle \
> -emConfiguration none -redoLogFileSize 500 -storageType ASM \
> -asmsnmpPassword abcdefg -diskGroupName API04_DATA -characterSet AL32UTF8 \
> -totalMemory 5000 -recoveryAreaDestination API04_FRA -nationalCharacterSet AL16UTF16
Copying database files
1% complete
3% complete
35% complete
Creating and starting Oracle instance
37% complete
42% complete
47% complete
52% complete
53% complete
56% complete
58% complete
Registering database with Oracle Restart
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
86% complete
96% complete
100% complete
Look at the log file "/opt/oracle/cfgtoollogs/dbca/D01DBA01/D01DBA011.log" for further details.
D01AC001:/opt/oracle/database/11gR203/dbs> cat /opt/oracle/cfgtoollogs/dbca/D01DBA01/D01DBA011.log
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 35%
Creating and starting Oracle instance
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 42%
DBCA_PROGRESS : 47%
DBCA_PROGRESS : 52%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 56%
DBCA_PROGRESS : 58%
Registering database with Oracle Restart
PRCD-1119 : Failed to create database D01DBA01 because the database unique name matches that of database D01DBA01 in the first 8 characters
DBCA_PROGRESS : 64%
Completing Database Creation
DBCA_PROGRESS : 68%
DBCA_PROGRESS : 71%
DBCA_PROGRESS : 75%
DBCA_PROGRESS : 85%
PRCR-1079 : Failed to start resource ora.d01dba01.db
CRS-5017: The resource action "ora.d01dba01.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 1901
Session ID: 53 Serial number: 1
. For details refer to "(:CLSN00107:)" in "/opt/oracle/grid/11gR203/log/slcd000dbs001/agent/ohasd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.d01dba01.db' on 'slcd000dbs001' failed
DBCA_PROGRESS : 86%
ORA-01034: ORACLE not available
DBCA_PROGRESS : 96%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/D01DBA01.
Database Information:
Global Database Name:D01DBA01
System Identifier(SID):D01DBA01

Seems don’t clean the old db clearly.

Fix

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
D01DBA01:/opt/oracle/database/11gR203/dbs>more initD01DBA01.ora
SPFILE='+PEAPIGW_DATA/D01DBA01/spfileD01DBA01.ora' # line added by Agent
D01DBA01:/opt/oracle/database/11gR203/dbs>ls |grep DBA
hc_D01DBA01.dat
initD01DBA01.ora
initD01DBA01.ora.bak.slcd000dbs001
lkD01DBA01
orapwD01DBA01
D01DBA01:/opt/oracle/database/11gR203/dbs>srvctl config database -d D01DBA01
Database unique name: D01DBA01
Database name: D01DBA01
Oracle home: /opt/oracle/database/11gR203
Oracle user: oracle
Spfile: +PEAPIGW_DATA/D01DBA01/spfileD01DBA01.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: D01DBA01
Disk Groups: PEAPIGW_DATA,API04_DATA
Services:
You have new mail in /var/mail/oracle
D01DBA01:/opt/oracle/database/11gR203/dbs>srvctl remove database -d D01DBA01
Remove the database D01DBA01? (y/[n]) y
D01DBA01:/opt/oracle/database/11gR203/dbs>more initD01DBA01.ora.bak.slcd000dbs001
SPFILE='+API04_DATA/D01DBA01/spfileD01DBA01.ora'
D01DBA01:/opt/oracle/database/11gR203/dbs>cp initD01DBA01.ora.bak.slcd000dbs001 initD01DBA01.ora
D01DBA01:/opt/oracle/database/11gR203/dbs>si
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 21 06:34:49 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3926204416 bytes
Fixed Size 2165312 bytes
Variable Size 754980288 bytes
Database Buffers 2885681152 bytes
Redo Buffers 283377664 bytes
Database mounted.
Database opened.