Re: removing previous installations effects for Oracle 10-win32

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Sun, 16 May 2010 05:09:08 -0700 (PDT)
Message-ID: <e5031d83-bc06-4eb2-8ace-2b91f00507da_at_c11g2000vbe.googlegroups.com>

On May 16, 4:26 am, happy <ehabaziz2..._at_gmail.com> wrote:
> On May 16, 3:02 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > Consider this post to be a continuation of Mark's post.
>
> > ORADIM may be used to remove the service for the old instance.  For
> > example, assume that we have an instance named TESTDB (the following
> > creates the services for the instance):
> > ----------------------------------
> > C:\>ORADIM -NEW -SID TESTDB
> > Instance created.
> > The Oracle TESTDB VSS Writer Service service is starting.
> > The Oracle TESTDB VSS Writer Service service was started successfully.
> > ----------------------------------
>
> > Before uninstalling the old oracle release you can use ORADIM to
> > remove the service:
> > ----------------------------------
> > C:\>ORADIM -DELETE -SID TESTDB
> > The Oracle TESTDB VSS Writer Service service is stopping.
> > The Oracle TESTDB VSS Writer Service service was stopped successfully.
>
> > Instance deleted.
> > ----------------------------------
>
> > Remove any ODBC connections that belong to the old Oracle home.  At
> > this point you should be able to use the Oracle installer to remove
> > the Oracle related files from the old Oracle home.
>
> > Open the Windows Registry Editor (Start - Run - REGEDIT).  Then
> > navigate to the following location:
> > HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
>
> > You should be able to delete the ORACLE branch of the registry found
> > in that location.
>
> > Navigate to the C:\Program Files\ folder using Windows Explorer.  You
> > should find an Oracle folder inside the Program Files folder - delete
> > that folder.
>
> > Navigate to the folder where the old Oracle home was located, and
> > delete any remaining Oracle files.
>
> > Install the new Oracle release.
> > ---
>
> > The above assumes that you are attempting to use the same instance
> > name and/or Oracle home location with the new Oracle release, and are
> > encountering a problem.
>
> I could not fine that command :
> ORADIM
>
> What ODBC entry in the registory editor ?

If you open a Windows command line (Start - Run - CMD), you should be able to just type the ORADIM command, assuming that the BIN folder of the Oracle home is in the PATH environment variable. For example:

C:\>path

PATH=C:\oracle\product\11.2.0\dbhome_1\bin;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\windows\system32;C:\windows;C: \windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C: \Program Files\Common Files\Microsoft Shared\Windows Live

In this example, C:\oracle\product\11.2.0\dbhome_1\bin is in the path. (If you are using either Windows Vista or Windows 7 and User Access Control is enabled, you will need to open the Windows command line with administrator rights.)

As a demonstration, I will switch to the folder containing the ORADIM file (found using the PATH command) and verify that it exists in that folder:

C:\>cd C:\oracle\product\11.2.0\dbhome_1\bin

C:\oracle\product\11.2.0\dbhome_1\BIN>dir oradim.*  Volume in drive C is TI105803W0C
 Volume Serial Number is 1ABF-57AE

 Directory of C:\oracle\product\11.2.0\dbhome_1\BIN

04/02/2010  07:59 AM            20,480 oradim.exe
               1 File(s)         20,480 bytes
               0 Dir(s)  180,366,725,120 bytes free

---

ODBC entries should be removed using the Windows Control Panel ODBC
utility - the location of that utility in the Control Panel differs
based on the version of Windows you are using, and potentially whether
or not you are using a 32 bit or 64 bit version.  For example, on
Windows 7/Vista (and possibly Windows 2008) you should find the
utility by selecting "System and Security" - "Administrative Tools" -
"Data Sources ODBC"

For the 32 bit version of Windows, you can also start it from the
Windows command line (note that I have already changed the directory
to the C:\Windows\System32 folder):
C:\Windows\System32>ODBCAD32

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration
from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

Received on Sun May 16 2010 - 07:09:08 CDT