Ao executar o dbca para criar uma nova instância me deparei com o seguinte erro:
|
1 2 3 4 |
[oracle@bdoracle]$ dbca -silent -createDatabase -templateName New_Database.dbt -gdbName ORCL -characterSet WE8MSWIN1252 -sysPassword passccmoracle -systemPassword passccmoracle -emConfiguration NONE -databaseType OLTP -redoLogFileSize 300 -recoveryAreaDestination /u02/fra |
|
1 2 3 4 |
[WARNING] [DBT-10328] Specified GDB Name (ORCL) 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 (ORCL) already exists. ACTION: Specify a different SID Name that does not already exist. |
Ao analisar identifiquei que já havia ocorrido a tentativa de criar uma instância com o nome ORCL
Executar o dbca para remover.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
[oracle@bdoracle]$ dbca -silent -deleteDatabase -sourceDB ORCL -sysDBAPassword password -sysDBAUserName SYS The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the database will be destroyed. Do you want to proceed? Connecting to database DBCA_PROGRESS : 4% DBCA_PROGRESS : 5% ORA-12547: TNS:lost contact DBCA_PROGRESS : 10% DBCA_PROGRESS : 14% DBCA_PROGRESS : 19% DBCA_PROGRESS : 24% DBCA_PROGRESS : 29% ORA-12547: TNS:lost contact DBCA_PROGRESS : 47% Updating network configuration files DBCA_PROGRESS : 52% Deleting instance and datafiles DBCA_PROGRESS : 76% DBCA_PROGRESS : 100% Database deletion completed. |
Lembrar de excluir do arquivo oratab a linha:
|
1 |
ORCL:/u01/oracle/product/12.2.0/dbhome_1:Y |