Grid Control (14)

Friday 06 June, 2008 - 22:54

One (1) target warning message on gridctrl related to performance.

Guess what? AWR is not installed in the emrep database. Used @?/rdbms/admin/catawr to install AWR, and I installed StatsPack at the same time.

The other seven (7) all relate to the issue identified in Grid Control (11) .

This does not make sense. Something is wrong here.

I checked the logs outside of Grid Control by browsing $ORACLE_HOME/OracleHomes/oms10g/Apache/Apache/logs/error_log.1212710400 , and found many errors like the following:

[Fri Jun 6 21:54:28 2008] [error] [client 192.168.0.202]
  [ecid: 1212753268:192.168.0.200:3367:0:872,0] client denied by server configuration:
  /em/upload/

It would appear that rmancat (192.168.0.202) is trying to upload data to gridctrl but is being refused permission to do so.

On rmancat ,

$ 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 : /u00/app/oracle/OracleHomes/agent10g Agent binaries : /u00/app/oracle/OracleHomes/agent10g Agent Process ID : 3763 Parent Process ID : 3748 Agent URL : http://rmancat.yaocm.id.au:3872/emd/main/ Repository URL : http://gridctrl.yaocm.id.au:4889/em/upload/ Started at : 2008-06-06 16:33:12 Started by user : oracle Last Reload : 2008-06-06 16:33:12 Last successful upload : (none) Last attempted upload : (none) Total Megabytes of XML files uploaded so far : 0.00 Number of XML files pending upload : 98 Size of XML files pending upload(MB) : 5.97 Available disk space on upload filesystem : 89.09% Last successful heartbeat to OMS : 2008-06-06 22:34:59 --------------------------------------------------------------- Agent is Running and Ready

The solution is in Enterprise Manager Grid Control Installation and Basic Configuration (Appendix A) . The clue is that I was trying to run the agent unsecured across a network. To fix this,

$ emctl secure agent pw
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Agent successfully stopped... Done.
Securing agent... Started.
Requesting an HTTPS Upload URL from the OMS... Done.
Requesting an Oracle Wallet and Agent Key from the OMS... Done.
Check if HTTPS Upload URL is accessible from the agent... Done.
Configuring Agent for HTTPS in CENTRAL_AGENT mode... Done.
EMD_URL set in /u00/app/oracle/OracleHomes/agent10g/sysman/config/emd.properties
Securing agent... Successful.
Agent successfully restarted... Done.
$ emctl secure status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Checking the security status of the Agent at location set
  in /u00/app/oracle/OracleHomes/agent10g/sysman/config/emd.properties... Done.
Agent is secure at HTTPS Port 3872.
Checking the security status of the OMS at http://gridctrl:4889/em/upload/... Done.
OMS is secure on HTTPS Port 1159
$ emctl upload
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
$ 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 : /u00/app/oracle/OracleHomes/agent10g
Agent binaries : /u00/app/oracle/OracleHomes/agent10g
Agent Process ID : 31261
Parent Process ID : 31246
Agent URL : https://rmancat.yaocm.id.au:3872/emd/main/
Repository URL : https://gridctrl:1159/em/upload
Started at : 2008-06-06 22:52:05
Started by user : oracle
Last Reload : 2008-06-06 22:52:05
Last successful upload : 2008-06-06 22:53:00
Total Megabytes of XML files uploaded so far : 7.48
Number of XML files pending upload : 2
Size of XML files pending upload(MB) : 0.03
Available disk space on upload filesystem : 89.17%
Last successful heartbeat to OMS : 2008-06-06 22:52:09
---------------------------------------------------------------
Agent is Running and Ready

And rmancat appears in the list of targets on Grid Control. This fixes the problem described in RMANCAT (1) (I think).