Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • Database
  • How to install Oracle 11g and unlock sample databases

How to install Oracle 11g and unlock sample databases

If you are from a non-IT background and want to switch  your career to IT, learning Oracle SQL and PL/SQL will be a good place to start. This blog will explain how to install Oracle 11g and unlock sample schemas so that you can set yourself on a path to a rewarding IT career.

If you want to learn about the underlying principles of databases systems visit Basics of RDBMS and 12 Codd rules.

Installing Oracle 11g

  1. Navigate to the link below to download Oracle 11g installation files.

https://www.oracle.com/database/technologies/112010-win64soft.html

  1. There are two zip files, you should download both,

Oracle Installation files

Oracle Installation files

3. Clicking on the first link will take you to the sign-in page, create an Oracle account if you don’t have one or sign in with your account.

Oracle account SignIn

Oracle account Sign In

4. Download both the zip files in your laptop ‘download’ folder or folder of your preference. Extract them into two separate folders.

5.  Since Oracle installation come in two separate files, you should copy the content of one file into the other so that you can use just one folder/setup file for installation. Follow the steps below:

  • Go to the  folder where you have extracted the second zip file, navigate to

          \stage\Components folder. This folder will contain the following 4 sub-folders.

Oracle

Copy all these folders (Ctrl + A and Ctrl + C)

6. Navigate to the location where you have extracted the first Oracle installation file (in step 4) and go to sub folders

\stage\Components

Paste all the folders (copied in the previous step) (Ctrl + v)

7. In the same folder, navigate to the root folder and click on setup

Click on setup to start installation

8. This will start the installation. You will get a dialogue box – Do you want to allow the following program to make changes to your computer? Select Yes

  1. Next you will get an environment warning, select Yes hereIgnore the environment warning

10. In the next dialogue box, it is not mandatory to specify your email and password, so just select Next

Oracle Database 11g

11. The next dialogue box will ask you the different install options. If you want to install, create and configure the database, select the default and select Next

Options to create or modify database

12. In the next screen of options, if you are installing the software on your laptop or desktop, select the default and select Next

Oracle Database 11g

Important configuration settings

13. In the next screen, provide the configuration settings,

  • Oracle base: is the  location where Oracle Software and configuration files are stored. You can select the default or change the location

    • Software location: is Oracle home directory. Default can be selected or change

    • Database file location: Default is fine. In this location all the Oracle files will be installed such as Data files, control files and redo log files.

    • Database edition: There are several options( Enterprise, Standard and personal), you can choose the default  Enterprise Edition.

    • Character Set: choose the default

    • Global database name: This is your database name or SID. It will go into your tnsnames.ora file and also will be used while making connections through client such as SQL developer. You can provide any name or specify oral. Make sure to remember this name as it will be used in creating connections.

    • Administrative password:  This is your administrative password for the user SYS or SYSTEM. You can give any password. Oracle may give a warning that Admin password entered does not conform  to Oracle recommended standards. Just say Yes and move forward. Remember this password, you cannot reset it, if you forget.

    • Take a screen shot of this screen as you may need these settings later.

Important Configuration settings

14. This will start your database installation. After the installation is done, don’t close the window or hit ok.

Unlocking the default schema and users

  1. After the installation is done, don’t close the window, instead click on Password Management. This will help you in unlocking sample databases.

Navigate to unlock database screen

2.  In the Password Management window will display a list of  Oracle provided sample databases. Check the ones you want to unlock and provide your own passwords for each. For learning and practicing SQL , unlock HR and Scott schema.

You can provide any password or just use hr for HR schema and Tiger for Scott schema.

You will receive another warning that password/s provided are not confirming to Oracle standards, you can say Yes here.

3. Now you hit ok and installation and configuration is now successfully completed. In the next screen you can now hit close.

After the installation is completed, you can verify if the installation is successful – Verify your Oracle Installation


If you face any problem in installation or for further steps in learning Oracle, put your comments in the comment section or contact us  at Hello@OhioComputerAcademy.com


Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
What are the 12 Codd rules of RDBMS
Read More
Basics of RDBMS
Read More
Primary Key and Foreign Key with example
Read More
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions