Proper Steps to Uninstall Oracle Database in Window XP

1 Go to START è Control Panel è Administrative Tools. Service stop all Oracle related services.


2 START è PROGRAMS è ORACLE è OraDb10g_home1 è Oracle Installation Products è Universal Installer. Uninstall all Oracle products, but Universal Installer itself can not be deleted.


3 START è RUN. Type regedit and then press enter, when window open choose HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE and press the del key to delete the entry;


4 START è RUN. Type regedit and then press enter, when window open choose HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services, scroll through the list, remove all Oracle entrance.


5 START è RUN. Type regedit and then press enter, when window open, select the HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application, remove all Oracle entrance.


6 START è Control Panel è System è Advanced è Environment Variables. Delete the environment variable CLASSPATH and PATH settings relating to Oracle.


7 START è ALL PROGRAMS menu, delete all the Oracle of the group and icons.


8 Delete the C:\ Program Files \ Oracle directory.


9 Restart the computer after the restart to completely remove the Oracle directory.


10 Delete the Oracle-related files, select the default directory where Oracle C: \ Oracle, delete this entry directory and all subdirectories, and from the Windows XP directory (usually d: \ WINDOWS) Delete the following files ORACLE.INI , oradim73.INI, oradim80.INI, oraodbc.ini etc.


11 WIN.INI file if [ORACLE] section of the tag, delete the paragraph.


12 If necessary, remove all Oracle related ODBC-DSN;


13 To the event viewer, delete the Oracle-related logs. If you can not remove individual DLL files 
the case, then it does not matter. 

Comments

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more