Eu estava tentando parar o OMS quando eu recebi o seguinte erro “EM Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/ocm.localdomain_OEM not found.”. Para resolver este problema, eu fiz os seguintes passos: Meu erro: [oracle@ocm bin]$ emctl status oms EM Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/ocm.localdomain_OEM not found. Minha solução: [oracle@ocm MWOEM]$ export OMS_HOME=/u01/Oracle/MWOEM/oms11g [oracle@ocm MWOEM]$ export AGENT_HOME=/u01/Oracle/MWOEM/agent11g [oracle@ocm MWOEM]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 [oracle@ocm bin]$ $OMS_HOME/bin/emctl start oms [oracle@ocm bin]$ $OMS_HOME/bin/emctl start oms Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Starting WebTier… WebTier Successfully Started Starting Oracle…
Category: Oracle Enterprise Management (OEM or EM)
Create Enterprise Manager User in OEM Grid Control 11G
Using Oracle Enterprise Manager, you can 3 types of authentication schemes: Repository-Based Authentication: Default authentication option. SSO-Based Authentication:The single sign-on authentication. Enterprise User Security Based Authentication: Users for Oracle database in LDAP server. Therefore, OEM has 3 types of acess: Super Administrator: Can do anything. Administrator: Can do what you define. Repository Owner: Database administrator for the Management Repository. To create use in OEM it is very easy, you have to do the follow steps: Go to OEM Grid Control Page Click “Setup” -> Click “Administrators” -> Click “Create” ->…
Creating alerts in OEM DB Control 11G
In the Oracle Enterprise Management you can create alerts for users. This alerts can be OS_BASED (using scripts) or SQL_BASED (using PL/SQL queries). In this post I will show an example about this alerts. OS_BASED: For to do an alert using scripts , before you must do a script to put it in the OEM metrics. Then, I will use a script from Oracle’s Documentation: #!/usr/bin/perl # Description: 5-min load average. # Sample User Defined Event monitoring script. $ENV{PATH} = “/bin:/usr/bin:/usr/sbin”; $DATA = `uptime`; $DATA =~ /average:s+([.d]+),s+([.d]+),s+([.d]+)s*$/; if (defined $2)…
Creating notifications using Oracle Enterprise Manager (OEM) DB Control 11G
There are several types to do a notification using Oracle Enterprise Manager as notification by e-mail, by script, by PL/SQL , SNMP and so on. Here I will show how to do a notification to an e-mail and another notification to a script in a server that OMS (Oracle Management Service) is located. Then … hands-on : In OEM click “Setup” -> “Notification Methods” . In this section you have to complete some informations: Outgoing Mail (SMTP) Server = “smtp.brunors.com:587″ User Name = “open2kg@brunors.com” Password / Confirm Password = “XXXXXXXXXX”…
What’s my port number in Oracle Enterprise Manager (OEM)?
I was trying to remember the port number of my Oracle Rac in Oracle Linux. Then, I find this information in $ORACLE_HOME/install/portlist.ini. In this case the port number was 1158 (the default number), but it is important you know about this file because it can help you in other situation. Also you can find this information in $ORACLE_HOME/Oracle_sid/sysman/config/emd.properties by variable REPOSITORY_URL: I hope this post can help you. More informations in : Oracle® Database 2 Day DBA 11g Release 2 (11.2) Part Number E10897-06 brunors
Oracle 11g Enterprise Manager DB Control Changing Accessibility Mode Disabled to Enabled
I was using the OEM11G, when after the logon with my credential users, I saw the follow message “Accessibility Mode Disabled” as the image below: To solve it, you need to change the status of the accessibility-mode in the file “uix-config.xml”. This file can be found on directory: $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/WEB-INF/. Then, you need to do the follow steps: vi $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/WEB-INF/uix-config.xml (Look the status “inaccessible” in the picture below): Change the status of the accessibility mode in the file from inaccessible to accessible. After you changed the accessibility mode, save and close…