Rewrite in Apache does not work anymore

By | June 21st, 2010|Categories: App. Server|Tags: , , |

Installed an Apache on Suse Linux 10. Configured httpd.conf including a rewrite rule in a virtual host. No configuration errors, but it did not work at all! After a while I discovered that the mod-rewrite module had been installed, but not enabled with this version of Apache (2.2.x).

While migrating discoverer sso-connections, ‘ssomig’ hangs

By | May 30th, 2010|Categories: App. Server|Tags: , , |

Helped a collegae who was migrating a discoverer configuration to another node with a different version (from 10.1.2 to 10.1.4) with now a 10.2 – infrastructure database in a separate home. The OID-users were already successfully migrated, with a little help of the example-script here, but one of the problems was that discoverer didn’t use the single-sign on. The other was that the private and public connection users had made, had disappeared.

How firefox 3.6 accelerates the phasing out of Jinitiator (and frustrates Metalink..)

By | March 15th, 2010|Categories: App. Server|Tags: , , , |

The customer is using Firefox, 3.5 in this case, and Internet Explorer (6!). Suddenly the application does not work anymore for a lot of clients, as a matter of fact, the firefox-users. They had upgraded their Firefox to 3.6., and got the message that an add-on must me installed ( appears to be the JRE ) . After installing this, it still does not work.

Suse 10 and OAS, The Oracle at Delphi

By | February 16th, 2010|Categories: App. Server|Tags: , |

Simple question: is Oracle Application Server with Forms and Reports certified on Suse Linux 10. The customer is forced to move to Suse 10, and is not quite happy to upgrade to, for that could have numerous consequences for Forms, Designer, Java etc.

Logrotating of files like default-web-access.log with help of Linux

By | October 27th, 2009|Categories: App. Server|Tags: , |

What to do about the ever growing files on Oracle application server as: - default-web-access.log - server.log and more.. These files are not logrotated (OAS < 10.1.3 ) and cannot always be deleted or renamed manually on a 'normal' way, and it must be scripted to avoid extraordinary large log-files. Quite annoying, until Frits Hoogland pointed me to a standard Linux-functionality, 'logrotate'.

Knowabouts regarding C# webservices connecting Oracle database

By | September 28th, 2009|Categories: App. Server|Tags: , |

A java-progam (.jar) is calling a webservice, written in C#. I'm able to unzip the jarfile to detect which service it is calling, but how do I know the service is listening to that name? Especially it's not documented and I don't have a clue about the name of the wsdl-file. A webservice, written in C#, is calling an Oracle Database. Oracle 9i client has been installed. Message appears: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater".

OID gives status NONE. Error: sgslunlListen: Bind Failed On Communication Endpoint

By | September 10th, 2009|Categories: App. Server|Tags: , , |

Installed and configured application server  on VM-ware with guest-OS Suse Linux 9. All worked fine, until a (hard) reboot by system admin. OID can’t connect to the default port 13060.

Error in $ORACLE_HOME/ldap/log/oidldapd01.log :

“Bind Failed On Communication Endpoint”  and “Dispatcher Process unable to bind to port”

Because it was a rough […]

Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control

By | August 31st, 2009|Categories: grid control|Tags: , |

After installing Oracle Application Server, with corresponding OID, Grid Control gave me the obove mentioned error, and the the item OID gave a 'metric collection error'. To fix the metric collection error downloaded and applied Patch 5686191 on top of OID product.This is a sql-script to run against the OID-repository.

Adding a true-type font to Reports Services while running Reports deployed on the web

By | August 11th, 2009|Categories: App. Server|Tags: , , , |

Problem: A report, designed for generating PDF with the true-type font Univers in it, does not work while deployed on the web, and uses other fonts instead.
Cause: there’s no Univers installed in the Reports Services on Unix.
Solution: install the font and configure the Reports Service!  Sounds simple…

In the process of figuring this out, I had several error-messages, like rep-1352 (The fonts specified for this report cannot be found for the character set specified by NLS_LANG) , and rep-1 (nothing else…).
Took a lot of time to eliminate those errors, partly because there was a feature in the specified report what did’nt speed up the process of resolving this issue: embedded html. This caused for example the “rep-1”-error.

With special thanks to Marc Riesewijk, developer:

1. First, make a so called ‘AFM’-file of the font-files from your windows-client, which will be used to copy to the Linux-server.

In the case of Univers there are the following files in c:\windows\fonts:


Creating / deleting a reports server in OAS 10.1.2, integrated with EM/AS-console

By | July 10th, 2009|Categories: App. Server|Tags: , |

Creating a reports server and integrate it with Enterprise Manager / iasconsole

– Under control of opmn (wil be automatically restarted)
– Visible and manageable under Enterprise Manager.

1. Create/start a new reports server : “$ORACLE_HOME/bin/ repproject
2. A small window will pop-up, showing that the reports server is starting up.
3. After it’s status is ready, stop this server.
4. Register this new reports server (you can do this also by hand, in the section of deleting this, you can also see what files you will have to update to insert or delete a reports server).

$ORACLE_HOME/bin/ repproject

The command registers the reports server to OPMN and Enterprise Manager.

The following entry is added to $ORACLE_HOME/opmn/conf/opmn.xml (sorry for the layout) :

<ias-component id=”repproject” status=”enabled” id-matching=”false”>
<process-type id=”ReportsServer” module-id=”ReportsServices”>
<process-set id=”repproject” restart-on-death=”true” numprocs=”1″>
<variable id=”PATH” value=”/home/ias10g/OraHome1/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/kerberos/bin:/opt/IBMJava2-131/bin:/opt/IBMJava2-131/jre/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin”/>
< module-data>
<category id=”general-parameters”>
<data id=”batch” value=”yes”/>
<category id=”restart-parameters”>
<data id=”reverseping-timeout” value=”120″/>
<OID infrastructure=”true”/>
<database infrastructure-key=”portal”/>
<managed-process ias-component=”OC4J” process-type=”OC4J_BI_Forms” process-set=”default_island” autostart=”true”/>
<managed-process ias-component=”HTTP_Server” process-type=”HTTP_Server” process-set=”HTTP_Server” autostart=”true”/>
<start timeout=”120″ retry=”3″/>
<stop timeout=”120″/>
<restart timeout=”120″/>
<ping timeout=”30″ interval=”30″/>