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
- Navigate to the link below to download Oracle 11g installation files.
https://www.oracle.com/database/technologies/112010-win64soft.html
- There are two zip files, you should download both,
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.
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.
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
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
- Next you will get an environment warning, select Yes here
10. In the next dialogue box, it is not mandatory to specify your email and password, so just select Next
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
12. In the next screen of options, if you are installing the software on your laptop or desktop, select the default and select Next
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 orcl. 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.
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
- After the installation is done, don’t close the window, instead click on Password Management. This will help you in unlocking sample databases.
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