1Z0-114 – Oracle SOA Foundations, Adoption and Implementation certification for SOA Architects
In next few months I am planning to take Certification “Oracle SOA Architect Certified Expert” more information here so I decided to dedicate this post on what books I am following and few sites (including Oracle) which gives dummy questions to practice. To gain “Oracle SOA Architect Certified Expert” credentials you need to clear one exam 1Z0-114 “Oracle SOA Foundations, Adoption and […]
Read MoreOracle Apps 11i/R12 AutoPatch adpatch / admsi.pl
Patching : is process of Bug Fix, adding new Functionality or enhancements. Depending on component (database, apps, forms/report) there are different tools to apply patches. adpatch – is utility to apply Oracle Apps Patches (This utility usually updates files under $APPL_TOP, $JAVA_TOP and Database objects) opatch – is utility to apply database and application server (10gR3 for forms, reports […]
Read MoreOracle Email Center in R12 (Download/Outbox Processor)
Oracle Email Center : is comprehensive email response management system tightly integrated into the eBusiness Suite (11i/R12). From R12, You can use any Mail Server(IMAP compliant) with email center. (For pre-R12 (i.e. 11i), only mail server certified with email center is “Oracle Email Server” (Oracle Email Server is Mail Server from Oracle). . Oracle Email […]
Read MoreOracle Fusion Middleware 11g concepts for Apps DBA’s
Oracle Fusion Middleware 11g is collection of Oracle middleware components – Oracle WebLogic Server (J2EE Application Server) – Oracle SOA Suite – Oracle WebCenter – Oracle HTTP Server – Oracle WebCache – Oracle Internet Directory – OID – Oracle Virtual Directory – OVD – Oracle Identity Federation – OIF – Oracle Web Services Manager – […]
Read MoreORA-1652: unable to extend temp segment by 128 in tablespace TEMP
This post covers quick fix for temp tablespace issue (ORA-1652) which is to add temporary datafile and then find root cause of temp tablespace issue. Extent – An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents make up segment. Segment […]
Read MoreDownload Oracle Apps R12 12.1.1
Looking at download location requests in my inbox , I decided to dedicate this post on download location for Oracle Apps (aka ERP, E-Business Suite) and which files to download for Vision Instance. For Oracle Apps 11i (11.1.5.10.2) download location click here . Download R12 (12.1.1) 1. Login to edelivery here 2. From Media Pack […]
Read Moreadoacorectl.sh , adformsctl.sh , adoafmctl.sh – exiting with status 204
Oracle E-Business Suite uses three OC4J (oacore, oafm & forms) for Java Applications including Forms and HTTP Server for static HTML content. All these four components are managed (including startup/shutdown) by OPMN (Oracle Process Manager & Notification) . A. Script to start/stop OPMN in R12 – $ADMIN_SCRIPTS_HOME/ adopmnctl.sh B. Script to start/stop HTTP Server in R12 – $ADMIN_SCRIPTS_HOME/ adapcctl.sh C. Script […]
Read MoreADAPCCTL.SH : EXITING WITH STATUS 150 , 204 : Apache Logs in R12
This article covers how to troubleshoot Oracle HTTP Server (OHS aka Oracle Apache, Apache or Web Server) in Oracle E-Business Suite R12. Web Server background in Oracle Apps R12 : Web Server (OHS) is built on Apache and part of Application Server 10g R3 (10.1.3) in Oracle Apps R12 ( in Oracle Apps 11i version is 9iAS […]
Read MoreOracle E-Business Suite (ERP/Apps) 11.5.10 Software Download
You can download latest version of Oracle E-Business Suite (ERP / Apps) i.e. 12.1.1 from eDelivery by selecting Product Pack as “E-Business Suite” To download 11.5.10.2 (old version of ERP) from edelivery use below steps Login to Oracle eDelivery here From Select a Product Pack drop down menu Select On Demand and from Platform drop down […]
Read MoreAdministering Oracle Clusterware
1. CRSCTL: Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by the “root” user. a. To check the current state of all oracle clusterware daemon: [root@rac1 bin]# ./crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy b.You can also check the […]
Read More