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
Minimum
Requirement
·
Minimum 2 GB of physical memory
·
Sufficient virtual memory (swap)
·
At
least 10 GB of free disk space
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 class 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.
9) Select Create new windows user and provide user name and password and click Next Button.
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.
1) 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)
)
)
(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.
Thank you for viewing this post.
