Category Archives for r12
“oamDS”: ORA-28001: The Password Has Expired
Recently i come across an issue where R12 E-Business Users which was integrated with OAM 11g for SSO were not able to login.They were getting error message as shown below: From first look of redirection URL in browser, it appears that it was crossing the OAM authentication process and it was the application which is […]
Read MoreOracle EBS Integration with OIM (Identity Manager) : Things you should know
This post covers Oracle E-Business Suite (EBS or Apps) integration with Oracle Identity Manager (OIM) for User Provisioning and Reconciliation. OIM is Identity Management and Identity Provisioning/Reconciliation software from Oracle. OIM 11g Architecture & Administration is also covered in my book Oracle Identity and Access Manager for Administrators. Here are key things you should […]
Read MoreWhy should Oracle Apps (EBS) DBAs learn WebLogic Server ? Release 12.2 with FMW 11g
If you follow (if you don’t then you must) Steven Chan’s blog and have seen EBS Technology Stack Roadmap then it is clear that next version of Oracle Apps R12 i.e. 12.2 will come with Fusion Middleware 11g where WebLogic Server replaces 10g Application Server (10.1.2 Forms/Reports and 10.1.3 Web Tier are replaced by 11g Forms/Reports and 11g Web […]
Read MoreHow to compile Apps Schema (invalid objects) in R12 ?
Quick tip on how to compile apps schema (or invalid objects in database) in Oracle applications R12 You can compile invalid objects (or Apps Schema) using below three methods (compiling invalid is not limited to these three methods) 1. From Database Tier a) Login as database tier user (ovisr12 in my case) b) Set environment […]
Read MoreORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data (r12)
ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data Yesterday, during RMAN (11g) backup the aforementioned issue was raised and resolved by following the enclosed Document. Error: ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/PROD/db/apps_st/data/system09.dbf Alert Log Entry: Reread of blocknum=165656, file=/oracle/PROD/db/apps_st/data/system09.dbf. found same corrupt data Dont forget to […]
Read MoreReduce autoconfig downtime – Parallel run & Profiler
Oracle has introduced two new features in autoconfig. These two new features for sure gonna help to reduce the downtime of application for maintenance tasks.1. AutoConfig: Parallel Run Option The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend […]
Read MoreHow to Start / Stop services in Oracle Applications R12 ( Application / Database Tier)
This post covers step by step instructions of How to Start/Stop services in Oracle Applications R12. These steps are from Online Oracle Apps DBA (11i /R12) training here (This is interactive online course over weekend with hands on exercises on installation, patching, cloning during weekdays) Assumptions Application Tier O.S. User : avisr12 (usually applmgr) Database Tier […]
Read MoreDocuments to install Oracle Apps (E-Business) R12 on Windows / Linux / Solaris
This post is from our Oracle Apps DBA Online Training [Weekend batches only for USD 699 from Home] here , next batch starting on 28th Feb 2010. In this post I am going to cover Oracle Apps R12 Installation with link to Oracle Standard Document, Metalink Notes and link to sites including common installation issues . Oracle Apps R12 Installation […]
Read MoreOracle eBusiness Export Function Stopped Working (11i export report to Excel)
Everything was okayed before and now the aforesaid issue occurs. Login to SQL*Plus as apps user and run the following: set serveroutput on declare db_file NUMBER; mime_type VARCHAR2(255) := ‘text/plain’; out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’; web_server_prefix VARCHAR2(500); url VARCHAR2(500); begin db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’); fnd_gfm.file_write_line(db_file, out_string); db_file := fnd_gfm.file_close(db_file); […]
Read MoreReader’s Question : Autoconfig : What is difference between adautoconfig.sh, adautocfg.sh and adconfig.sh
Here is one of Reader’s Question around Autoconfig in Oracle Apps 11i/R12 “What is difference between adautoconfig.sh, adautocfg.sh and adconfig.sh ?” To those who are new to Oracle Applications , using AutoConfig you can reconfigure your Oracle E-Business Suite configuration from values mentioned in $CONTEXT_FILE . To know more about Autoconfig click here or read chapter 5 from Oracle […]
Read More