Re: emca fails to create database control repository with ORA-01034

On Jan 19, 10:52 am, "Frank R." <tre..._at_gmail.com> wrote:
> Hello,
>
> After installing Oracle 10.2.0.3 software and successfully creating a
> database (named "10gr2") I'm trying to setup EM Database Control.
>
> This is the command I execute:
>
> ***********************************************************
>  $ emca -config dbcontrol db -repos create
>
> STARTED EMCA at Jan 18, 2008 8:52:20 AM
> EM Configuration Assistant, Version 10.2.0.1.0 Production
> Copyright (c) 2003, 2005, Oracle.  All rights reserved.
>
> Enter the following information:
> Database SID: 10gr2
> Listener port number: 1521
> Password for SYS user:
> Password for DBSNMP user:
> Invalid username/password. [ORA-01034: ORACLE not available]
> *****************************************************
>
> I don't know why it says "Oracle not available" since both instance
> and listener are up and running.
>
> EMCA log reports this:
> ************************************
> Jan 18, 2008 8:53:02 AM oracle.sysman.emcp.util.GeneralUtil
> initSQLEngine
> CONFIG: SQLEngine connecting with SID: 10gr2, oracleHome: /oracle/app/
> oracle/product/10.2.0, and user: SYS
> Jan 18, 2008 8:53:02 AM oracle.sysman.emcp.util.GeneralUtil
> initSQLEngine
> CONFIG: SQLEngine created successfully and connected
> Jan 18, 2008 8:53:02 AM oracle.sysman.emcp.DatabaseChecks
> validateUserCredentials
> CONFIG: 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.jav­a:
> 1467)
>         at
> oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.ja­va:
> 694)
>         at
> oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:
> 1049)
>         at
> oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.ja­va:
> 1017)
>         at
> oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:
> 2702)
>         at
> oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:
> 591)
>         at
> oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java­:
> 2249)
>         at
> oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAs­sistant.java:
> 2275)
>         at
> oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfig­Assistant.java:
> 2302)
>         at
> oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant­.java:
> 946)
>         at
> oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:
> 469)
>         at
> oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:418)
> ***********************************
>
> Metalink and google have not been helpful  regarding this problem:(
>
> Need help or advice on this, please.
>
> Thanks in advance.

You might check the TNSNAME.ora file.

Check on both the client machine and server. Received on Sat Jan 19 2008 - 12:38:30 CST