TutorialDBA - Support | Training | Consultant

Overview When you choose to create a preconfigured database during the Oracle 10g installation, you can select the Oracle Enterprise Manager (OEM) interface that you want to use to manage the database. The following options are available: Database Grid Control This option is available only if an Oracle Management Agent is installed on the system. When the Installer detects an Oracle Management Agent on the system, it allows you to choose this option and specify the Oracle Management Service that you want to use to manage the database. If an Oracle Management Agent is not installed, you must choose to use Database Control to manage the database. However, if you install Oracle Management Agent after you install Oracle Database, you can then use Grid Control to manage this database. Database Control This option is selected by default if an Oracle Management Agent is not installed on the system. However, even if a Management Agent is installed, you can still choose to configure Data...

In most of the time DBAs used to go for manual configuration of the database after the database creation. Suppose your database is cloned from other database where you have grid already installed and configured. After the cloning, in the target database the same set of configuration will not work. You have to reconfigure the same.  For that you have to drop the existing configuration first. If it is a new database you can directly configure the grid using emca. Step 1. Drop the existing configuration if it is having sysman user already present. Connect to sqlplus with sys as sysdba and check SYSMAN is exist or not SQL> Select username from dba_users where username='SYSMAN'; USERNAME ------------------------------ SYSMAN   Command to drop the existing configuration [oracle@dg2 ] $ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Jun 23, 2011 5:27:34 AM EM Configuration Assistant, Version 11.1.0.7.0 Production Copyright (c) 2003, 2005, Oracle. A...