安装Oracle成功，但创建数据库错误，已贴错误日志

本帖最后由 chenqiuyu8888 于 2011-11-04 08:36:54 编辑

解决方案 »

  1.   

    2011-11-4 7:35:21 oracle.sysman.emcp.DatabaseChecks validateUserCredentials
    配置: Failed to update account status.
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:1197)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1113)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    2011-11-4 7:35:21 oracle.sysman.emcp.EMConfig perform
    严重: 用户名/口令无效。 [ORA-01034: ORACLE not available
    ]
    有关详细资料, 请参阅 C:\app\Lenovo\cfgtoollogs\dbca\orcl\emConfig.log 中的日志文件。
    2011-11-4 7:35:21 oracle.sysman.emcp.EMConfig perform
    配置: Stack Trace: 
    oracle.sysman.emcp.exception.EMConfigException: 用户名/口令无效。 [ORA-01034: ORACLE not available
    ]
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4097)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:1197)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1113)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    ... 11 more
    2011-11-4 7:35:21 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig addEMCALogFile
    配置: ORACLE_BASE :C:\app\Lenovo
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig perform
    信息: 正在将此操作记录到 C:\app\Lenovo\cfgtoollogs\dbca\orcl\emConfig.log。
    2011-11-4 8:19:17 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
    配置: isCRSInstalled: false
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
    2011-11-4 8:19:17 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager setFlag
    配置: Flag 'CHECK_CONFIG' set to true
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager getParam
    配置: 未设置参数 ASM_OH 的值。
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager getParam
    配置: 未设置参数 REP_DB_RUNNING_HOST 的值。
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager getParam
    配置: 未设置参数 ORACLE_HOSTNAME 的值。
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager getHost
    配置: Host having instnces running for database orcl : Lenovo-PC
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager setParam
    配置: Setting param: REP_DB_RUNNING_HOST value: Lenovo-PC
    2011-11-4 8:19:17 oracle.sysman.emcp.ParamsManager getRepDbPort
    配置: Listener Port: 1521
    2011-11-4 8:19:17 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    配置: isLocalConnectionRequired: true
    2011-11-4 8:19:17 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    配置: isLocalConnectionRequired: true. Connecting to database instance locally.
    2011-11-4 8:19:17 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\Lenovo\product\11.2.0\dbhome_1, and user: SYS
    2011-11-4 8:19:17 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: SQLEngine created successfully and connected
    2011-11-4 8:19:17 oracle.sysman.emcp.DatabaseChecks checkRestrictedMode
    配置: ORA-01034: ORACLE not availableoracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.checkRestrictedMode(DatabaseChecks.java:1146)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1070)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1626)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    2011-11-4 8:19:18 oracle.sysman.emcp.DatabaseChecks checkDataGuardEnabled
    配置: ORA-01034: ORACLE not availableoracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.checkDataGuardEnabled(DatabaseChecks.java:1171)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1077)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1626)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager getParam
    配置: 未设置参数 ASM_OH 的值。
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager getHost
    配置: Host having instnces running for database orcl : Lenovo-PC
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager setParam
    配置: Setting param: REP_DB_RUNNING_HOST value: Lenovo-PC
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager getRepDbPort
    配置: Listener Port: 1521
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    配置: isLocalConnectionRequired: true
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    配置: isLocalConnectionRequired: true. Connecting to database instance locally.
      

  2.   

    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\Lenovo\product\11.2.0\dbhome_1, and user: DBSNMP
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not existoracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
    at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
    at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1066)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager getHost
    配置: Host having instnces running for database orcl : Lenovo-PC
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager setParam
    配置: Setting param: REP_DB_RUNNING_HOST value: Lenovo-PC
    2011-11-4 8:19:18 oracle.sysman.emcp.ParamsManager getRepDbPort
    配置: Listener Port: 1521
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    配置: isLocalConnectionRequired: true
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    配置: isLocalConnectionRequired: true. Connecting to database instance locally.
    2011-11-4 8:19:18 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\Lenovo\product\11.2.0\dbhome_1, and user: SYS
    2011-11-4 8:19:19 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    配置: SQLEngine created successfully and connected
    2011-11-4 8:19:19 oracle.sysman.emcp.DatabaseChecks validateUserCredentials
    配置: Failed to update account status.
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:1197)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1113)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    2011-11-4 8:19:19 oracle.sysman.emcp.EMConfig perform
    严重: 用户名/口令无效。 [ORA-01034: ORACLE not available
    ]
    有关详细资料, 请参阅 C:\app\Lenovo\cfgtoollogs\dbca\orcl\emConfig.log 中的日志文件。
    2011-11-4 8:19:19 oracle.sysman.emcp.EMConfig perform
    配置: Stack Trace: 
    oracle.sysman.emcp.exception.EMConfigException: 用户名/口令无效。 [ORA-01034: ORACLE not available
    ]
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4097)
    at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1633)
    at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)
    at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
    at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
    at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
    at oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:1197)
    at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1113)
    at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
    at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4087)
    ... 11 more
    2011-11-4 8:19:19 oracle.sysman.emcp.EMConfig restoreOuiLoc
    配置: Restoring oracle.installer.oui_loc to C:\app\Lenovo\product\11.2.0\dbhome_1\oui
      

  3.   

    这个在Wondows下可能有个注册表的问题,可以到网上搜索一下