Archive Monthly Archives: July 2009

Oracle 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 More

ORA-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 More

Download Oracle Apps R12 12.1.1

This entry is part 2 of 3 in the series Oracle Apps DBA Training

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 More

adoacorectl.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 More

ADAPCCTL.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 More

Oracle 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 More

Administering 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

Voting Disk Management in RAC

What is voting disk ? Voting disk is a file that manages information about node membership. It is located on the shared cluster system or a shared raw device file. Its primary purpose is to help in a situation where the private network communication fails. CSS (Cluster Synchronization Service) is the service that determines which […]

Read More

Oracle Fusion Middleware – SOA Suite 11g R1 installation

This entry is part 7 of 7 in the series Oracle Fusion Middleware Training

This post covers installation of SOA Suite component of Oracle Fusion MiddleWare (FMW) 11g R1 (11.1.1.1). Oracle Fusion Middleware 11g components (SOA, Webcenter, Identity Management….) uses Oracle WebLogic Server 11g R1 (10.3.1) as underlying Application Server. If you are new to WebLogic Server then my recommendation is to read more about Domain, Administration and Managed Server in WebLogic here . Overview of Fusion […]

Read More

Single Instance to RAC conversion using DBCA :Part-II

This is Part II for Single Instance to RAC conversion. For Part-I click here Pre-requisite before conversion 1. Set up the cluster environment and validate the cluster using clvufy. 2. Copy the pre-configured database image from $OLD_ORACLE_HOME/ assistants/ dbca/ templates/ *.dbf & *.dbc    to  new rac environmnet   $NEW_ORACLE_HOME/assistants/dbca/templates/*.dbf & *.dbc 3. Run  ORACLE_HOME/bin/dbca step-1 […]

Read More
Not found