Mandalika's scratchpad: Oracle 10g: Setting up The Oracle Enterprise Manager Console

(This blog post assumes that the reader is already familiar with the idea behind the Oracle Enterprise Manager (OEM). Hence there won't be any introductory paragraphs around the OEM. And although I haven't tested it on other operating systems, I believe the steps mentioned in this blog post are applicable on all platforms.).

Create the repository for the Oracle Enterprise Manager Console.

% emca -repos create

STARTED EMCA at Feb 14, 2008 1:52:03 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: TEST <- you may have to input your database's SID
Listener port number: 1521
Password for SYS user:  change_on_install <- choose any string you like
Password for SYSMAN user:  manager <- choose any string you like

Do you wish to continue? [yes(Y)/no(N)]: y
Feb 14, 2008 1:52:39 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /export/home/oracle/cfgtoollogs/emca/TEST/emca_2008-02-14_01-52-03-AM.log.
Feb 14, 2008 1:52:39 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Feb 14, 2008 1:54:33 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 14, 2008 1:54:33 AM

emca is the Enterprise Manager Configuration Assistant. And the repository that we just created will hold a set of tables containing the internal state information of Enterprise Manager for the managed environment.

Dynamically increase the maximum number of processes that can be created for the execution of jobs, JOB_QUEUE_PROCESSES.

% sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 14 01:54:57 2008
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> alter system set job_queue_processes = 2;

System altered.

Unlock the accounts of OEM super admin user, SYSMAN; and the database monitoring agent, DBSNMP.

% sqlplus / as sysdba

SQL> alter user dbsnmp identified by dbsnmp account unlock;

User altered.

SQL> alter user sysman identified by manager account unlock;

User altered.

Configure the database control for the database that we just created (step #1)

% emca -config dbcontrol db

STARTED EMCA at Feb 14, 2008 1:55:35 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: TEST
Listener port number: 1521
Password for SYS user:  change_on_install
Password for DBSNMP user:  dbsnmp
Password for SYSMAN user:  manager
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /export/home/oracle

Database hostname ................ ben05
Listener port number ................ 1521
Database SID ................ TEST
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 14, 2008 1:56:17 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /export/home/oracle/cfgtoollogs/emca/TEST/emca_2008-02-14_01-55-35-AM.log.
Feb 14, 2008 1:56:20 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Feb 14, 2008 1:57:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 14, 2008 1:57:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ben05:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 14, 2008 1:57:57 AM

% netstat -a | grep 1158
    *.1158               *.*                0      0 799744      0 LISTEN

Grant sysdba privileges to the sys user.

 % sqlplus / as sysdba

SQL> grant sysdba to sys;

Grant succeeded.

Note:
If the grant sysdba .. command fails with an ORA-01994: GRANT failed: password file missing or disabled, make sure the parameter REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE, not to NONE. Also create the orapw<ORACLE_SID> file as shown in the following steps.

SQL> grant sysdba to sys;
 grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> show parameter password

NAME
------------------------------------
TYPE
--------------------------------------------------------------------------------
VALUE
------------------------------
remote_login_passwordfile
string
NONE

Set REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE in the init<ORACLE_SID> file, shutdown the database instance.

Login as the same OS user that owns the file $ORACLE_HOME/bin/oracle and (re)create the passwordfile as shown below.

% orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=newsyspassword entries=16 force=y
% chown oracle:dba $ORACLE_HOME/dbs/orapw$ORACLE_SID <- replace the user id and the group with yours
% chmod 4640 $ORACLE_HOME/dbs/orapw$ORACLE_SID

eg.,
% ls -l $ORACLE_HOME/dbs/orapw$ORACLE_SID
-rw-r-----   1 oracle     dba        39424 Feb 14 02:12 /export/home/oracle/dbs/orapwTEST

Start up the database and run the grant sysdba .. command again.

At this point, you should be able to access the Oracle Enterprise Manager Console through a web browser using the URL emitted in the emca -config dbcontrol db step (http://ben05:1158/em in this case).

Commands to start, stop and check the status of the console

To start the console:

emctl start dbconsole

eg.,% emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://ben05:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............................ started. 
------------------------------------------------------------------
Logs are generated in directory /export/home/oracle/ben05_TEST/sysman/log

To stop the console:

emctl stop dbconsole

eg., % emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://ben05:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ... 
 ...  Stopped.

To check the status of the console

emctl status dbconsole

eg., % emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://ben05:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.