emca fails to create database control repository with ORA-01034

From: Francisco Rodera <trek1s_at_gmail.com>
Date: Mon, 11 Feb 2008 21:52:29 +0100
Message-ID: <1c05bf770802111252r7f68c66eg990420df92cbf36d@mail.gmail.com>

Hello,

After installing Oracle 10.2.0.3 (on RHEL 5) 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)

---

Environment seems correctly configured:

[ora10_at_pegasus ~]$ env | grep ORA

ORACLE_SID=10gr2
ORACLE_HOSTNAME=pegasus
ORACLE_BASE=/oracle/app/oracle/
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/

[ora10_at_pegasus ~]$ hostname

pegasus

And, I insist, both instance and listener are up as well as users SYS, DBSNMP and SYSMAN are unlocked. (I've verified this several times)

Metalink and google have not been helpful regarding this problem :(

Need help or advice on this, please.

Thanks in advance.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 11 2008 - 14:52:29 CST