Author Archives: Andrew Fraser

Oracle Developer Suite 10g 9.0.4.0.1 windows software download media

Posted on 15 July 2011 by Andrew Fraser

Oracle Developer Suite 10g 9.0.4.0.1 for Windows (forms developer) is not easy to obtain now, out of support by Oracle for a long time, but that version is still in use out there. So I have zipped both installation CDs … Continue reading →

Posted in Uncategorized | 10 Comments

Cron fix for ulimit: max user processes: cannot modify limit:operation not permitted

Posted on 14 July 2011 by Andrew Fraser

Werner Puschitz has details of how to use ulimit and limits.conf to change maximum processes and open file descriptors. But for processes running from cron, I found I had to additionally make the below changes (this is on old version: … Continue reading →

Posted in Uncategorized | 1 Comment

Split space delimited string with regexp SQL

Posted on 13 July 2011 by Andrew Fraser

Split up a delimited string with: select regexp_substr(‘Hello world !’ ,’[^ ]+’, 1, 1) , regexp_substr(‘Hello world !’ ,’[^ ]+’, 1, 2) , regexp_substr(‘Hello world !’ ,’[^ ]+’, 1, 3) from dual ; Output: REGEX REGEX R —– —– – … Continue reading →

Posted in Scripts | Leave a comment

sed change entire line

Posted on 8 June 2011 by Andrew Fraser

Here I use sed to replace the entire 2nd line in a lot of files with a new 2nd line. The shell script: for fle in `ls *.msg` do # copy file first so as can keep permissions and ownership … Continue reading →

Posted in Linux, Scripts | Leave a comment

RAID internal hard disks linux

Posted on 6 June 2011 by Andrew Fraser

Useful commands to show RAID level of internal hard disks. On HP blade servers: /usr/sbin/hpacucli controller all show status /usr/sbin/hpacucli controller slot=0 logicaldrive all show On other servers: cat /proc/mdstat

Posted in Linux | Leave a comment

Intermittent ORA-12545 with oracle RAC database

Posted on 9 May 2011 by Andrew Fraser

Problem: Client suffers intermittent ORA-12545 “Connect failed because target host or object does not exist” trying to connect to oracle RAC database. Solution: Edit server side (not client side) listener.ora and tnsnames.ora files to have fully qualified hostnames. Thanks to … Continue reading →

Posted in RAC, SQL*Net | Leave a comment

Database Resident Connection Pooling

Posted on 23 April 2011 by Andrew Fraser

(Update: Firewalls can prevent DRCP functioning correctly – details at end of this post) Database Resident Connection Pooling is new with 11g, and should be used for PHP applications. It will allow them to use the same type of connection pooling … Continue reading →

Posted in RAC, SQL*Net | Leave a comment

Cron during British Summer Time / Daylight Saving Time

Posted on 6 April 2011 by Andrew Fraser

For older versions of unix/linux, crons running at 01.* (anything from 01:00 to 01:59) do not run during the Spring Sunday time change. Those sames crons will run twice during the Autumn time change. So it is important to not … Continue reading →

Posted in Linux | Leave a comment

Change WordPress colours for link visited hover

Posted on 18 March 2011 by Andrew Fraser

Go to your wordpress dashboard, click on ‘Appearance’ > ‘Editor’. This will open up a Stylesheet (style.css) editor. Here you can change the colours for ‘link’, ‘visited’, and ‘hover’, like this: a:link { color: #hexcodelinkcolor; } a:visited { color: #hexcodeyouwantvisitedlinktobe; … Continue reading →

Posted in Wordpress | Leave a comment

Oracle Forms popup dialog alert box

Posted on 18 March 2011 by Andrew Fraser

Howto create a popup dialog box in Oracle Forms – called ‘alerts’ although can be used for all kinds of purposes, not just alerting. First create a new alert. Alerts are listed in the forms developer object navigator, immediately underneath … Continue reading →

Posted in Oracle forms | 2 Comments