Who am I?      What is this site?      Contact me

Check out my Advanced Oracle Fusion Middleware blog.

Oracle Application Server
Topology network configuration in OAS 10g (10.1.3)  (2008-06-11)
"System.out" not being logged in OAS 10.1.3  (2007-10-31)
Change the default EM (Enterprise Manager) port number  (2004-07-29)

Oracle HTTP Server (OHS)
Hardening Oracle HTTP Server (OHS)  (2006-04-10)
Manually check status of Oracle HTTP Server (OHS)  (2004-07-29)
Finding the Apache version in Oracle HTTP Server (OHS)  (2005-10-12)
The "LimitRequestLine" directive in OHS cannot exceed 8190 bytes  (2004-07-29)
Configure OHS to port 80 on Linux  (2006-06-01)
Filter EM monitoring activities in the Apache log to reduce access_log size  (2006-11-06)
Disable AggreSpy servlet in OAS 10.1.2  (2008-02-14)

Oracle Containers 4 Java (OC4J)
Changing the JDK version on OC4J  (2008-02-05)
Identify the OC4J version and build  (2008-02-12)
Configure session failover in an OC4J cluster (10g)  (2008-06-29)
Configure session failover in an OC4J cluster (9i)  (2004-07-29)
No OC4JMount directives in mod_oc4j.conf in Oracle Application Server 10g R3  (2008-06-03)
Configuring default files <welcome-file> in OC4J and <DirectoryIndex> in OHS  (2008-07-16)

Oracle Web Cache
Configure WebCache to port 80 on Linux  (2006-10-04)
Configure load balancing with Web Cache in 5 minutes  (2008-06-12)

Oracle Applications 11i
Exporting passwords in cleartext from FND_USERS  (2005-06-20)
Configuring a different mail user for Workflow Mailer 2.5  
SSO enabling Apps 11.5.4/11.5.6  
Restoring missing tasks in Oracle Exchange (OEX) 6.2  

Oracle B2B
ORA-02266 when trying to truncate B2B.TIP_DATASTORAGE_TR  (2008-02-19)
Purge B2B runtime data from the command prompt  (2007-10-16)
Increase columns in B2B_CTLNUM tables to accomodate larger transaction control numbers  (2008-01-30)
Performance tuning Oracle B2B 10.1.2  
"AIP-11016: SQL error" when deploying a configuration  
Getting JMS-120 "Dequeue failed" and ORA-01555 in B2B logs  

Oracle Collaboration Suite (OCS)
Getting "OID connection misconfigured or other error detected" error  

Oracle Web Conferencing
Enabling Web Conferencing 9i on Windows Vista and IE 7  (2007-11-06)
Change SMTP server for and Web Conferencing 9i  (2007-04-20)
"OID connection misconfigured" when connecting to a Web Conference in OCS 9i  (2006-11-10)

Oracle Files
Cannot download attachments in Internet Explorer (IE) via SSL  (2006-10-02)
Change SMTP server for OCS Files  

Oracle Data Integrator (ODI)
JDK, not JRE, required to execute Web Services with OracleDI  (2009-02-05)
"java.sql.SQLException: No suitable driver" when executing a scenario from the command prompt  (2009-02-05)
"com.sunopsis.core.SecurityAccessException: Invalid password" when executing a scenario from the command prompt  (2009-02-05)

Oracle Database
Configure Very Large Memory (VLM) for Oracle 10g 32-bit  (2007-12-20)
Introduction to Advanced Queues (AQ)  (2008-05-21)
ORA-00904 when trying to select a type attribute from a table  (2008-06-05)
Running "urlrp.sql" automatically disconnects with ORA-03113 and ORA-03114  (2007-08-21)
DCE32.dll not found when running Oracle executables  (2008-07-09)
make for target client_sharedlib failed  

Oracle Enterprise Manager (OEM) Grid Control

Oracle Management Server (OMS)
'No trusted certificate' error when running an OEM Grid Control Web Transaction  (2006-12-04)
Changing the SYSMAN password  (2007-05-08)
Installing OEM 10g Grid Control 32-bit on a 64-bit OS  
Securing OMS fails with "Failed rc = 1"  

