Skip to main content

How to Remove Oracle services from Windows

How to Remove Oracle services from Windows

If you have uninstall the Oracle software from your system, but, the services are not removed. This resulted, when you are trying to install oracle back and trying to configure your Instance as old name is not allowed.
Method1:
To remove OracleService , go to the command prompt and type:
oradim -delete -sid <SID>
where SID is the sid of your database, as it appears when you type net start | more (you should get an "OracleServiceSID")
Method2:
If you have the resource kit, you can use delsrv.exe to remove the listener service.
If you don't have the resource kit, you can download delsrv.exe from Microsoft Support: http://www.microsoft.com/windows2000/tec…
Method3:
Go to Registry (Type regedit on RUN)
Take a backup of Registry. (For the backup Click on file menu on Registry and export your registry backup any location so whenever required you can import your old registry.)
Now go to registry HKEY_LOCAL_MACHINE
Then go to system –> current control set –> services
From there you can remove oracle services (directly selecting and pressing delete)

Manually removing all Oracle Components and services from your system
These instructions remove all Oracle components, services, and registry entries from your computer. In addition, any database files in the subdirectories under ORADATA and oracle network configuration files, user made scripts or any other stored scripts are also removed.
WARNING:
It is not recommended, remove all Oracle components from your computer manually only as a last option.
Exercise extreme care when removing registry entries. Removing incorrect entries can severely compromise your computer.
On Windows NT/Windows 2000/Windows XP:
1. Login with Administrator Privilege user.
2. Then first stop all the running Oracle services. To list the services either goes to Control Panel > Services or type in RUN services.msc then if any oracle services exist have the status started simply right click on the services and press stop.
3. Now start the registry just type on RUN regedit and Go to the HKEY_LOCAL_MACHINE\SOFTWARE\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, will be deleted later or Delete this ORACLE key.
From HKEY_LOCAL_MACHINE\SOFTWARE\ODBC remove all keys related with the "Oracle ODBC Driver"
From HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services remove all keys that begin with ORACLE or ORAWEB.
From HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application remove all keys that begin with ORACLE.
From HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall remove any entries related to Oracle.
From HKEY_CLASSES_ROOT, remove all keys that begin with Oracle, OraPerf or OraoleDB
4. Do not forget to Clean up the environment settings. Go to Control Panel > System > Environment tab check out the below screenshot.







Click on the variable PATH in order to modify the value
– Check if the %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\bin path.
– Check if JRE was installed by Oracle, remove the JRE path.
– Check if there is a CLASSPATH variable make note, then delete it. This can be added back at
a later if needed.
– Check if there are any other Oracle variables exist, delete them also.
5. Delete the software and icons:
Note: These locations depend on the OS or whether it is upgraded or this was a fresh install
6. After deleting oracle installed file from hard drive, reboot your computer.
On Unix/Linux:
­This method is not recommended better to use Oracle Universal installer (OUI)
rm -rf $ORACLE_HOME
rm -rf /etc/ora*
rm -rf /path/to/your/oraInventory
rm -f /usr/local/bin/coraenv
rm -f /usr/local/bin/oraenv

rm -f /usr/local/bin/dbhome

Comments

Post a Comment

Popular posts from this blog

Tablespace Management using Toad

You can view all of your tablespace information using toad tablespace screen from Database –> Administer –> Tablespaces Here each table describes different detailed information across all the tablespaces in database. If you open this screen from the toad DBA module then you are also able to see the “space history” and “IO history” tab along with Files, Free space, object, Fragmentation. With these tab you are able to able perform space monitoring and planning steps. These tab permits you check graphically space and IO usage over time. Through this way DBA are also able to estimate ‘Object size’ based on this estimation. From the below “alter tablespace” tab you can §          Modify the tablespace and datafile size. §          Add new datafile to the tablespace.
Post a Comment
Read more

Import Excel Data into Oracle using Oracle form Button

Import Excel Data into Oracle using Oracle form Button 1. Create a button on the form with the name "IMPORT_EXCEL" and write a pl/sql on "WHEN BUTTON PRESSED" trigger. BEGIN IF :System.Cursor_Block<>'GL_DAILY_COMPOUND_HEADER' THEN   Go_Item('GL_DAILY_COMPOUND_HEADER.V_DATE'); END IF; IF :System.Mode = 'NORMAL' AND :System.Record_Status IN ('NEW','INSERT') THEN   IMPORT_EXCEL_PROC;   ---Form procedure ELSE  MESSAGE('Import allowed only for new entry!!!');  MESSAGE('Import allowed only for new entry!!!'); END IF; END; 2. Now write the procedure "IMPORT_EXCEL_PROC" into the program unit. Don't forget to create required table and folder for procedure IMPORT_EXCEL_PROC PROCEDURE IMPORT_EXCEL_PROC IS application    OLE2.Obj_Type; workbooks      OLE2.Obj_Type; workbook       OLE2.Obj_Type; worksheets      OLE2.Obj_Type; worksheet       OLE2.Obj_Type; cell      
Post a Comment
Read more

Changing National Character Set AL16UTF16 to UTF8

Changing National Character Set AL16UTF16 to UTF8 The national character set is used for data that is stored in table columns of the types NCHAR, NVARCHAR2, and NCLOB.  In contrast, the database character set is used for data stored in table columns of the types CHAR, VARCHAR2 and CLOB. Like the database character set, the national character set is defined when the database is initially created and can usually no longer be changed, at least not easily or without involving quite a lot of work (export, recreate database, import). Except when creating the database, where the national character set is defined explicitly, it can change implicitly even when upgrading the database from Oracle8i to Oracle9i (or Oracle10g). You require SYSDBA authorization to change the national character set. Changing the national character set means changing an Oracle Dictionary entry, but no data is changed.  $sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> Select property_value fro
Post a Comment
Read more