Good catch there Roman!! RF Robert G. Freeman Author: Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature Blog: http://robertgfreeman.blogspot.com (Oracle Press) ----- Original Message ---- From: Roman Podshivalov <roman.podshivalov@xxxxxxxxx> To: trek1s@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: Monday, February 11, 2008 2:11:58 PM Subject: Re: emca fails to create database control repository with ORA-01034 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