OEM(oracle enterprise manager)

OEM:-ORACLE ENTERPRISE MANAGER

Oracle enterprise manager provides a web based interface that you can use to manage your oracle instance and database.

SQL> alter user sysman identified by manager;

User altered.

SQL> alter user dbsnmp identified by manager;

User altered.

Go to cd $ORACLE_HOME/bin and check emca file exists are not.

[subbu@subbuapps ~]$ cd $ORACLE_HOME/bin

[subbu@subbuapps bin]$ ls emca

emca

[subbu@subbuapps ~]$ emca -config dbcontrol db -repose create

STARTED EMCA at Oct 26, 2016 5:15:15 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

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

Enter the following information:

Database SID: subbu

Listener port number: 1521

Listener ORACLE_HOME [ /u01/app/subbu/product/11.2.0.4 ]: 

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/subbu/product/11.2.0.4

Local hostname ................ subbuapps.erp.com

Listener ORACLE_HOME ................ /u01/app/subbu/product/11.2.0.4

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

Database SID ................ subbu

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

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

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

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

Oct 26, 2016 5:37:24 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/subbu/cfgtoollogs/emca/subbu/emca_2016_10_26_17_36_49.log.

Oct 26, 2016 5:37:39 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

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

Oct 26, 2016 5:40:13 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Oct 26, 2016 5:40:18 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

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

Oct 26, 2016 5:41:20 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Oct 26, 2016 5:41:20 PM oracle.sysman.emcp.util.DBControlUtil startOMS

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

Oct 26, 2016 5:43:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Oct 26, 2016 5:43:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://subbuapps.erp.com:1158/em <<<<<<<<<<<

Oct 26, 2016 5:43:15 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/subbu/product/11.2.0.4/subbuapps.erp.com_subbu/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. 

***********************************************************

Enterprise Manager configuration completed successfully

FINISHED EMCA at Oct 26, 2016 5:43:15 PM

****

if we get any errors like password file may be missing or configured incorrectly.

it means password file is missing in cd $ORACLE_HOME/dbs location so create it.

[subbu@subbuapps dbs]$ orapwd file=orapw$ORACLE_SID entries=10

Enter password for SYS: (here enter sys password)

****

copy the link https://subbuapps.erp.com:1158/em  and open it in browser.

login with username and password and connect as sysdba.

username: sys

password : manager