Setting up Hugepages for Oracle

use scripts etc to  calculate the right number of pages - or take an estimated guess.

SHOW SGA will give you the current SGA size you need.

I wanted 8G reserved for DB pages

Usual hugepage size is 2M -  you can see this from one of the entries in  /proc

 grep Hugepagesize /proc/meminfo
Hugepagesize:       2048 kB

OK so for 8G reserved 8g/2M = 4096 

add that number to /etc/sysctl.conf

vm.nr_hugepages = 4096

and reboot 

once the instances come up have a look at the Alert Log 

(this is 12.1.0.2 ) 

*********************************************************************

Thu Nov 26 10:08:41 2015

Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Nov 26 10:08:41 2015

 Per process system memlock (soft) limit = 128G

Thu Nov 26 10:08:41 2015

 Expected per process system memlock (soft) limit to lock

 SHARED GLOBAL AREA (SGA) into memory: 1922M

Thu Nov 26 10:08:41 2015

 Available system pagesizes:

  4K, 2048K

Thu Nov 26 10:08:41 2015

 Supported system pagesize(s):

Thu Nov 26 10:08:41 2015

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

Thu Nov 26 10:08:41 2015

        4K       Configured               3               3        NONE

Thu Nov 26 10:08:41 2015

     2048K             4096             961             961        NONE

Thu Nov 26 10:08:41 2015

**********************************************************************

we can see the SGA being allocated into the hugepages 

Running Oracle ETCC for Middle Tier

As per previous post log on to the Middle Tier, download the patch.

Source the run environment and run MTCC.sh
If the environment is correctly sourced you don't need the path to the context file but you DO need the apps password


[oracle@ebsapp4 ETCC]$ ./checkMTpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |             Oracle E-Business Suite Release 12.2              |
 |           Middle Tier Technology Codelevel Checker            |
 +===============================================================+

Using context file from currently set applications environment:
/u02/oracle/VIS/fs2/inst/apps/VIS_ebsapp4/appl/admin/VIS_ebsapp4.xml

Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.21.
Wed Nov 18 05:53:00 EST 2015
Log file for this session: /tmp/ETCC/checkMTpatch_3079.log

Bugfix XML file version: 120.0.12020000.20
This file will be used as the reference for identifying missing bugfixes.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user:
Database connection successful.
The installed AD.C.6 codelevel does not support storing the results in the datab

==================================================================
Oracle Forms and Reports
==================================================================
Now examining product Oracle Forms and Reports.

Oracle Home = /u02/oracle/VIS/fs2/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
  Missing Bugfix: 17353142
  Missing Bugfix: 20643256
  Missing Bugfix: 16041055
  Missing Bugfix: 16910762
  Missing Bugfix: 20270659
  Missing Bugfix: 17372642
  Missing Bugfix: 17566694
  Missing Bugfix: 20240480
  Missing Bugfix: 19304738
The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.

==================================================================
Oracle Fusion Middleware (FMW) - Web Tier
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/webtier.
Product Version = 11.1.1.6.0

------------------------------------------------------------------
[WARNING]
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.6.0 is no longer
recommended for use with Oracle E-Business Suite Release 12.2.
Details of required bugfixes and patches are no longer
maintained for this version, so ETCC output may be out of date
and inapplicable.

For information on recommended versions, refer to My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".
------------------------------------------------------------------

Checking required bugfixes for FMW - Web Tier 11.1.1.6.0.
All required bugfixes are present for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.

==================================================================
Oracle Fusion Middleware (FMW) - oracle_common
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/oracle_common.
Product Version = 11.1.1.6.0

------------------------------------------------------------------
[WARNING]
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.6.0 is no longer
recommended for use with Oracle E-Business Suite Release 12.2.
Details of required bugfixes and patches are no longer
maintained for this version, so ETCC output may be out of date
and inapplicable.

For information on recommended versions, refer to My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".
------------------------------------------------------------------

Checking required bugfixes for FMW - oracle common 11.1.1.6.0.
  Missing Bugfix: 14803792
The above list shows missing bugfixes for FMW - oracle common.

==================================================================
Oracle WebLogic Server (WLS)
==================================================================
Now examining product Oracle WebLogic Server.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
All required patches are present for Oracle WebLogic Server (WLS).

