Oracle Database Appliance – /u01 filling up

[Amr Samy]

I have Oracle Database Appliance x4-2

I have Node 0 and Node 1

the /u01 directory at Node 1 is filling up so fast and just remain 2.5 GB as a free space

I applied action plans at these Notes ( 2193643.1 & 2081655.1) and still have no more space.

[ErmanArslansOracleBlog]

Did you do analysis using OS tools like "du" (i.e du -sh )?
What is filling it up?
Which folders are the cause? Which files are located there?

[Amr Samy]

I did and these are the first 17 lines

618625244 /u01
618625224 /u01/app
530157216 /u01/app/sharedrepo
372868316 /u01/app/sharedrepo/prodrepo
157288040 /u01/app/sharedrepo/test_1
157287856 /u01/app/sharedrepo/test_1/VirtualDisks
49286200 /u01/app/12.1.0.2
49286196 /u01/app/12.1.0.2/grid
37420108 /u01/app/12.1.0.2/grid/rdbms
37242296 /u01/app/12.1.0.2/grid/rdbms/audit
31624356 /u01/app/grid
28303540 /u01/app/grid/crsdata
27522012 /u01/app/grid/crsdata/@global
27522008 /u01/app/grid/crsdata/@global/cvu
27521988 /u01/app/grid/crsdata/@global/cvu/baseline
27487932 /u01/app/grid/crsdata/@global/cvu/baseline/cvures
7544696 /u01/app/oracle

[Amr Samy]

the output file

http://www.mediafire.com/file/k2y393e9runw39t/du_k_u01.txt

[ErmanArslansOracleBlog]

Send me the following;

1)output of df -h
2)output of "du -sh" (recursively, for all directory levels..
"Go inside the directories (where you see huge size) using cd
After that reissue du -sh.

do these steps till you reach the leaf directory. After you reach the leaf directory, check the files there, check what files they are, what kind of files they are and consider if they can be deleted..)"

From the first look, your VM files are occupying the space.
I mean : /u01/app/sharedrepo/test_1/VirtualDisks

However, audit log is also big: /u01/app/12.1.0.2/grid/rdbms/audit

[Amr Samy]

Dear Erman,

I found the problem , it was in these two directories :
/u01/app/grid/crsdata/@global/cvu/baseline/cvures
/u01/app/12.1.0.2/grid/rdbms/audit/

and I am trying to delete the files , but still searching for a good solution

[ErmanArslansOracleBlog]

****check this note for cvures directory -> Bug 22594310 - CVU health check reports not purged even after applying patch for 20177779 (Doc ID 22594310.8)

CVU health check reports are not purged even after applying patch for 20177779
 
Rediscovery Notes
 This bug may be suspected if the cvures directory accumulates files that
 do not get deleted.
     
Workaround
 Manually remove the files.
 
Note:
 This fix supersedes the fix originally made in bug 20177779.


****check this note for audit directory -->

Large Number Of Audit Files Being Created In GI_HOME/rdbms/audit (Doc ID 2114215.1)

[ErmanArslansOracleBlog]

Also check the following note for that audit directory:

Manage Audit File Directory Growth with cron (Doc ID 1298957.1)

[Amr Samy]

Thank you so much , the problem is solved

[ErmanArslansOracleBlog]

Hi Amr,

Can you please write the solution as well..

Thanks

[Amr Samy]

Hi,

I open the the audit directory with this command :

cd  /u01/app/12.1.0.2/grid/rdbms/audit

then used this command to remove the files , this give me more than 20 GB

 /usr/bin/find /u01/app/12.1.0.2/grid/rdbms/audit/ -type f -mtime +14 -exec rm {} \;

[Phindile]

Hi Amr,

I'm a newbie to Oracle and Linux, I'm currently experiencing the same problem

When I type the following command : /usr/bin/find /u01/app/12.1.0.2/grid/rdbms/audit/ -type f -mtime +14 -exec rm {} \;

I get the following: /usr/bin/find/:missing argument to -exec'
Or maybe I'm not typing the command correctly, could you please provide me with the correct one.

Thanks.

[ErmanArslansOracleBlog]

Command is correct.
Maybe you have a copy paste problem.
Maybe there is an extra character which gets produced while you are copy-pasting it.
Try writing the command from scratch.

[ErmanArslansOracleBlog]

Especially - check the space between -exec and rm {} \ commands.
I suspect there is an EOF there.

[Phindile]

Hi Erman, thanks for your response,

This is what I typed cd /usr/bin/find /u01/app/12.1.0.2/grid/rdbms/audit/ -type f -mtime +14 -exec rm {}\;

Thanks.

[ErmanArslansOracleBlog]

There is a "cd" command, which is wrong and unnecessary.

Delete it and then write the command from scratch and try. (/usr/bin/find /u01/app/12.1.0.2/grid/rdbms/audit/ -type f -mtime +14 -exec rm {}\; )

[Phindile]

Thank you.

On Mon, Oct 2, 2017 at 10:52 AM, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

There is a "cd" command, which is wrong and unnecessary.

Delete it and then write the command from scratch and try. (/usr/bin/find /u01/app/12.1.0.2/grid/rdbms/audit/ -type f -mtime +14 -exec rm {}\; )

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Oracle-Database-Appliance-u01-filling-up-tp2573p3697.html

To unsubscribe from Oracle Database Appliance – /u01 filling up, click here.
NAML

[Phindile]

Hi I need help

My one database is not showing after typing ps -ef | grep pmon,
when I type cat /etc/oratab, it appears like this:
wmdev:/u01/app/oracle/product/12.1.0.2/dbhome_1:N

Please help.
Thanks

[ErmanArslansOracleBlog]

It is not started then...
Start your database..

[Phindile]

Oh alright, thanks 

On 25 Oct 2017 12:40 PM, "ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum]" <[hidden email]> wrote:

It is not started then...
Start your database..

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Oracle-Database-Appliance-u01-filling-up-tp2573p4173.html

To unsubscribe from Oracle Database Appliance – /u01 filling up, click here.
NAML