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.