Search This Blog

maintaining oracle database control(not actually oracle enterprize manager)

case 0) creating DB control if you already do not have it.

emca -config dbcontrol db -repos create

It will prompt for listener port/home, passwords for sys,dbsnmp and sysman. It will also prompt if you want to use smtp to send email alerts so it needs smtp host name and your email id from which alerts are sent

case 1) If you already have  Oracle DB control existing in your database(which is mistakenly called Oracle Enterprise manager in dba community) and you change your hostname then service of oracle enterprize manager(I will also use same wrong terminology) does not start because of hostname mismatch in configuration. In this case you do not need to drop DB control and repository and create Oracle DB control from scratch. You only need to configure Oracle Enterprize manager again.

So you only need to run below two commands followed by instructions given by oracle.

emca -deconfig dbcontrol db
emca -config dbcontrol db

case 2) If you want to drop oracle enterprize manager before upgrade or downgrade of database then it is good idea you con drop Oracle enterprize manager dbcontrol alongwith repository(sysman) from following command.

emca -deconfig dbcontrol db -repos drop

Some times oracle is able to drop repositort successfully but it can not deconfigure dbcontrol , in this case delete directory my-PC_orcl here my_PC is host name and orcl is dbname for which oem was configured. This case is also required when you want to create enterprize manager again,after dropping it as in this case it will report dbconfig already exists

case 3) if for some reason "emca -deconfig dbcontrol db" does not work then you can try command given in case 2)

case 4) if you think you have corrupted DB contrrol (Oracle enterprize manager) repository then you can run

emca -deconfig dbcontrol db -repose recreate

emca -deconfig dbcontrol db -repose create

case 5) Oracle enterprize manager can not be starting due changed time zone of the host, in this case you can set environment variable TZ to point to the original time zone which is recorded in enterprize manager repository

case 6)  getting rid of https for oracle enterprize manager
it is very easy, this comes handy when browsers does not support oem over https or when want fast response

emctl unsecure dbconsole

This will unsecure oracle enterprize manager and you get rid of https

Note: dropping Oracle enterprize manager puts database in quiesce mode so all new operations and connections are stalled. So be prepared for this outage

C:\Users\testuser>emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 22, 2013 8:37:46 PM
EM Configuration Assistant, Version Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.
Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------

Follow by Email