August 2018 Update to E-Business Suite Technology Codelevel Checker (ETCC)

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps missing overlay patches to the default corresponding Database Patch Set Update (PSU) patches, and displays them in a patch recommendation summary.

Click this link for details

Oracle Access Manager 12c and Oracle Internet Directory 12c Certified with EBS 12.2 and 12.1

Oracle Access Manager 12c (12.2.1.3.0) and Oracle Internet Directory 12c (12.2.1.3.0) are now certified with E-Business Suite Releases 12.2.3 and higher and Release 12.1.3 and higher.

Click this link for details

Oracle Database 12.1.0.2 certified with EBS 12.2

Oracle Database 12.1.0.2 certified with EBS 12.2


For Oracle Database 12.1.0.2 certified with EBS 12.2
Please check "Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 (Doc ID 1926201.1)"

For Oracle Database 12.1.0.1 certified with EBS 12.2
Please check "Interoperability Notes EBS Release 12.2 with Database 12cR1 (12.1.0.1) (Doc ID 1959604.1)"

(adsbygoogle = window.adsbygoogle || []).push({});

Internet Explorer 11 Certified with E-Business Suite 12.2 and 12.0

Internet Explorer 11 Certified with E-Business Suite 12.2 and 12.0

EBS 12.2 Prerequisites

• EBS 12.2.3 or later 12.2 updates 
• Java Plug-in JRE 1.6.0_03 (32-bit) or higher, or JRE 1.7.0_10 (32-bit) and higher
• Java Plug-in JRE 1.6.0_32 (64-bit) or higher, or JRE 1.7.0_10 (64-bit) and higher

EBS 12.0 Prerequisites

• EBS 12.0.6
• Java Plug-in JRE 1.6.0_03 (32-bit) or higher, or JRE 1.7.0_10 (32-bit) and higher
• Java Plug-in JRE 1.6.0_32 (64-bit) or higher, or JRE 1.7.0_10 (64-bit) and higher

Below is the link "https://blogs.oracle.com/stevenChan/entry/ie11_ebs_12_2_certified" regarding the details.

E-Business 12.2 Step by Step Installation - Part 1

EBS 12.2 Step by Step Installation

1. Download below files from below link and unzip in staging area.

(https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=17928684)

2. Download all 12.2.0 Rapid Install (All Disks and Parts) and keep it in zip source folder

mkdir /oapps_staging/ebs/software/zip

a)    Download database software install CD

b)    Download database Vision/Prod  Instance CD’s

c)    Download Application , One-Off Patches, Web Server & Web Tier Utilities CD’s

3. Check all requirements for Linux based on below Oracle Support Note.

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

ASM Scripts

ASM Scripts

Some Important v$ views for ASM

v$asm_diskgroup

v$asm_client

v$asm_disk

v$asm_file

v$asm_template

v$asm_alias

v$asm_operation 

Some useful scripts to get ASM details.

1) ASM Diskgroup Details

SELECT *

  FROM v$asm_diskgroup

 ORDER BY group_number;

2) ASM Connected database

SELECT ad.name,

       ac.instance_name,

       ac.db_name,

       status

  FROM v$asm_diskgroup ad,

       v$asm_client ac

 WHERE ad.group_number = ac.group_number

 ORDER BY ac.instance_name,

       ac.db_name, 

       ac.group_number;

3) ASM disk details

SELECT * from v$asm_disk;

4) ASM disk operations

SELECT * from v$asm_operation;

5) Free disk details

SELECT * from v$asm_disk;

check header_status is FORMER or CANDIDATE  

Oracle 12c RAC

Oracle 12c RAC

Oracle RAC 12c introduces two new concepts

Hub Nodes: They are connected among them via private network and have direct access to the shared storage just like previous versions. These nodes are the ones that access the Oracle Cluster Registry (OCR) and Voiting Disk (VD) directly.

Leaf Nodes: These nodes are lighter and are not connected among them, neither access the shared storage like the Hub Nodes. Each Leaf Node communicates with the Hub Node that is attached to, and its connected to the cluster via the Hub Node that is linked to.

Oracle FLEX ASM

In earlier releases (11g), ASM and database instances are tightly coupled with 1:1 mapping. If any ASM instance goes down then corresponding database node also crashes.

Oracle FLEX ASM - Introduced in 12c, ASM and database instances are loosely coupled, means every database node doesn't require ASM instance running on each node to serve storage. In 12c, by default you will get three ASM instances in cluster to server storage. In 12c, ASM instances use dedicated interconnect like database private interconnect in RAC.