Installing Oracle 11g on Windows

Introduction

• Overview of the installation process for Oracle 11g on Windows OS.

Steps to Install Oracle 11g

1. Download Oracle 11g

• Open a web browser.
• Search for "Oracle download."
• Click on the first search result (Oracle Database).
  • Latest version displayed (e.g., 19.5, 19.3).
• Scroll down to find Oracle Database Express Edition.
• Click on Oracle Database 11g Release 2 Express Edition for Windows 64-bit.

2. Sign In or Create Oracle Account

• Choose the correct version (Windows 64-bit).
• Log in with your Oracle account.
  • If you don’t have an account, create one.
• The download of OracleXE will start automatically.
• Save the file (ZIP format).

3. Extract Files

• Navigate to the Downloads folder.
• Right-click on the downloaded OracleXE.zip file and select "Extract Here."
• Go inside the extracted folder (disk1).

4. Run the Installer

• Locate and double-click on setup.exe to start the installation.
• Follow the InstallShield Wizard prompts:
  • Click Next.
  • Accept the license agreement.
  • Use the default installation path (C:\oraclexe) or change it as needed.
• Set and confirm the password when prompted.
• Click Install; this process may take some time.

5. Complete Installation

• Once completed, a shortcut will be created on the desktop.
• Click Finish to exit the installation wizard.

Configuring the Database

6. Start the Database

• Open the shortcut created on the desktop.
• If you encounter an error, navigate to:
  • C:\oraclexe\app\oracle\products\11.2.0\server.
  • Go to Get Started Shortcuts and change the port to 8080 in properties.
• Retry opening the database.

7. Accessing Application Express

• Open the database in a web browser.
• Log in using the default SYS user and password.
• Create a workspace (e.g., user name: XE, password: XE).
• Confirm the workspace creation.

8. Using SQL Workbench

• Navigate to SQL Workbench:
  • Use SQL commands to query the database (e.g., SELECT SYSDATE FROM dual;).
• Create tables, views, indexes, sequences using the wizard.
• Access Object Browser to view tables (e.g., department and employee tables).

9. Querying Data

• Run SQL commands to retrieve data from the employee table (e.g., SELECT * FROM emp;).

Connecting Using SQL Plus

• Type sql to run SQL commands.
• Connect to the database with:
  • Username: XE
  • Password: [your password]
• Execute SQL commands to interact with the database.

Conclusion

• Recap of the installation process for Oracle Database on Windows.
• Encouragement to follow the steps shown in the video.