Oracle

使用 DBCA 創建數據庫時出錯

  • August 20, 2019

我在 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 的新手並且是自學成才的,那麼我該如何解決這個問題?

不支持基本作業系統,找到支持的作業系統。

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ladbi/operating-system-checklist-for-oracle-database-installation-on-linux.html#GUID-E5C0A90E-7750-45D9-A8BC-C7319ED934F0

我建議直接使用虛擬機而不是您的機器,這應該有助於嘗試不同的配置,這些配置可能無法直接從您的機器上進行。

對於失去的聯繫,請檢查 Listener 中配置的主機名。

然後,您可以檢查該主機名解析到哪個 IP。

對於試用版,只需修改您的主機文件並將 localhost、系統名稱和 FQDN 映射到 127.0.0.1。

引用自:https://dba.stackexchange.com/questions/243865