• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1324
  • Last Modified:

Oracle 10g uninstall

Hi,

I running Oracle 10g in a Solaris10 environment.

I would like to remove it and its instances as well but Im not should what would be the best practice to do so...

To remove the instance I would use:
Sqlplus system/manager as sysdba
Startup mount;
Drop database;

Is this the way to do it?

Tks,
Joao
0
joaotelles
Asked:
joaotelles
  • 7
  • 7
  • 3
  • +2
4 Solutions
 
slightwv (䄆 Netminder) Commented:
Shut down the database and just remove the files.

You will also likely have some config files in /etc and the init.d directories as well.
0
 
imran_fastCommented:
0
 
slightwv (䄆 Netminder) Commented:
Interesting, that is the very first link provided by Google.

The installer typically doesn't completely remove the Oracle footprint.  I always suggest a manual removal.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
joaotellesAuthor Commented:
Cant find the Unistaller here...

But Im concerned with config files in /etc and the init.d directories as well. Im not sure I will be able to know what to change...

Which files u mean to remove? the dbf one's? shouldnt it be removed by just drop the database../

0
 
sventhanCommented:
0
 
joaotellesAuthor Commented:
Tks for the link I guess I will just do this:

This should the work right?

UNIX
Uninstalling all products from UNIX is a lot more consistent. If you do need to resort to a manual uninstall you should do something like:

    Uninstall all Oracle components using the Oracle Universal Installer (OUI).
    Stop any outstanding processes using the appropriate utilities:

        # oemctl stop oms user/password
        # agentctl stop
        # lsnrctl stop

    Alternatively you can kill them using the kill -9 pid command as the root user.
    Delete the files and directories below the $ORACLE_HOME:

        # cd $ORACLE_HOME
        # rm -Rf *

    With the exception of the product directory, delete directories below the $ORACLE_BASE.

        # cd $ORACLE_BASE
        # rm -Rf admin doc jre o*

    Delete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.

        # rm /etc/oratab /etc/emtab

0
 
slightwv (䄆 Netminder) Commented:
>>But Im concerned with config files in /etc and the init.d directories as well. Im not sure I will be able to know what to change...

There should be at least /etc/oratab.  I'm not current on Solaris but under the startup directories there should be a dbstart and dbshut script.

>>Which files u mean to remove?

Drop database will work but why bother?  The 'rm' command will be much faster.

Remove everything under the Oracle install directory $ORACLE_HOME and the data folders.
0
 
slightwv (䄆 Netminder) Commented:
>>This should the work right?

That appears to miss the dbstart and dbshut scipts.

There might also be some oraenv and coraenv scripts in a public folder.  These are small and can probably be left.  They won't hurt anything.
0
 
joaotellesAuthor Commented:
This would work for Solaris right?
0
 
slightwv (䄆 Netminder) Commented:
At a high level, *nix is *nix.  Some files might be in slightly different places but at the core, they are basically all the same.

If should work as described.
0
 
PilouteCommented:
Hi,

1) You want to get rid of oracle :
- drop the database (make suire datafiles are deleted too)
- use OUI to unistall everyhting that's binaries.

2) You want to get rid of oracle and any treace of oracle in the system :
- do first the #1
- make sure you get rid of the additional files like oratab, sql net related config files and inventory related ones.

In solaris, most of htese files are in /var/opt/oracle

Cheers,
P
0
 
joaotellesAuthor Commented:
Tks Piloute.

I will try and get back here to show results.
0
 
slightwv (䄆 Netminder) Commented:
I still suggest the 'rm' command over running a program to basically do the same simple 'rm' command.
0
 
PilouteCommented:
Ah,

Almost fogot : you might have files in non standard locations. These might be backups or configuration files. For those ones you really need to know where they are to delete them.

I'm thinking also to your $TNS_ADMIN directory and your Flash Recovery Area. Additionnaly you can have some log archives also... For the FRA and the log archive locations, consult your database parameters (before deleting it ! ;) ).

P

@slightwv

I'm giving here the 'cleanest recipe' for removing oracle. Not the only one, of course...
0
 
joaotellesAuthor Commented:
Hi,

Im having problems to run the runInstaller script at oui directory:

oraclea@labcla01> ls
addLangs.sh      attachHome.sh    lsnodes          ouica.sh         runConfig.sh     runInstaller.sh
addNode.sh       detachHome.sh    ouica.bat        resource         runInstaller
oraclea@labcla01> ./runInstaller
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-08_11-10-35AM. Please wait ...oraclea@labcla01> Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-1" to type FontStruct
Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-2" to type FontStruct
Warning: Cannot convert string "-b&h-LucidaSansLat4-Normal-r-normal--*-140-*-*-p-*-iso8859-4" to type FontStruct
Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-5" to type FontStruct
Warning: Cannot convert string "-monotype-arial greek-regular-r-normal--*-140-*-*-p-*-iso8859-7" to type FontStruct
Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-9" to type FontStruct
Warning: Cannot convert string "-monotype-arial-regular-r-normal--*-140-*-*-p-*-iso8859-15" to type FontStruct
Warning: Cannot convert string "-ricoh-hg gothic b-medium-r-normal--*-140-*-*-m-*-jisx0201.1976-0" to type FontStruct
Warning: Cannot convert string "-ricoh-hg gothic b-medium-r-normal-*-*-140-*-*-m-*-jisx0208.1983-0" to type FontStruct
Warning: Cannot convert string "-ricoh-heiseimin-w3-r-normal--*-140-*-*-m-*-jisx0212.1990-0" to type FontStruct
Warning: Cannot convert string "-hanyang-kodig-medium-r-normal--*-140-*-*-m-*-ksc5601.1992-3" to type FontStruct
Warning: Cannot convert string "-monotype-song-medium-r-normal--*-140-*-*-m-*-gb2312.1980-0" to type FontStruct
Warning: Cannot convert string "-hanyi-ming-medium-r-normal--*-140-*-*-m-*-big5-1" to type FontStruct

oraclea@labcla01>
oraclea@labcla01>
oraclea@labcla01>
oraclea@labcla01> pwd
/opt/oraclea/product/10.2.0/db_1/oui/bin


The X is working since the xclock worked...

oraclea@labcla01> export DISPLAY=localhost:10.0
oraclea@labcla01> xclock
Warning: Missing charsets in String to FontSet conversion
oraclea@labcla01>


Any suggestions?
0
 
joaotellesAuthor Commented:
Hi,

I gave up on trying to run oui...

TO remove manually I should do this?

        # cd $ORACLE_HOME
        # rm -Rf *

AND

    With the exception of the product directory, delete directories below the $ORACLE_BASE.

        # cd $ORACLE_BASE
        # rm -Rf admin doc jre o*

AND

    Delete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.

        # rm /etc/oratab /etc/emtab

By doing this oracle will be removed from the system right? It can be reinstalled without problem right?

Tks
0
 
slightwv (䄆 Netminder) Commented:
>>By doing this oracle will be removed from the system right?

If the database datafiles were under one of those directories, then that should take care of 99.9% of everything.

>>It can be reinstalled without problem right?

Should be no problems.
0
 
PilouteCommented:
For the note

Those "can not convert string" errors are just simple font display errors. They usually block or slow down extremely the display. This makes me conclude you are using windows and some x server like Xming and you have no access to some fonts. For Xming, for example, there are additional fonts you can install to avoid such errors...

P

0
 
joaotellesAuthor Commented:
Tks all for the help.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 7
  • 7
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now