OraFAQ Forum: Server Administration » Oracle home directory full

Home » RDBMS Server » Server Administration » Oracle home directory full (Oracle 10g,11g,unix,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle home directory full [message #606094]

Sun, 19 January 2014 14:19

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

Report message to a moderator

Re: Oracle home directory full [message #606095 is a reply to message #606094]

Sun, 19 January 2014 14:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rm -rf $ORACLE_HOME

Report message to a moderator

Re: Oracle home directory full [message #606096 is a reply to message #606095]

Sun, 19 January 2014 14:30

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: Oracle home directory full [message #606098 is a reply to message #606097]

Sun, 19 January 2014 14:56

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

EdStevens
Messages: 1376
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?

Report message to a moderator

Re: Oracle home directory full [message #606104 is a reply to message #606103]

Sun, 19 January 2014 17:53

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Concepts
Administrator's Guide

Report message to a moderator

Re: Oracle home directory full [message #606334 is a reply to message #606104]

Wed, 22 January 2014 08:06

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Previous Topic:	Archive log files generation
Next Topic:	Creating PeopleSoft Environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 21:52:21 CST 2024