Installing Oracle 11g

                                                        Assalamualaikum n Hai..

       I'll share how to install Oracle 11g in Window. Hope this few steps can help anybody whose still clueless about it..

*The important thing before you start to install Oracle 11g, you must make sure that your PC NOT CONNECTED TO ANY NETWORK!!



                                      ******************** INSTALL ORACLE 11g ********************

Figure 1

1. Click on 'setup' icon in the folder that u have download before, then the window like Figure 2 will be appear. After that wait until the window like Figure 3 appear before you'll continue the installing progress.

Figure 2

Figure 3

 

Figure 4

 2. In Figure 4, if you want to receive any to receive security issue notification via email, you can tick in the provided box and insert your e-mail address.

 

Figure 5

 3. If you don't insert your e-mail, the pop-up in Figure 5 will appear. Just click on 'Yes' button if you wish to remain uninformed of critical security issues in configuration via email.

Figure 6

 4. As this tutorial is about installation of Oracle, then you just tick on "Install database software only" and click on 'Next' button to proceed.

Figure 7

 5. Tick on "Single instance database installation" and click on 'Next' button to proceed.
     ~ For more detail about "single instance database installation", feel free to click here =D ~

Figure 8

 6. Choose the language that you'll use in this software i.e English.

Figure 9

 7. Tick on "Enterprise Edition (3.34 GB)", then click on 'Next' to proceed.

Figure 10

 8. Look at the Oracle Base and Software Location, its' the location of your software being installed. If something happen to your Oracle, you can refer to the location.

Figure 11

 9. For Figure 11, you have to wait until the system done it's checking, then the Figure 12 will appear.

Figure 12

 10. After you click on 'Finish' button in Figure 12, the Figure 13 will appear. Now process of installing the Oracle is start. You must not interrupt the process, or the software will not work properly.

Figure 13

Figure 14

Figure 15

11. Before process in Figure 13 finished, pop-up like Figure 14 will appear. You can choose whether 'Allow access' or 'Cancel' it. After clicking any button, the process is finished. Window in Figure 15 will appear as the process of installing Oracle 11g is finished.

~For more detail about Figure 14, feel free to read it here ~

Figure 16

12. To make reconfirmation whether the installation are finished or not, you can click on

        Start - All programs - Oracle - Application Development - SQL Plus. Then Figure 17  will appear.

Figure 17

13. Here you need to insert your user-name and password. The password will not appear in the screen, so, you just need to type the real password. Then if, the installation is settled, the message that appear is
    " Connected to :
       Oracle Database 11g Enterprise Editing Release 11.2.0.1.0 - 64bit Production With the Partitioning,             OLAP, Data Mining and Real Application Testing options".





                                    ********************* TO CREATE DATABASE*********************

Figure 18

1. Click on Start - All program - Oracle - Configuration and Migration Tool - Database Configuration Assistant. Then, window like in Figure 19 will appear. Click on 'Next' button to proceed.

Figure 19

Figure 20

 2. Tick on "Create Database", then click on 'Next' button to proceed.

Figure 21

 3. Tick on "General Purpose or Transaction Processing", then click on 'Next' button to proceed.
 if for Oracle 10g, the reason we choose "General Purpose or Transaction Processing" is because we can minimize input required. You can create your database more quickly than with the advanced type.  As for Oracle 11g, i cannot find the reason, but i think the reason is the same as in Oracle 10g.

~ For more details, you can read here and here. ~

Figure 22

 4. Insert any name, then click on 'Next' button to proceed.

Figure 23

 5. Tick on "Configure Enterprise Manager" and " Configure Database Control for local management", then click on 'Next' button to proceed.

Figure 24

 6. If you not add any Listener yet, this pop-up will appear. You have to add Listener first, then you can proceed. For more detail, please refer to "ADD LISTENER" steps below.

Figure 25

7. After you have add your Listener, Figure 25 will appear. Now you need to create any password and both of them must match. If both passwords not match, Figure 26 will appear.

Figure 26

Figure 27

8. Tick on "Use Database File Locations From Template", then click on 'Next' button to proceed.

Figure 28

9. Tick on "Specify Flash Recovery Area", then click 'Next' button to proceed.

Figure 29

10. Click on 'Next' button to proceed.

Figure 30

11. Tick on "Typical" and "Use Automatic Memory Management", then click on 'Next' button to proceed.

Figure 31

12. Click on 'Next' button to proceed.

Figure 32

13. Tick on "Create Database", then click on 'Finish' button.

Figure 33

Figure 34

14. After you click on 'Finish' button. Figure 32 will appear, then click on 'OK' button, then window in Figure 34 will appear. You have to wait until window just like in Figure 35 appear. Lastly you will click 'Exit' button. It's mean, your database has been created.

Figure 35

                                           *********************** ADD LISTENER ********************

# From Figure 24, if you do not have any Listener yet, you have to add first before you proceed process of creating database.

Figure 36

1. Click on Start - All Programs - Oracle - Configuration and Migration Tools - Next Configuration Assistant. Then Figure 37 will appear. Tick on "Listener Configuration", then click 'Next' button to proceed.

Figure 37

Figure 38

2. Tick on "Add", then click on 'Next' button to proceed.

Figure 39

3. You can name the Listener by using any name, then click on 'Next' button to proceed.

Figure 40

4. Choose the Selected Protocol i.e TCP, then click on 'Next' button to proceed.

Figure 41

5. Tick on 'Use the standard port number of 1521, then click on 'Next' button to proceed.

Figure 42

6. After click on 'Next' button in Figure 42, this pop-up will appear. You can choose either "Allow access" or "Cancel".

Figure 43

7. Tick on "No", then click on 'Next' button to proceed.

Figure 44

8. Your Listener configuration is complete!! Click on 'Next' button to proceed.

Figure 45

 9. Tick on Listener configuration, then click on 'Finish' button. Finally the process of adding listener is complete !! =D



                                      ***************** CHECKING THE ORACLE 11g ****************

Figure 46

1. Click on Start - All programs - Oracle - Database Control-Afifah

Figure 47

2. Please insert the "User name" and 'Password", then click on 'Login'. The password is based on password that you've created before. Please look at Figure 21 for more detail.

Figure 48

 3. After you have success to login, Figure 42 is shown. If the "Status" in "General" shown "Up", it's means, your software is ready to use.

Figure 49

4. Finally, if you have 'Log Out', Figure 43 will be shown.


---------------------------------------------------------------------------------------------------------------------------------------

Alhamdulillah, that's all that I can share. Hope this few steps can help anyone.. Thanks  =D


There are a lots of website that share everything about Oracle 11g ..
Feel free to drop here and here =D.. All the best to those who want to install Oracle 11g..