Home » RDBMS Server » Server Administration » Oracle home directory full (Oracle 10g,11g,unix,Linux)
Oracle home directory full [message #606094] Sun, 19 January 2014 14:19 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

How to reduce the space in Oracle home directory if it is 100% full ?

Thanks,
Jack
Re: Oracle home directory full [message #606095 is a reply to message #606094] Sun, 19 January 2014 14:20 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
rm -rf $ORACLE_HOME
Re: Oracle home directory full [message #606096 is a reply to message #606095] Sun, 19 January 2014 14:30 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi Blackswan,

rm -rf $ORACLE_HOME

This command will remove Oracle home and its content.If these are removed , then how oracle database will function ?
Can you please make me understand this point ?

Thanks,
Jack

[Updated on: Sun, 19 January 2014 14:30]

Report message to a moderator

Re: Oracle home directory full [message #606097 is a reply to message #606096] Sun, 19 January 2014 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59280
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No it will not function but did you think a little bit at the question you posted?
BlackSwan's answer perfectly answer to your question.
Next one?

Re: Oracle home directory full [message #606098 is a reply to message #606097] Sun, 19 January 2014 14:56 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi Michel,

Quote:
No it will not function but did you think a little bit at the question you posted?

No, i dont understand what Blackswan says. Could you make me clear on this ?

[Updated on: Sun, 19 January 2014 14:57]

Report message to a moderator

Re: Oracle home directory full [message #606103 is a reply to message #606098] Sun, 19 January 2014 17:38 Go to previous messageGo to next message
EdStevens
Messages: 294
Registered: September 2013
Senior Member
Jack14 wrote on Sun, 19 January 2014 14:56
Hi Michel,

Quote:
No it will not function but did you think a little bit at the question you posted?

No, i dont understand what Blackswan says. Could you make me clear on this ?


he didn't say it wouldn't break your sysytem, only that it would free up space.

If you need to free up space and not break your system you still have to remove files but be more select in identifying which ones,

my guess is you've not done any housekeeping on the various logs that can collect there. is this the same file system you've allowed to fill with archivelogs?
Re: Oracle home directory full [message #606104 is a reply to message #606103] Sun, 19 January 2014 17:53 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi Stevens,

Find my inline answers.

Quote:
If you need to free up space and not break your system you still have to remove files but be more select in identifying which ones,

This is what i want to know which files are to be removed from Oracle Home directory to free up space.

Quote:
my guess is you've not done any housekeeping on the various logs that can collect there

Can you tell me which logs are you talking about ?

Quote:
is this the same file system you've allowed to fill with archivelogs?

No

Thanks,

[Updated on: Sun, 19 January 2014 17:54]

Report message to a moderator

Re: Oracle home directory full [message #606109 is a reply to message #606104] Mon, 20 January 2014 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59280
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Concepts
Administrator's Guide


Re: Oracle home directory full [message #606334 is a reply to message #606104] Wed, 22 January 2014 08:06 Go to previous message
gazzag
Messages: 326
Registered: November 2010
Location: Bristol, UK
Senior Member
Jack14 wrote on Sun, 19 January 2014 23:53

Can you tell me which logs are you talking about ?


The output from the following may give you a starting point:

SQL> show parameter dest


HTH
-g
Previous Topic: Archive log files generation
Next Topic: Creating PeopleSoft Environment
Goto Forum:
  


Current Time: Wed Oct 01 01:58:02 CDT 2014

Total time taken to generate the page: 0.09283 seconds