Oracle Technologies Blog

By ASKM

Archive for the ‘OEM’ Category

Edit Add Modify Delete Oem 12c Agent Registration Password

Posted by Srikrishna Murthy Annam on January 19, 2013

Posted in Cloud Control 12c, OEM | Tagged: , , , , , | 1 Comment »

Blocking And Unblocking OEM Agent in OEM 12c

Posted by Srikrishna Murthy Annam on December 31, 2012

In this present short demo, i am going to show you how to block and unblock an oem agent manually in oem 12c. There might be various reasons an oem agent may into a blocked state and this demo shows you how to unblock it.

The reasons that the agent may go into blocked state are ..
If there is any network break between oem agent and oms server
If there is any space issue on oms server and oem agent can’t upload the metrics data to oms server

This demo does not contain any voice and the navigations are self explanatory. Leave your comments if you have any doubts.

 

Thanks

SRI

 

Posted in Cloud Control 12c | Tagged: , , , | Leave a Comment »

12c oem template export and import using emcli

Posted by Srikrishna Murthy Annam on May 15, 2012

This demo explains the steps to export and import a template in oem 12c using emcli command line tool.

 

Thanks

SRI

Posted in Cloud Control 12c | Tagged: , , , , | Leave a Comment »

Oracle VM templates for Cloud Control

Posted by Srikrishna Murthy Annam on May 2, 2012

Oracle VM templates for Cloud Control oem 12c are now available for download from edelivery.

Oracle VM Template for Enterprise Manager Cloud Control 12c Media Pack for x86 (64 bit)

Oracle VM Template for Enterprise Manager Cloud Control 12c (Agent only) Media Pack for x86 (64 bit)

Hope it helps

SRI

 

Posted in Cloud Control 12c | Tagged: , , | Leave a Comment »

CLOUD CONTROL INTEGRATION WITH OVM

Posted by Srikrishna Murthy Annam on May 1, 2012

OEM 12C CLOUD CONTROL INTEGRATION WITH OVM

  1. Configure Oracle Software Library    2
  2. Setting up the infrastructure for Online mode    3
  3. Setup MOS(My Oracle Support) Credentials    6
  4. Deploying the Cloud Plug-ins    6
  5. Deploying the Cloud Plug-ins to the Management Server    9
  6. Deploying the Oracle Virtualization Plug-in to the Management Agent    11
  7. Oracle VM Manager 3.0 Registration Prerequisites    12
  8. Registering the Oracle VM Manager in oem 12c    13
  9. Synchronizing the OVM Manager Targets    15

 

 

 

 

 

 

 

 

 

 

  1. Configure Oracle Software Library

    Oracle Software Library (Software Library) is a repository that stores software patches, virtual appliance images, reference gold images, application software and their associated directive scripts.

    Verify whether you already have the Software Library configured. If not follow the below steps to configure:

    From the Enterprise menu, select Provisioning and Patching, then click Software Library.

    From there choose actions > administration.

    If there is nothing configured yet, click Add then choose OMS Shared Filesystem location.

 

 

Upon addition of the location, a job executes to configure the Software Library. Under this location, all required entities for EMs features like Provisioning, Patching, and Cloud Management are populated.

Once the job is successful, you will see the components configured in the Software Library.

To view the Software Library, navigate to: Enterprise Manager > Patching and Provisioning > Software Library


 

 

  1. Setting up the infrastructure for Online mode

    If the enterprise manager is configured to connect to MOS , plugins or patches can be automatically downloaded. Follow the following sequence of steps ..

    1. Set up connection to MOS (Online Mode)

      Check to see if the connection to My Oracle Support is set to “Online”. Navigate to

      Setup > Provisioning and Patching > Offline Patching.

       

    2. The connection setting has to be “Online”. If not set, set it to Online and click Apply.

       

    3. Select the adjacent tab My Oracle Support and Proxy Connection

       

    4. Configure your Proxy Connection to connect to My Oracle Support. Provide the required Proxy Server, Port and Realm details, then click Apply.

       

    5. Once the configuration is done, click Test to check if the connectivity works correctly.

  2. Setup MOS(My Oracle Support) Credentials

  3. Deploying the Cloud Plug-ins

    Plug-ins must first be downloaded to the OMS using Self Update before they can be deployed. To enable monitoring of virtualization targets, you must download the plug-ins and deploy them. The following plug-ins must be deployed on the Management Server:

  • Oracle Virtualization
  • Oracle Cloud Application
  • Oracle Chargeback and Capacity Planning
  • Oracle Exalogic


Select one of the above plugins (list specified above) , then click Download. The Schedule Download dialog appears. In this example, “Oracle Virtualization” plug-in is selected.


Then it changes the status from “Available” to “Downloaded”

Repeat the same step to all the other plugins (Oracle Cloud Application, Oracle Chargeback and Capacity Planning, Oracle Exalogic)

Once an entity has been downloaded to the Software Library, it is ready to be applied to your installation. Select an update from the list whose status is Downloaded, then click Apply.

 


You will be redirected to the plug-in deployment page.


  1. Deploying the Cloud Plug-ins to the Management Server

    Complete the below steps to all the plugins mentioned in step 4.

    Select the plugin and deploy it on OMS. Right click the plugin ->Deploy on->Management server


     

    Plugin pre-requisites will be executed. After successful pre-requisite checks, click on deploy.

    NOTE : OMS will be bounced now.

    Once the OMS is up, navigate to Setup->Extensibility->Plug-in . The Plugin version on OMS is now 12.1.0.2.

 

  1. Deploying the Oracle Virtualization Plug-in to the Management Agent

Click on Add to add the management agent where plugin will be deployed

Once you have selected the agents, click continue

It runs the plugin pre-requisites and click next

Click Deploy, to deploy the plug-in on the agents

  1. Oracle VM Manager 3.0 Registration Prerequisites

    The following prerequisites must be meet before Oracle VM Manager can be registered in Oracle Enterprise Manager 12c Cloud Control.

    1. The Oracle Virtualization plug-in must be install and enabled on the Oracle Management Service.
    2. The Oracle VM Manager host must have the Oracle Management Agent (OMA) and be a monitored target in Oracle Enterprise Manager 12c Cloud Control.
    3. The Oracle VM Manager host must have the Oracle Virtualization plug-in.
    4. The preferred credentials for the Oracle VM Manager host must be configured in Oracle Enterprise Manager 12c Cloud Control.
    5. The Oracle Management Service and the Oracle VM Manager host must have consistent name resolution using DNS with both forward and reverse lookups.
  2. Registering the Oracle VM Manager in oem 12c

     

     

Table 1

Oracle VM Manager Registration Page Title

Entry Selections and Entry Syntax

  1. Name

The name entered in the “Name” text box is displayed on the Infrastructure Cloud page.

  1. EM Agent URL

The EM Agent URL is selected by clicking the magnifying glass icon. A pop-up window will appear, select the Oracle VM Manager agent from the list. The EM Agent URL syntax is: “https://<AGENT-FQDN&gt;:3872/emd/main/”

Note: The Oracle VM Manager host can be selected as long as the host is managed target by OEM with the Oracle Virtualization plug-in.

  1. Oracle VM Manager Core

Enter “http://<ORACLE VM MANAGER HOST FQDN>:7001″ in the
Oracle VM Manager Core URL text box.

  1. Automatic Synchronization

Select the Automatic Synchronization check box to enable automated synchronization between OEM and the Oracle VM API Core.

  1. Monitoring Credentials for Oracle VM Manager

Enter the Oracle VM Manager admin user name and the admin
password in the Monitoring Credentials for Oracle VM Manager text fields.

  1. Administration Credentials for Oracle VM Manager / Use Administration Credentials

Enter the Oracle VM Manager admin user name and the admin password in the Administration Credentials for Oracle VM Manager text fields.

 
 

Select the Use Administration Credentials check box.

  1. Oracle VM Manager Console URL

Enter the non-SSL Oracle VM Manager URL, i.e.http://<ORACLE VM MANAGER HOST FQDN>:7001/ovm/console/faces/login.jspx in the Oracle VM Manager Console URL text box.

  1. Submit

