Configuration of Enterprise Manager in Oracle Applications R12

  Before starting with the configuration of EM on Oracle R12 Database Node, check if the password file exists.(Password file is required for Authentication of users logging in as SYSDBA)

As Oracle Database owner

$cd $ORACLE_HOME/dbs

$ls orapw<SID>

If password file doesn’t exist, create one.

$ orapwd file=orapw password= entries=5

Set the parameter remote_login_passwordfile=EXCLUSIVE

After this make sure you are able to connect to database as SYSDBA from Application Tier.

Manually configuring EM (Steps to be performed as Database owner)

$ emca -config dbcontrol db -repos create

STARTED EMCA at Jan 28, 2011 2:26:17 PM
EM Configuration Assistant, Version 11.1.0.7.0 ProductionCopyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:Database SID: <SID>

Listener port number: <Port No.>

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/xxxxx/db/tech_st/11.1.0

Local hostname ……………. XXXXXX.xxxx.com

Listener port number ……………. <Port No.>

Database SID ……………. XXXX

Email address for notifications ……………

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

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

Jan 28, 2011 2:27:36 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/xxxxx/db/tech_st/11.1.0/cfgtoollogs/emca/XXXX/emca_2011_01_28_14_26_17.log.Jan 28, 2011 2:27:38 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) …INFO: Uploading configuration data to EM repository (this may take a while) …Jan 28, 2011 3:18:57 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyJan 28, 2011 3:19:00 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLibINFO: Software library configured successfully.Jan 28, 2011 3:19:00 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Deploying Provisioning archives …Jan 28, 2011 3:19:20 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Provisioning archives deployed successfully.Jan 28, 2011 3:19:20 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) …Jan 28, 2011 3:19:41 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Jan 28, 2011 3:19:41 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) …Jan 28, 2011 3:20:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyJan 28, 2011 3:20:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://xxxxxx.xxxx.com:1158/em <<<<<<<<<<<Jan 28, 2011 3:20:34 PM oracle.sysman.emcp.EMDBPostConfig invokeWARNING:************************  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: /mnt1/dbdev/db/tech_st/11.1.0/srvdevl.ccil.com_DEV/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************Enterprise Manager

configuration completed successfullyFINISHED EMCA at Jan 28, 2011 3:20:34 PM
$
Login to EM with URL listed above.