How to find Oracle Enterprise Manager startup time.

 

    Oracle Enterprise Manager(OEM) is an on-premises solution for a comprehensive monitoring and management solution for Oracle products such as Oracle Database and Engineered Systems. A lot of plugins, monitoring Templates, thresholds, and other features make OEM a great tool for monitoring.

    Few days ago, I was asked to find the Oracle Management Service(OMS) startup time. I googled a lot and search for a better way to present the startup time for the OEM process. Finally, after 2 hours of searching I found the solution to find the startup time of the OEM.

    Following is the step-by-step process to find the startup time of the OMS startup time.

1. Click on Setup >> Manage Cloud Control >> Management Servers.

2. Click on the Management Servers >> Monitoring >> Status History.

3. The time value in the Up Since provides the time the OMS server has been started.

4. At the top left side, there is a drop-down menu to check the Overall Availability Duration. We have the option to check availability during the last 24 hours, last 7 days, last 31 days, and custom.

Read More

Manually drop and recreate Oracle Enterprise Manager 11g Database Console repos

Login as user sys and execute DBMS_AQADM.DROP_QUEUE_TABLE. This will drop the queue table that is located on the sysman schema.

sqlplus "/ as sysdba"

DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE);

Shutdown the database and start database in restrict mode to remove dbms_jobs.

SHUTDOWN IMMEDIATE;

STARTUP RESTRICT;

Remove dbms_jobs and set em user context to 5

EXEC sysman.emd_maintenance.remove_em_dbms_jobs;

EXEC sysman.setEMUserContext('',5);

Using following PL/SQL block remove all the SYNONYMS that belongs to SYSMAN

DECLARE

CURSOR c1 IS

SELECT owner, synonym_name name

FROM dba_synonyms

WHERE table_owner = 'SYSMAN';

BEGIN

FOR r1 IN c1

LOOP

IF r1.owner = 'PUBLIC' THEN

EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;

ELSE

EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;

END IF;

END LOOP;

END;

/

Drop role mgmt_user and users mgmt_view, sysman with cascade option. Once users are dropped we can disable restricted session. This will lift an instance from restricted mode to normal.

DROP ROLE mgmt_user;

DROP user mgmt_view cascade;

DROP user sysman cascade;

ALTER SYSTEM DISABLE RESTRICTED SESSION;

Make sure SYSMAN is dropped successfully.

select username, account_status, created from dba_users where username in ('SYSMAN');

Creating em repos with the command below.

$ORACLE_HOME/bin/emca -config dbcontrol db -repos create 

In my case I got error message with insufficient privileges. Since password file is missing in my case this error has occured.

Create password file for the database.

cd $ORACLE_HOME/dbs

orapwd file=orapworcl password=oracle_4U entries=5

With new password file, em repos will be created successfully.

Read More

Oracle Enterprise Manager 13c Release 2 Cloud Control installation

For Oracle Enterprise Manager 13c R2 installation Oracle init parameter compatible parameter should be set to 12.1.0.0 or higher.
show parameter compatible;

Make sure _allow_insert_with_update_check parameter is set to be true.
alter system set "_allow_insert_with_update_check" = true;

Create Middleware Home directory, directory to store agent, BI conf, BI cluster and swlib directory.

Download Oracle Enterprise Manager Cloud Control 13c Release 2 from URL below:
http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

Change mode of the file em13200p1_linux64.bin to executable and execute the file.

The warning message will be appeared if you do not have 10GB free space on the /tmp directory. Alternatively we can provide the new tmp location for the installation.

Below is the landing page once you have started the installation process.

Uncheck the option I wish to receive security updates via My Oracle Support.

Once you uncheck the option Click on Next to continue.

Critical message will be displayed. It is safe to ignore on the test or the lab environment. Click on Yes to continue.

Click Skip on the Software updates and Click on Next to continue.

Prerequisite checks will be performed. Make sure that the status of all the checks are Succeeded. If there is any failure, fix the issue before moving ahead. Click on Next.

Make sure you have selected Create a new Enterprise Manager system and then Simple.

Set proper Middleware Home Location, and Agent Base Directory.

Set Administrator password and the Database connection Details for the repository database.

Information window will be displayed regarding the database character set. Click on OK to continue.

Following error message will be displayed. Click on Yes to fix the issue by the installer itself.

Again new Warning message will be displayed. Click on OK to fix the issue by the installer itself.

Configure BI config Volume directory and the BI Cluster Volume directory and Click on Next to continue.

Check the review and click on Install to begin installation.

Installation is on progress ##########.

Installation is on progress ####################.

Installation is on progress ########################################.

Execute Configuration scripts window will be displayed. Make sure the listed script has been executed as user root before Click on OK.

Once the script execution is completed Click on OK on the Execute configuration script window.

Note the information displayed on the summary screen. Click on Close to complete the installation.

Now you may open the Enterprise Manager Cloud Control 13c using the url below:
https://:7802/em

Set Accessibility Preference and Click on the Save and Continue.

Click on I Accept on the EULA window.

Read More

Change sysman password Oracle Enterprise Manager

Change directory to OMS_HOME/bin

cd /ssd/oracle/Middleware_1/bin

Stop OMS service

./emctl stop oms

Change sysman password with emctl command

./emctl config oms -change_repos_pwd -use_sys_pwd -new_pwd
./emctl config oms -change_repos_pwd -use_sys_pwd

if we do not provide sys password and new password option then password will be prompted as below.

Stop oms services and start OMS

./emctl stop oms -all

./emctl start oms

Now we can login with new password.

Read More