Once all of the information has been entered, click the Submit button to start the registration job.

  1. Synchronizing the OVM Manager Targets

Posted in Cloud Control 12c, OEM, Uncategorized | Tagged: , , | Leave a Comment »

Cloud Control OEM 12c Installation

Posted by Srikrishna Murthy Annam on April 28, 2012

OEM 12C CLOUD CONTROL INSTALLATION

1.Software    2

2.OS installation    2

3.Database Installation    2

4.Oem 12c Prerequisites    2

a.Hardware Requirements    2

b.Operating System Requirements    2

c.Package Requirements    2

d.Kernel Parameter Requirements    3

e.Library Requirements    3

f.Operating System Groups and Users Requirements    3

g.Unique Host Name and Static IP Address Requirements    4

h.Temporary Directory Space Requirements    4

i.Central Inventory Requirements    4

j.UMASK Value Requirements    4

k.File Descriptor Requirements    4

l.Existing Database Version Requirements    5

m.Host File Requirements    5

n.Port Requirements    5

o.Internet Connection Requirements    5

5.Oem 12c Installation Procedure    6

6.Verification Checks    16

7.Starting and Stopping oem 12c Services    17

 

  1. Software

The required software for the oem 12c cloud control are :

  1. Oracle Linux 6.1 (x86_64) Download
  2. Oracle Database 11gR2 (x86_64) Download
  3. Enterprise Manager Cloud Control 12c (12.1.0.1) (x86_64) with BP1 patch Download
  4. OS installation :

Oracle Linux 6.1 (x86_64) installation :

  1. Database Installation :

Oracle Database 11gR2 installation :

Below links help to install database

Documentation

OBE

Video

  1. Oem 12c Prerequisites :

 

  1. Hardware Requirements :

CPU, RAM, Heap Size, and Hard Disk Space requirements vary depending on the type of installation we are choosing. Please review the here to know the exact hardware requirements.

 

  1. Operating System Requirements :

Ensure that you install Enterprise Manger Cloud Control only on certified operating system as mentioned in the Enterprise Manager Certification Matrix.

  1. Package Requirements :

    make-3.81

    binutils-2.17.50.0.6

    gcc -4.1.1

    libaio-0.3.106

    glibc-common-2.3.4

    libstdc++ -4.1.1

    setarch-1.6

    sysstat-5.0.5

    rng-utils-2.0

    libXtst-1.0.1-3.1(x86_64)

    xorg-x11-utils (This package is required only for GUI-based interactive installation, and not for silent installation)

     

    In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49 to avoid any linking errors while installing the OMS. The installer checks for this package, so if this package is not installed, the installer displays an error.

     

  2. Kernel Parameter Requirements

For installing an OMS or a Management Agent on Unix operating systems (32-bit or 64-bit), set the kernel.shmmax parameter to a value 1 byte less than 4 GB or 4294967295.

 

To verify the value assigned to kernel.shmmax parameter, run the following command:

cat /proc/sys/kernel/shmmax

 

To set the value for kernel.shmmax parameter, run the following command:

sysctl -w kernel.shmmax=<new value>

 

 

  1. Library Requirements :

    Install glibc-2.5.12 package

 

  1. Operating System Groups and Users Requirements:

# /usr/sbin/groupadd oinstall

 

# /usr/sbin/useradd -g oinstall oracle

 

# passwd oracle

  1. Unique Host Name and Static IP Address Requirements :

Ensure that you check the network configuration to verify that the host on which you are installing resolves to a unique host name and a static IP address that is visible to other hosts in the network.

You must use a static IP address. If you use a dynamic IP address, the installation might fail.

Ensure that the host name specified in /etc/hosts file is unique, and that it maps to the correct IP address. Following is the recommended format of the /etc/hosts file:

<ip address> <fully_qualified_host_name> <short_host_name>

 

If the DNS server is configured, then it should resolve the host name for the OMS machine correctly. For example, all these command must return the same output:

nslookup host1

nslookup host1.foo.com

nslookup 141.81.5.71

  1. Temporary Directory Space Requirements :

Ensure that you allocate 400 MB of space for a temporary directory where the executables can be copied.

  1. Central Inventory Requirements :

Ensure that you allocate 100 MB of space for the central inventory directory.

Also ensure that the central inventory directory is not on a shared file system. If it is already on a shared file system, then switch over to a non-shared file system by following the instructions outlined in My Oracle Support note 1092645.1.

To determine whether the Oracle Inventory group exists, enter the following command:

$ more /etc/oraInst.loc

If the oraInst.loc file exists, then the output from this command looks like:

inventory_loc=/u01/app/oracle/oraInventory

inst_group=oinstall

  1. UMASK Value Requirements:

Ensure that you set the default file mode creation mask (umask) to 022 in the shell startup file.

  1. File Descriptor Requirements :

If the current value is less than 4096, then as root user, update the /etc/security/limits.conf file as shown below:

<UID> soft nofile 4096

<UID> hard nofile 4096

  1. Existing Database Version Requirements :

Ensure that the database is patched with all the Patch Set Updates (PSU) or Critical Patch Updates (CPU) released for that release. Also ensure that you apply the patches.

If you use Oracle Database 11g Release 2 (11.2.0.1), then ensure that you apply the patches for bugs 10014178 and 8799099.

If you use Oracle Database 11g Release 1 (11.1.0.7), then ensure that you apply Patch Set Update 2 and the patches for bugs 8644757 and 7525072.

The database can also have the Automatic Memory Management (AMM) feature enabled.

  1. Host File Requirements :

Ensure that the host name specified in the /etc/hosts file is unique, and ensure that it maps to the correct IP address of that host. Otherwise, the installation can fail on the product-specific prerequisite check page.

The following is the recommended format of the /etc/hosts file:

<ip> <fully_qualified_host_name> <short_host_name>

  1. Port Requirements :

Ensure that the ports you assign (within the given range) to the following components are free and available:

 

Admin Server HTTP SSL Port = 7101 – 7200

Enterprise Manager Upload HTTP Port = 4889 – 4898

Enterprise Manager Upload HTTP SSL Port = 1159, 4899 – 4908

Enterprise Manager Central Console HTTP Port = 7788 – 7798

Enterprise Manager Central Console HTTP SSL Port = 7799 – 7809

Oracle Management Agent Port = 3872, 1830 – 1849

 

To verify if a port is free, run the following command:

On Unix:

netstat -anp | grep <port no>

  1. Internet Connection Requirements :

Oracle recommends that the host from where you are running the installer have a connection to the Internet so that the configuration information can be automatically collected and uploaded to My Oracle Support.

  1. Oem 12c Installation Procedure :

  1. Verification Checks :

    Access the following URL with sysman user and navigate to different pages to verify everything looks good.


https://<hostname with FQDN>:7803/em

  1. Starting and Stopping oem 12c Services :

Use the following commands to start all components :

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

$ export OMS_HOME=/u01/app/oracle/Middleware/oms

$ export AGENT_HOME=/u01/app/oracle/Middleware/agent/core/12.1.0.1.0

 

# Start everything

$ $ORACLE_HOME/bin/sqlplus ‘/as sysdba’

SQL> startup

 

$lsnrctl start listener

 

$ $OMS_HOME/bin/emctl start oms

 

$ $AGENT_HOME/bin/emctl start agent

 

Use the following commands to stop all components :

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

$ export OMS_HOME=/u01/app/oracle/Middleware/oms

$ export AGENT_HOME=/u01/app/oracle/Middleware/agent/core/12.1.0.1.0

 

# Stop everything

$ $OMS_HOME/bin/emctl stop oms -all

 

$ $AGENT_HOME/bin/emctl stop agent

 

$ $ORACLE_HOME/bin/sqlplus ‘/as sysdba’

SQL> shut immediate

 

$ $lsnrctl stop listener


 

Posted in Cloud Control 12c, OEM, Uncategorized | Tagged: , , | Leave a Comment »

OEM Grid Control 10.2.0.1 Installation On Linux 5.4

Posted by Srikrishna Murthy Annam on November 3, 2011

In this article, we will discuss how to install OEM grid control 10.2.0.1 on Linux 5.4(32 bit).

Download the required software from the location : Download Software
Download the installation Document from the location : Download Installation Document

