Windows Uninstall Oracle

Source: Internet
Author: User

Because of the need for work or exposure to many Oracle versions under Windows, this time a general summary of the database upgrade is made: Windows Oracle11.2.0.1 upgrade to Oracle11.2.0.4.

But the vast majority of online programs are not used here: the DBUA approach.

Pre-step:

Full downtime

Operating system: Windows Server R2 Standard

Database version: Oracle 11.2.0.1

Step 1: Backup

EXPDP system/oracle directory=dmp schemas=dbseeker dumpfile=dbseeker.dump logfile=dbseeker.dump.log

Step 2: Uninstalling Oracle

Perfect uninstall oracle11g steps:

1. Start-> Settings-> Control Panel-> Administrative Tools-> Service stop all Oracle services.

2. Start-> Program->oracle-orahome->oracle installation products-> Universal Installer, click "Uninstall Product"-"Expand All" and select "Oradb11g_home1" All directories outside of the directory, delete. Here to run a Deinstall.bat script

3. Run regedit, select Hkey_local_machine\software\oracle, and press the DEL key to delete.

4. Run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete any content that begins with Oracle or Oraweb.

5. Run refedit,hkey_local_machine\system\currentcontrolset\services\eventlog\application to delete all Oracle-related content.

6. Delete all content that is prefixed with Ora, Oracle, ORCL, or Enumora in the HKEY_CLASSES_ROOT directory.

7. Delete Hkey_current_user\software\microsoft\windows\currentversion\explorer\menuorder\start Menu\ All content that begins with Oracle in programs.

8. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.

9. From the desktop, the Startup group, the Programs menu, delete all the groups and icons about Oracle.

10. Delete all Oracle-related directories (if not deleted, restart the computer and then delete it) include:

One: C:\Program file\oracle directory.

II: Oracle_base directory (ORACLE's installation directory).

Three: C:\WINDOWS\system32\config\systemprofile\Oracle directory.

Four: C:\Users\Administrator\Oracle directory.

If there are individual DLL files can not be deleted, then ignore, restart, start a new installation, install, select a new directory, installed and restarted, the old directory and files can be deleted.

Step 3: Direct installation of Oracle 11.2.0.4

Note: It is not recommended to choose to create and configure a database like most examples on the Web, honestly install the database software first, and then dbca the library, the reason is to better customize our database.

Step:4 bundle Patch, Note: Windows call bundle patch

1. Stop monitoring and stop the service, the service must be all shut down

2. Update Opatch:opatch version requires 11.2.0.3.5 above, default is 11.2.0.3.4

3. Update Bundle Patches:

Absolute path \opatch Apply

@catbundle. SQL PSU Apply

After the patch, the results are as follows:

C:\soft\25632525>c:\u01\app\oracle\product\11.2.0.4\ta\opatch\opatch lspatches

25632525; WINDOWS DB BUNDLE PATCH 11.2.0.4.170418: (25632525)

STEP5: Data Recovery

IMPDP system/oracle directory=dmp dumpfile=dbseeker.dump logfile=dbseeker.dump.log schemas=dbseeker

Windows Uninstall Oracle

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.