Installing Oracle 12c Database on Windows 7 64 Bit

Installing Oracle 12c Database on Windows 7 64 Bit

This tutorial is used to install new 12c Release 1 (12.1.0.2.0) for Microsoft Windows (x64)

 64 bit platform using Oracle Universal Installer.

I have installed this database on my Microsoft Windows 7 Home basic.

Hardware used for this installation is   
Intel i3-2370M CPU
8 GB RAM
64 Bit Operating system Windows 7 Home Basic Service Pack 1

Prerequisites

1) You should have Oracle Database 12c distribution media or you can download 2 zip file from oracle official website. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

2) Extract it to your local drive will make folder name database.

Installing Oracle 12c Database.

1) Expand the database folder which you have extracted and Right click your mouse button to Setup.exe select Run as administrator and click YES button when asked for User access control.

2) Oracle Universal Installer window will appear.

3) Uncheck the option for security update if you do not want to receive any update from Oracle Support       else provide email and my oracle support password and click the Next Button.

4) Click YES button.

5) Select Create and configure a database and click Next.

6) Select Server or Desktop class(As per your Requirment) and click Next Button.

7) Select Single Instance and click Next.

8) Select Typical installation and click Next.

9) Select Create new windows user and provide user name and password and click Next Button.

10) In Typical install configuration select the drive where you want to install the database, provide Global Database name, password and Create as Container database and give pluggable database name. This pluggable database will be helpful while installing Oracle Forms 12c.

11) Prerequisite check completed and summary is appear, press Install Button to proceed for installation.

12) Progress window will appear.

13) Database configuration starts.

14) Database configuration completes.

  

15) Click OK to continue. After installation you can navigate to https://localhost:5500/em and unlock the users and change the password for various users.

16) Installation complete and you can close this window.

17) Now we will verify that installation of database is up an running. go to c:\windows\system32 directory and double click services.msc.

18) You will see the most of the oracle database related services are started.

19) Now navigate to the folder C:\Oracle12c\OracleUser. This folder contains database files in oradata folder.

20) Now navigate to the folder C:\Oracle12c\OracleUser\product\12.1.0\dbhome_1 which contains oracle software files.

21) Now we will check the TNS entry in tnsnames.ora file in C:\Oracle12c\OracleUser\product\12.1.0\dbhome_1\NETWORK\ADMIN. If it is not available then create it. You can see that "orcl" is created and it is pointing to container database with the service name as "orcl".

 22) Now we will create another database connect entry for Pluggable database "PDBORCL" created during installation copy the following entry in tnsnames.ora file at the end. Save and close the file

.

PDBORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)
    )
  )

23) Now we will connect to pluggable database using SQL*plus utility.

24) Now we are successfully connected to the pluggable database as sys user.

25) Now we will alter and unlock the hr user which is created during installation as

alter user hr identified by hr account unlock;

 

  

26) Now we will connect to the hr user of pdborcl and query the catalog.

select * from tab;

27) Now we will query the COUNTRIES table.

select * from countries; 

Now the database is successfully created and working.