If you are planning to install OEM grid control in a vmware linux machine, Please follow the article VMware Server – Linux installation  and complete the linux machine creation. You can omit this point if you are directly provided with linux machine with OS linux 5.4.

Prepare the linux machine ( Linux 5.4 ) for the OEM grid control 10201 installation. Please use the article  Prepare Linux virtual machine for OEM Grid Control Installation. Though this is to prepare the linux machine for 11gR2 database, it holds good for OEM 10201 installation also. You can also refer the document mentioned above to prepare the linux machine for OEM grid control installation.

There are some identified Common Installation Errors while installing OEM 10201 on Linux 5.4. Please follow the article OEM Gridcontrol 10201 Installation Errors On Linux 5.4 to correct all the issues.

Follow the video to complete the installation of OEM grid control 10.2.0.1 on Linux 5.4.

Video will be uploaded very soon. <video place holder>

Hope It Helps
SRI

Posted in OEM | Tagged: , , , , , | Leave a Comment »

Applying OEM Grid Control Patchset 10.2.0.5

Posted by Srikrishna Murthy Annam on May 25, 2011

In this article, i will show you how to apply patchset 10.2.0.5 to Oracle Enterprise Manager (OEM) 10.2.0.1. In the present article,we assume that there is already OEM 10.2.0.1 installed on Linux 5. There is no full installation of OEM 10.2.0.5 and all we need to do is install OEM 10.2.0.1 and apply the patchset 10.2.0.5.

Please download the required software from the location : Software Download

Please download the upgrade document from the location : Document Download

  1. Pre-Upgrade Tasks
  2. Upgrading from 10201 to 10205 ( With Video Demo)
  3. Post Upgrade Tasks

1.Pre-Upgrade Tasks:

Version Check Before Upgrade :

SQL> select name,user from v$database;

NAME      USER
--------- ------------------------------
EMREP     SYS

SQL> select comp_name,version,status from dba_registry;

COMP_NAME                           VERSION         STATUS
----------------------------------- --------------- ----------
Oracle Database Catalog Views       10.1.0.4.0      VALID
Oracle Database Packages and Types  10.1.0.4.0      VALID
Oracle Workspace Manager            10.1.0.2.0      VALID

SQL> select component_name,version from sysman.mgmt_versions;

COMPONENT_NAME                   VERSION
-------------------------------- ---------------
CORE                             10.2.0.1.0
DB                               10.2.0.1.0
PP                               10.2.0.1.0
IAS                              10.2.0.1.0
SSO_SERVER                       10.2.0.1.0
BC4J                             10.2.0.1.0
FORMS                            10.2.0.1.0
WIRELESS                         10.2.0.1.0
OCS                              10.2.0.1.0
WORKFLOW                         10.2.0.1.0
PORTAL                           10.2.0.1.0
INTEGRATIONBPM                   10.2.0.1.0
INTEGRATIONBAM                   10.2.0.1.0
DISCOVERER                       10.2.0.1.0
IFS                              10.2.0.1.0
REPSERV                          10.2.0.1.0
INTEGIC                          10.2.0.1.0
INTEGB2B                         10.2.0.1.0
CI                               10.2.0.1.0

19 rows selected.

SQL>

Status Check:

