cancel
Showing results for 
Search instead for 
Did you mean: 

oracle 10g /u01 full

SOLVED
Go to solution
tareq_2
Regular Advisor

oracle 10g /u01 full

hi
i have rp7420 hp-ux11i with oracle 10g installed the size of the /u01 is 11GB
my problem is the /u01 is full now, when i go to the directory inside /u01/app/oracle/admin/orcl/
i can see this folders:- adump,bdump,cdump,dpdump,pfile,udump
the size of "cdump" folder is 6GB
and i have another server but the size of "cdump" is 400MB
the cdump folder take the size of the /u01
and iside this folder there is a folders with name core_0000 i can't run the sqlplus because there is no free space

what i cane do to solve this problem?

thanks for all
14 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: oracle 10g /u01 full

Shalom,

Bring down the database and copy off some of those files to a better location.

The database server processes probably have open file handles to some of those files.

I would think the cdump folder is a good place to start.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

hi steven
did you mean move it you say copy if i move this files to another location is there any thing will happen to the oracle and what this files do.

thanx
Court Campbell
Honored Contributor

Re: oracle 10g /u01 full

If no one needs them you can delete the older files in the dump directories.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

hi

inside the cdump folder there is folders with name core_**** and inside this folders theres files with name core
can i delete this files and how i know if is necessary or not.
this files is not oracle backup files i mean *.dmp


thanx
Sani
Frequent Advisor

Re: oracle 10g /u01 full

If you have oracle DBA's ,please check with them.

If this is a "cdump" folder, i think you can remove the core files .
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

hi sani

this is cdump folder and my problem is with the growth of this folder.
more than the plausible.

my regards
Court Campbell
Honored Contributor

Re: oracle 10g /u01 full

just keep the most recent cdump's. Maybe a week or a month. Anything older than that probably isn't useful anymore. You usually only need them when you create an SR with oracle.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Court Campbell
Honored Contributor

Re: oracle 10g /u01 full

I guess I should alos note tht if you are getting a lot of cdumps, you may have an issue with your instance.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Steven E. Protter
Exalted Contributor

Re: oracle 10g /u01 full

To answer your second question:

With the database down, moving any of the dump files to relieve space issues is fine.

The database will come up afterward.

Longer term, you need a bigger file system for this database.

Have you checked database layout from the performance standpoint? Whole database on one file system, that isn't a high performance strategy.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

hi steven
(Whole database on one file system)
what that mean ? i have file system /u02 for data base but i didnt see any noticeable growth in this file system.
what is my fault as you think?
thanks for your help.
Court Campbell
Honored Contributor

Re: oracle 10g /u01 full

I am not sure why this thread isn't closed. You can delete the dump file if no one needs them. They are for troubleshooting purposes. You don't need to shutdown the instance to do this. Just use the find command to remove files older than 30 days old and remove them. Example.

cd to_cdump_dir

find . - mtime +30 -exec -name 'core*' -exec rm -fr {} \+

There is nothing else to it. This is a normal dba function. You can also remove old .trc files from bdump and udump.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Nikon MIS
Occasional Contributor

Re: oracle 10g /u01 full

The above post is correct. You can remove the dump files. What you need to do is find out why the database is creating such large/so many dump files.
george drew
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

thanks for all
I have found the solution from your suggestion, good help,
but i want to open new thread to know why my database create like this large many dump files
thanks again
tareq_2
Regular Advisor

Re: oracle 10g /u01 full

thanks