Home » RDBMS Server » Server Administration » removing an instance
removing an instance [message #186826] Wed, 09 August 2006 14:21 Go to next message
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.
Re: removing an instance [message #186866 is a reply to message #186826] Wed, 09 August 2006 23:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
> what else?
FORMAT C:
will ensure complete removal
Re: removing an instance [message #186964 is a reply to message #186826] Thu, 10 August 2006 06:04 Go to previous messageGo to next message
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
Re: removing an instance [message #186988 is a reply to message #186826] Thu, 10 August 2006 07:59 Go to previous messageGo to next message
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!
Re: removing an instance [message #186991 is a reply to message #186826] Thu, 10 August 2006 08:03 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: removing an instance [message #188165 is a reply to message #186826] Thu, 17 August 2006 06:01 Go to previous message
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)
Previous Topic: odd 10g shutdown behaviour
Next Topic: INSERT VALUES IN PARENT TABLES WITH SQL LOADER
Goto Forum:
  


Current Time: Sat Dec 10 18:18:55 CST 2016

Total time taken to generate the page: 0.08779 seconds