OraFAQ Forum: Server Administration » removing an instance

Home » RDBMS Server » Server Administration » removing an instance

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

removing an instance [message #186826]

Wed, 09 August 2006 14:21

nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa

Member

let us suppose that i've several instances running on the same box - on the same oracle software binaries.

suppose an instance is to be decommissioned/removed - what are the files to be removed?

the data files, the control files, the spfile, the archive logs, the dumps - what else?

appreciate the feedback.

Report message to a moderator

Re: removing an instance [message #186866 is a reply to message #186826]

Wed, 09 August 2006 23:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> what else?
FORMAT C:
will ensure complete removal

Report message to a moderator

Re: removing an instance [message #186964 is a reply to message #186826]

Thu, 10 August 2006 06:04

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

remove
datafile
logfile
control file
INITSID.ora
archive files
remove entry from oratab .i think thts all

Report message to a moderator

Re: removing an instance [message #186988 is a reply to message #186826]

Thu, 10 August 2006 07:59

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

>>remove entry from oratab .i think thts all

WHAT IS ORATAB

PLZ EXPLAIN

THANKS!

Report message to a moderator

Re: removing an instance [message #186991 is a reply to message #186826]

Thu, 10 August 2006 08:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>WHAT IS ORATAB
GOOGLE is your friend but only when you show some action & use it!
Results 1 - 10 of about 58,200 for oratab

Report message to a moderator

Re: removing an instance [message #188165 is a reply to message #186826]

Thu, 17 August 2006 06:01

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Remove your system.dbf and indexe files as well.

ORATAB is in the /var or /opt directory?

Try 'find ./ -name ORATAB -print' from your su account in the root directory.

perhaps in /var/opt/oracle/ORATAB ? (Solaris)

Report message to a moderator

Previous Topic:	odd 10g shutdown behaviour
Next Topic:	INSERT VALUES IN PARENT TABLES WITH SQL LOADER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 16:17:19 CST 2025