‘GRID’ Archives
ORA-7445 core dump [kokscold()+849] from EM 12c
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file /u01/app/oracle/diag/rdbms/pkldb/pkldb/trace/pkldb_j035_14712.trc (incident=52961): ORA-07445: exception [Read More]
EM12c:Automated discovery of Targets
In this post we will discuss the Automated discovery of Targets in Enterprise Manager Cloud Control(EM 12c). Once you have installed agents, you can schedule automatic discovery of new targets. Let’s get started 1)Click on Add Target>Configure Auto Discovery from [Read More]
Em12c:Silent Oracle Management agent Installation
This Post would describe how to install Oracle Management Agent 12c in silent mode. We need to download the agent software which can be done using emcli utility which is present on OMS host.Login to OMS host and execute emcli utility as mentioned below [Read More]
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c (12.1.0.1.0). The Complete Upgrade process will be carried out under 3 different stages: 1. Patch existing 11g OMS to get the 12c upgrade console. 2. Deploy and [Read More]
Retrieving Database SID,Port information from Grid Control repository
This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be used to create a tns entries and we can further use it to run a sql on all these databases. set pages 999 lines [Read More]
‘Metric execution timed out’ error reported by Grid
We use 10.2 Enterprise Manager Grid control to monitor our oracle database environments . Apart from the normal metrics provided by oracle we also use host based and sql user defined metrics which allows you to monitor almost anything . Coming back to the main issue, [Read More]
Installing 10.2.0.5 EM using software-only on 10.2.0.4/11g DB (GUI)
In this article , I will discuss how to install 10.2.0.5 EM Grid using 10.2.0.4 database. This method can also be used with 11g database.When you carry out 10.2.0.1 EM Grid control installation, it creates a 10.1.0.4 Database by default which is no longer supported and [Read More]
Grid Control Fails to Start
The link for Grid Control was not Working and it failed to show the login page. In this situation checked the following things: 1. The repository database was up and running 2. The listener was up. 3. OMS server was down. Tried to stratup the OMS server using opmnctl [Read More]
DBConsole Issue on RAC -Part II
Continuing with DBConsole issue, we were able to get the cluvfy return success for the nodes. Basically Oracle suggested us that when we use ssh we should not get any banner. E.g $ ssh PROD02 date Fri Jun 13 02:00:41 IST 2008 But in our case it was displaying a banner which [Read More]
DBConsole Issue on RAC -Part I
Currently I am working on issue where DBConsole is not starting on our 2 Node RAC system. When I try to start, I get following errors $ emctl status dbconsole TZ set to US/Pacific Exception in getting local host java.net.UnknownHostException: PROD01: PROD01 at [Read More]