OEM Grid Control Agent
Configure OEM Grid Control Agent against Oracle BPEL Process Manager  (2007-12-23)
Getting ORA-06512 when 10.2.0.1 Agent uploads to 10.2.0.3 OMS  (2007-02-18)
Deploy Microsoft IIS 6.0 plugin for OEM Grid Control 10g  (2007-05-10)
Deploy Microsoft SQL Server 2000 plugin for OEM Grid Control 10g  (2007-05-10)
Clearing the OEM 10g Grid Control Agent  (2009-01-05)
Enabling VERBOSE to troubleshoot securing the OEM 10g Grid Control Agent  (2006-05-08)
Deploy the .NET Framework plugin  
Deploy the BEA Weblogic plugin  
Installing Agents on identically cloned VMs  
Installing Agents without HTTP enabled on OMS  
Getting NET HELPMSG 3547 when starting 10.2.0.1 Agent on Windows  

Oracle Gateways
Installing and configuring Oracle Transparent Gateway for MS SQL Server  
Installing and configuring Oracle Transparent Gateway for DB2/400  
Installing and configuring Oracle Transparent Gateway for DRDA  
Installing and configuring Oracle Procedural Gateway for APPC (mainframe) over SNA  

Oracle iLearning
Why 'trusted URL' in iLearning 4 is insecure  
SSO enabling iLearning  

Oracle Identity Management

Oracle Single Sign-On (SSO)
"Exception while configuring SSO Server :ORA-06502: PL/SQL: numeric or value error"  (2005-06-06)
WWC-41439 when trying to log in to ssoserver/pls/orasso  (2005-06-06)
Retrieve the password of the ORASSO database user  (2005-02-15)
Testing SSO authentication via PL/SQL (sso_auth.sql)  (2007-02-10)
SSO enable an Oracle Application Server 10g midtier with an Oracle SSO 10g server  (2007-04-04)
SSO enable on Oracle Application Server 9i/10g midtier with an Oracle SSO 9i server  (2005-06-06)
Random user-related queries for SSO 9i  (2007-06-25)
High Availability via cold failover for Oracle Single Sign-On 9i R1  
Delegating Oracle SSO authentication to a 3rd party access manager (Sun Access Manager)  

Oracle Internet Directory (OID)
Configure OID 10g Connector to bi-directionally synchronize with Sun Directory Server 5.2  (2008-10-20)
Setting up LDAP replication  

Oracle Portal
 

Oracle SOA Suite
Silent install of Oracle SOA Suite 10g (10.1.3.3) on Red Hat Linux  (2008-05-29)
Silent install of Oracle SOA Suite 10g (10.1.3.3) on Windows  (2008-06-04)
Oracle SOA Suite 10g response files created through the record mode are not supported  (2008-06-04)
Applying Oracle SOA Suite 10g Patch Set 4 (10.1.3.4.0)  (2008-08-28)
Changing the hostname and port in Oracle SOA Suite 10g (10.1.3)  (2008-08-29)
"Passive connection 127.0.0.1,6100 missing connect" or "Local connection 0,127.0.0.1,6100 missing form factor" in opmn.log  (2007-06-11)
"XPath query string returns zero node."  (2009-04-03)
MQSeries Adapter disappears from AS Control after configuring it  (2008-09-01)
ORABPEL-12511: "Adapter Framework unable to create outbound JCA connection" due to java.lang.IndexOutOfBoundsException  (2008-07-29)
What is SOA Governance?  (2008-04-22)
HTTP 500 in Apache access log for 'RegistrationService'  
AQ adapter logging  
Avoiding SOA transaction timeouts and exceptions  

Oracle Application Integration Architecture (AIA)
Installing Oracle Application Integration Architecture (AIA) Foundation Pack 2.0.1 for Microsoft Windows 32-bit  (2008-07-16)
Installing Oracle Application Integration Architecture (AIA) Foundation Pack 2.2.0 for Microsoft Windows 32-bit  (2008-09-12)
Upgrading Oracle Application Integration Architecture (AIA) Foundation Pack 2.2.0 to 2.2.1 on Microsoft Windows 32-bit  (2008-10-01)
"The SOA suite server installed is not the required version (10.1.3.3.0)" when installing AIA 2.2.0  (2008-11-19)
BUILD FAILED for target "buildfile" when installing AIA FP2 demos  (2008-07-15)
"Error occurred during initialization of VM" when starting up OC4J_SOA  (2008-09-12)
Getting "Unknown argument: --noconfig" when trying to deploy the AIA FP 2.2 demo  (2008-09-12)
Summary of the Oracle AIA Foundation 2.0.1: Concepts and Technologies Guide  (2008-07-27)