[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/oms10g/bin
[oracle@oemmach01 bin]$ ./emctl status oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle Management Server is Up.
[oracle@oemmach01 bin]$ ./emctl status iasconsole
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/oem/oms10g/sysman/log
[oracle@oemmach01 bin]$

[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/oms10g/opmn/bin
[oracle@oemmach01 bin]$ ./opmnctl status

Processes in Instance: EnterpriseManager0.oemmach01.localdomain
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status
-------------------+--------------------+---------+---------
DSA                | DSA                |     N/A | Down
HTTP_Server        | HTTP_Server        |    2260 | Alive
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |   10843 | Alive
OC4J               | home               |    2262 | Alive
OC4J               | OC4J_EMPROV        |    2261 | Alive
OC4J               | OC4J_EM            |    2264 | Alive
WebCache           | WebCache           |    2272 | Alive
WebCache           | WebCacheAdmin      |    2265 | Alive

[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/agent10g/bin
[oracle@oemmach01 bin]$ ./emctl status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.1.0
OMS Version       : 10.2.0.1.0
Protocol Version  : 10.2.0.0.0
Agent Home        : /u01/app/oracle/oem/agent10g
Agent binaries    : /u01/app/oracle/oem/agent10g
Agent Process ID  : 3294
Parent Process ID : 3276
Agent URL         : https://oemmach01.localdomain:3872/emd/main/
Repository URL    : https://oemmach01.localdomain:1159/em/upload
Started at        : 2011-04-18 21:37:55
Started by user   : oracle
Last Reload       : 2011-04-18 21:43:15
Last successful upload                       : 2011-04-18 22:33:49
Total Megabytes of XML files uploaded so far :     5.50
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    43.08%
Last successful heartbeat to OMS             : 2011-04-18 22:34:20
---------------------------------------------------------------
Agent is Running and Ready
[oracle@oemmach01 bin]$

Perform Backup:
Backup OMS oracle home ( you can use tar -cvzf <OMS oracle home> to backup the OMS oracle home )
Backup Repository database ( This is database backup. Use your convinient way to backup the database)
Backup the Oracle Inventory Directory.

Verify SGA:
Verify that the Shared pool size of the repository database is set to a min value of 512MB.
SQL> show parameter pool

Other Checks

SQL> sho user
USER is "SYSMAN"
SQL> set timing on
SQL> exec emd_maintenance.analyze_emd_schema('SYSMAN');

PL/SQL procedure successfully completed.

Elapsed: 00:00:04.18
SQL> select object_name, object_type from all_objects where owner='SYSMAN' and status <> 'VALID';

no rows selected

SQL>

The above query should return 0 rows. If there are rows, then run the below SQL statement:

[oracle@oemmach01 bin]$ locate admin_recompile_invalid.sql
/u01/app/oracle/oem/oms10g/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql
[oracle@oemmach01 bin]$

SQL> @admin_recompile_invalid.sql SYSMAN

The admin_recompile_invalid.sql script is available under /sysman/admin/emdrep/sql/core/latest/admin/ Where  is the Oracle home directory of the Oracle Management Service (OMS).

SQL> select object_name, object_type from all_objects where status<>'VALID' and object_name like 'DBMS%';

no rows selected

SQL>

Verify The Permission:

If the permission is not set to 664 for the below files, you will get a permission denied error during the upgrade. For example:
Error in writing to file
‘/u01/app/oracle/product/10.2.0/oms10g/rdbms/admin/dbmsaw.plb’ Permission denied

[oracle@oemmach01 askm]$ locate dbmsaqds.plb  dbmsaw.plb  prvtlmd.plb  prvtpexp.plb  prvtlsby.plb  prvtlms.plb  prvtaqip.plb  prvtstas.plb  prvtsqlt.plb  prvttxfm.plb  prvtaqdi.plb  prvtaqds.plb  prvtcdpu.plb  prvtcdpi.plb  prvtmeti.plb  prvtxdbz.plb  exfeapvs.plb  prvtdupg.plb  prvtupgi.plb  prvtkupc.plb  prvtbpw.plb  prvtaqiu.plb  prvtaqim.plb  prvtbsqu.plb  prvtbut4.plb  prvtmetu.plb  prvtmeta.plb  prvtcdcp.plb  prvtcdcu.plb  >> filelist
[oracle@oemmach01 askm]$ cat filelist
/u01/app/oracle/oem/db10g/rdbms/admin/dbmsaqds.plb
/u01/app/oracle/oem/db10g/rdbms/admin/dbmsaw.plb
....
.....
/u01/app/oracle/oem/oms10g/rdbms/admin/prvtxdbz.plb
[oracle@oemmach01 askm]$

[oracle@oemmach01 askm]$ for i in `cat filelist`; do chmod 644  $i; done
[oracle@oemmach01 askm]$ for i in `cat filelist`; do ls -lrt $i; done
-rw-r--r-- 1 oracle oracle 5697 Feb 21  2005 /u01/app/oracle/oem/db10g/rdbms/admin/dbmsaqds.plb
-rw-r--r-- 1 oracle oracle 10558 Feb 12  2005 /u01/app/oracle/oem/db10g/rdbms/admin/dbmsaw.plb
......
......
-rw-r--r-- 1 oracle oracle 6818 Jul 14  2005 /u01/app/oracle/oem/oms10g/rdbms/admin/prvtxdbz.plb
[oracle@oemmach01 askm]$

SQL> sho user
USER is "SYSMAN"
SQL> execute emd_maintenance.remove_em_dbms_jobs;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> select a.instance_name as sid, b.value as jobqueue from gv$instance a, gv$parameter b where a.inst_id = b.inst_id and b.name='job_queue_processes';

no rows selected

SQL> select count(*) from dba_jobs_running;

COUNT(*)
----------
0

SQL>

SQL> exec dbms_scheduler.set_scheduler_attribute ('SCHEDULER_DISABLED','TRUE');

PL/SQL procedure successfully completed.

SQL> select count(*) from dba_scheduler_running_jobs where SLAVE_PROCESS_ID IS NOT NULL;

COUNT(*)
----------
0

SQL>

2.Upgrading from 10201 to 10205

Unzip the software to any temporary directory and follow the below video to upgrade OEM from 10201 to 10205.

NOTE: This will upgrade only OMS ORACLE_HOME and Agent ORACLE_HOME and will not upgrade the repository database. To upgrade the repository database,we will follow the normal procedure to upgrade a database.

3.Post Upgrade Tasks:

SQL> exec dbms_scheduler.set_scheduler_attribute ('SCHEDULER_DISABLED','FALSE');

PL/SQL procedure successfully completed.

SQL>

Verification :

SQL> select name,user from v$database;

NAME      USER
--------- ------------------------------
EMREP     SYS

SQL> select comp_name,version from dba_registry;

COMP_NAME                                VERSION
---------------------------------------- ---------------
Oracle Database Catalog Views            10.1.0.4.0
Oracle Database Packages and Types       10.1.0.4.0
Oracle Workspace Manager                 10.1.0.2.0

SQL> cl scr

SQL> desc sysman.mgmt_versions
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
COMPONENT_NAME                            NOT NULL VARCHAR2(32)
VERSION                                   NOT NULL VARCHAR2(32)
COMPAT_CORE_VERSION                       NOT NULL VARCHAR2(32)
COMPONENT_MODE                                     VARCHAR2(32)
STATUS                                             NUMBER

SQL> select component_name,version from sysman.mgmt_versions;

COMPONENT_NAME                   VERSION
-------------------------------- ---------------
CORE                             10.2.0.5.0
DB                               10.2.0.5.0
PP                               10.2.0.5.0
IAS                              10.2.0.5.0
SSO_SERVER                       10.2.0.5.0
BC4J                             10.2.0.5.0
FORMS                            10.2.0.5.0
WIRELESS                         10.2.0.5.0
OCS                              10.2.0.5.0
WORKFLOW                         10.2.0.5.0
PORTAL                           10.2.0.5.0
INTEGRATIONBPM                   10.2.0.5.0
INTEGRATIONBAM                   10.2.0.5.0
DISCOVERER                       10.2.0.5.0
IFS                              10.2.0.5.0
REPSERV                          10.2.0.5.0
INTEGIC                          10.2.0.5.0
INTEGB2B                         10.2.0.5.0
CI                               10.2.0.5.0
_UPGRADE_                        0
CONNECTOR                        10.2.0.5.0
PA                               10.2.0.5.0
OCM                              10.2.0.5.0
CONTENT                          10.2.0.5.0
VT                               10.2.0.5.0
BEEHIVE                          10.2.0.5.0

26 rows selected.

SQL>
SQL> cl scr

SQL> !
[oracle@oemmach01 ~]$ cd /u01/app/oracle/oem/oms10g/bin
[oracle@oemmach01 bin]$ ./emctl status oms
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle Management Server is Up.
[oracle@oemmach01 bin]$ ./emctl status iasconsole
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle 10g Application Server Control is not running.
[oracle@oemmach01 bin]$ cd ../opmn/bin
[oracle@oemmach01 bin]$ ./opmnctl status

Processes in Instance: EnterpriseManager0.oemmach01.localdomain
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status
-------------------+--------------------+---------+---------
HTTP_Server        | HTTP_Server        |    5536 | Alive
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |    6498 | Alive
OC4J               | home               |    5537 | Alive
OC4J               | OC4J_EMPROV        |    5538 | Alive
OC4J               | OC4J_EM            |    5540 | Alive
OC4J               | OCMRepeater        |   13900 | Alive
WebCache           | WebCache           |    5561 | Alive
WebCache           | WebCacheAdmin      |    5541 | Alive
DSA                | DSA                |     N/A | Down

[oracle@oemmach01 bin]$

Related articles: Install 10gR2 grid control and Agents

Hope It Helps
SRI

Posted in OEM | Tagged: , , , , , , , | Leave a Comment »

OEM Grid Control 11g(11.1.0.1.0) Installation

Posted by Srikrishna Murthy Annam on May 17, 2011

This article explains the OEM grid control 11g ( 11.1.0.1.0 ) installation on Linux 5.4 (32-bit) OS with 11gR2 database.

Software Requirements:

SUN JDK 1.6_18 ( for 32/64 bit Linux OS) : Download
WebLogic Server 10.3.2(32bit) : Download
Oracle Database 11gR2 : Download
OEM 11g Grid Control( 11.1.0.1.0 ) : Download

Grid Control 11g uses WebLogic Server instead of OC4J which was traditional with Grid Control versions 10.1 and 10.2. Grid Control 11g will deploy from an existing Weblogic Server during the Grid Control Installation. Weblogic server installation requires a JDK 1.6_18 as a pre requisite. A database for repository use must exist at the time of Grid Control 11.1.0.1.0 installation. The option to “Install Grid Control with a new database” is no longer offered. So we need to have  the database created before starting the grid control 11g installation. Please review the Oracle Enterprise Manager Grid Control Certification Checker @ 412431.1 for the database version.

So the sequence of steps to install 11g grid control including all the external components are ..

1) Create Linux Machine
2) Prepare the linux machine for OEM grid control 11g installation.
3) Install JDK 1.6_18
4) Install Weblogic server 10.3.2
5) Install database 11.2.0.1
6) Prepare the database for OEM 11g Installation.
7) Install OEM grid control 11.1.0.1.0
8 ) Status Check
9) Issues and Resolutions

1.Create Linux Machine:

If you are planning to install OEM grid control in a vmware linux machine, Please follow the article VMware Server – Linux installation  and complete the linux machine creation. You can omit this point if you are directly provided with linux machine with OS linux 5.4(32-bit).

2.Prepare the linux machine for OEM grid control 11g installation:

Prepare the linux machine ( Linux 5.4 ) for the OEM grid control 11g installation. Please use the article Prepare Linux virtual machine for 11gR2 installation on Linux 5.x. Though this is to prepare the linux machine for 11gR2 database, it hold good for OEM 11g installation also. You can also refer the installation document here.

Check the following RPMs and make sure all the RPMs are installed.

[oracle@oem11gmach01 ~]$ rpm -qa | egrep -i "binutils|compat-libstdc|elfutils-libelf|glibc|glibc-common|ksh|libaio|libgcc|libstdc|make"
libgcc-4.1.2-48.el5
automake16-1.6.3-8.el5.1
elfutils-libelf-devel-static-0.137-3.el5
compat-libgcc-296-2.96-138
libstdc++-4.1.2-48.el5
imake-1.0.2-3
compat-libstdc++-33-3.2.3-61
glibc-headers-2.5-49
automake14-1.4p6-13.el5.1
ksh-20100202-1.el5
glibc-common-2.5-49
glibc-2.5-49
elfutils-libelf-0.137-3.el5
binutils-2.17.50.0.6-14.el5
compat-libstdc++-296-2.96-138
glibc-devel-2.5-49
automake-1.9.6-2.3.el5
automake17-1.7.9-7.el5.2
make-3.81-3.el5
libaio-0.3.106-5
automake15-1.5-16.el5.2
elfutils-libelf-devel-0.137-3.el5
libstdc++-devel-4.1.2-48.el5
MAKEDEV-3.23-1.2
[oracle@oem11gmach01 ~]$

