s_krish
asked on
URGENT!! Remove Personal Oracle 8, Install Personal Oracle 9
Dear Oracle Experts,
I have a sticky (and urgent) situation on my hands and I hope you can help me.
I installed Personal Oracle 8 on my Windows 98 PC (Pentium ~ 700Mhz). I then decided to install Oracle 9i personal edition. However :
a)I could not remove/unistall Personal Oracle 8 from my system, so I manually deleted it. I know, that stinks :(
b)When I put in the 9i CD, it would only let me install Oracle 9i Client and NOT Database! But database is what I want!
c)I still have no way of knowing if the old database was removed or not.
Could someone tell me
a) Why it doesn't allow me to install the 9i database?
b) How I must clean up Personal Oracle 8 and the related database from my PC COMPLETELY?
I only have 55 points with me, but I hope that doesn't deter you from answering... :D
I have a sticky (and urgent) situation on my hands and I hope you can help me.
I installed Personal Oracle 8 on my Windows 98 PC (Pentium ~ 700Mhz). I then decided to install Oracle 9i personal edition. However :
a)I could not remove/unistall Personal Oracle 8 from my system, so I manually deleted it. I know, that stinks :(
b)When I put in the 9i CD, it would only let me install Oracle 9i Client and NOT Database! But database is what I want!
c)I still have no way of knowing if the old database was removed or not.
Could someone tell me
a) Why it doesn't allow me to install the 9i database?
b) How I must clean up Personal Oracle 8 and the related database from my PC COMPLETELY?
I only have 55 points with me, but I hope that doesn't deter you from answering... :D
ASKER
Seazodiac,
I did clean up the registry, but it still won't let me install the database. I only get the 9i Client.
I even tried to re-install the old Personal Oracle 8, and now that too doesn't work!!!
I did clean up the registry, but it still won't let me install the database. I only get the 9i Client.
I even tried to re-install the old Personal Oracle 8, and now that too doesn't work!!!
To do a complete uninstall of Oracle from a Windows server, you have to do a number of things manually (since the Oracle installer usually doesn't uninstall everything).
1. stop any Oracle... services that may be started
2. remove the entire Oracle_home directory
3. in C:\Program Files remove the \Oracle sub-directory
4. run regedit, go to Hkey-Local-Machine, Software and delete the Oracle key
5. go to Hkey-Local-Machine, System, CurrentControlSet, Services and remove any "Oracle..." entries
6. right click your "my Computer" icon, choose Properties. Go to the Advanced tab, Environment Variables section. Check the "Path" under System Variables. If there are any references to directories in the Oracle_home directory you deleted, remove them.
7. then reboot (just to be safe) and try a fresh install. That should get everything working.
I have more experience with Oracle on Windows server operating systems than on Win98, but I expect the uninstall process to be similar. You should also check your "Startup" folder for any Oracle-related objects and remove them. And one other place to check in the registry:
Hkey-Local-Machine, Software, Microsoft, Windows,CurrentVersion,Run
Remove any Oracle-related entries there also.
1. stop any Oracle... services that may be started
2. remove the entire Oracle_home directory
3. in C:\Program Files remove the \Oracle sub-directory
4. run regedit, go to Hkey-Local-Machine, Software and delete the Oracle key
5. go to Hkey-Local-Machine, System, CurrentControlSet, Services and remove any "Oracle..." entries
6. right click your "my Computer" icon, choose Properties. Go to the Advanced tab, Environment Variables section. Check the "Path" under System Variables. If there are any references to directories in the Oracle_home directory you deleted, remove them.
7. then reboot (just to be safe) and try a fresh install. That should get everything working.
I have more experience with Oracle on Windows server operating systems than on Win98, but I expect the uninstall process to be similar. You should also check your "Startup" folder for any Oracle-related objects and remove them. And one other place to check in the registry:
Hkey-Local-Machine, Software, Microsoft, Windows,CurrentVersion,Run
Remove any Oracle-related entries there also.
Here is the steps to remove Oracle components on Windows 98.
-------------------------- ---------- ---------- -----
1. Remove the entries in the Windows registry:
-------------------------- ---------- -------
1.a. Start the registry editor at the MS-DOS command prompt:
C:\> REGEDIT
1.b. Go to HKEY_LOCAL_MACHINE\SOFTWAR E\ORACLE
Note the value of the key INST_LOC, this is the location of the Oracle
Universal Installer. The default location is
C:\Program Files\Oracle\Inventory
If this value is different, make note of it, so we can delete these files
later. Delete this ORACLE key.
1.c. Go to HKEY_LOCAL_MACHINE\SOFTWAR E\ODBC and expand all subkeys and
remove all keys under here which are related with the
"Oracle ODBC Driver".
1.d. Go to:
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\Windows\ CurrentVer sion\Unins tall
and remove any entries related to Oracle.
1.e. Go to HKEY_CLASSES_ROOT, remove all keys that begin with Ora or ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).
1.f. Go to HKEY_LOCAL_MACHINE\SOFTWAR E\Classes, remove all keys that begin with Ora or ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).
1.g. Go to HKEY_CURRENT_USER\Software \Oracle, delete this ORACLE key.
1.h. Go to HKEY_USERS\?\Software\Orac le, delete this ORACLE key.
1.i. Close the registry.
2. Clean up the environment settings:
-------------------------- --------
2.a. Open your AUTOEXEC.BAT with an editor to modify the PATH variable.
For example, you may see a path similar to this one:
C:\ORACLE\ORA81\BIN;G:\PRO GRAM FILES\ORACLE\JRE\1.1.7\BIN .
2.b. If an %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\BIN path.
2.c. If there is a CLASSPATH variable set in the AUTOEXEC.BAT, first make note
of the path defined, then delete it. This variable can be added back at
a later date if needed.
2.d. If JRE was installed by Oracle, remove the JRE path.
2.e. Save the AUTOEXEC.BAT file and close the edit.
3. Delete the software and icons:
-------------------------- ----
3.a. Choose Start > Programs > Windows Explorer.
3.b. Go to SYSTEM_DRIVE:\WINDOWS\STAR T MENU\PROGRAMS
and delete the following icons:
- Oracle - HOME_NAME
where HOME_NAME is the previous Oracle home name.
- Oracle Installation Products
3.c. Go to SYSTEM_DRIVE:\Program Files\Oracle or the location of INST_LOC as
noted earlier in step 1.b and delete this directory.
3.d Go to SYSTEM_DRIVE:\Temp and delete all files and directories in here.
3.e. Go to the drive where the Oracle software is installed on your machine
and delete all ORACLE_BASE directories on your hard drive.
3.f. Remove any Oracle-related .INI files that may exist in the Windows
directory. The Windows directory may be found by entering
"echo %WINDIR%" from a command prompt.
Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI,
ORACLE.INI, ORAODBC.INI
3.g. Close the Windows Explorer.
4. Finish the removal:
-------------------
4.a. Empty the recycle bin
Right click on recycle bin > Empty Recycle Bin
4.b. Reboot your computer.
--------------------------
1. Remove the entries in the Windows registry:
--------------------------
1.a. Start the registry editor at the MS-DOS command prompt:
C:\> REGEDIT
1.b. Go to HKEY_LOCAL_MACHINE\SOFTWAR
Note the value of the key INST_LOC, this is the location of the Oracle
Universal Installer. The default location is
C:\Program Files\Oracle\Inventory
If this value is different, make note of it, so we can delete these files
later. Delete this ORACLE key.
1.c. Go to HKEY_LOCAL_MACHINE\SOFTWAR
remove all keys under here which are related with the
"Oracle ODBC Driver".
1.d. Go to:
HKEY_LOCAL_MACHINE\Softwar
and remove any entries related to Oracle.
1.e. Go to HKEY_CLASSES_ROOT, remove all keys that begin with Ora or ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).
1.f. Go to HKEY_LOCAL_MACHINE\SOFTWAR
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and ORCL...).
1.g. Go to HKEY_CURRENT_USER\Software
1.h. Go to HKEY_USERS\?\Software\Orac
1.i. Close the registry.
2. Clean up the environment settings:
--------------------------
2.a. Open your AUTOEXEC.BAT with an editor to modify the PATH variable.
For example, you may see a path similar to this one:
C:\ORACLE\ORA81\BIN;G:\PRO
2.b. If an %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\BIN path.
2.c. If there is a CLASSPATH variable set in the AUTOEXEC.BAT, first make note
of the path defined, then delete it. This variable can be added back at
a later date if needed.
2.d. If JRE was installed by Oracle, remove the JRE path.
2.e. Save the AUTOEXEC.BAT file and close the edit.
3. Delete the software and icons:
--------------------------
3.a. Choose Start > Programs > Windows Explorer.
3.b. Go to SYSTEM_DRIVE:\WINDOWS\STAR
and delete the following icons:
- Oracle - HOME_NAME
where HOME_NAME is the previous Oracle home name.
- Oracle Installation Products
3.c. Go to SYSTEM_DRIVE:\Program Files\Oracle or the location of INST_LOC as
noted earlier in step 1.b and delete this directory.
3.d Go to SYSTEM_DRIVE:\Temp and delete all files and directories in here.
3.e. Go to the drive where the Oracle software is installed on your machine
and delete all ORACLE_BASE directories on your hard drive.
3.f. Remove any Oracle-related .INI files that may exist in the Windows
directory. The Windows directory may be found by entering
"echo %WINDIR%" from a command prompt.
Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI,
ORACLE.INI, ORAODBC.INI
3.g. Close the Windows Explorer.
4. Finish the removal:
-------------------
4.a. Empty the recycle bin
Right click on recycle bin > Empty Recycle Bin
4.b. Reboot your computer.
ASKER
I've done everything that has been suggested. It still doesnt work. Neither does 9iDB load and nor does 8 DB!!
I noticed a few more oracle entries in the registry.
1)HKEY_CLASSES_ROOT\Oracle SMPDiscove ryCache2\C LSID
2)HKEY_CLASSES_ROOT\OraOLE DB.Oracle\ CLSID
HKEY_CLASSES_ROOT\OraOLEDB .Oracle\Cu rVer
3)HKEY_CLASSES_ROOT\OraOLE DB.Oracle. 1\CLSID
Should I delete these too? The second and third seem like conflicting entries. Could those be a problem?
I noticed a few more oracle entries in the registry.
1)HKEY_CLASSES_ROOT\Oracle
2)HKEY_CLASSES_ROOT\OraOLE
HKEY_CLASSES_ROOT\OraOLEDB
3)HKEY_CLASSES_ROOT\OraOLE
Should I delete these too? The second and third seem like conflicting entries. Could those be a problem?
I've never needed to delete any HKEY_CLASSES_ROOT entries, but these certainly look like they will installed by Oracle, so I would say, yes, remove those also.
yes, sure. you have to delete those keys also
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ALSO TRY
c:\pathto\oradim80 -delete -sid<sidvalue>
c:\pathto\oradim80 -delete -sid<sidvalue>
ASKER
Thanks everyone for your tips on this.
However, I haven't been able to solve it. Its strange why 8i won't load anymore! Maybe the 9i disk isn't the correct one (!?)
I have decided to download the 9i personal oracle edition from the link given by bnac.
However, I haven't been able to solve it. Its strange why 8i won't load anymore! Maybe the 9i disk isn't the correct one (!?)
I have decided to download the 9i personal oracle edition from the link given by bnac.
1. HKEY_LOCAL_MACHINE-->SOFTW
2. HKEY_LOCAL_MACHINE-->SYSTE
then restart the machine, and try to reinstall oracle9i.