Re: emca fails to create database control repository with ORA-01034
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: trek1s@xxxxxxxxx
- Date: Mon, 11 Feb 2008 16:11:58 -0500
*Francisco, *
**
There is a disconnect in your configuration - check out an ORACLE_HOME
variable:
EMCA:
CONFIG: SQLEngine connecting with SID: 10gr2, oracleHome:
/oracle/app/oracle/product/10.2.0, and user: SYS
ENV:
[ora10@pegasus ~]$ env | grep ORA
ORACLE_SID=10gr2
ORACLE_HOSTNAME=pegasus
ORACLE_BASE=/oracle/app/oracle/
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/
See that trailing slash ? Are you able to connect to SYS account via regular
sqlplus command ? Was database started with ORACLE_HOME set to
/oracle/app/oracle/product/10.2.0/
or /oracle/app/oracle/product/10.2.0 ?
--romas
On 2/11/08, Francisco Rodera <trek1s@xxxxxxxxx> wrote:
>
> 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@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@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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