[oracle@oem11gmach01 ~]$ rpm -qa | egrep -i "elfutils-libelf-devel|kernel-headers|glibc-headers|glibc-devel|libstdc++-devel|libgomp|gcc-|gcc-c++|libaio-devel|sysstat|unixODBC"
kernel-headers-2.6.18-194.el5
libgcc-4.1.2-48.el5
gcc-gfortran-4.1.2-48.el5
elfutils-libelf-devel-static-0.137-3.el5
compat-libgcc-296-2.96-138
glibc-headers-2.5-49
libgomp-4.4.0-6.el5
glibc-devel-2.5-49
gcc-4.1.2-48.el5
gcc-c++-4.1.2-48.el5
elfutils-libelf-devel-0.137-3.el5
[oracle@oem11gmach01 ~]$ rpm -qa | grep libstdc++-devel
libstdc++-devel-4.1.2-48.el5
[oracle@oem11gmach01 ~]$ rpm -qa | grep libaio-devel
[oracle@oem11gmach01 ~]$

[oracle@oem11gmach01 ~]$ rpm -qa | egrep -i "rng-utils|make|binutils|gcc|libaio|glibc-common|compat-libstdc++|libstdc++|setarch|compat-db"
libgcc-4.1.2-48.el5
automake16-1.6.3-8.el5.1
gcc-gfortran-4.1.2-48.el5
compat-libgcc-296-2.96-138
libstdc++-4.1.2-48.el5
imake-1.0.2-3
compat-libstdc++-33-3.2.3-61
automake14-1.4p6-13.el5.1
rng-utils-2.0-1.14.1.fc6
glibc-common-2.5-49
binutils-2.17.50.0.6-14.el5
compat-libstdc++-296-2.96-138
automake-1.9.6-2.3.el5
automake17-1.7.9-7.el5.2
make-3.81-3.el5
setarch-2.0-1.1
libaio-0.3.106-5
automake15-1.5-16.el5.2
gcc-4.1.2-48.el5
gcc-c++-4.1.2-48.el5
libstdc++-devel-4.1.2-48.el5
MAKEDEV-3.23-1.2
[oracle@oem11gmach01 ~]$ rpm -qa | grep -i compat-db
[oracle@oem11gmach01 ~]$

[root@oem11gmach01 sf_Shared_folder]# rpm -ivh libaio-devel-0.3.106-3.2.i386.rpm
warning: libaio-devel-0.3.106-3.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:libaio-devel           ########################################### [100%]
[root@oem11gmach01 sf_Shared_folder]# rpm -qa | grep -i libaio-devel
libaio-devel-0.3.106-3.2
[root@oem11gmach01 sf_Shared_folder]# rpm -ivh compat-db-4.2.52-5.1.i386.rpm
warning: compat-db-4.2.52-5.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:compat-db              ########################################### [100%]
[root@oem11gmach01 sf_Shared_folder]# rpm -qa | grep -i compat-db
compat-db-4.2.52-5.1
[root@oem11gmach01 sf_Shared_folder]# rpm -ivh sysstat-7.0.0-3.el5.i386.rpm
warning: sysstat-7.0.0-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:sysstat                ########################################### [100%]
[root@oem11gmach01 sf_Shared_folder]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm unixODBC-devel-2.2.11-7.1.i386.rpm
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:unixODBC               ########################################### [ 50%]
2:unixODBC-devel         ########################################### [100%]
[root@oem11gmach01 sf_Shared_folder]#

Create Directory Structure:

Create following directories and make sure you give read / write permission to oracle user.

/u01/app/OEM11g/Middleware
/u01/app/OEM11g/Middleware/oms11g
/u01/app/OEM11g/Middleware/agent11g
/u01/app/OEM11g/Middleware/Oracle_WT
/u01/app/OEM11g/Middleware/oracle_common
/u01/app/OEM11g/gc_inst
/u01/app/oracle/oradata/OEMDB

3.Install JDK 1.6_18:

Installing JDK depends on the OS bit version you are using. If you are using 32-bit version OS, you will find weblogic server bundled with JDK. But if you are using 64-bit OS,you must install an appropriate jdk to support the WebLogic Server and Grid Control 11.1.0.1.0 installations on 64bit platforms, since the required jdk is not bundles with the installer as it is with the 32bit platforms.
In this demo, i am using a 32-bit OS and i can skip this part of installing JDK. For those we need to install JDK 1.6_18 for 64-bit OS, Please follow the detailed procedure explained with screen shots here. For more details, Please follow the MOS ID : 1063587.1.

NOTE: jdk 1.6.0_18 is recommended due to potential problems with newer versions.

jdk 1.6.0 updates 19 and higher do not allow subsequent patching with required WLS patch WDJ7, so these versions are not effective and must be avoided. They may be used when a cacerts file that allows Smartupdate can be appropriately substituted for the native one.

[root@oem11gmach01 Grid Control 11g]# mkdir -p /u01/app/OEM11g/Middleware
[root@oem11gmach01 Grid Control 11g]# chown -R oracle:oinstall /u01/app/OEM11g/Middleware/
[root@oem11gmach01 Grid Control 11g]# chmod -R 755 /u01/app/OEM11g/Middleware/
[root@oem11gmach01 Grid Control 11g]# cd /u01/app/OEM11g/Middleware/
[root@oem11gmach01 Middleware]# mkdir jdk
[root@oem11gmach01 Middleware]# chown -R oracle:oinstall jdk
[root@oem11gmach01 Middleware]# chmod 755 jdk
[root@oem11gmach01 Middleware]# cd -
/media/sf_Shared_folder/Grid Control 11g
[root@oem11gmach01 Grid Control 11g]# cp jdk-6u18-linux-i586.bin /u01/app/OEM11g/Middleware/jdk/
[root@oem11gmach01 Grid Control 11g]# chown oracle:oinstall /u01/app/OEM11g/Middleware/jdk/jdk-6u18-linux-i586.bin
[root@oem11gmach01 Grid Control 11g]# chmod 755 /u01/app/OEM11g/Middleware/jdk/jdk-6u18-linux-i586.bin
[root@oem11gmach01 Grid Control 11g]# su - oracle
/u01/app/oracle/product/11.2.0/db_1
OEMDB
[oracle@oem11gmach01 ~]$ cd /u01/app/OEM11g/Middleware/jdk/
[oracle@oem11gmach01 jdk]$

[oracle@oem11gmach01 bin]$ ./jdk-6u18-linux-i586.bin

[oracle@oem11gmach01 jdk]$ pwd
/u01/app/OEM11g/Middleware/jdk
[oracle@oem11gmach01 jdk]$ ls
jdk1.6.0_18  jdk-6u18-linux-i586.bin
[oracle@oem11gmach01 jdk]$ cd jdk1.6.0_18/
[oracle@oem11gmach01 jdk1.6.0_18]$ ls
bin        db    include  lib      man          README_ja.html     register.html     register_zh_CN.html  src.zip
COPYRIGHT  demo  jre      LICENSE  README.html  README_zh_CN.html  register_ja.html  sample               THIRDPARTYLICENSEREADME.txt
[oracle@oem11gmach01 jdk1.6.0_18]$ cd bin
[oracle@oem11gmach01 bin]$ ./java -version
java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) Client VM (build 16.0-b13, mixed mode, sharing)
[oracle@oem11gmach01 bin]$
[oracle@oem11gmach01 ~]$ java -fullversion
java full version "1.6.0_18-b07"
[oracle@oem11gmach01 ~]$

4.Installing Weblogic Server 10.3.2:

The only version of the WebLogic Server that can be used to deploy Grid Control is 10.3.2.The WebLogic Server associated with Oracle products such as SOA Suite or Identity Management is not appropriate for use in deploying Grid Control.

After completing the installation, we need to apply the recommended patches to WLS for grid control installation. Either use SmartUpdate tool or use offline method to install patch. Download the WLS patch WDJ7 manually and place it in the directory WLS_ORACLE_HOME/utils/bsu/cache_dir.

Offline Method:


