在使用Oracle 12c尝试在容器数据库中创建可插拔数据库时遇到“无效用户名/密码”错误。 “数据库配置助手”尝试加载容器数据库ORCL的信息时发生此错误。请找出错误的截图如下：ORA-01017：无效的用户名/密码;登录被Oracle 12c“数据库配置助手”工具引发被拒绝
正如你可以看到农田“用户名”和“密码”是灰色的。我可以通过使用sqlplus(sqlplus/as sysdba)访问OCRL数据库。
我可以看到在日志文件C以下异常：\ oracle12c \用户名\ cfgtoollogs \ DBCA \ dbcaui.log
---＃开始堆栈跟踪＃----------- ---------------- ID：mons.util.exception.DefaultErrorAdvisor：1824 oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException：ORA-01017：invalid用户名密码;登录被拒绝
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:987)
at oracle.sysman.assistants.util.PluggableDatabaseUtils.isCDB(PluggableDatabaseUtils.java:278)
at oracle.sysman.assistants.dbca.wizard.view.DatabaseListPage.doValidate(DatabaseListPage.java:911)
at oracle.sysman.assistants.util.wizard.WizardPanel.validate(WizardPanel.java:269)
at mons.flow.validation.ValidationHelper.validateView(ValidationHelper.java:168)
at mons.flow.AbstractFlowExecutor.validate(AbstractFlowExecutor.java:391)
at mons.flow.AbstractFlowExecutor.leaveVertex(AbstractFlowExecutor.java:644)
at mons.flow.AbstractFlowExecutor.transition(AbstractFlowExecutor.java:336)
at mons.flow.AbstractFlowExecutor.nextState(AbstractFlowExecutor.java:276)
at mons.flow.AbstractFlowExecutor.nextViewState(AbstractFlowExecutor.java:235)
at mons.flow.DefaultFlowNavigator.goForward(DefaultFlowNavigator.java:58)
at mons.flow.jewt.FlowWizard$1.run(FlowWizard.java:137)
at mons.flow.jewt.FlowWizard$TransitionManager$1.run(FlowWizard.java:113)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:682)
有关如何解决问题的任何想法？
谢谢。
UPDATE
这是我的tnsnames.ora C的含量：\ oracle12c \ icirillo \产品\ 12.1.0 \ dbhome_1 \网络\ ADMIN \ tnsnames.ora中
# tnsnames.ora Network Configuration File: C:\oracle12c\icirillo\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.)
#(SERVICE_NAME = ORCL)
)
)
更新2
我想出了另一件事。如果在DBCA中，当我到达数据库列表窗体(上图中的那个窗体)时选择“删除数据库”(而不是“管理可插入数据库 - >创建可插入数据库”)，然后单击下一步，我不遇到同样的问题，我可以导航到下一个表单没有任何问题(没有显示错误消息)。
更新3 当在安装日志看我能注意到一个与磁盘空间的问题。也许这可能会损坏一些东西。我会尝试重新安装。
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/18/ 17:38:43
ORA-19870: error while restoring backup piece C:\ORACLE12C\ICIRILLO\PRODUCT\12.1.0\DBHOME_1\ASSISTANTS\DBCA\TEMPLATES\SAMPLESCHEMA.DFB
ORA-19504: failed to create file "C:\ORACLE12C\ICIRILLO\ORADATA\ORCL\PDBORCL\EXAMPLE01.DBF"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
RMAN>
echo set on
[Thread-7] [ -05-18 17:38:45.110 CEST ] [RmanFileRestorer.restoreFiles:222] reset _catalog_foreign_restore
[Thread-7] [ -05-18 17:38:45.220 CEST ] [PlugDatabaseStep.executeImpl:240] ERROR :oracle.sysman.assistants.dbca.backend.storage.FileRestoreException: Error while restoring PDB backup piece
[Thread-7] [ -05-18 17:38:45.220 CEST ] [BasicStep.configureSettings:353] messageHandler being [emailprotected]f304
[Thread-7] [ -05-18 17:38:45.220 CEST ] [CreatePDBAfterCDBCreationStep.executeImpl:376] Error while restoring PDB backup piece
[Thread-7] [ -05-18 17:38:45.220 CEST ] [CreatePDBAfterCDBCreationStep.executeImpl:377] Pluggable Database pdborcl creation failed
oracle12c没有单库口令 ORA-01017：无效的用户名/密码;登录被Oracle 12c“数据库配置助手”工具引发被拒绝...
