).
- 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.
- Finally if you want to drop the database console, use this command:
% emca -deconfig dbcontrol db