Thursday, December 22, 2016

[INS-30131] Initial setup required for the execution of installer validations failed

Oracle Client 11.2.0.4 Installation Fails  ::

Oracle Client 11.2.0.4 Installation Fails -- [INS-30131] Initial setup required for the execution of installer validations failed

Problem
While installing Oracle Client 11.2.0.4 on windows, installation fails with the error below:

[INS-30131] Initial setup required for the execution of installer validations failed.

Cause - Failed to access the temporary location.

Action - Check current user has required permissions to access the temporary location. or check the other solution below.

Solution : 

Using the Task Manager, check if RemoteExecService.exe *32 is running or not from your temp location, for example C:\Users\\AppData\Local\Temp\oraremservice. If it does, then kill the process and delete the oraremservice folder.


If you the process in the Task Manager then kill the process and then restart the installation as shown in below pic.

Thursday, December 1, 2016

Check the Oracle Home & Client Version (32 bit- or 64 bit) installed on windows




======================================================================= Check the Oracle Home and Client and db installed in windows system
=======================================================================

Go to %ORACLE_HOME%\inventory\ContentsXML folder and open comps.xml file



Example : C:\app\Murthy\product\11.2.0\client_1\inventory\ContentsXML -- then find the "comps.xml file"  in the file you can see the following lines.
 
If you installed 64-bit client then you can see the following lines.
 
PLAT="NT_AMD64" then this Oracle Home is 64 bit.

If you installed 32-bit client then you can see the following lines.

PLAT="NT_X86" then - 32 bit.

You can install both 32-bit and 64-bit Oracle Home & Clients.

Friday, November 11, 2016

[INS-20802] Grid Infrastructure Configuration failed in windows 2012 R2 or 2008 R2 (11.02.0.4.0)


Error "[INS-20802] Grid Infrastructure Configuration Failed" while installing the Oracle Standard Edition 2 (11.2.0.4 ) on Windows 2012 Standard R2 or 2008 R2

I got error "[INS-20802] Grid Infrastructure Configuration Failed" during installation of  Oracle Standard Edition 2 (11.2.0.4) on Windows 20128 R2 (64 bit). All prerequisites were checked,  installation got failed by giving  following error screen .

