Exadata Storage Server Patching in 18.1.1 and Above

One of the cool new features that was introduced with 18.1.0.0.0 was a subtle change in the Exadata storage server patching process.  While not required, this new functionality removes the need to use patchmgr to drive Exadata storage server patches.

Click this link for details

Offloading EBS 12.2 Reporting Using Active Data Guard 12.1.0.2

Oracle Active Data Guard 12.1.0.2 is now certified with Oracle E-Business Suite 12.2.  This certification supports the ability to offload some production reporting from your production EBS 12.2 environment to an Active Data Guard instance. For example, you can use Oracle Discoverer and Concurrent Manager to run selected reports against an Oracle Active Data Guard physical standby database instance.

Click this link for details

JRE 1.8.0_181 Certified with Oracle EBS 12.1 and 12.2

Java Runtime Environment 1.8.0_181 (a.k.a. JRE 8u181-b13) and later updates on the JRE 8 codeline are now certified with Oracle E-Business Suite 12.1 and 12.2 for Windows clients.

Click this link for details

Oracle Grid 12c Release 2 (12.2) Certified with RAC 12.1 and EBS 12.2

Oracle Grid 12c Release 2 (12.2) is now certified when using Oracle 12c Release 12.1 Real Application Clusters (RAC) with Oracle E-Business Suite Release12.2.  When using Oracle RAC 12.1 with Oracle E-Business Suite 12.2, you now have the option to use either Oracle Grid 12c Release 12.2 or 12.1.

Click this link for details

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.

11.2.0.4 database patchset - certified with EBS

11.2.0.4 database patchset is now certified with Oracle E-Business Suite 11i and R12.

11.5.10 E-Business Suite Consolidated Update 2 with ATG Rollup Patch 6 is certified with 11.2.0.4 database patchset




Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) (Doc ID 881505.1)

12.0.4 or 12.1.1 E-Business Suite is certified with 11.2.0.4 database patchset

Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)

12c database certified with 11i and R12

New oracle database 12c version is certified with ebusiness 11i and R12.

11.5.10 E-Business Suite Consolidated Update 2 with ATG Rollup Patch 7 is certified with 12c release 1 (12.1.0)database.




Please refer Interoperability Notes EBS 11i with RDBMS 12cR1 (Doc ID 1524399.1)

12.0.6 or 12.1.3 E-Business Suite is certified with 12c release 1 (12.1.0) database.

Please refer Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

Oracle E-Business Suite 12.2 - Released

Oracle E-Business Suite 12.2 has been released just before oracle open world 2013 starts.




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

Oracle Apps R12 - Concurrent Program terminated by signal 25

Concurrent Program terminated by signal 25

Issue
Concurrent program getting errored with emsg:was terminated by signal 25

Solution
Concurrent program accessing reports.log in $APPLCSF/$APPLLOG will get above error if reports.log file size is more than 2 GB.

cd $APPLCSF/$APPLLOG
mv reports.log reports.log_bkup
touch reports.log

This File Size limit of 2 GB applies to any log/out file generated by EBS process. Any log/out file limit of 2 GB has been reached then corresponding process/program will get error out. This applicable for DB/Apps Listener as well.

Error: Signal 25 Concurrent Program Completes with Error (Metalink Doc ID 842850.1)

Oracle Apps R12 - Concurrent manager is consuming high usage

Concurrent manager is consuming high usage

Query

SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date,'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date,'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, 0)
FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X
WHERE R.Status_code = 'I' And ((R.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on,1,FND_CONC_GLOBAL.OPS_INST_NUM,R.OPS_INSTANCE))) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists
(Select Null
From Fnd_Concurrent_Requests Sr
Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))) AND ((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) NOT IN ((20006,121091),(20006,167185),(20007,127088)))) FOR UPDATE OF R.status_code NoWait

Issue

All standard managers run this query with "library cache: mutex X" event

Solution

Test and apply patch 13629213 for 12.1 EBS Instances

While applying if you hit Relink of module "AFPASSWD" failed issue

Test and apply Patch 13855823 for 12.1 EBS Instances

Concurrent Managers are consuming high CPU and memory (Metalink Doc ID 1075684.1)

Oracle Database 12c - Administer PDB Datafile

How to administer PDB datafile

