manually configure oracle enterprise manager

Manually Configure Oracle Enterprise Manager:

If Oracle Enterprise Manager Configuration failed in Oracle 11g R2 Installation:

Here:

HostName=sun

Post#=1521

OracleSID=orcl

Step – 1: Edit listener.ora and tnsnames.ora

Location: /u01/app/oracle/product/11.2.0/db_1/network/admin/

[oracle@sun admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File:

/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = sun)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

[oracle@sun admin]$ more listener.ora

# listener.ora Network Configuration File:

/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = sun)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /u01/app/oracle

Step – 2: Start Oracle Listener:

[oracle@sun ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JUN-2011 19:31:34

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is


Log messages written to /u01/app/oracle/diag/tnslsnr/sun/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sun)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 21-JUN-2011 19:31:50

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File


Listener Log File /u01/app/oracle/diag/tnslsnr/sun/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sun)(PORT=1521)))

The listener supports no services

The command completed successfully

Step – 3: Manually Configure OEM:

cd $ORACLE_HOME/db_1/bin

Location: /u01/app/oracle/product/11.2.0/db_1/bin

[oracle@sun bin]$ emca -config dbcontrol db -repos recreate -ORACLE_HOSTNAME sun

STARTED EMCA at Jun 21, 2011 5:52:00 PM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database SID: orcl

Listener port number: 1521

Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Local hostname ................ sun

Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Listener port number ................ 1521

Database SID ................ orcl

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

Jun 21, 2011 5:52:33 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/u01/app/oracle/cfgtoollogs/emca/orcl/emca_2011_06_21_17_52_00.log.

Jun 21, 2011 5:52:36 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...


INFO: Repository successfully dropped

Jun 21, 2011 5:55:28 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...


INFO: Repository successfully created

Jun 21, 2011 6:05:39 PM oracle.sysman.emcp.EMReposConfig

uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) ...


INFO: Uploaded configuration data successfully

Jun 21, 2011 6:07:50 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib

INFO: Software library configured successfully.

Jun 21, 2011 6:07:50 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Deploying Provisioning archives ...

Jun 21, 2011 6:09:36 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

INFO: Provisioning archives deployed successfully.

Jun 21, 2011 6:09:36 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) ...

Jun 21, 2011 6:10:01 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Jun 21, 2011 6:10:01 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Jun 21, 2011 6:11:54 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jun 21, 2011 6:11:54 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://sun:1158/em <<<<<<<<<<<

Jun 21, 2011 6:12:02 PM oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data

will be encrypted. The encryption key has been placed in the file:

/u01/app/oracle/product/11.2.0/db_1/sun_orcl/sysman/config/emkey.ora. Please

ensure this file is backed up as the encrypted data will become unusable if this file is

lost.

manually configure oracle enterprise manager

Documents