Oracle Technology > Enterprise Manager >
em notes
EM11g install - RAC found on Single Instance
Whilst running the EM11g installer I received an error telling me that the value of the initi parameter cluster_database was incorrect. As I was trying to install EM11g on a single instance database this was not expected at all. Looking into the logfiles crated I discovered that this error was being thrown out as the installer was querying the Real Application Clusters paramter in V$option and discovering that it was true? Now although I do have RAC Enabled in this ORACLE_HOME I am not currently hosting any RAC databases, so on this occasion I was able to relink Oracle in this ORACLE_HOME with RAC turned off.
If I was then going to use the same ORACLE_HOME for RAC and non-RAC databases I could then enable RAC once the Em11g install completed, or create a seperate ORACLE_HOME for the EM11g Repository Database. |
Query OEM Targets in the Repository
This query can be imported into SQL Developer to show a graph of the targets in the OEM Repository and then further detail in a child query. This runs against OEM 11.1 |
Cloning the Oracle EM11g Agent
Copy the software to the new node ./runInstaller -clone -forceClone ORACLE_HOME=<full path of Oracle home> ORACLE_HOME_NAME=<Oracle home name> -noconfig -silent OMS_HOST=<oms_host> OMS_PORT=<oms_port> >> prompted to run ORACLE_HOME/root.sh for the agent at this point << $<ORACLE_HOME>/bin/agentca -f -c "node1, node2, node3...." |
Using the Oracle Support Hub with 10.2.0.5 Grid Control
Reference Oracle Support Note: 886615.1 & http://download.oracle.com/docs/html/E14501_02/stdalone_rptr.htm
This guide is for how i did it on my RHEL 5 Grid Control host, but the Support Note referenced gives Windows examples as well.
On the clients that will use the support hub, you configure using the files in $ORACLE_HOME/ccr/bin
- Check OMS host
- $ORACLE_HOME/opmn/bin/opmnctl status -l | grep HTTP_Server
- HTTP_Server | HTTP_Server | 24017 | Alive | 1544486943 | 356216 | 20:02:24 | http1:7778,http2:7201,https1:4444,https2:1159,http3:4889
- this identifies http3 (the direct console port) as 4889 [handy as this is the default value]
- The command line tool for the OCM Repeater is found in $ORACLE_HOME/ocm/bin
- ./ocmrepeaterctl status
-
I need to modify the Proxy Settings so that a connection can be made to the internet../ocmrepeaterctl configure
enter the proxy details as username@proxy.host:80 - using your own username and proxy host of course, port is 80 "mostly"
This will stop and start the repeater through opmn and checking the status again will show this is now set.
- If this is a new install you will need to run setupCCR to deploy the OCM Application
- may need to use setupCCR -s -d (if no connection to the internet is possible)
- then run $ORACLE_HOME/ccr/bin/emocmrsp -repeater http://<hostname>[:<port>]
- this creates an ocm.rsp (a response file with your proxy details)
- then run configCCR -R ocm.rsp
- finally test using emCCR -verbose test and you should see your hub server is used.
Grid Control Metrics Browser
It's possible in Grid Control to get the Agent on a monitored host to
publish it's information to a browser without the need for a logon.
Very useful if you want to check that the Agent is working correctly, or for providing some useful links to developers while they are trying to debug peformance etc.
Very useful if you want to check that the Agent is working correctly, or for providing some useful links to developers while they are trying to debug peformance etc.
Stress Testing using Grid Control
Created a number of scheduled SQL jobs to push through many transactions and see what happens :-) | exec dbms_session.set_identifier('Alan Stress Test 5'); exec dbms_application_info.set_module('Alan Stress Test 5','Create Table'); create table alanstresstest5 as select * from alanloadtest; exec dbms_application_info.set_module('Alan Stress Test 5','Query Table'); select count(*) from alanstresstest5; exec dbms_application_info.set_module('Alan Stress Test 5','Update Table'); update alanstresstest5 set status = 'STRESS' where owner='ALANNOLANDAVIES'; exec dbms_application_info.set_module('Alan Stress Test 5','Create Index'); create index stressindex5 on alanstresstest5(object_name); exec dbms_application_info.set_module('Alan Stress Test 5','Delete from Table'); delete from alanstresstest5 where object_id between 1000 and 2000; exec dbms_application_info.set_module('Alan Stress Test 5','Query Table'); select count(*) from alanstresstest5; exec dbms_application_info.set_module('Alan Stress Test 5','Drop Table'); drop table alanstresstest5; |
|
1-10 of 10