All posts by Atul Kumar
Upgrade Oracle Applications to 12.0.4
Oracle Applications Release 12 update 4 (12.0.4) is available now. This post covers top level steps for upgrading Oracle Applications R12 (12.0.0, 12.0.1, 12.0.2, 12.0.3) to latest patchset i.e. 12.0.4 Key Points for Upgrade to 12.0.4 1. You can upgrade to 12.0.4 directly from following releases 11.5.8, 11.5.9 (Base, Update1 and Update2), 11.5.10 (Base, Update1 and […]
Read MoreChange Data Capture – Oracle CDC
CDC : is database functionality that helps in capturing incremental changes to Oracle Database. Terminology in CDC Publisher: is database user that publishes captured changed data Subscriber: is database user that consumes changed data Change Tables: Changes in database are written to change tables Subscriber Views: are database views against change tables for subscribers. Note* […]
Read MoreNotes/Docs to integrate Apps 11i with 10g AS Portal/OID/SSO
In this post you’ll find metalink notes and related docs used in Integration of Oracle 10g Application Server (Portal, BI, Forms, OID, SSO) with Oracle E-Business Suite 11i. Soon I’ll focus on key points for integrating Oracle E-Business Suite with Oracle Single Sign-On (SSO) and Oracle Internet Directory (OID). 10g Application Server can be integrated with E-Business Suite […]
Read MoreBPEL Admin/Control Console
In today’s post I am going to cover BPEL Admin Console & BPEL Control Console which are part of Oracle SOA Suite. URL to access Console BPEL Control Console : http://hostname.domainname:port/BPELConsole BPEL Admin Console : http://hostname.domainname:port/BPELAdmin User to access BPEL Admin Console or BPEL Control are – oc4jadmin (This user is For all BPEL […]
Read MoreOracle 11.5.10.2/12.0.X Software on Linux : Download (11i/R12/12i)
Often I get question in my inbox from lot of newbie asking what all files to download to install Oracle Apps 11i or R12/12i . Here is the list of files you need to download from http://edelivery.oracle.com to install 11i/R12/12i Oracle® Applications 11i Release 10.2 Update Media Pack v1 for Linux x86 (11.5.10.2) Oracle® Applications […]
Read MoreOID Quesries/ Scripts FAQ
Oracle Internet Directory (OID) is LDAP compliant directory server from Oracle. OID is part of Identity Management stack of Fusion Middleware (Infrastructure tier of Oracle Application Server) Here is list of commonly asked questions/scripts for OID Q: How to find orasso (Single Sign-On) schema password. A: orasso password is randomly generated and stored in OID. To find password run […]
Read MoreOracle Application Server Service Registry : Installation
Oracle Service Registry is UDDI (Universal Description, Discovery and Integration) version 3 compliant platform for publishing, categorizing and discovering Web Services. Oracle Service Registry is component of Oracle Fusion Middleware and can be installed with Oracle SOA Suite. In today’s post we are going to cover installation of Oracle Service Registry. Download Oracle Service Registry from Here […]
Read MoreTablespace and Datafiles in Oracle Database : Back to Basics
Image taken from Oracle Documentation Tablespace : is logical storage unit in Oracle Database. ii) Tablespace connsit of one or more datafiles (check below) iii) Information about Tablespace can be obtained from view DBA_TABLESPACES, USER_TABLESPACES, DBA_TEMP_FILES (for Temporary Tablespaces) iv) Tablespace is further divided in to logical units Segments (Segment is divided in to Extent and Extent in […]
Read MoreOracle Identity Manager 9.1 released
Oracle Identity Manager is Identity Provisioning & Reconciliation software from Oracle and is part of Oracle Identity Management (IdM) product stack (which in turn is part of Oracle Fusion Middleware). Oracle Identity Manager is built on Thor Exellerate acquired by Oracle. Oracle Identity Manager version 9.1 is released and now available to download from here For […]
Read MoreBlocks , Extents, Segments in Oracle Database : Back to Basics
On popular demand from our newbie DBA readers, I am starting Oracle Database Back to Basics series where I am going to cover basic concepts and Architecture of Oracle Database (9i, 10g, 11g) Today’s post is dedicated to logical storage component of Oracle Database i.e. Data Blocks, Extents and Segment A. Data Blocks is smallest […]
Read More