Installation log as follows :: 
--------------------------------------------------------
INFO: Entering ConfigClient.executeToolsInAggregate method
INFO: ConfigClient.executeToolsInAggregate oAggregate=oracle.crs:oracle.crs:11.2.0.4.0:common
INFO: Entering ConfigClient.assignAction method
INFO: ConfigClient.assignAction actionref=[Loracle.sysman.emCfg.common.IActionReference;@37aff6b1
INFO: ConfigClient.assignAction action is of type :configuration
INFO: Exiting ConfigClient.assignAction method
INFO: ConfigClient.executeToolsInAggregate action assigned
INFO: Started Plugin named: Grid Infrastructure Configuration
INFO: Found associated job
INFO: Starting 'Grid Infrastructure Configuration'
INFO: Starting 'Grid Infrastructure Configuration'
INFO: 2016-11-10 04:16:46: Checking for super user privileges
INFO: 2016-11-10 04:16:46: superUser=Administrator groupName=Administrators
INFO: 2016-11-10 04:16:46: domain=WORKGROUP user=ADMINISTRATOR
INFO: 2016-11-10 04:16:46: C:\app\Administrator\product\11.2.0\grid\bin\crssetup.exe getsystem
INFO: 2016-11-10 04:16:46: Executing cmd: C:\app\Administrator\product\11.2.0\grid\bin\crssetup.exe getsystem
INFO: 2016-11-10 04:16:46: Command output:
INFO: >  SYSTEM
INFO: >End Command output
INFO: 2016-11-10 04:16:46: User has Administrator privileges
INFO: Using configuration parameter file: C:\app\Administrator\product\11.2.0\grid\crs\install\crsconfig_params
INFO: Creating trace directory
WARNING:
INFO:
INFO: Completed Plugin named: Grid Infrastructure Configuration
INFO: Grid Infrastructure Configuration failed.
INFO: Grid Infrastructure Configuration failed.

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


Solution : 

As per my observations and tried to install with multiple ways and multiple times I got this above error. 
There is process like 
1. Use install software only option and install the software. 
2. After successful installation of the grid software, Manually configure the ASM.

In any way that is quite common error and if we got this error we can just skip this error and proceed for the further installation , in this process which I got succeed.and installation went fine .


Note :- Who are installing the grid software there is issue with 11.2.0.4 for windows 2012 R2.
Would suggest please install 11.2.0.3 for windows 2012 R2.


Windows Database Bundle Patch 11.2.0.4.14 or later is required for Windows Server 2012 R2 support.

Oracle Database Standard Edition and Enterprise Edition License, Named User Plus and Perpetual

Product Description

Oracle Standard Edition 2 (SE2) database software is a full-featured database that includes all features needed to build business applications. SE2 has a low-entry price and offers low maintenance costs as well as improved performance, reliability, and security.

Oracle Database Standard Edition Two (SE2) can only be licensed on servers that have a maximum capacity of 2 sockets. If licensing by Named User Plus, the minimum is 10 Named User Plus licenses.When used with Oracle Real Application Clusters, may only be licensed on a single cluster of servers supporting up to a total maximum capacity of 2 sockets.
Oracle Database 12c Standard Edition 2 delivers unprecedented ease-of-use, power, and price/performance for database applications on servers that have a maximum capacity of two sockets.

Oracle Database Standard Edition 2 is an affordable, full featured database that delivers unprecedented ease of use, power, and performance for work group, department-level, and web applications.
From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition 2 includes all the facilities necessary to build business-critical applications with support for clustering of services with Oracle Real Application Clusters (Oracle RAC). It also enables users to leverage a Multitenant architecture to provide more flexible and responsive management for their databases moving forward, provides enterprise-class performance and security, is simple to manage, and can easily scale as demand increases. Oracle Database Standard Edition 2 manages all data types and enables all your business applications to take advantage of the performance, reliability, security and scalability for which Oracle is renowned. It also provides complete upward compatibility with Oracle Database Enterprise Edition, protecting your investment as your requirements grow.

Features :

  •  Fast Installation, Configuration and Self Management.
  • Suitable for all types of data, and applications.
  • Fully upgrade-able to Oracle Database Enterprise Edition.
  • Offers customers a container database architecture, making it easier to plug into the cloud
  • SE2 replaced Oracle Databases Standard Edition (SE) and Standard Edition 1 (SE1) to make an enterprise-class database available to SMB customers.
  •  Optimized for deployment in  small enterprises, line-of-business departments, and distributed branch environments
  •  Built-in Real Application Clusters and Automatic Storage Management.
  •  High availability and rapid application development tools supporting a wide range of developer frameworks.
  •  Cost effective license model – licensed per Socket vs. Cores regardless of how many cores are added over time.
  •  Enables easy migration to the cloud.
  •  Protects your investments as usage requirements grow by offering upward compatibility.
  •  Zero-cost license migration from either SE or SE1 to SE2.
Benefits :
  •     Low cost entry price
  •     Low maintenance costs
  •     Reduced cost of downtime
  •     Proven performance, reliability and security
  •     Save money by buying only what you need today, and scale out as your demand changes with Real Application Clusters
  •     Improve Quality of Service with enterprise-class performance, security and availability
  •     Run on Windows, Linux, and Unix operating systems and easily manage with automated, self-managing capabilities
  •     Streamline application development with Oracle Application Express, Oracle SQL Developer and Oracle Data Access Components for Windows
Technical Specifications :
  •     Maximum Sockets – 2
  •     Maximum Threads Per Database – 16
  •     The maximum core counts per 2-socket server can increase over time without impacting customer  license obligation
  •     Minimum NUPS Per Server – 10
  •     When used with Oracle Real Application Clusters (RAC), each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time.
  •     RAC clusters are limited to 2 nodes, each node must be a single-socket server.
  •     RAM – OS Max
  •     Database Size – no limit
  •     Windows, Linux, Unix, 64-Bit Support
  •     SE2 is required when upgrading to database version 12.1.0.

Minimum Quantities :
The minimum license requirements for database products are in listed below.
Named User Plus licenses:

Program                                                                     Named User Plus Minimum
Oracle Database Enterprise Edition                              25 Named Users Plus per Processor
Oracle Database Standard Edition                                10 Named Users Plus*

Oracle Database Enterprise Edition Options and Enterprise Managers Enterprise Edition Options & Enterprise Managers must match the number of licenses of the associated Oracle Database Enterprise Edition. In addition, a minimum of 25 Named User Plus licenses per Processor must be met. Associated Database is defined as the database(s) which is (are) being managed by the option.

Oracle Standard Edition One    5 Named Users Plus**

** Oracle Standard Edition One may only be licensed on servers that have a maximum capacity of 2 sockets. If licensing by Named User Plus, the minimum is 10 Named User Plus licenses.
 
 If the user minimum is 25 Named Users Plus per processor, then follow the instructions below to calculate the minimum number of named user plus licenses required for your intended hardware configuration.

1. Determine the number of processors on each server where the programs are installed and/or running.
2. Add together the processors on each server.
3. Multiply the total number of processors by 25.
4. The resultant number represents the minimum number of named user plus licenses required for this hardware configuration.

Example: For Database Enterprise Edition on 3 servers each with 2 processors:

1. Number of processors on each server = 2
2. Total number of processors = 6 (3 servers x 2 processors = 6)
3. Multiply the total number of processors by 25 - the required minimum for Database Enterprise Edition is 25 named users plus per processor. (6*25 = 150 named users plus)
4. For this hardware configuration containing 6 processors the minimum number of named user plus licenses required for Database Enterprise Edition is 150.

Processor licenses:

The minimum is 1 for all Oracle Database Products.
Database licensing and user minimums

Example:
A customer who wants to license the Database Enterprise Edition on a 4-way  box  will  be  required  to  license  a  minimum  of  4  processors  *  25  Named User Plus, which is equal to 100 Named User Plus.

Processor:
This metric is used in environments where users cannot be identified and counted.  The Internet is a typical environment where it is often difficult to count   users.      This   metric   can   also   be   used   when   the   Named   User   Plus population  is  very  high  and  it  is  more  cost  effective  for  the  customer  to  license the Database using the Processor metric. The Processor metric is not offered for Personal Edition.    The  number  of  required  licenses  shall  be  determined  by multiplying  the  total  number  of  cores  of  the  processor  by  a  core  processor licensing  factor  specified  on  the  Oracle  Processor  Core  Factor  Table  which  can be  accessed  at  http://oracle.com/contracts.  All  cores  on  all  multicore  chips  for each   licensed   program   are   to   be   aggregated   before   multiplying   by   the appropriate  core  processor  licensing  factor  and  all  fractions  of  a  number  are  to be  rounded  up to  the  next  whole  number.    When licensing Oracle programs
with  Standard  Edition  One,  Standard  Edition  2 or  Standard  Edition  in  the product  name,  a  processor  is  counted  equivalent  to  a  socket;  however,  in  the case  of  multi-chip  modules,  each  chip  in  the  multi-chip  module  is  counted  as one occupied socket.

For example, a multicore chip based server with an Oracle Processor Core Factor of 0.25 installed and/or running the program (other than Standard Edition One programs  or  Standard  Edition  programs)  on  6  cores  would  require  2  processor licenses  (6  multiplied  by  a  core  processor  licensing  factor  of  .25  equals  1.50,which  is  then  rounded  up  to  the  next  whole  number,  which  is  2).    As  another example, a multicore server for a hardware platform not specified in the Oracle Processor  Core  Factor  Table  installed  and/or  running  the  program  on  10  cores
would require 10 processor licenses (10 multiplied by a core processor licensing factor of 1.0 for ‘All other multicore chips’ equals 10).

Note on Minimums:
Product Minimums for Named User Plus licenses (where the minimums are per processor) are calculated after the number of processors to be licensed is determined, using the processor definition.