Install/Configure SOA Repository (Dehydration Store – ORABPEL, ORAESB, ORAWSM) in 11g Database
As per Oracle SOA Suite (10.1.3.1 or 10g AS R3 Patchset 1) Installation document, You can use Oracle Database 9i or 10g (XE – Express Edition, SE – Standard Edition or EE – Enterprise Edition) as repository for SOA Suite (dehydration store) schema i.e. ORAESB, ORABPEL and ORAWSM. As per new certification Matrix for Oracle […]
Read MoreHow to Deregister SSO/OID from Oracle Apps 11i/R12/12i
Your Oracle Apps 11i/R12/12i instance is currently integrated with Oracle Single Sign-On (SSO) & Oracle Internet Directory (OID) and you would like to remove integration (so that apps 11i/R12 instead of redirection to SSO, authentication happens at FND_USER). Broad level steps to deregister apps (11i/R12) from SSO 1. Deregister Oracle Apps (11i/R12) from OID and […]
Read MoreLatest Patchset TXK.S Bug Removes Izu_top and Custom Top From Context File
We all know that the proper way to add a custom top directory to your E-Business Suite instance is through the ${APPL_TOP}/admin/topfile.txt (Note 216589.1). By adding an entry to that file, AutoConfig will:1) Create the environment variable for you 2) Put it into the context file 3) Update various commonly missed files (formservlet.ini, for example). […]
Read MoreListener Security – Important Tips
Turn on Logging In order to know, which listener commands were executing, one should enable the logging by the following: LSNRCTL> set log_directory …/log LSNRCTL> set log_file Listener_<sid name>.log LSNRCTL> set log_status on LSNRCTL> save_config Set the Listener Password Setting Listener Password is strongly recommended in order to prevent the distinct attacks. There are two […]
Read MoreOEM DBConsole startup issues on 10g R2 database for 11i/R12
On one of our cloned 11i Instance, I faced issues while trying to start Database Control (aka Enterprise Manager Console) using “emctl start dbconsole“. This post covers issues and resolution (Issues mentioned here are specific to particular Database and Operating System Version) . Instance Details Operating System : Solaris Sparc 64 Bit Database : Oracle […]
Read MoreGoodbye 2008, Welcome 2009 !!
As year 2008 comes to an end I look back at stats for year 2008, this blog had 795000 Page Hits, 370000 page views, 1800 comments and approx. 1000 feedburner subscription. . Here is top Six posts of year 2008 (ranking by page views) Step by Step RAC Build 1Z0-233 Dump/Questions Instance Home Overview in […]
Read MoreRAC Basics : CRS, Voting Disk, OCR, Cache Fusion ….
Oracle Clusterware (Cluster Ready Services in 10g/ Cluster Manager in 9i) – provides infrastructure that binds multiple nodes that then operate as single server. Clusterware monitors all components like instances and listeners. There are two important components in Oracle clusterware, Voting Disk and OCR (Oracle Cluster Registry). . Voting Disk – is file that resides […]
Read MoreOracle Service Bus << AquaLogic Service Bus (BEA) + Oracle Enterprise Service Bus (Oracle)
BEA’s AquaLogic Service Bus (ALSB) and Oracle’s Enterprise Service Bus (ESB) are now called as Oracle Service Bus (OSB). . Use of Service Bus (SB): Service Bus offers connectivity options (for standard interfaces like SOAP, messages .. and packaged applications & legacy system via adapters), messaging & routing (efficient, reliable and secure flow of data) , […]
Read MoreApplication Object Library is unable to reconnect to your gateway ORACLE account
While starting Apache (Web Server) in E-Business Suite 11i using “adapcctl.sh start“, I got below error message *********** Cannot reconnect to gateway Cause: Application Object Library is unable to reconnect to your gateway ORACLE account after you unsuccessfully attempted to sign-on. Action: Check that your gateway environment variable is set correctly. *********** My first attempt […]
Read MoreHow to find out Schema Passwords in a 10gAS Application Server
There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:- A) Steps (through the ODM tool):- 1) Log onto the host that hosts the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird. 2) Log on as user “oracle” – the user that did the install. […]
Read More