Oracle BPEL Process Manager
Deploying BPEL processes (SOA Suite 10g) via ANT  (2008-06-11)
BPEL process unable to dequeue and "Resource Adapter requested Process shutdown!" in domain.log  (2008-12-09)
ORABPEL-11622: "javax.transaction.RollbackException" thrown when BPEL Process Manager (10.1.3.1) is under load  (2007-10-23)
ORABPEL-11947: Random "SQL wrapper has been closed!" during BPEL process execution  (2007-10-24)
ORABPEL-11811: "Internal Exception: java.sql.SQLException"  (2009-03-26)
ORABPEL-10057: "invalid query" when deploying BPEL process  (2009-04-17)
ORABPEL-08033 occurring intermittently  (2009-01-07)
ORABPEL-05002: "java.lang.OutOfMemoryError: Java heap space"  (2008-02-01)
ORABPEL-10902: "BPEL validation failed" when deploying BPEL process  (2007-07-27)
ORABPEL-10903: "failed to read wsdl" when deploying BPEL process  (2009-03-31)
ORABPEL-05244: ORABPEL-05244: "Failed to obtain load lock for process" for BPEL instance  (2009-04-15)
"HTTP transport error" due to "Premature EOF encountered" in BPEL instance  (2009-04-14)
Cannot connect activity to Partner Link when designing BPEL process  (2009-04-15)
Update OC4J_SOA settings to print Garbage Collection information  (2008-01-01)
BPEL process hanging upon invocation and getting "Not a valid SOAP" in opmn.log  (2009-04-14)
"com.oracle.bpel.client.delivery.ReceiveTimeOutException" exception in BPEL activity, resolved by syncMaxWaitTime  (2008-06-30)
"com.collaxa.cube.ejb.impl.FinderBean.tryLookupInstanceByReferenceId" when logging in to BPEL Console after 10.1.3.3 upgrade  (2008-07-10)
"Could not initialize activation agent" when deploying BPEL process  (2007-09-09)
"oracle.AQ.AQOracleSQLException: Closed Connection" in domain.log  (2007-07-02)
"Cannot find the specified instance" and no instances are displayed when initiating a BPEL process from console  (2007-07-02)
Exception on JaxRpc invoke caused by HTTP transport error due to "Premature EOF encountered"  (2008-02-01)
Exception on JaxRpc invoke caused by HTTP transport error due to "Message transmission failure, response code: 404"  (2008-07-10)
Resolving JVM core dumps caused by AQ Adapter by upgrading container to JDK 1.5.0_14  (2008-02-05)
BPEL Performance Tuning: Increase JVM memory  (2007-12-22)
BPEL Performance Tuning: Recommended oc4j-ra.xml settings  (2007-12-22)
BPEL Performance Tuning: Recommended DbAdapter settings  (2007-09-05)
BPEL Performance Tuning: Validate connections in the connection pool  (2007-11-22)
BPEL Performance Tuning: Set log levels  (2007-11-22)
Configuring a BPEL Process Manager cluster using node-to-node (TCP) instead of multicast (UDP)  (2008-09-16)
Executing a BPEL process from the command prompt  
BPEL Console cannot fetch a datasource connection "jdbc/BPELServerDataSourceWorkflow"  

Oracle Enterprise Service Bus (ESB)
Deploying ESB projects (SOA Suite 10g) via ANT  (2008-06-16)
Batch resubmit all failed ESB instances by using the ConsoleClient Interface (includes working code)  (2008-07-28)
Dynamic routing of endpoints in ESB using DVM and the header transformation extension function 'setOutboundHeader'  (2008-07-31)
ESB Control shows "Designtime cache has not been initialized"  (2008-06-02)
"RCV: Transport endpoint is not connected" when trying to start up the SOA Suite 10g  (2008-02-20)
"The metadata XML that was processed does not comply with the ESB Metadata XML Schema" when clicking on any service in ESB Control  (2008-07-28)
"Could not instantiate InteractionSpec" due to missing class oracle.tip.adapter.aq.outbound.AQEnqueueInteractionSpec  (2008-08-04)
"oracle.tip.esb.server.common.exceptions.BusinessEventRetriableException" when receiving fault from BPEL process  (2008-09-18)
ORABPEL-11947: "Enqueue failed" due to identifier 'DBMS_AQIN' must be declared  (2008-07-29)
Enable ESB debugging  (2008-07-22)
Various ant build errors when updating the Oracle ESB Metadata using esbparam.properties  (2008-08-14)
Start OC4J with the -userThreads if getting "Cannot find service <service> on current cluster" in an ESB cluster  (2008-08-15)
ESB services not showing up in ESB Control  (2008-08-15)
"XML Parsing Error: no element found" when viewing concrete WSDL URL of SOAP service  (2008-08-27)
"Unable to determine operation id from SOAP Message" when using SOAP endpoint URI  (2008-10-02)
ESB service not capturing faults from BPEL process and getting env:ESBMessageProcessingFailed  (2008-09-05)
ESB service cannot invoke another ESB service exposed as an external SOAP service in SOA Suite 10g  (2008-09-17)
Useful SQL queries for Oracle ESB  (2009-02-23)
Purge ESB instances  (2008-06-11)
Useful ESB database queries  (2008-06-12)
"The selected porttype is using a message that is invalid for ESB" error when importing a WSDL  (2008-06-11)
"Exception: Invalid input/output combination" when reading a WSDL file in ESB  (2008-06-10)
"Failed to open the target schema: The schema does not contain the global element" when creating a new mapper file in ESB  (2008-06-10)
ESB runtime exception in "oracle.tip.esb.server.common.exceptions.BusinessEventRetriableException"  (2008-06-10)

Oracle Service Registry (OSR)
ClassNotFoundException for oracle.jdbc.driver.OracleDriver when installing Service Registry 10g  (2008-07-11)
"DatabaseCoreException: (12021) Cannot obtain new connection" when installing Oracle Service Registry 10g  (2008-09-11)

Oracle Web Services Manager (OWSM)
BUILD FAILED when running 'wsmadmin.sh'  (2008-09-12)

Oracle WebCenter
 

General Oracle
"Interim Patch XXXXXXX is holding the lock from this patch XXXXXXX" when running OPatch  (2008-07-11)
Installing non-certified 32-bit Oracle software on a 64-bit Linux operating system  (2005-12-08)

General Technology

Development
"PLS-00302: component 'CONSTRUCT' must be declared" when initiating variable via SYS.AQ$_JMS_MESSAGE.construct  (2008-07-10)
Creating a top-down Java Web Service  (2009-01-19)
Creating a bottom-up Java Web Service  (2009-03-23)
Encrypting strings in Java using SHA  (2009-04-18)
Using JDBC direct connect in a JSP to connect to an Oracle database (for the newbie)  (2007-11-11)
Using JDBC direct connect in a JSP to connect to a MySQL database (for the newbie)  (2009-04-05)
Using a JDBC connection pool in a JSP to connect to an Oracle database (for the newbie)  (2007-11-11)
Using a JDBC connection pool in a JSP to connect to a MySQL database (for the newbie)  (2009-05-11)
Use Java to upload files to a filesystem or a database BLOB column  (2009-05-09)
Wrapping PL/SQL packages  (2008-01-23)
JSP that dumps all OC4J system properties  (2007-06-11)
Finding CLASS files inside JAR files  (2006-06-27)
Install and configure the 'pen' load balancer  (2008-06-30)
Sending email from PL/SQL  
Converting codepage IBM-420 (mainframe EBCDIC) to ISO8859-6 (RS/6000 ASCII)  

Linux
How to query for 64-bit (x86_64) RPM packages  (2007-04-20)
Configure multicast on Linux  (2008-06-12)
Build an RPM from source  (2006-05-18)
Execute script upon Linux reboot  (2008-06-01)
Configure "sudo su" to disallow sharing passwords of shared accounts  (2006-05-02)
Red Hat Linux AS 3/4 hardening (to comply with DoD STIG)  (2007-12-20)
Red Hat Linux hardening with Bastille  (2008-06-19)
Configure sendmail.cf to use mail relay  (2007-03-03)
Why does Linux report 100% memory usage all the time?  (2008-01-23)
Creating a Red Hat OBI (Oracle Base Install) image to support multiple Oracle products  (2005-11-30)
Passwordless SCP authentication  (2005-12-28)
Mounting an NTFS firewire drive in Ubuntu 8 (Hardy)  (2008-09-07)
Dual booting with Windows XP and Linux (high-level)  (2008-09-16)
Calculating memory usage for each process  
What is /dev/shm?  
Getting "ntfs not supported file system" when mounting an external USB drive formatted in NTFS  

Tomcat
Increase JVM memory of your Tomcat server  (2009-05-05)

MySQL
MySQL Cheat Sheet (for the newbie)  (2007-12-19)
Cannot log in to MySQL as 'root'  (2006-10-29)

VMware
Add an extra virtual hard disk to a Linux VM running on VMware GSX Server 3.2.1  (2007-12-21)
"Cnx_CreateSocketDir" error when starting up VM on VMware GSX Server 3 on Linux  (2007-12-21)
Getting 'VMware Server cannot find the virtual disk' on VMware GSX 3  (2007-12-21)
Installing VMware GSX 3.2.1 on Ubuntu 8.04 (Hardy) 64-bit  (2008-09-07)
Configuring IP NATing on a Linux host  
NTP not working inside the VM  

Ahmed Aboulnaga