Unable to query agent reports on the CMS

Hello, dear!

Have a nice day to you!

Today I will share with you a solution to unable to query agent reports on the CMS.

Issue description

Unable to query agent reports on the CMS. 

The CMS version is V600R006C10.

Handing process

1. Check the disk space of two DB servers, both disks have sufficient space.

   

2. Check the tablespace usage.

   

   The smaller the value of PCT_FREE, the smaller the remaining tablespace. The free space of the ICD_SERVICE tablespace is 0.

3. Check the ICD_SERVICE tablespace.

   selectsum(bytes)/1024/1024 free_MB from dba_free_space where tablespace_name='ICD_SERVICE';

   

   As shown above, ICD_SERVICE has no free space and needs to be expanded.

4. Query tablespace quota.

   selectfile_id,file_name,tablespace_name,bytes/1024/1024 Total_MB from dba_data_fileswhere tablespace_name='ICD_SERVICE';

   

   
   

Root cause

The tablespace is full.

Solution

If it is confirmed that the tablespace needs to be expanded, please modify it according to the following case.

1. First, confirm the free storage space.

   su – grid

   Use command

   asmcmd lsdg

2. Expand the icd_service tablespace according to the following command.
   

   alter tablespace icd_service add datafile'+DG_DATA/ipcc/rdata52' size 1024m reuse autoextend on next 10m maxsize 5120m;
   

   altertablespace icd_service add datafile '+DG_DATA/ipcc/rdata53' size 1024m reuseautoextend on next 10m maxsize 5120m;
   

Thanks for reading!