Re: Uninstall an instance from Oracle8i on Unix-AIX

Jeff B wrote:
> I am trying to find out how to uninstall an Oracle8i database instance
> on Unix-AIX 4.3. I do not want to remove the oracle software, just one
> of the database instances. Metalink and OTN have not been of any help.
> Does anyone out there have a step-by-step procedure for this?
>
> Thanks in advance,
> Jeff
>

As a database consists of files, simply remove the files that belong to the database.

If the instance is still active, and the database open:

sqlplus "/ as sysdba"
show parameter dump
(lists various dump/logging directories, usually in .../admin/bdump)

select name from v$datafile;
select name from v$controlfile;
select member from v$logfile;
(lists various types of files, usually in .../oradata/...)

Not sure if you have 'em, but possible:
select name from v$tempfile;

shutdown abort;
(kills the instance, closes the database) delete all files listed. Pretty good start, I'd say. Drop database is 10g, so if you could upgrade... ;)

Remember to tidy up: /etc/oratab, listener control files, tnsnames, just to name a few...

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...