==================================================================

One or more products have bugfixes missing.
Apply the missing bugfixes and rerun this script.

See Doc ID 1594274.1 for the patches that provide the bugfixes.
The footnotes for patches also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.
Wed Nov 18 05:54:32 EST 2015

==================================================================
[oracle@ebsapp4 ETCC]$

Running Oracle ETCC for E-Business Suite - DB Tier

This is for EBS 12.2

Download ETCC from Metalink 17537119

Unzip into its own directory onto the database server

If you have no idea how to run it you will need the path to the context file. 

If you are not experienced you need to know how to find it. 

If you have the environment set then just do 


[oracle@ebsvdbr4 ETCC]$ export |grep -i CONTEXT_FILE

declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"

now we can run ETCC Database checker

[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh                                                                                                                                                    
 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28
Enter the full path to the DB Context file :^C
[oracle@ebsvdbr4 ETCC]$ export |grep -i CON
declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"
declare -x CONTEXT_NAME="VIS_ebsvdbr4"
declare -x HISTCONTROL="ignoredups"
[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28

*** Here paste in the path to the Context File **** 


Enter the full path to the DB Context file :/u02/oracle/VIS/11.2.0/appsutil/VIS_                                                                                                             ebsvdbr4.xml

Using database context file:
/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml

Bugfix XML file version: 120.0.12020000.27
This file will be used as the reference for identifying missing bugfixes.

Identifying database release.
Setting database release to 11.2.0.3.

================================================================================                                                                                                             ===

[WARNING]

Oracle Database 11.2.0.3 is no longer recommended  for use with Oracle
E-Business Suite Release 12.2. Details of bugfixes and patches
are no longer maintained for this version, so ETCC output may be out of date and
inapplicable.

For recommended database versions, refer to  My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".

================================================================================                                                                                                             ===

Database connection successful.

Table to store DB-ETCC results already exists in the database.

Started prerequisite patch testing : Wed Nov 18 05:29:57 EST 2015

Log file for this session : ./checkDBpatch_43824.log

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is at the required version.

Found patch records in the inventory.

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database successfully.

Finished prerequisite patch testing : Wed Nov 18 05:30:06 EST 2015


=========================================================

Yes I know 11.2.0.3 is not supported.  I am upgrading to 12.1.0.2 but before I do that I need to put all the interop patches needed on.  Here I am just showing how to run ETCC 

E-Business Oracle EBS 12.2 Check AD and TXK patches versions applied

Standard question for EBS 12 - what AD and TXK versions have been applied ?

You can check via query on a  metatable



sqlplus connect as apps and run

column codelevel format a30
column name format a40
 select  ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');


ABBREVIA NAME                                     CODELEVEL
-------- ---------------------------------------- ------------------------------
ad       Applications DBA                         C.6
txk      Oracle Applications Technology Stack     C.6

SQL>

Column Codelevel is what you want  So C.6 

Installing 12.1.0.2 database and cannot select Enterprise Edition

So your Oracle Installer it has come to select the Edition and ENTERPRISE EDITION is greyed of grayed out !!!  you can only select SE2 .

Heavens to Betsy

WHAT HAVE YOU DONE WRONG

WELL Just like the rest of us you have unzipped all the patchsets into a single directory.

But with this release Oracle have made SE2 different so Enterprise Edition is disks1 and 2 and SE2 is disks 3 and 4

So when you unzipped disks 1...10  SE2 has overwritten the database directory.

How to fix ?  Remove the unzipped database directory and just unzip disks1 and 2 for EE, and disk3 and 4 for SE2

HTH

Chris.

Installing 12c and get invalid inventory pointer location file

This happened to me recently when testing a 12.1.0.2 upgrade 
As I know for sure this machine's inventory is good I decided to investigate. 

Metalink Note 1292347.1 is a useful reference 

It turns out the inventory oraInst.loc file used to be able to get away with only inst_loc line , now you need inst_group as well. 

on Linux this is usually oinstall. 

So oraInst.loc should look like 

inventory_loc=/u01/oracle/inventory

inst_group=oinstall

Once that is done re-run the installer and it should now start up OK.