Apply the patch by running the following command:-
./bsu.sh -prod_dir=WLS_ORACLE_HOME/wlserver_10.3 -patchlist=patch number -verbose -install
For example:
./bsu.sh -prod_dir=/scratch/gc/Oracle/Middleware/wlserver_10.3 -patchlist=WDJ7 -verbose -install

You can view the report of applied patched by running the following command:-
./bsu.sh -report -patch_id_mask=patch number
For example: ./bsu.sh -report -patch_id_mask=WDJ7

Using SmartUpdateTool(please watch the demo)

Watch this demo which shows how to apply the recommended patches to weblogic server.

A step-by-step description with graphical representation of the installer progress is available here.

5.Install Database 11.2.0.1:

The option to “Install Grid Control with a new database” is no longer offered. So we need to have  the database created before starting the grid control 11g installation.

Please follow the article “Installing 11gR2 Single Instance Database With Non-ASM Storage” for installling 11g database software and creating a database for OEM grid control repository.

This procedure with step-by-step screen shot graphics can be found here.  ( This guide installs 11.1.0.7 Database, but we are installing 11gR2 in our demo ).

6.Prepare the database for OEM 11g Installation.

SQL> select active_state from v$instance;

ACTIVE_ST
---------
NORMAL

SQL> SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME='SYSMAN';

COUNT(*)
----------
1

SQL> SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME IN ('SYSMAN','SYSMAN_MDS');

COUNT(*)
----------
1

SQL> !

=>Deconfigure DB console :

[oracle@oem11gmach01 database]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop -SYS_PWD welcome1 -SYSMAN_PWD welcome1

STARTED EMCA at Apr 27, 2011 10:38:10 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: OEMDB
Listener port number: 1521

Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 27, 2011 10:38:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/OEMDB/emca_2011_04_27_22_38_10.log.
Apr 27, 2011 10:38:49 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Apr 27, 2011 10:39:23 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 27, 2011 10:43:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 27, 2011 10:43:34 PM
[oracle@oem11gmach01 database]$ exit
exit

SQL> SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME='SYSMAN';

COUNT(*)
----------
0

SQL> SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME IN ('SYSMAN','SYSMAN_MDS');

COUNT(*)
----------
0

SQL> select value from v$option where parameter='Fine-grained access control';

VALUE
----------------------------------------------------------------
TRUE

SQL>
SQL> select sum(decode(autoextensible,'YES',200*1024*1024+1,bytes)) total from dba_data_files f, dba_tablespaces s
2  where s.contents='UNDO' and s.tablespace_name=f.tablespace_name;

TOTAL
----------
209715201

SQL> select count(*) from dba_temp_files where tablespace_name='TEMP' and AUTOEXTENSIBLE <> 'YES';

COUNT(*)
----------
0

SQL> select count(*) from dba_data_files where tablespace_name='UNDOTBS' and AUTOEXTENSIBLE <> 'YES';

COUNT(*)
----------
0

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL>

Optional : Verify the init.ora parameters as specified in the installation document

7.Install OEM grid control 11.1.0.1.0:

There are three ways to install Enterprise Manager.
1) Installing Enterprise Manager System with graphical mode including all configuration tools
2) Installing Enterprise Manager Software Only in Graphical Mode and Configuring Later
3) Installing Enterprise Manager Software Only in Silent Mode and Configuring Later

In the present demo i am choosing option 2 to install Enterprise Manager.

Go to the directory where the software is unzipped and start the installation with the following command …

<Software_Location>/runInstaller -noconfig

After successful installation of the OEM grid control 11g software, install the configuration tools using

$<OMS_ORACLE_HOME>/perl/bin/perl <ORACLE_HOME>/sysman/install/ConfigureGC.pl
Ex : /u01/app/OEM11g/Middleware/oms11g/perl/bin/perl /u01/app/OEM11g/Middleware/oms11g/sysman/install/ConfigureGC.pl

Watch the video to install OEM grid control 11g software.

For detailed explanation, verify MOS ID 1064495.1 and for step by step screen shot explanation of the installation, refer the the document here.

8.Status Check:

[oracle@oem11gmach01 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@oem11gmach01 ~]$ echo $ORACLE_SID
OEMDB
[oracle@oem11gmach01 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 30 02:27:52 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
OEMDB            OPEN

SQL>


[oracle@oem11gmach01 ~]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-APR-2011 02:28:14

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                29-APR-2011 23:55:06
Uptime                    0 days 2 hr. 33 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oem11gmach01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oem11gmach01.localdomain)(PORT=1521)))
Services Summary...
Service "OEMDB.localdomain" has 1 instance(s).
Instance "OEMDB", status READY, has 1 handler(s) for this service...
Service "OEMDBXDB.localdomain" has 1 instance(s).
Instance "OEMDB", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oem11gmach01 ~]$



[oracle@oem11gmach01 bin]$ pwd
/u01/app/OEM11g/Middleware/oms11g/bin
[oracle@oem11gmach01 bin]$ ./emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Up
[oracle@oem11gmach01 bin]$



[oracle@oem11gmach01 bin]$ pwd
/u01/app/OEM11g/Middleware/agent11g/bin
[oracle@oem11gmach01 bin]$ ./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        : /u01/app/OEM11g/Middleware/agent11g
Agent binaries    : /u01/app/OEM11g/Middleware/agent11g
Agent Process ID  : 10432
Parent Process ID : 10400
Agent URL         : https://oem11gmach01.localdomain:3872/emd/main/
Repository URL    : https://oem11gmach01.localdomain:4900/em/upload
Started at        : 2011-04-30 02:04:10
Started by user   : oracle
Last Reload       : 2011-04-30 02:05:44
Last successful upload                       : 2011-04-30 02:25:26
Total Megabytes of XML files uploaded so far :    21.91
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    25.10%
Last successful heartbeat to OMS             : 2011-04-30 02:24:52
---------------------------------------------------------------
Agent is Running and Ready
[oracle@oem11gmach01 bin]$



[oracle@oem11gmach01 bin]$ pwd
/u01/app/OEM11g/gc_inst/WebTierIH1/bin
[oracle@oem11gmach01 bin]$ ./opmnctl status

Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
ohs1                             | OHS                |    7870 | Alive

[oracle@oem11gmach01 bin]$


Access the URL:

https://oem11gmach01.localdomain:4900/em/

9.Issues and Resolutions

During Enterprise Manager installation, the configuration tool “Repository Configuration Assistant” failed.

Reviewed the following logfiles:
$<OMS_ORACLE_HOME>/cfgtoollogs/cfgfw/emmdscreate_<timestamp>.log
$<OMS_ORACLE_HOME>/sysman/log/schemamanager/m_<timestamp>/m_<timestamp>.<ACTION>/

Following information found in various logfiles under the directories mentioned above:

[Initializing the EM RCU Runner, Failed Parameter Validation]
action logger path calculated finally: /u01/app/OEM11g/Middleware/oms11g/sysman/log/schemamanager/m_042911_1243_AM/m_042911_1243_AM.TRANSX/

==================================================

2011-04-29 00:56:36,991 [vd92mfm9eocy] INFO  emschema.vd92mfm9eocy - not found repos connection
2011-04-29 00:56:36,992 [vd92mfm9eocy] INFO  emschema.vd92mfm9eocy - error: not found repos connection for transx repos user exists: false mgmt_messages exists: false; found connection for repos user: false
2011-04-29 00:56:36,992 [vd92mfm9eocy] ERROR emschema.vd92mfm9eocy - Failed Parameter Validation
2011-04-29 00:56:36,992 [vd92mfm9eocy] ERROR emschema.vd92mfm9eocy - NULL Exception was thrown!
2011-04-29 00:56:36,992 [vd92mfm9eocy] ERROR emschema.vd92mfm9eocy - Failed Parameter Validation
"/u01/app/OEM11g/Middleware/oms11g/sysman/log/schemamanager/m_042911_1243_AM/m_042911_1243_AM.TRANSX/emschema.log.TRANSX" 407L, 44064C     407,1         Bot

========================

