Oracle
使用 DBCA 創建數據庫時出錯
我在 Elementary OS 5.0 上使用 Oracle Database 12c R2。安裝完成,沒有任何錯誤。然後我創建了監聽器,它開始就好了。 當我使用 dbca 創建數據庫時,它顯示警告
ORA-12547: TNS: 失去聯繫
(當我執行 tnsping 127.0.0.1 它返回 OK (0 ms) )點擊忽略後,它顯示此錯誤
日誌是
[Thread-70] [ 2019-07-26 16:27:42.193 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output= [Thread-70] [ 2019-07-26 16:27:42.193 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=Recovery Manager: Release 12.2.0.1.0 - Production on Fri Jul 26 16:27:42 2019 [Thread-70] [ 2019-07-26 16:27:42.193 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output= [Thread-70] [ 2019-07-26 16:27:42.193 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. [Thread-70] [ 2019-07-26 16:27:42.764 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output= [Thread-70] [ 2019-07-26 16:27:42.765 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=RMAN> [Thread-70] [ 2019-07-26 16:27:42.861 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=RMAN-00571: =========================================================== [Thread-70] [ 2019-07-26 16:27:42.862 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== [Thread-70] [ 2019-07-26 16:27:42.862 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=RMAN-00571: =========================================================== [Thread-70] [ 2019-07-26 16:27:42.862 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=ORA-12547: TNS:lost contact [Thread-70] [ 2019-07-26 16:27:42.877 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output= [Thread-70] [ 2019-07-26 16:27:42.878 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=RMAN> [Thread-70] [ 2019-07-26 16:27:42.878 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=echo set on [Thread-70] [ 2019-07-26 16:27:42.878 WIB ] [RMANEngine.readSqlOutput:988] Log RMAN Output=set echo off; [Thread-70] [ 2019-07-26 16:27:42.878 WIB ] [RMANEngine.readSqlOutput:1031] hasError is true [Thread-70] [ 2019-07-26 16:27:42.879 WIB ] [RMANEngine.readSqlOutput:1037] ERROR TRACE DETECTED [Thread-70] [ 2019-07-26 16:27:42.879 WIB ] [RMANEngine.readSqlOutput:1044] m_errHdlr=null [Thread-70] [ 2019-07-26 16:27:42.879 WIB ] [RMANEngine.readSqlOutput:1068] FATAL ERROR DETECTED [Thread-70] [ 2019-07-26 16:27:42.879 WIB ] [RMANEngine.readSqlOutput:1132] Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=truem_bFatalErrorOccured=true [Thread-63] [ 2019-07-26 16:27:42.892 WIB ] [RMANEngine.executeImpl:1333] Completed wait from reader [Thread-63] [ 2019-07-26 16:27:42.892 WIB ] [RMANEngine.executeImpl:1348] Calling done as got exception [Thread-63] [ 2019-07-26 16:27:42.892 WIB ] [RMANEngine.done:1654] Done called [Thread-63] [ 2019-07-26 16:27:42.895 WIB ] [RMANEngine.executeImpl:1375] GOT FATAL Error=Recovery Manager: Release 12.2.0.1.0 - Production on Fri Jul 26 16:27:42 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-12547: TNS:lost contact RMAN> echo set on [Thread-63] [ 2019-07-26 16:27:42.895 WIB ] [RMANUtil.catalogBackup:741] Error while cataloging RMAN Backups: Cannot get RMANUtil [Thread-63] [ 2019-07-26 16:27:42.896 WIB ] [RmanRestoreDatafilesStep.executeImpl:171] exception renaming datafiles oracle.sysman.assistants.util.rmanEngine.RMANFatalErrorException: Error while cataloging RMAN Backups [Thread-63] [ 2019-07-26 16:27:42.896 WIB ] [BasicStep.configureSettings:383] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@6f449889 [Thread-70] [ 2019-07-26 16:27:42.901 WIB ] [RMANEngine.run:841] Return Value from readSqlOutput=null [Thread-63] [ 2019-07-26 16:27:42.896 WIB ] [BasicStep.configureSettings:383] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@6f449889 [Thread-63] [ 2019-07-26 16:27:42.906 WIB ] [StepContext$ModeRunner.run:2961] Error while cataloging RMAN Backups oracle.sysman.assistants.dbca.backend.RmanRestoreDatafilesStep.executeImpl(RmanRestoreDatafilesStep.java:172) oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:278) oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:330) oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:391) 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)
dbca 關閉了。我還是 Oracle DB 的新手並且是自學成才的,那麼我該如何解決這個問題?
不支持基本作業系統,找到支持的作業系統。
我建議直接使用虛擬機而不是您的機器,這應該有助於嘗試不同的配置,這些配置可能無法直接從您的機器上進行。
對於失去的聯繫,請檢查 Listener 中配置的主機名。
然後,您可以檢查該主機名解析到哪個 IP。
對於試用版,只需修改您的主機文件並將 localhost、系統名稱和 FQDN 映射到 127.0.0.1。