Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.
Installing Oracle 11g Release 2 on Windows:
- Download the two zip files to any directory. You can download the files from this given link. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Unzip both of the zip files to the same folder. After unzipping them to the current directory which should produce one “database” directory.
Below is a figure of Windows Explorer after navigating to the database directory.
Starting the Oracle Installer:
- Run setup.exe program. At the Welcome screen, click the Next.
2. If you have an Oracle Support account, fill in the appropriate data and click on Next button. If you do not have support, leave the fields blank and click on Next.
3. Select the option to “Create and Configure a Database”, then click on the Next button.
4. Select the Desktop Class and click the Next button.
5. Check and supply settings for the following:
- Specify a destination folder for Oracle Base (e.g.:- F:\ is used here)
- Select “Enterprise Edition” for the Database Edition.
- Specify the global database name (orcl in this case)
- Provide a new database administrator password.
6. At this point, all of the options have been set and Oracle Installer is ready to begin. Click the Finish button to begin the install.
NOTE: If you receive errors about problems copying files, the safest way to recover is to exit out of the installer, then remove all of the files form the install directories (F:\ which I have used). You may need to stop the OracleMTSRecoveryService before removing some files).
After clicking on the details button, we can check the installation files details.
7. Once all of the files are copied and installed, the Database Configuration Assistant will launch. Generally, there is not much you need to do at this point except allow the Assistant to finish.
8. After bringing up the Oracle Enterprise Manager at URL: https://localhost:1158/em type in the DBA username (typically system) and password that you set up during the installation.
9. The Oracle Enterprise Manager provides control over all of the Oracle functions.
Uninstallation of Oracle 11g R2:-
Stop all Oracle services first.
1) START -> RUN -> Services.msc
2. Locate all Ora* services & click on STOP
- Start -> Run -> Regedit
- Locate HKEY_LOCAL_MACHINE folder in the registry
- Open Software folder
- Delete the Oracle folder under Software
- Open System folder in HKEY_LOCAL_MACHINE
- Open CurrentControlSet folder within the System folder
- Open Services
- Delete all keys related to Oracle. Every key starts with “ORA..”
- Close the regedit
- Delete ORACLE_HOME folder
- Delete the Oracle folder in Program Files