Wednesday, October 31, 2012

'emctl status agent' Command Shows "Collection Status Disabled By Upload Manager"


./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        : /fg01/app/linux/hostname/agent11g
Agent binaries    : /fg01/app/linux/hostname/agent11g
Agent Process ID  : 27736
Parent Process ID : 27698
Agent URL         : https://domain.com:3872/emd/main/
Repository URL    : https://domain.com:4900/em/upload
Started at        : 2012-10-30 20:52:45
Started by user   : oracle
Last Reload       : 2012-10-30 21:14:01
Last successful upload                       : 2012-10-31 06:55:18
Total Megabytes of XML files uploaded so far :     8.91
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :     4.39%

Collection Status                            : Disabled by Upload Manager
Last successful heartbeat to OMS             : 2012-10-30 19:05:14
---------------------------------------------------------------
Agent is Running and Ready



./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload error: Upload was successful but collections currently disabled - disk full

Solution:
-----------

<AGENT_HOME>/bin/emctl stop agent
<AGENT_HOME>/bin/emctl clearstate agent

cd <AGENT_STATE>/sysman/emd/upload
ls *.xml | wc -l



- Delete any pending upload files from the agent home
rm -r <AGENT_STATE>/sysman/emd/upload/*
rm <AGENT_STATE>/sysman/emd/lastupld.xml  
After deleting the files from upload re-start the agent and verify, if still did not help, please process the below.

- If needed, the values of the following parameters can be increased in the emd.properties file:



vi $AGENT_HOME/sysman/config/emd.properites


Below are the default values

UploadFileSize=2048
UploadMaxBytesXML=50
UploadMaxDiskUsedPct=98
Increase the above values as

UploadMaxBytesXML=60
UploadMaxDiskUsedPct=99 (Default value is 98)

<AGENT_HOME>/bin/emctl start agent
<AGENT_HOME>/bin/emctl status agent
./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        :
/fg01/app/linux/hostname/agent11g
Agent binaries    : /fg01/app/linux/hostname/agent11g
 Agent Process ID  : 27736
Parent Process ID : 27698
Agent URL         : https://domain.com:3872/emd/main/
Repository URL    : https://domain.com:4900/em/upload
Started at        : 2012-10-30 20:52:45
Started by user   : oracle
Last Reload       : 2012-10-30 21:14:01
Last successful upload                       : 2012-10-31 06:55:18
Total Megabytes of XML files uploaded so far :     8.91
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :     4.39%
Last successful heartbeat to OMS             : 2012-10-31 07:04:08
---------------------------------------------------------------
Agent is Running and Ready
 
<AGENT_HOME>/bin/emctl upload agent
./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully

 
 



Optimize Oracle UNDO Parameters

Overview
Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at which point it was made available for overlaying.
Best of all, automatic undo management allows the DBA to specify how long undo information should be retained after commit, preventing "snapshot too old" errors on long running queries.
This is done by setting the UNDO_RETENTION parameter.  The default is 900 seconds (5 minutes), and you can set this parameter to guarantee that Oracle keeps undo logs for extended periods of time.
Rather than having to define and manage rollback segments, you can simply define an Undo tablespace and let Oracle take care of the rest. Turning on automatic undo management is easy.  All you need to do is create an undo tablespace and set UNDO_MANAGEMENT = AUTO.
However it is worth to tune the following important parameters
  1. The size of the UNDO tablespace
  2. The UNDO_RETENTION parameter
Calculate UNDO_RETENTION  for given UNDO Tabespace
You can choose to allocate a specific size for the UNDO tablespace and then set the UNDO_RETENTION parameter to an optimal value according to the UNDO size and the database activity. If your disk space is limited and you do not want to allocate more space than necessary to the UNDO tablespace, this is the way to proceed. The following query will help you to optimize the UNDO_RETENTION parameter:
Because these following queries use the V$UNDOSTAT statistics, run the queries only after the database has been running with UNDO for a significant and representative time!
Actual Undo Size
SELECT SUM(a.bytes) "UNDO_SIZE"
  FROM v$datafile a,
       v$tablespace b,
       dba_tablespaces c
 WHERE c.contents = 'UNDO'
   AND c.status = 'ONLINE'
   AND b.name = c.tablespace_name
   AND a.ts# = b.ts#;
 UNDO_SIZE
----------
  209715200
Undo Blocks per Second
SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
    
 "UNDO_BLOCK_PER_SEC"
  FROM v$undostat;
UNDO_BLOCK_PER_SEC
------------------
        3.12166667
DB Block Size
SELECT TO_NUMBER(value) "DB_BLOCK_SIZE [KByte]"
 FROM v$parameter
WHERE name = 'db_block_size';
DB_BLOCK_SIZE [Byte]
--------------------
                4096
Optimal Undo Retention
209'715'200 / (3.12166667 * 4'096) = 16'401 [Sec]
Using Inline Views, you can do all in one query!
SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]",
       SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]",
       ROUND((d.undo_size / (to_number(f.value) *
       g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]"
  FROM (
       SELECT SUM(a.bytes) undo_size
          FROM v$datafile a,
               v$tablespace b,
               dba_tablespaces c
         WHERE c.contents = 'UNDO'
           AND c.status = 'ONLINE'
           AND b.name = c.tablespace_name
           AND a.ts# = b.ts#
       ) d,

       v$parameter e,
       v$parameter f,
       (
       SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
              undo_block_per_sec
         FROM v$undostat
       ) g

WHERE e.name = 'undo_retention'
  AND f.name = 'db_block_size'
/
ACTUAL UNDO SIZE [MByte]
------------------------
200

UNDO RETENTION [Sec]
--------------------
10800

OPTIMAL UNDO RETENTION [Sec]
----------------------------
16401
Calculate Needed UNDO Size for given Database Activity
If you are not limited by disk space, then it would be better to choose the UNDO_RETENTION time that is best for you (for FLASHBACK, etc.). Allocate the appropriate size to the UNDO tablespace according to the database activity:
Again, all in one query:
SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]",
       SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]",
       (TO_NUMBER(e.value) * TO_NUMBER(f.value) *
       g.undo_block_per_sec) / (1024*1024) 
      "NEEDED UNDO SIZE [MByte]"
  FROM (
       SELECT SUM(a.bytes) undo_size
         FROM v$datafile a,
              v$tablespace b,
              dba_tablespaces c
        WHERE c.contents = 'UNDO'
          AND c.status = 'ONLINE'
          AND b.name = c.tablespace_name
          AND a.ts# = b.ts#
       ) d,
      v$parameter e,
       v$parameter f,
       (
       SELECT MAX(undoblks/((end_time-begin_time)*3600*24))
         undo_block_per_sec
         FROM v$undostat
       ) g
 WHERE e.name = 'undo_retention'
  AND f.name = 'db_block_size'
/
ACTUAL UNDO SIZE [MByte]
------------------------
200
UNDO RETENTION [Sec] 
--------------------
10800
NEEDED UNDO SIZE [MByte]
------------------------
131.695313
The previous query may return a "NEEDED UNDO SIZE" that is less than the "ACTUAL UNDO SIZE". If this is the case, you may be wasting space. You can choose to resize your UNDO tablespace to a lesser value or increase your UNDO_RETENTION parameter to use the additional space.

Saturday, October 27, 2012

You may be a victim of software counterfeiting?

As everyone unable to use the Geninue software and using the pirted one and using with Internet may effect the below Genuine Software Issues.

For the below Issue


Here is the solutions to get it resolved.
---------------------------------------'
Please download the executable RemoveWGA.exe from the link
 http://www.download.hr/download-removewga.html
and unzip the zip file double click on the RemoveWGA.exe then it will prompt for reboot of your PC. Click on OK and proceed for Reboot of computer. In a process of restarting the PC it will remove the WGAlogon.dll and wgatra.exe and all it related files.