emca fails to create database control repository with ORA-01034

From: Frank R. <trek1s_at_gmail.com>
Date: Sat, 19 Jan 2008 08:52:11 -0800 (PST)
Message-ID: <9d7bc0d9-caab-48d6-9783-6b92e2f045d7@21g2000hsj.googlegroups.com>

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.java: 1467)

        at
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java: 694)

        at
oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java: 1049)

        at
oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java: 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(EMConfigAssistant.java: 2275)

        at
oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.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. Received on Sat Jan 19 2008 - 10:52:11 CST