{"id":130,"date":"2009-01-08T15:02:00","date_gmt":"2009-01-08T13:02:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/01\/08\/oracle-grid-control\/"},"modified":"2010-08-24T22:42:23","modified_gmt":"2010-08-24T20:42:23","slug":"oracle-grid-control","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/01\/08\/oracle-grid-control\/","title":{"rendered":"ORACLE GRID CONTROL"},"content":{"rendered":"<p><span style=\"font-weight: bold;\">Install repository:<\/span><\/p>\n<ol>\n<li>get full version Grid Control 10.2.0.1.0 (10.2.0.2.1 for Windows) and install, newer versions are installed against 10.2.0.1.0<\/li>\n<li>unpack files straight to directory with file runInstaller, in the other case error: OUI-10133 invalid staging area appear<\/li>\n<li>when on machine was instaled database do not forget remove \/etc\/oraInst.loc which describe path to previous inventory<\/li>\n<li>install missing libraries:\n<ul>\n<li>openmotif2.1<\/li>\n<li>ysstat<\/li>\n<li>control-center<\/li>\n<li>compat-db<\/li>\n<\/ul>\n<\/li>\n<li>run runInstaller<\/li>\n<li>at the end files was generated:<\/li>\n<ul>\n<li>\/usr\/bin\/dbhome, \/usr\/local\/bin\/dbhome<\/li>\n<li> \/usr\/bin\/oraenv,  \/usr\/local\/bin\/oraenv<\/li>\n<li>\/usr\/bin\/coraenv, \/usr\/local\/bin\/<\/li>\n<\/ul>\n<\/ol>\n<p>Install agent on every monitoring hosts<br \/><b>CHECK STATUS, START AND STOP:<\/b><br \/>EMCTL (Enterprise Manager tool starts,stops and manages security for Oracle Enteripise Manager)<br \/>[agent_path]\/bin\/emctl status | start | stop agent #check status, start, stop AGENT &#8211; perl application [oms_path]\/bin\/emctl<br \/>status iasconsole<br \/>[oms_path]\/opmn\/bin\/opmnctl status -l | startall | stopall #check status, start, stop AS &#8211; java application<\/p>\n<p><span style=\"font-weight: bold;\">LOCAL EM &#8211; not GRID:<\/span><br \/>Must remember that EM is installed in directory ORACLE_HOME\/hostname_sid so when ex hostname was changed it must be change in files:<br \/>\/sysman\/config\/emca.properties #repo config<br \/>\/sysman\/config\/emd.properties #AGENT config<br \/>\/sysman\/config\/emoms.properties #repo config<br \/>\/sysman\/emd\/targets.xml #AGENT config<\/p>\n<p><b>DBCONSOLE (for LOCAL EM) &#8211; not GRID:<\/b><br \/>set ORACLE_HOSTNAME <span style=\"font-style: italic;\">(beware it is casesensitive, sometimes password for DBSNMP inside quotation mark)<\/span><br \/>emca -deconfig dbcontrol db -repos drop #drop all directory and repository from db<br \/>emca -config dbcontrol db -create #create directory and repository in db<br \/>emca -config dbcontrol db -repos recreate -SID [sid] -PORT [port] -ORACLE_HOME [oracle_home] -DBCONTROL_HTTP_PORT [port]<br \/>emca -config all db -repos recreate<span style=\"font-weight: bold;\">;<\/span><br \/>emctl getemhome<\/p>\n<p><span style=\"font-weight: bold;\">during changing hostname<\/span>:<br \/>from<br \/>oracle_home\/oc4j\/j2ee\/OC4J_DBConsole_[oldhostname]_sid<br \/>oracle_home\/[oldhostname]_sid<br \/>to newhostname_sid<br \/>and changes in files:<br \/>\/sysman\/config\/emca.properties<br \/>\/sysman\/config\/emd.properties<br \/>\/sysman\/config\/emoms.properties<br \/>\/sysman\/emd\/targets.xml<br \/>\/hostname_sid\/config\/emca.properties<br \/>\/hostname_sid\/config\/emd.properties<br \/>\/hostname_sid\/config\/emoms.properties<br \/>\/hostname_sid\/emd\/targets.xml<\/p>\n<p><span style=\"font-weight: bold;\">set ports:<\/span><br \/>emca -reconfig ports [-DBCONTROL_HTTP_PORT [port]] [-RMI_PORT [port]] [-JMS_PORT [port]] [-AGENT_PORT [port]]<br \/><span style=\"font-weight: bold;\">ISQLPLUS:<\/span><br \/>isqlplusctl start | stop http:\/\/hostname:5560\/isqlplu<\/p>\n<table class=\"tbl\">\n<tbody>\n<tr>\n<th>EM DIRS<\/th>\n<\/tr>\n<tr>\n<td>ORACLE_HOME\/cfgtoollogs<\/td>\n<\/tr>\n<tr>\n<td>ORACLE_HOME\/oc4J<\/td>\n<\/tr>\n<tr>\n<td>ORACLE_HOME\/opmn<\/td>\n<\/tr>\n<tr>\n<td>ORACLE_HOME\/sysman<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>check reposidory database:<\/b><br \/>SELECT * FROM sysman.mgmt_targets;<br \/>SELECT * FROM sysman.mgmt_versions;  <\/p>\n<p><b>GRID:<\/b><br \/>when Management Service (MS) was changed so it must reconfigure Agent but it is not necessary to make changes in Management Service, but restart Agent only<\/p>\n<p>1. stop AGENT<br \/>2. $AGENT_HOME\/sysman\/config\/emd.properties<br \/>REPOSITORY_URL<br \/>emdWalletSrcUrl<br \/>emdWalletDest<br \/>3. remove all files from:<br \/>$AGENT_HOME\/sysman\/emd\/upload\/*<br \/>$AGENT_HOME\/sysman\/emd\/state\/*<br \/>4. restart AGENT<\/p>\n<p><b>when AGENT port (to get commands from MS) was changed:<\/b><br \/>1. stop AGENT<br \/>2. $AGENT_HOME\/sysman\/config\/emd.properties<br \/>EMD_URL<br \/>3. start AGENT<\/p>\n<p><b>set password for db which is monitored by AGENT:<\/b><br \/>1. stop AGENT<br \/>2. edit $AGENT_HOME\/sysman\/emd\/targets.xml<\/p>\n<div class=\"console\"><target type=\"oracle_database\" name=\"sid_hostname.domain\"><property name=\"OracleHome\" value=\"\/u01\/app\/oracle\/product\/10.2.0\/db_1\"><\/property><property name=\"UserName\" value=\"dbsnmp\"><\/property><property name=\"MachineName\" value=\"hostname.domain\"><\/property><property name=\"Port\" value=\"1521\"><\/property><property name=\"SID\" value=\"SID\"><\/property><property name=\"ServiceName\" value=\"SIDAGNDB\"><\/property><property name=\"password\" value=\"fdsafsffdsafsa\" encrypted=\"TRUE\"><\/property><property name=\"Role\" value=\"NORMAL\"><\/property><\/target><\/div>\n<p>3. change password for DMSNMP user in line:<property name=\"password\" value=\"nowe_haslo\" encrypted=\"FALSE\">4. start AGENT<\/p>\n<p><b>limit disk size for AGENT to buffer data before sending to repository:<\/b><br \/>$AGENT_HOME\/sysman\/emd\/upload<br \/><i>default is up to 50M or to 98% disk size<\/i><br \/>$AGENT_HOME\/sysman\/config\/emd.properties<br \/>UploadMaxBytesXML<br \/>UplloadMaxDiskUsedPct<\/p>\n<p>watchdog process &#8211; controling AGENT if it is on, and start it when not<br \/>$AGENT_HOME\/bin\/emwd.pl<br \/>ps aux|grep emwd<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>${ORACLE_HOME}\/bin\/mkwallet -i welcome<br \/>${ORACLE_HOME}\/sysman\/config\/monwallet<br \/>${ORACLE_HOME}\/sysman\/config\/b64SiteCertificate.txt NZDST_CLEAR_PTP<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p><b>changing password in repository:<\/b><br \/>MANAGEMENT SERVICE<br \/>1. set repo<br \/>[$ORACLE_HOME\/sysman\/config\/emoms.properties]<br \/>emdRepUser<br \/>emdRepPwd<br \/>emdRepConnectDescriptor<br \/>emdRepSID<br \/>emdRepServer<br \/>emdRepPort<\/p>\n<p>2. stop MS<br \/>$ORACLE_HOME\/bin\/emctl stop oms<br \/>3. set passwd<br \/>$ORACLE_HOME\/bim\/emctl setpasswd oms<br \/>4. start MS<br \/>$ORACLE_HOME\/bim\/emctl start oms<\/p>\n<p><b>change IAS password:<\/b><br \/>The ias_admin user is the administrative user for Oracle Application Server instances<br \/>This password is same as the SYSMAN password that you specified when you first installed the Grid Control in your environment. <br \/>After installing the Grid Control in your environment, if you change the SYSMAN password, ias_admin password will not be changed.<br \/>$ORACLE_HOME\/bin\/emctl set password <old ias_admin=\"\" password=\"\"> <new ias_admin=\"\" password=\"\"><\/p>\n<p><b>reset IAP password:<\/b><br \/>OMS_path\/bin\/emctl stop iasconsole<br \/>edit:<br \/>OMS_path\/sysman\/j2ee\/config\/jazn-data.xml<br \/>change lines:<br \/><name>ias_admin<\/name><br \/><credentials>{903}fdsafsafsdafsadfsdafsd<\/credentials><br \/><credentials>!new_password<\/credentials><br \/>OMS_path\/bin\/emctl start iasconsole<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>spr.<br \/>agntstmp.txt<br \/>lastupld.xml<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/><b>change MS port:<\/b><br \/>1. stop MS<br \/>2. edit $ORACLE_HOME\/sysman\/config\/httpd_em.conf<br \/>change all references to port 4889<br \/>3. send info to DCM tier<br \/>$ORACLE_HOME\/dcm\/bin\/dcmctl updateconfig -ct ohs<br \/>4. edit $ORACLE_HOME\/sysman\/config\/emoms.properties<br \/>oracle.sysman.emSDK.svlt.ConsoleServerPort=4889<br \/>5. start MS<br \/>6. reconfigure all AGENTS<\/p>\n<p><b>AGENT logs:<\/b><br \/>edit:<br \/>$AGENT_HOME\/sysman\/config\/emd.properties<br \/>lines:<br \/>LogFilewithPID<br \/>LogFIleMaxSize<br \/>LogFIleMaxRolls<br \/>TrcFileMaxSize<br \/>TrcFileMaxRolls<\/p>\n<p>filelogs for AGENT<br \/>$AGENT_HOME\/sysman\/log\/emagent.log<br \/>$AGENT_HOME\/sysman\/log\/emagent.trc<br \/>$AGENT_HOME\/sysman\/log\/emagent.nohup<\/p>\n<p>settings in $Agent_HOME\/sysman\/config\/emagantlogging.properies<br \/>log4j.appender etc.<br \/>for collecting stats:<br \/>emagentfetchlet.log<br \/>emagentfetchlet.trc<\/p>\n<p><b>MS logs:<\/b><br \/>emoms.log<br \/>emoms.trc<br \/>$AS_HOME\/sysman\/log<br \/>settings in $AS_home\/sysman\/config\/emomslogging.properies<\/p>\n<p><b>AS logs<\/b><br \/>HTTP Server ORACLE_HOME\/Apache\/Apache\/logs\/error_log.timeORACLE_HOME\/Apache\/Apache\/logs\/access_log.time<br \/>OC4J  ORACLE_HOM<br \/>\nE\/j2ee\/instance_name\/logORACLE_HOME\/j2ee\/instance_name\/application-deployments\/application_name\/application.log<br \/>OPMN  ORACLE_HOME\/opmn\/logs<br \/>Web Cache ORACLE_HOME\/webcache\/logs<\/p>\n<p><b>Errors:<\/b><br \/>ERROR host.HostOverviewDataObject getLogonInfo.2447 &#8211; Connection refused<br \/>oracle.sysman.emSDK.emd.comm.CommException: Connection refused<br \/>ERROR host.HostSummaryDataObject getHostSummary.815 &#8211; Connection refused<br \/>oracle.sysman.emSDK.emd.comm.CommException: Connection refused<\/new><\/old><\/property>\n","protected":false},"excerpt":{"rendered":"<p>Install repository: get full version Grid Control 10.2.0.1.0 (10.2.0.2.1 for Windows) and install, newer versions are installed against 10.2.0.1.0 unpack files straight to directory with file runInstaller, in the other case error: OUI-10133 invalid staging area appear when on machine was instaled database do not forget remove \/etc\/oraInst.loc which describe path to previous inventory install [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[48],"class_list":["post-130","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-grid-control"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":196,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/130\/revisions\/196"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}