[FATAL] [DBT-10317] Specified SID Name (xzzhh) already exists.

最新推荐文章于 2024-07-24 02:15:02 发布

好记忆不如烂笔头abc

最新推荐文章于 2024-07-24 02:15:02 发布

阅读量5.8k

点赞数 2

分类专栏： oracle

本文链接：https://blog.csdn.net/jycjyc/article/details/98206957

版权

oracle 专栏收录该内容

433 篇文章 7 订阅

订阅专栏

[oracle templates]$ pwd
/oracle/app/oracle/product/12.2.0/dbhome_1/assistants/dbca/templates
[oracle templates]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname xzzhh -sid xzzhh -sysPassword password -systemPassword password -responseFile NO_VALUE -createAsContainerDatabase false -datafileDestination /oracle/app/oracle/oradata -redoLogFileSize 500 -recoveryAreaDestination NO_VALUE -storageType FS -characterSet ZHS16GBK -nationalCharacterSet UTF8 -sampleSchema false -memoryPercentage 70 -databaseType OLTP -emConfiguration NONE
[FATAL] [DBT-10317] Specified SID Name (xzzhh) already exists.
ACTION: Specify a different SID Name that does not already exist.
[oracle templates]$ dbca -silent -deleteDatabase -sourceDB xzzhh -sysDBAUserName sys -sysDBAPassword password
[FATAL] [DBT-10201] Delete database operation cannot be performed.
CAUSE: There are no databases present on the system.
[oracle templates]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname xzzhh -sid xzzhh -sysPassword password -systemPassword password -responseFile NO_VALUE -createAsContainerDatabase false -datafileDestination /oracle/app/oracle/oradata -redoLogFileSize 500 -recoveryAreaDestination NO_VALUE -storageType FS -characterSet ZHS16GBK -nationalCharacterSet UTF8 -sampleSchema false -memoryPercentage 70 -databaseType OLTP -emConfiguration NONE
[FATAL] [DBT-10317] Specified SID Name (xzzhh) already exists.
ACTION: Specify a different SID Name that does not already exist.
[oracle templates]$ ps -ef|grep ora_
oracle 7278 1 0 15:11 ? 00:00:00 ora_smon_xzzhh

处理方法:
1.在/etc/oratab去掉最后加入的数据库信息
2.检查进程是否存在ps -ef|grep ora_smon，然后kill掉