Error Starting Database Control Emca
Contents |
in an Oracle RAC Environment Deleting and Creating Database Control Objects EMCA Troubleshooting Tips Database Control Overview This chapter describes the functionality and administration of Oracle how to configure enterprise manager in oracle 11g manually Enterprise Manager Database Control (Database Control), the Web-based interface and primary tool
How To Start Oracle Enterprise Manager 11g On Linux
for managing an Oracle database. Using Database Control, you can perform administrative tasks such as creating schema configure enterprise manager oracle 11g windows objects (tables, views, indexes, and so on), managing user security, managing database memory and storage, backing up and recovering your database, and importing and exporting data. You can
How To Configure Enterprise Manager In Oracle 10g
also view performance and status information about your database. After you have installed the Oracle Database software, created or upgraded a database, and configured the network, you can use Database Control to manage your database. Database Control also provides an interface for both performance advisors and Oracle utilities such as SQL*Loader and Recovery Manager (RMAN). Oracle how to configure oem in oracle 11g on linux also offers separately licensed Oracle Enterprise Manager management packs, management plug-ins, and other products that you can purchase to enhance the capabilities of Oracle Enterprise Manager in specific environments. Understanding the Enterprise Manager Directories When you install Oracle Database, you also install Database Control by default. As a result, the Oracle Database installation procedure installs a set of Enterprise Manager directories and files into the $ORACLE_HOME directory. In particular, the emctl commands required to control Database Control are installed into the $ORACLE_HOME/bin directory. The Management Agent and Management Service support files are installed in two locations in an installation of Oracle Database: Files that are common and shared among all instances of the database are stored in the following directory: $ORACLE_HOME/sysman For example, the administration files, which define the supported target types and the scripts used to perform Management Agent configuration tasks are stored in the $ORACLE_HOME/sysman/admin directory Files that are unique to each instance of the database are stored in the following directory: $ORACLE_HOME/hostname_dbuniquename/ (for
severe : error starting database control [message #571728] Thu, 29 November 2012 11:27 sam524 Messages: 77Registered: July 2012 Location:
How To Configure Enterprise Manager In Oracle 11g Rac
sydney Member hi guys, I am trying to configure OEM
Configure Dbconsole 11gr2
by following method... C:\oracle\product\10.2.0\db_1\BIN>emca -config dbcontrol db -repos recreate STARTED EMCA at 29/11/2012 18:12:37 EM emca -config dbcontrol db -repos recreate Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Database Control is already configured https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbcontrol.htm for the database orcl You have chosen to configure Database Control for managing the database orcl This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: n C:\oracle\product\10.2.0\db_1\BIN>sc delete OracleDBConsoleorcl [SC] DeleteService SUCCESS C:\oracle\product\10.2.0\db_1\BIN>emca -config dbcontrol db -repos recreate STARTED http://www.orafaq.com/forum/t/185136/ EMCA at 29/11/2012 18:24:38 EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Database Control is already configured for the database orcl You have chosen to configure Database Control for managing the database orcl This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: n C:\oracle\product\10.2.0\db_1\BIN>emca -deconfig dbcontrol db -repos drop STARTED EMCA at 29/11/2012 18:25:22 EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Listener port number: 1521 Password for SYS user: Password for SYSMAN user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y 29/11/2012 18:25:40 oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollog s\emca\orcl\emca_2012-11-29_06-25-22-PM.log. 29/11/2012 18:25:43 oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ...
Database Control is unable to start. Attempting to document every possible issue with OEM not starting and their solution would be a monumental task. However, I http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_22.shtml recently ran into a scenario that I believe was worth documenting http://www.online-database.eu/index.php/oracle-11g/133-database-control-configuration and sharing. OEM Database Control was configured on several Oracle database severs and had been running successfully for several years. One day, Database Control was not able to start on any of these database servers. Absolutely no changes were made to the environment (Oracle Database, OS, Network, how to Security, etc.). I still followed through a series of troubleshooting steps like verifying the correct hostname and reverse name lookup (nslookup). But knowing that nothing changed in the environment, I wasn't convinced the problem was being caused by a setup or configuration issue. I then tried several times to drop the OEM Database Control application and re-create it. Database how to configure Control successfully dropped and re-created, however, I was still not able to start the OEM application. ============================================================= C:\>set oracle_sid=TESTDB ============================================================= C:\>emca -deconfig dbcontrol db -repos drop STARTED EMCA at Mar 2, 2011 4:45:41 PM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: TESTDB Listener port number: 1521 Password for SYS user: xxxxxxxx Password for SYSMAN user: xxxxxxxx Password for SYSMAN user: xxxxxxxx Do you wish to continue? [yes(Y)/no(N)]: y Mar 2, 2011 4:46:04 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\TESTDB\emca_2011-03-02_04-45-41-PM.log. Mar 2, 2011 4:46:07 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Mar 2, 2011 4:46:11 PM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... Mar 2, 2011 4:46:42 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Mar 2, 2011 4:46:42 PM ============================================================= C:\>emca -config dbcontrol db -repos create STARTED EMCA at Mar 2, 2011 4:46:59 PM EM Configuration Assistant, Version 10.2.0
Resources ScriptsOracle Documentation Latest Articles Row Archival About nologging and direct path load Grant a "standard" DB user the possibility to unlock a user Redo log management in physical standby database Query dba_audit_session Succeeding with online table redefinition Which session is generating the redo ? Move datafiles online Using Invoker's Rights Versus Definer's Rights (AUTHID Clause) Script to generate role DDL Popular Articles Manage the archivelogs using RMAN How to restore an RMAN backup from TAG How to restore an RMAN cold backup on a new server. ( same OS, same Oracle version ) Grant with grant option as a workaround for ORA-01720 Flashback database using guaranteed restore point Keep RMAN backupsets Archivelogs in the flash recovery area Create manually a sql profile and set your own hints Data Guard : Adjust RMAN' s archivelog deletion policy Datapump feature : Attach to and Manage a running Datapump job 11G Database Control Configuration User Rating:/1 PoorBest Details Parent Category: Articles Created on Sunday, 21 March 2010 22:37 Last Updated on Friday, 27 September 2013 15:43 Published on Sunday, 21 March 2010 22:37 Written by Guy Lambregts Hits: 5217 The Database Control Configuration ( 11G ) See also at Oracle' s Metalink How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g (Doc ID 278100.1) This is how I configured the database control after I initially created my database without configuring it. Important to mention is thatthesomewhat unlucky hostname of my laptop is "pc_van_guy" and that these underscores triggereda severeerror while I tried to configure the Database Control. A logfile located in %ORACLE_HOME%\cfgtoollogs\emca mentionned the below error CONFIG: No value was set for the parameter ORACLE_HOSTNAME. 2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam CONFIG: No value was set for the parameter ORACLE_HOSTNAME. 2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam CONFIG: No value was set for the parameter EMAIL_ADDRESS. 2-jun-2009 22:48:04 oracle.sysman.emcp.ParamsManager getParam CONFIG: No value was set for t