我在 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。