Tuesday, 20 August 2013

Configuration of Enterprise Manager in Oracle Applications R12


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.

No comments:

Post a Comment