Installation Details:
Current Operating System: Windows 64-bit Server
Database Version: Oracle 11.2.0.4
Database Edition: Enterprise Edition
Minimum Hardware Requirements:
Log on as a member of the Windows
Administrator group to the machine on which you want to install Oracle
Software. Oracle strongly recommends to install the Oracle
database home on Oracle ACFS or NTFS. The database files must be placed on
Oracle ASM if using Oracle ACFS; otherwise they can be placed on NTFS.
Usage of Oracle ACFS and Oracle ASM or NTFS instead
of FAT32 is recommended to ensure security of these files.
Note: Oracle
provides limited certification for 32-bit
Oracle Database Client on 64-bit Windows x64. Oracle
Database for Windows x64 is supported on the following operating systems:
Minimum Software Requirements:
Oracle
Database for Windows x64 is supported on the following operating systems:
- Windows Server 2003 - all x64 editions
- Windows Server 2003 R2 - all x64 editions
- Windows XP Professional x64 Edition
- Windows Vista x64 - Business, Enterprise, and Ultimate editions
- Windows Server 2008 x64 - Standard, Enterprise, Datacentre, and Web editions.
- Windows Server 2008 R2 x64 - Standard, Enterprise, Datacentre, Web, and Foundation editions.
- Windows 7 x64 - Professional, Enterprise, and Ultimate editions
- Windows 8 x64 - Pro and Enterprise editions
- Windows 8.1 x64 - Pro and Enterprise editions
- Windows Server 2012 x64 and Windows Server 2012 R2 x64 - Standard, Datacentre, Essentials, and Foundation editions
- Windows Multilingual User Interface Pack is supported.
Note: The Server
Core option is not supported for all Windows Server operating systems.
Network Protocol:
The Oracle Net foundation layer uses Oracle protocol support to
communicate with the following industry-standard network protocols:
- TCP/IP
- TCP/IP with SSL
- Named Pipes
Step 1: Now you will not get Oracle 11g Software from Oracle Downloads,
instead you download Oracle 11g R2 patchset
from Oracle Support Site. Download
the first 2 setup files and go to the folder where downloaded files exist.
Step 2: Now if you try to extract these files as same as Linux OS then you will receive an error
message like “file is missing”. That
is why because extraction on Windows Server
will create two different database
folders in two different directories. But on Linux, it will create only one database directory.
To avoid this problem, extract 1st
file in normal way and extract 2nd file by selecting 1st
extracted folder so that it will use same folder and you will get only one database folder. Please find below
screenshots for the same.
Step 3: Go to database folder and right click on setup file, use “Run as administrator” option. You will
receive one pop-up box. Click YES to
continue.
Step 5: Select “Create and configure
a database”.
Create
and configure a database => Using this option,
you can install Oracle software and configure database too.
Install
database software only => Using this option, you
can only install Oracle Software. Later you can create database using DBCA
method or manual method.
Upgrade
and existing database=> Using this option, you
can only upgrade you Oracle database from older version to latest release.
Step 6: Select “Server Class” option.
Desktop
Class=> Use this option if you are installing
software on a Laptop or Desktop System which includes minimal configuration.
Server
Class=> Use this option if you are installing
software on a Server Class System which Oracle defines as a system used in a
production datacenter. This option allows for more advanced configuration
option.
Step 7: Select “Single instance
database installation” option and click NEXT.
Single
instance database installation=> This option is
useful only for Oracle Single Instance installation.
Oracle
Real Application Clusters database installation=> This option is used for installing Oracle Real Application Clusters
database to install and configure multiple instances.
Oracle
Real One Node database installation=> This
option is used for installing Oracle Real Application Clusters database to
install and configure RAC one node.
Step 8: select “Advanced install”
option and click NEXT to continue.
Typical
install=> This option allows full Oracle
Database installation with basic configuration.
Advanced
install=> This option allows advanced selections
such as:
- Different passwords for SYS, SYSMAN, SYSTEM, and DBSNMP accounts
- Different character set
- Product languages
- Automated backups
- Custom installation, and
- Alternative storage options such as ASM (Automatic Storage Management).
Select language “ENGLISH” and click NEXT
to continue.
Step 8: Select “Enterprise Edition”
and click NEXT.
Enterprise
Edition (3.8 GB) => This Edition is a
self-managing database that has the scalability, performance, high
availability, and security features required to run the most demanding,
missing-critical applications.
Standard
Edition (3.7 GB) => This Edition is full
featured data management solution ideally suited to the needs of medium-sized businesses. It includes
Oracle RAC with its own Oracle Clusterware and Storage management capabilities.
Standard
Edition One (3.7 GB) => This Edition is full
featured data management solution ideally suited to the needs of small and medium-sized businesses.
Personal
Edition (3.7 GB) => This Edition supports
single-user development and deployment that requires full compatibility with Oracle Enterprise Edition 11g and Oracle Standard Edition 11g.
Step 9: Select path for Oracle Base and Oracle Home directories of your
choice but ensure that the current user has valid permissions on these
directories.
Select “General
Purpose / Transaction Processing” option and click NEXT to continue.
General
Purpose / Transaction Processing => This option
allows general purpose use, or for transaction-heavy applications.
Data
Warehousing => It allows database optimized for
data warehousing applications.
Step 10: Enter your database name and click NEXT to continue.
Global
Database Name => which must be uniquely
identified by a Global Database Name, formed by “databasename.domainname”.
For
Example: Your database name is test and domain name is domain.com
then Global database name will be test.domain.com.
Oracle
Service Identifier (SID) => A database is
referenced by at least one oracle instance that is uniquely identified from any
other instance on the machine by an Oracle Service Identifier(SID).
Use AMM
(Automatic Memory Management) option if you want which is recommended by
Oracle. I have disabled it as it is testing environment. Increase Allocated
Memory for both SGA and PGA if you wish to allocate. Click NEXT to continue.
The below option “Oracle Enterprise Manager Database Control for database management”
is by default selected as you have initially selected “Advanced” option. Click NEXT
to continue.
Step 11: Select “File System” option
and click NEXT.
The second option is for ASM (Automatic
Storage Management).
Below option allows to enable or disable
automated backups for your database. If you choose to enable automated backups,
then the backup job uses the specified recovery area storage.
Click NEXT
to continue.
Step 12: Verify below phases are running in proper way without any error. If
you want to save response file then you can save it. Click Install.
- Oracle Database Installation
- Prepare
- Copy Files
- Setup Files
- Oracle Database Configuration
You will receive pop-up box for Password Management. If you want to set
password and unlock any account then you can do that by editing info in that
pop-up box.
Write down URL of Oracle Enterprise Manager.
Click Close to finish.
You have successfully installed and
configured Oracle Database Software.
Thanks for reading this post ! Please comment if you like this post !
Thank U sir..
ReplyDeleteThank U sir..
ReplyDelete