INFO: oracle.sysman.top.oms:[Initializing the EM RCU Runner, Failed Parameter Validation]
INFO: oracle.sysman.top.oms: action logger path calculated finally: /u01/app/OEM11g/Middleware/oms11g/sysman/log/schemamanager/m_042911_0115_AM/m_042911_0115_AM.TRANSX/
INFO: oracle.sysman.top.oms:The transx command execution is completed with the status 0
INFO: oracle.sysman.top.oms:process_id:
INFO: oracle.sysman.top.oms:The Process ID: [] does not exist.  Either it has been completed, or this is not the executing JVM
INFO: oracle.sysman.top.oms:The plug-in Repository Configuration has failed its perform method

====================

2011-04-29 01:29:44,272 [xkdp7xnv3zx2] INFO  emschema.xkdp7xnv3zx2 - not found repos connection
2011-04-29 01:29:44,272 [xkdp7xnv3zx2] INFO  emschema.xkdp7xnv3zx2 - error: not found repos connection for transx repos user exists: false mgmt_messages exists: false; found connection for repos user: false
2011-04-29 01:29:44,273 [xkdp7xnv3zx2] ERROR emschema.xkdp7xnv3zx2 - Failed Parameter Validation
2011-04-29 01:29:44,273 [xkdp7xnv3zx2] ERROR emschema.xkdp7xnv3zx2 - NULL Exception was thrown!
2011-04-29 01:29:44,273 [xkdp7xnv3zx2] ERROR emschema.xkdp7xnv3zx2 - Failed Parameter Validation

===========================

INFO: oracle.sysman.top.oms:The command run for transx is /u01/app/OEM11g/Middleware/oms11g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oem11gmach01.localdomain)(PORT=1521)))(CONNECT_DATA=(SID=OEMDB))) -action transx  -repos_user SYSMAN -dbUser SYS -mwHome /u01/app/OEM11g/Middleware -mwOraHome /u01/app/OEM11g/Middleware/oms11g
INFO: oracle.sysman.top.oms:processing arguments
INFO: oracle.sysman.top.oms:compiling arguments for validation
INFO: oracle.sysman.top.oms:stty: standard input: Invalid argument
INFO: oracle.sysman.top.oms:stty: standard input: Invalid argument
INFO: oracle.sysman.top.oms: Enter SYSMAN repository password :
INFO: oracle.sysman.top.oms:stty: standard input: Invalid argument
INFO: oracle.sysman.top.oms:stty: standard input: Invalid argument
INFO: oracle.sysman.top.oms:Verify :
INFO: oracle.sysman.top.oms:Enter password for: SYSMAN
INFO: oracle.sysman.top.oms:^H ^Hdone checking required user credentials...
INFO: oracle.sysman.top.oms:done creating arguments...

Solution:

Clean up the Management Repository by running the following command
/u01/app/OEM11g/Middleware/oms11g/sysman/admin/emdrep/bin/RepManager oem11gmach01.localdomain 1521 OEMDB -action dropall -dbUser SYS -dbPassword xxxxxxx -dbRole sysdba -mwHome /u01/app/OEM11g/Middleware -mwOraHome /u01/app/OEM11g/Middleware/oms11g -oracleHome /u01/app/OEM11g/Middleware/oms11g  -continueOnError

Then re-run the configuration tool script.
/u01/app/OEM11g/Middleware/oms11g/perl/bin/perl /u01/app/OEM11g/Middleware/oms11g/sysman/install/ConfigureGC.pl

If there are any failed configuration tools, please refer the document here.

Reference MOS IDs :  1067438.1 , 1106105.1 , 1063587.1 , 1063112.1 , 1064441.1 , 1064495.1 , Install Guide

Thanks
SRI

Posted in OEM | Tagged: , , , , , | 17 Comments »

OEM Gridcontrol 10201 Installation Errors On Linux 5.4

Posted by Srikrishna Murthy Annam on March 17, 2011

In this article i am gooing to describe the issues we faced during 10.2.0.1 oem grid controll on a RHEL 5.4.

Issue 1:

When i start installing the oem grid control after completing all the pre requesites, we got the following error. The cursor hangs there instead of populating OUI window.

[oracle@dhcppc30 ~]$ cd /u01/dumps/oem/Disk1/
[oracle@dhcppc30 Disk1]$ ./runInstaller
Starting Oracle Universal Installer…Checking installer requirements…Checking operating system version: must be enterprise-4, enterprise-5, redhat-3, redhat-4, redhat-5, redhat-5.1, SuSE-9, SuSE-10, UnitedLinux-1.0, asianux-1 or asianux-2
PassedAll installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-17_11-43-44AM. Please wait …[oracle@dhcppc30 Disk1]$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2011-03-17_11-43-44AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
at oracle.sysman.emgc.oneclick.OneClickWizard.getGuiDefaults(OneClickWizard.java:239)
at oracle.sysman.emgc.oneclick.OneClickWizard.<init>(OneClickWizard.java:205)
at oracle.sysman.emgc.oneclick.OneClick.<init>(OneClick.java:230)
at oracle.sysman.emgc.oneclick.OneClickInstaller.<init>(OneClickInstaller.java:116)
at oracle.sysman.emgc.oneclick.OneClickInstaller.process(OneClickInstaller.java:268)
at oracle.sysman.emgc.oneclick.OneStartup.startup(OneStartup.java:359)
at oracle.sysman.emgc.oneclick.OneArgs.main(OneArgs.java:650)
at oracle.sysman.emgc.oneclick.OneStartup.main(OneStartup.java:367)

When i observe the error message i thought it may the error with LD_LIBRARY_PATH and tried all the possible values for this variable , but no luck. Then after googling i came to know that there is one rpm missing in the OS RHEL 5.4.  Then i installed “libXp-1.0.0-8.1.el5.i386.rpm” and tried. It works …..

RPMs Locations

Issue 2:

error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Solution: Install libaio and libaio-devel packages. If packages already installed and error still occurs try execute “ldconfig” as root.

Issue 3:

Failed in smi manipulation().
A problem has occurred reading the initial configuration and storing it into repository
Resolution:
Please refer to the base exception for resolution, or call Oracle support.
Base Exception:
/u01/app/oracle/oem/oms10g/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
Resolution:
Please make sure the values entered in OHS configuration files are correct.
oracle.ias.sysmgmt.exception.InvalidConfigurationException: Base Exception:
/u01/app/oracle/oem/oms10g/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
Resolution:
Please make sure the values entered in OHS configuration files are correct.
at oracle.ias.sysmgmt.repository.plugin.advanced.apache.StateTranslator.checkConfigFileValidity(Unknown Source)
at oracle.ias.sysmgmt.repository.plugin.advanced.apache.StateTranslator.validateConfigDuringEvaluate(Unknown Source)
at oracle.ias.sysmgmt.repository.plugin.advanced.apache.PlugInImpl.localConfigValidation(Unknown Source)
at oracle.ias.sysmgmt.repository.DcmPlugin.localConfigValidation(Unknown Source)
at oracle.ias.sysmgmt.repository.RepositoryImpl.performLocalValidation(Unknown Source)
at oracle.ias.sysmgmt.repository.SyncUpHandler._updatePluginConfigData(Unknown Source)
at oracle.ias.sysmgmt.repository.SyncUpHandler.syncUpFromLocalFiles(Unknown Source)
at oracle.ias.sysmgmt.repository.RepositoryImpl.syncUpFromLocalFiles(Unknown Source)
at oracle.ias.sysmgmt.utility.editpropagator.PropagateLocalEdit.repositoryInit(Unknown Source)
at oracle.ias.sysmgmt.persistence.utility.PMUtility.initConfiguration(Unknown Source)
at oracle.ias.sysmgmt.task.TaskMaster.initConfiguration(Unknown Source)
at oracle.ias.sysmgmt.task.TaskMaster.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.TaskMaster.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.InstanceManager.sysInit(Unknown Source)
at oracle.ias.sysmgmt.task.InstanceManager.init(Unknown Source)
at oracle.ias.sysmgmt.EntryPoint.init(Unknown Source)
at oracle.ias.webcache.config.WebcacheConfig.smiSetup(WebcacheConfig.java:483)
at oracle.ias.webcache.config.WebcacheConfig.smiEnableWebcache(WebcacheConfig.java:454)
at oracle.ias.webcache.config.WebcacheConfig.enableConfiguration(WebcacheConfig.java:299)
at oracle.ias.webcache.config.WebcacheConfig.main(WebcacheConfig.java:87)Command = /u01/app/oracle/oem/oms10g/jdk/bin/java has failedINFO: Configuration assistant “Web Cache Configuration Assistant” failed

