问题描述:dbca建库时报错DBT-10328 DBT-10317,如下所示:
环境说明:此为删除原实例后新建实例遇到的异常.
1、异常重现
[oracle@hisdb1 ~]$ dbca -silent -createDatabase \
> -ignorePrereqFailure \
> -templateName General_Purpose.dbc \
> -responseFile NO_VALUE \
> -sid orcl \
> -gdbName orcl \
> -sysPassword oracle123 \
> -systemPassword oracle123 \
> -redoLogFileSize 1024 \
> -storageType FS \
> -databaseConfigType SINGLE \
> -datafileDestination /u01/app/oracle/oradata/orcl \
> -enableArchive true \
> -archiveLogDest /u01/app/oracle/archivelog \
> -characterset ZHS16GBK \
> -nationalCharacterSet AL16UTF16 \
> -emConfiguration NONE \
> -automaticMemoryManagement false \
> -totalMemory 21504 \
> -databaseType OLTP \
> -createAsContainerDatabase false
[WARNING] [DBT-10328] Specified GDB Name (orcl1) may have a potential conflict with an already existing database on the system.
ACTION: Specify a different GDB Name that does not conflict with existing databases on the system.
[FATAL] [DBT-10317] Specified SID Name (orcl1) already exists.
ACTION: Specify a different SID Name that does not already exist.
[oracle@hisdb1 ~]$ dbca -silent -deleteDatabase -sourceDB orcl1
Enter SYS user password:
[WARNING] [DBT-11503] The instance (orcl1) is not running on the local node. This may result in partial delete of Oracle database.
CAUSE: A locally running instance is required for complete deletion of Oracle database instance and database files.
ACTION: Specify a locally running database, or execute DBCA on a node where the database instance is running.
2、解决方案
[oracle@hisdb1 ~]$ vi /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
orcl:/u01/app/oracle/product/19.3/db_1:N (手动删除该行)
说明:如上所示手动删除/etc/oratab文件最后一行内容后,成功建库.