set container to corresponding pdb from root.

SQL> alter session set container=dx12p1;

Session altered.

SQL> alter database datafile '/oradisk/oradata/dx12c/dx12p1/user_01.dbf' autoextend off;

Database altered.

SQL> select file_name from cdb_data_files;

FILE_NAME
---------------------------------------------------------------------------------
/oradisk/oradata/dx12c/dx12p1/system_01.dbf
/oradisk/oradata/dx12c/dx12p1/sysaux_01.dbf
/oradisk/oradata/dx12c/dx12p1/user_02.dbf
/oradisk/oradata/dx12c/dx12p1/user_01.dbf

cdb_data_files will list all the datafiles of all pdbs if it is executing from cdb$root container.

SQL> alter session set container=cdb$root;

Session altered.

SQL> select con_id,file_name from cdb_data_files;

    CON_ID FILE_NAME
---------- --------------------------------------------------------------------------------
         4 /oradisk/oradata/dx12c/dx12p1/system_01.dbf
         4 /oradisk/oradata/dx12c/dx12p1/sysaux_01.dbf
         4 /oradisk/oradata/dx12c/dx12p1/user_01.dbf
         4 /oradisk/oradata/dx12c/dx12p1/user_02.dbf
         1 /oradisk/oradata/dx12c/o1_mf_system_92z0hgg0_.dbf
         1 /oradisk/oradata/dx12c/o1_mf_sysaux_92z0drb2_.dbf
         1 /oradisk/oradata/dx12c/o1_mf_undotbs1_92z0l5j5_.dbf
         1 /oradisk/oradata/dx12c/o1_mf_users_92z0l4c0_.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_o1_mf_system_92z0mhgh_.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_o1_mf_sysaux_92z0mhg3_.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_users02.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_users01.dbf
         2 /oradisk/oradata/dx12c/o1_mf_system_92z0mhgh_.dbf
         2 /oradisk/oradata/dx12c/o1_mf_sysaux_92z0mhg3_.dbf

14 rows selected.

SQL> alter session set container=dx12p;

Session altered.

SQL> select con_id,file_name from cdb_data_files;

    CON_ID FILE_NAME
---------- --------------------------------------------------------------------------------
         3 /oradisk/oradata/dx12c/dx12p/dx12p_o1_mf_system_92z0mhgh_.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_o1_mf_sysaux_92z0mhg3_.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_users02.dbf
         3 /oradisk/oradata/dx12c/dx12p/dx12p_users01.dbf

Oracle Database 12c - Drop PDB

Drop pluggable database

Unplugged database can not be opened again. This database can be dropped using keep datafiles or including datafiles.

SQL> drop pluggable database dx12p1 keep datafiles;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DX12P                          READ WRITE NO

SQL> drop pluggable database dx12p including datafiles;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO

Oracle Database 12c - Unplug PDB

How to Unplug the pluggable database

PDB must be closed before unplug the corresponding PDB.

SQL> alter pluggable database dx12p1 unplug into '/oracle/app/oracle/product/12.1.0/my_pdb/DX12P1.xml';
alter pluggable database dx12p1 unplug into '/oracle/app/oracle/product/12.1.0/my_pdb/DX12P1.xml'
*
ERROR at line 1:
ORA-65025: Pluggable database DX12P1 is not closed on all instances.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 DX12P1                          READ WRITE NO

SQL> alter pluggable database dx12p1 close;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 DX12P1                         MOUNTED

SQL> alter pluggable database dx12p1 unplug into '/oracle/app/oracle/product/12.1.0/my_pdb/DX12P1.xml';

Pluggable database altered.

Unplugged database can not be opened again.

SQL> alter pluggable database dx12p1 open;
alter pluggable database dx12p1 open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

Oracle Database 12c - convert PDB from read only to read write

How to convert pdb from read only to read write

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DX12P                          READ ONLY  NO

SQL> alter pluggable database dx12p open;
alter pluggable database dx12p open
*
ERROR at line 1:
ORA-65019: pluggable database DX12P already open


SQL> alter pluggable database dx12p close immediate;

Pluggable database altered.

SQL> alter pluggable database dx12p open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DX12P                          READ WRITE NO
         4 DX12P1                         READ WRITE NO