Solution :

create a symbolic link “ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2″

chmod 755 /usr/lib/libgdbm.so.2.0.0
chmod 755 /usr/lib/libdb.so.2

[root@oemmach01 logs]# locate libdb.so.2
[root@oemmach01 logs]# locate libgdbm.so.2.0.0
/usr/lib/libgdbm.so.2.0.0
[root@oemmach01 logs]# ls -ldd libgdbm.so.2.0.0
ls: libgdbm.so.2.0.0: No such file or directory
[root@oemmach01 logs]# ls -ldd /usr/lib/libgdbm.so.2.0.0
-rwxr-xr-x 1 root root 25260 Jun  5  2007 /usr/lib/libgdbm.so.2.0.0
[root@oemmach01 logs]# ldd /usr/lib/libgdbm.so.2.0.0
linux-gate.so.1 =>  (0x0075b000)
libc.so.6 => /lib/libc.so.6 (0x0094c000)
/lib/ld-linux.so.2 (0x0092e000)
[root@oemmach01 logs]#

[root@oemmach01 logs]# ldd /usr/lib/libgdbm.so.2.0.0
linux-gate.so.1 =>  (0x0075b000)
libc.so.6 => /lib/libc.so.6 (0x0094c000)
/lib/ld-linux.so.2 (0x0092e000)
[root@oemmach01 logs]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
[root@oemmach01 logs]# chmod 755 /usr/lib/libgdbm.so.2.0.0
[root@oemmach01 logs]# chmod 755 /usr/lib/libdb.so.2
[root@oemmach01 logs]#

Issue 4:

Command = /u01/app/oracle/oem/oms10g/jdk/bin/java -Djava.net.preferIPv4Stack=true -Djava.io.tmpdir=/tmp -mx512M -classpath /u01/app/oracle/oem/oms10g/dcm/lib/dcm.jar:/u01/app/oracle/oem/oms10g/dcm/lib/oc4j_deploy_tools.jar:/u01/app/oracle/oem/oms10g/opmn/lib/opmnplugin.jar -Doracle.ias.sysmgmt.logging.logdir=/u01/app/oracle/oem/oms10g/j2ee/home/log oracle.j2ee.tools.deploy.Oc4jDeploy -oraclehome /u01/app/oracle/oem/oms10g -verbose -inifile /u01/app/oracle/oem/oms10g/j2ee/deploy.ini  has failed
Execution Error : oracle.ias.sysmgmt.exception.InvalidSMISessionException: Base Exception:
This DCM Client Session has been invalidated due to changes made to config files by some other session. All unsaved changes will be lost.
Resolution:
Please close this DCM Client session, start another one and redo the changes made.
at oracle.ias.sysmgmt.entity.Session.verifySessionIsValid(Unknown Source)
at oracle.ias.sysmgmt.entity.Session.makeDeleteEntityListConsistent(Unknown Source)
at oracle.ias.sysmgmt.smi.SMIEntryPoint.saveChanges(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.saveSMIChanges(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.saveSMIChanges(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.doDeploy(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.execute(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.deploy(Unknown Source)
at oracle.j2ee.tools.deploy.Oc4jDeploy.main(Unknown Source)INFO: Configuration assistant “OC4J Instance Configuration Assistant” failedSolution :

[root@oemmach01 logs]# /u01/app/oracle/oem/oms10g/jdk/bin/java -Djava.net.preferIPv4Stack=true -Djava.io.tmpdir=/tmp -mx512M -classpath /u01/app/oracle/oem/oms10g/dcm/lib/dcm.jar:/u01/app/oracle/oem/oms10g/dcm/lib/oc4j_deploy_tools.jar:/u01/app/oracle/oem/oms10g/opmn/lib/opmnplugin.jar -Doracle.ias.sysmgmt.logging.logdir=/u01/app/oracle/oem/oms10g/j2ee/home/log oracle.j2ee.tools.deploy.Oc4jDeploy -oraclehome /u01/app/oracle/oem/oms10g -verbose -inifile /u01/app/oracle/oem/oms10g/j2ee/deploy.ini

Reading ini file – ‘/u01/app/oracle/oem/oms10g/j2ee/deploy.ini’
Adding web-app ‘IsWebCacheWorkingWeb.war’ for app ‘IsWebCacheWorking’.
Initializing DCM…done.
OC4J instance ‘home’ already exists.
Starting OC4J instance ‘home’…done.
Deploying application ‘IsWebCacheWorking’ to OC4J instance ‘home’.
Notification ==> Application Deployer for IsWebCacheWorking STARTS [ 2011-04-17T04:04:15.915PDT ]
Notification ==> Undeploy previous deployment
Notification ==> Removing files for app file:/u01/app/oracle/oem/oms10g/j2ee/home/applications/IsWebCacheWorking.ear
Notification ==> Copy the archive to /u01/app/oracle/oem/oms10g/j2ee/home/applications/IsWebCacheWorking.ear
Notification ==> Unpack IsWebCacheWorking.ear begins…
Notification ==> Unpack IsWebCacheWorking.ear ends…
Notification ==> Initialize IsWebCacheWorking.ear begins…
Notification ==> Initialize IsWebCacheWorking.ear ends…
Notification ==> Initialize IsWebCacheWorkingWeb begins…
Notification ==> Initialize IsWebCacheWorkingWeb ends…
Notification ==> deleting:  /u01/app/oracle/oem/oms10g/j2ee/home/applications/IsWebCacheWorking.ear
Notification ==> deleting:  /u01/app/oracle/oem/oms10g/j2ee/home/applications/IsWebCacheWorking/IsWebCacheWorkingWeb.war
Notification ==> Application Deployer for IsWebCacheWorking COMPLETES [ 2011-04-17T04:04:16.023PDT ]

Calling updateConfig to notify DCM of new deployments…done.
Adding OC4J mount points for application ‘IsWebCacheWorking’…done.
Calling SMI to save changes.
SMISession.saveChanges succeeded.
Binding web app ‘IsWebCacheWorkingWeb’ to default-web-site for application ‘IsWebCacheWorking’ in OC4J instance ‘home’
Web app ‘IsWebCacheWorkingWeb’ bound successfully.
Calling updateConfig to notify DCM of new web-bindings…done.
Adding application ‘IsWebCacheWorking’ to the DCM repository…done.
Application ‘IsWebCacheWorking’ deployed successfully.
Stopping OC4J instance ‘home’…done.
Calling SMI to retry init of failed plugins…done.
Terminating DCM…done.
Copying /u01/app/oracle/oem/oms10g/j2ee/deploy.ini to /u01/app/oracle/oem/oms10g/j2ee/deploy.ini.1303038278047.bak.
Writing any undeployed entries back to /u01/app/oracle/oem/oms10g/j2ee/deploy.ini.

Oc4jDeploy tool completed successfully!

[root@oemmach01 logs]#

Issue 5:

Check complete. The overall result of this check is: Failed <<<<
Solution: Install missing package or set check system parameters (See reason of failure).

Hope it helps

SRI

Posted in OEM, Troubleshooting | Tagged: , , , , , , | 1 Comment »

Install 10gR2 grid control and Agents

Posted by Srikrishna Murthy Annam on February 9, 2011

In the present article i will show you how to install 10gR2 grid control and also how to install agents on different hosts linux and windows to monitor databases.

This demo is prepared assuming that you already have 2 linux servers and 1 windows server created in vmware.

The following topics are demonstrated …

  1. Installing 10gR2 grid control(OMS) on linux machine with new repository database and test the server URL.
  2. Installing agents on linux server with existing database
  3. Installing agents on linux when creating a new database with DBCA
  4. Installing agents on windows server with existing database
  5. Installing agents on windows when creating a new database with DBCA




Hope It Helps

SRI

Posted in OEM | Tagged: , , , , , , , | 1 Comment »

 
%d bloggers like this: