Oracle Document Capture (ODC) 11g installation on windows 2008 R2 64-bit

Tip of the week:
After installing the Oracle Database client on Windows Server 2008 R2, the Oracle Provider for OLE DB drivers are not available in the Oracle Document Capture’s Batch Setup Provider/driver tab, when configuring the Oracle Document Capture database connection.

This issue is caused by a combination of factors; Windows Server 2008 R2 is a 64-bit only operating system, and Oracle Document Capture is a 32-bit application. 32-bit applications operate within WoW on 64-bit editions of Windows, which means it can only see or access other 32-bit applications or drivers.

To resolve the problem, you must install the 32-bit version of the Oracle database client drivers on this system.


ORA-12203: TNS: Unable to Connect to Destination

Tip of the week: After server reboot, unable to start application services due to ORA-12203: TNS: Unable to Connect to Destination.

Resolution: As there are several fixes to this issue, one unique place to look for is the iptables/firewall in Redhat server. Even though EBS applications worked fine until the reboot, we looked at the iptables that was disabled using ‘service iptables stop’ but was never turned off in rc. Nonetheless, this forced the iptables to be enabled during startup and blocked the tns port.

running ‘service iptables off’ helped to fix the issue.

Also, you can confirm if this is the case by simply running telnet dbserver port number . If it doesn’t connect, about fix is valid.

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001 in R12.1

During our CRP, users received “FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001” and have to login again.
This typically happens when running queries in EBS core forms with the profile “FND: Enable Cancel Query” set to “Yes” in order to enable the cancel query functionality. If the “Cancel Query” window is displayed and the user tries to cancel the query, the following error message is displayed:

After working with Oracle support, analyst suggested to apply the patch 9357219 that lead to the problem resolution.
Ofcourse, after applying the patch on forsms home, relink the forms via
make -f install

Supported faxcard for Oracle Fusion WebCenter Imaging and Process Management (IP/M)

As fax cards market is pretty commoditized, niche products like IP/M may not work with all the available fax cards. After spending enough time, finally found only Brooktrout cards are supported. Atleast that’s per Oracle support. The following Brooktrout analog boards are supported.

* Brooktrout TR114 analog board, using the Brooktrout API version 4.3.

* Brooktrout TR1034 analog board, using the Brooktrout API version 5.2.

The files required to interface with Brooktrout TR114 boards are shipped with your Oracle I/PM releases.

The files include bfax.sys, btcall.cfg, dh.exe, faxinit.exe, install.exe, runfaxin.exe, tfax.exe, v101-164.pex, v202-2m.pex and winfaxdiag_tr114.exe. However, for Oracle I/PM to interface properly with the Brooktrout board, a board must be purchased from a Brooktrout reseller and properly installed.

Brooktrout has announced that TR1034 board replaces the Brooktrout TR114 board. Oracle will continue to support the TR114; however, it will no longer be tested during product certification.

Effective March 15, 2006 Brooktrout Technology merged with Excel Switching Corporation and the new company is called Cantata Technology. See the web site at The fax boards will continue to be referred to under the Brooktrout brand name.

NOTE : Gammafax is no longer supported as of version 7.7.

cwallet.sso (Access is denied) when starting OBIEE services.

Problem: When starting OBIEE services, you get the following erors.

WARNING: Opening of wallet based credential store failed. Reason
tion: F:\oracle\middleware\user_projects\domains\obiee_domain\config\fmwconfig\b
ootstrap\cwallet.sso (Access is denied)
Oct 19, 2011 6:20:12 PM
anager openKeyStore
WARNING: Opening of file based farm keystore failed.

To test this: Have the user who is starting up server navigate to the MW_HOME\user_projects\domains\domain_name\config\fmwconfig\bootstrap\cwallet.sso file and try to open it.

1. Log into the machine with a user who has administrator access to the machine and try this:
2. Navigate to MW_HOME\user_projects\domains\<UCM_Domain>\config\fmwconfig\bootstrap\cwallet.sso
3. Open cwallet.sso, go to properties of it and then security.
4. Enable full control,modify,Read and execute,read and write permissions for the current user (or the user who will be restarting the machine) and apply it.

AC-50480: when performing post R12 Autoconfig

Tip of the Week: AC-50480: Internal error occurred: when performing post R12 Autoconfig

When performing post R12 upgrade steps, AutoConfig fails with the following error while generating the “listener.ora”:
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Solution:Rerun AutoConfig on all nodes, starting with the database node(s), as per standard procedures.

12c Cloud Control – Key Features – Final

Key DB monitoring enhancements.

Oracle EM team has made some significant modifications to the Database Home page in Oracle 12c. The homepage has been divided into regions that can be personalized based on the requirement of the users. The performance region allows the administrator to quickly gauge system resource utilization by wait classes or by various database services. The Monitored SQL region gives a snapshot of all queries currently executing and can be very useful to identify long running queries.  One metric is “SQL Monitor – Last Hour” that provides exhaustive details on sqls ran in past hour.

ASH Analytics

This is one of the popular buzz words in 12c. A new tool to explore the ASH data that allows the  administrator to rollup, drill-down, and slice or dice performance data across various performance dimensions. With the ability to create filters on various dimensions, identifying performance issues has never been easier. The built‐in Treemap view allows administrators to explore performance data using predefined performance dimension hierarchies.

SQL Monitoring

Even though Real‐Time SQL Monitoring introduced in Oracle Database 11g provides the fastest and easiest way to identify and fix performance problems with long running SQL statements. Live visual displays track the details of SQL execution using new, fine‐grained SQL statistics that are updated automatically at no cost to the performance of production systems. This feature is immensely useful for the performance tuning DBAs.

Real-time ADDM

Real‐Time ADDM is an innovative way to analyze problems in extremely slow or hung databases. Real‐Time ADDM runs through a set of predefined criteria to analyze the current performance and helps the DBA to resolve deadlocks, hangs, shared pool contentions and many other exception situations which force the administrator to bounce their databases today.

Data Subsetting

Secure Test Data Management in Oracle Enterprise Manager Cloud Control 12c. Oracle Enterprise Manager Cloud Control 12.1 has several test data management capabilities, such as application data models, data subsetting and data masking. To be able to take advantage of these capabilities, each database involved in the test data management process must have the necessary library functions deployed onto the database.

When a new application has been provided to the application users, it can be a daunting task to construct the application relationships that make up the application. Fortunately, the process of creating the application data model has been greatly simplified for application schema where the application relationships are enforced through database constraint.

Monitor health of Fusion Middleware

As Oracle technologies are aggressively transforming into Fusion, an integral part of your daily administrator duties is to ensure that your Oracle Fusion Middleware and WebLogic deployments are up and performing as expected. In addition, it is also important to understand relationships between components of the farm/domain in order to understand the impact of problems either upstream or downstream from the problematic component. Having such data easily and quickly available is critical to efficiently managing your Oracle Fusion Middleware software.

Composite Application Management

In complex datacenter environments administrators need a single window view of top level metrics/information related to critical SLA of business services, application performance which expose the business services, critical business metrics exposed by applications, and performance of application stack components. This allows administrators to save times as they may have to visit several performance pages and consoles to get high level perspective of their environment. Some business applications such as EBS expose critical business metrics e.g. Number of Orders. In such cases dashboards become even more important as they allow administrators to bridge the gap between business metrics and system metrics. Also, requirements of every business, data center are different. In such scenario obviously Administrator would require an ability to customize dashboard and select appropriate performance metrics from various source. When you look at the dashboard for your new Composite Application, you can see all the members, service levels, incidents, JVM health, and whatever other type of metrics that you like such as the request Processing Time.

Middleware Diagnostic Advisor

12c EM helps Administrator with valuable information rather than just bunch of ‘performance metrics’. This information is given in terms of ‘findings’ on WebLogic server. These performance findings are generated based on variety of performance metrics from EM’s End‐to‐End diagnostic solution and various rules that will determine the root cause of the issue. This proactive root‐cause‐analysis helps Administrator save valuable time when it comes to identifying performance bottlenecks in production applications.

You can learn more about 12c’s capabilities in

How to Install Enterprise Manager Cloud Control (12c) [ID 1359176.1]

EM 12c: How to Install EM 12c Agent using Silent Install Method with Response File [ID 1360083.1]

Enterprise Manager Cloud Control 12c Installation – List of the Log Files and Commands to Zip them into One Zip Archive [ID 1363779.1]

Thanks to Oracle EM development team for the product and as well as for some key contents.

%d bloggers like this: