App. Server

Rewrite in Apache does not work anymore

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).

By |2022-06-07T20:30:05+02:00June 21st, 2010|App. Server|0 Comments

While migrating discoverer sso-connections, ‘ssomig’ hangs

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.

By |2022-06-18T13:32:18+02:00May 30th, 2010|App. Server|1 Comment

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

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'.

By |2022-06-07T20:25:22+02:00October 27th, 2009|App. Server|0 Comments

Apex, HTTP-404 while clicking ‘application builder’

Apex, version 3.2.1.00.10, on a 10.2.0.3-database is working fine for some time. Then, while clicking the 'application builder' home-page, we got the 'page not found'-error in the browser. Logging of Apache shows: mod_plsql: /pls/apex_schd/f HTTP-404 ORA-03113: end-of-file on communication channel\n mod_plsql: Unable to reset state for mode 0: Err 3114 url=>/pls/apex_schd/f

By |2022-06-07T20:25:47+02:00October 26th, 2009|App. Server, Database|1 Comment

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

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

By |2022-06-07T20:27:19+02:00August 11th, 2009|App. Server|4 Comments

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

Creating a reports server and integrate it with Enterprise Manager / iasconsole Why: – Under control of opmn (wil be automatically restarted) – Visible and manageable under Enterprise Manager. 1. Create/start a new reports server : “$ORACLE_HOME/bin/rwserver.sh repproject 2. A small window will pop-up, showing that the reports server is starting up. 3. After it’s

By |2022-06-07T20:27:38+02:00July 10th, 2009|App. Server|2 Comments

The curious case of the left-handed mouse in webforms

In OAS (10.1.2.0.2), webforms, when using a left-handed mouse to expand a menu, the tree node is not expanding. No error is given. For example, in 'Material Workbench' select the '+' to expand 'Organizations' in the menu. Left and right button does not do anything. Also, the left handed users are having difficulties in moving

By |2022-06-07T20:18:47+02:00July 6th, 2009|App. Server|0 Comments

Create virtual host with Webcache on OAS 10.1.0.2

Creating Virtual Host with Webcache and HTTP-server. Not that high-tech, but takes quite a lot of small steps, and must be done without taking risks in a production environment. I did this with Enterprise Manager, while I did not completely rely on my abilities on updating the $ORACLE_HOME/webcache/webcache.xml ..... , and eventually I had to hand it over to the production-DBA.

By |2022-06-07T20:19:37+02:00June 12th, 2009|App. Server|0 Comments

Signing jar-files

A project is using Sferyx in Webforms, and the file HTMLEditorLight.jar is used. But 'copy and paste' from outside the form to the editor is not working. Cause: the jar-file need to be signed. To sign a jar-file the tools 'keytool' and 'jarsigner' is needed. But... why not use a script from e.g. webutil: sign_webutil.sh? With a few adjustments it's a quite common, usable script.

By |2022-06-07T20:20:41+02:00April 29th, 2009|App. Server|0 Comments

Recent Tweets Jobaclenl