sed change entire line

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 identical cp -p $fle test_$fle # replace entire 2nd line with a new 2nd line […]

Read More sed change entire line
June 8, 2011
Posted in Linux, Scripts

RAID internal hard disks linux

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

Read More RAID internal hard disks linux
June 6, 2011
Posted in Linux

Intermittent ORA-12545 with oracle RAC database

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 David Yahalom for flagging this – it doesn’t appear to be covered in metalink/my oracle […]

Read More Intermittent ORA-12545 with oracle RAC database
May 9, 2011
Posted in RAC, SQL*Net

Database Resident Connection Pooling

(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 that java applications have had for a long time – largely equalising performance differences with […]

Read More Database Resident Connection Pooling
April 23, 2011
Posted in RAC, SQL*Net

Cron during British Summer Time / Daylight Saving Time

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 use 01.* times in your cron entries, for anything which runs on a Sunday. Newer […]

Read More Cron during British Summer Time / Daylight Saving Time
April 6, 2011
Posted in Linux

Change WordPress colours for link visited hover

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; } a:hover { color: #FF0000 } A lot of hex colour codes are listed at […]

Read More Change WordPress colours for link visited hover
March 18, 2011
Posted in Wordpress

Oracle Forms popup dialog alert box

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 Triggers. You can specify text and button names in the property palette of this new […]

Read More Oracle Forms popup dialog alert box
March 18, 2011
Posted in Oracle forms
12 Comments

ORA-38029 Object Statistics Are Locked – due to import with rows=n

A strange one – but it is a documented feature in oracle. If you import specifying option ‘rows=n’, then statistics for all imported tables will be locked after the import operation is finished. That is only for import – an export with ‘rows=n’ is fine, doesn’t lock anything. That’s probably not what you want to […]

Read More ORA-38029 Object Statistics Are Locked – due to import with rows=n
March 8, 2011
Posted in Stats
3 Comments

Windows 2008 Disappearing Printers Trick

Windows Server 2008 and Windows 7 both hide printers that use the same port as another printer. But the printers aren’t really gone, they just take a little more effort to see – details at http://blogs.technet.com/b/askperf/archive/2010/03/02/windows-7-where-are-my-printers.aspx Your friends will be amazed.

Read More Windows 2008 Disappearing Printers Trick
March 8, 2011
Posted in Windows